August 12, 2004 at 6:47 am
why this stored procedure doesn't work , can anybody figure it out ?
CREATE OR REPLACE PROCEDURE Ipts_Tra_Policy
/******************************************************************************
NAME: IPTS_TRA_POLICY
PURPOSE: Procedure for maintaining Policy table
REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 29/07/2003 Abhishek 1. Procedure for inserting a new policy
Policy table.
1.1 25/08/2003 Anagha 1. Changed comment
2. Removed commented code.
3. Cancellation date should be null
and not sysdate.
1.2 17/09/2003 Pankaj 1. Added parameter i_hypothecation_dtl
change made for CR No. 13
24/09/2003 Pankaj 2. Added parameter i_floater_type
change made for CR No. 6
******************************************************************************/
/******************************************************************************/
(i_actionFlag IN VARCHAR2,
io_syspolicy_no OUT POLICY.syspolicy_no%TYPE,
i_contact_id IN POLICY.contact_id%TYPE,
i_intermediary_id IN POLICY.intermediary_id%TYPE,
i_product_id IN POLICY.product_id%TYPE,
i_rn_no IN POLICY.rn_no%TYPE,
i_policy_status IN POLICY.policy_status%TYPE,
i_policy_no IN POLICY.policy_no%TYPE,
i_sysquotation_No IN POLICY.sysquotation_no%TYPE,
i_inception_dt IN POLICY.inception_dt%TYPE,
i_expiry_dt IN POLICY.expiry_dt%TYPE,
i_sum_insured IN POLICY.sum_insured%TYPE,
i_premium IN POLICY.premium%TYPE,
i_discount IN POLICY.discount%TYPE,
i_comm_pct IN POLICY.comm_pct%TYPE,
i_other_prod_desc IN POLICY.other_prod_desc%TYPE,
i_grp_id IN POLICY.grp_id%TYPE,
i_grp_company_id IN POLICY.grp_company_id%TYPE,
i_remark IN POLICY.remark%TYPE,
i_cancellation_dt IN POLICY.cancellation_dt%TYPE,
i_upd_id IN POLICY.upd_id%TYPE,
i_hypothecation_dtl IN POLICY.HYPOTHECATION_DTL%TYPE,
i_floater_type IN POLICY.FLOATER_TYPE%TYPE,
i_csum_insured IN POLICY.custom_sum_insured%TYPE
)IS
BEGIN
/*
the date format is being changed by abhishek on 05/08/2003
*/
SELECT policy_seq.NEXTVAL INTO io_syspolicy_no FROM dual;
INSERT INTO POLICY(POLICY.syspolicy_no,POLICY.sysquotation_no,POLICY.contact_id,
POLICY.intermediary_id,POLICY.product_id,POLICY.rn_no,POLICY.policy_status,
POLICY.policy_no,POLICY.inception_dt,POLICY.expiry_dt,POLICY.sum_insured,POLICY.custom_sum_insured,
POLICY.premium,POLICY.discount,POLICY.comm_pct,POLICY.upd_id,POLICY.grp_id,
POLICY.grp_company_id,POLICY.upd_dt,POLICY.upd_no,POLICY.other_prod_desc,
POLICY.remark,POLICY.HYPOTHECATION_DTL,POLICY.FLOATER_TYPE )
VALUES
(io_syspolicy_no,i_sysquotation_No ,i_contact_id ,i_intermediary_id ,i_product_id ,
i_rn_no ,'ACT',SYS.Toolkit.Encrypt(i_policy_no),TO_CHAR(i_inception_dt,'DD/MON/YYYY'),
TO_CHAR(i_expiry_dt,'DD/MON/YYYY'),i_sum_insured,i_csum_insured ,i_premium ,i_discount,i_comm_pct,
SYS.Toolkit.Encrypt(i_upd_id) ,SYS.Toolkit.Encrypt(i_grp_id),SYS.Toolkit.Encrypt(i_grp_company_id),
SYSDATE,1,SYS.Toolkit.Encrypt(i_other_prod_desc), SYS.Toolkit.Encrypt(i_remark),SYS.Toolkit.Encrypt(i_hypothecation_dtl),i_floater_type
);
/***********************************************************************************
ends the procedure
**************************************************************************************/
END Ipts_Tra_Policy;
/
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
August 16, 2004 at 8:00 am
This was removed by the editor as SPAM
August 16, 2004 at 8:27 am
You know that if you type 'show errors' at the SQL plus prompt it will tell you why it didn't compile.
Hope this helps
Adrian
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply