eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_AC_KRS dependencies on CZ_IMP_CONTACT

Line 16: SELECT ORIG_SYS_REF , FSK_CUSTOMER_1_1, FSK_address_2_1, ROWID FROM CZ_IMP_CONTACT

12: ) IS
13: BEGIN
14: DECLARE
15: CURSOR c_imp_contact IS
16: SELECT ORIG_SYS_REF , FSK_CUSTOMER_1_1, FSK_address_2_1, ROWID FROM CZ_IMP_CONTACT
17: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
18: ORDER BY ORIG_SYS_REF, FSK_CUSTOMER_1_1 , FSK_address_2_1, ROWID;
19:
20: /* cursor's data found indicator */

Line 26: nOnlContactId CZ_IMP_CONTACT.CONTACT_ID%TYPE;

22: x_onl_contact_f BOOLEAN:=FALSE;
23: x_onl_customer_customerid_f BOOLEAN:=FALSE;
24: x_onl_address_addressid_f BOOLEAN:=FALSE;
25: x_error BOOLEAN:=FALSE;
26: nOnlContactId CZ_IMP_CONTACT.CONTACT_ID%TYPE;
27: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
28: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
29: sImpOrigSysRef CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;

Line 29: sImpOrigSysRef CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;

25: x_error BOOLEAN:=FALSE;
26: nOnlContactId CZ_IMP_CONTACT.CONTACT_ID%TYPE;
27: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
28: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
29: sImpOrigSysRef CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;

Line 30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;

26: nOnlContactId CZ_IMP_CONTACT.CONTACT_ID%TYPE;
27: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
28: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
29: sImpOrigSysRef CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;

Line 31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;

27: nOnlcustomerId CZ_IMP_CUSTOMER.CUSTOMER_ID%TYPE;
28: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
29: sImpOrigSysRef CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;

Line 32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;

28: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
29: sImpOrigSysRef CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;

Line 33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;

29: sImpOrigSysRef CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
37: sThisFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;

Line 34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;

30: sFSKcustomer CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
37: sThisFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
38: sRecStatus CZ_IMP_CONTACT.REC_STATUS%TYPE;

Line 35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;

31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
37: sThisFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
38: sRecStatus CZ_IMP_CONTACT.REC_STATUS%TYPE;
39: sDisposition CZ_IMP_CONTACT.DISPOSITION%TYPE;

Line 36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;

32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
37: sThisFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
38: sRecStatus CZ_IMP_CONTACT.REC_STATUS%TYPE;
39: sDisposition CZ_IMP_CONTACT.DISPOSITION%TYPE;
40: /* Internal vars */

Line 37: sThisFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;

33: sThisFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;
34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
37: sThisFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
38: sRecStatus CZ_IMP_CONTACT.REC_STATUS%TYPE;
39: sDisposition CZ_IMP_CONTACT.DISPOSITION%TYPE;
40: /* Internal vars */
41: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 38: sRecStatus CZ_IMP_CONTACT.REC_STATUS%TYPE;

34: sLastFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
37: sThisFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
38: sRecStatus CZ_IMP_CONTACT.REC_STATUS%TYPE;
39: sDisposition CZ_IMP_CONTACT.DISPOSITION%TYPE;
40: /* Internal vars */
41: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
42: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 39: sDisposition CZ_IMP_CONTACT.DISPOSITION%TYPE;

35: sThisFSK2 CZ_IMP_CONTACT.FSK_CUSTOMER_1_1%TYPE;
36: sLastFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
37: sThisFSK3 CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
38: sRecStatus CZ_IMP_CONTACT.REC_STATUS%TYPE;
39: sDisposition CZ_IMP_CONTACT.DISPOSITION%TYPE;
40: /* Internal vars */
41: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
42: nErrorCount PLS_INTEGER:=0; /*Error index */
43: nInsertCount PLS_INTEGER:=0; /*Inserts */

Line 173: UPDATE CZ_IMP_CONTACT SET

169: END IF;
170: END;
171: END IF;
172:
173: UPDATE CZ_IMP_CONTACT SET
174: CONTACT_ID=DECODE(sDISPOSITION,'R',CONTACT_ID,'I', nNextValue+nAllocateCounter, nOnlContactId),
175: CUSTOMER_ID=DECODE(sDISPOSITION,'R',CUSTOMER_ID,nonlcustomerid),
176: ADDRESS_ID=DECODE(sDISPOSITION,'R',ADDRESS_ID,nonladdressid),
177: DISPOSITION=sDisposition, REC_STATUS=sRecStatus