[Home] [Help]
12: */
13:
14:
15: PROCEDURE ARI_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
16: v_org_tan_num jai_ap_tds_org_tan_v.org_tan_num%TYPE; --- 4323338
17: v_leg_org_tan_num jai_ap_tds_org_tan_v.org_tan_num%TYPE;--- 4323338
18: v_opt_unit_id NUMBER;
19:
20: BEGIN
13:
14:
15: PROCEDURE ARI_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
16: v_org_tan_num jai_ap_tds_org_tan_v.org_tan_num%TYPE; --- 4323338
17: v_leg_org_tan_num jai_ap_tds_org_tan_v.org_tan_num%TYPE;--- 4323338
18: v_opt_unit_id NUMBER;
19:
20: BEGIN
21: pv_return_code := jai_constants.successful ;
44: - Added the code to insert data into JAI_AP_TDS_CERT_NUMS table for LE
45:
46: 4. 2/05/2005 rchandan for bug#4323338. Version 116.1
47: India Org Info DFF is eliminated as a part of JA migration. A table by name ja_in_ap_tds_org_tan is dropped
48: and a view jai_ap_tds_org_tan_v is created to capture the PAN No,TAN NO and WARD NO. The code changes are done
49: to refer to the new view instead of the dropped table.
50:
51: 5. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
52: DB Entity as required for CASE COMPLAINCE. Version 116.1
73: pv_return_code := jai_constants.successful ;
74: /*
75: SELECT org_tan_num
76: INTO v_leg_org_tan_num
77: FROM jai_ap_tds_org_tan_v --4323338
78: WHERE organization_id = pr_new.Legal_Entity_id ;
79:
80: */
81: /*
136: /* BEGIN
137:
138: SELECT org_tan_num
139: INTO v_org_tan_num
140: FROM jai_ap_tds_org_tan_v --- 4323338
141: WHERE organization_id = c_org_id.organization_id;
142:
143: EXCEPTION
144: