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_ADDRESS

Line 28: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;

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;
31: sFSKaddress CZ_IMP_CONTACT.FSK_ADDRESS_2_1%TYPE;
32: sLastFSK1 CZ_IMP_CONTACT.ORIG_SYS_REF%TYPE;

Line 427: SELECT ORIG_SYS_REF, FSK_CUSTOMER_1_1, ROWID FROM CZ_IMP_ADDRESS WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY ORIG_SYS_REF,FSK_CUSTOMER_1_1, ROWID;

423: ) IS
424: BEGIN
425: DECLARE
426: CURSOR c_imp_address IS
427: SELECT ORIG_SYS_REF, FSK_CUSTOMER_1_1, ROWID FROM CZ_IMP_ADDRESS WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY ORIG_SYS_REF,FSK_CUSTOMER_1_1, ROWID;
428: /* cursor's data found indicators */
429: nOnlADDRESSId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
430: nOnlFSKCUSTOMERID CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;

Line 429: nOnlADDRESSId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;

425: DECLARE
426: CURSOR c_imp_address IS
427: SELECT ORIG_SYS_REF, FSK_CUSTOMER_1_1, ROWID FROM CZ_IMP_ADDRESS WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY ORIG_SYS_REF,FSK_CUSTOMER_1_1, ROWID;
428: /* cursor's data found indicators */
429: nOnlADDRESSId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
430: nOnlFSKCUSTOMERID CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;
432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;

Line 430: nOnlFSKCUSTOMERID CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;

426: CURSOR c_imp_address IS
427: SELECT ORIG_SYS_REF, FSK_CUSTOMER_1_1, ROWID FROM CZ_IMP_ADDRESS WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY ORIG_SYS_REF,FSK_CUSTOMER_1_1, ROWID;
428: /* cursor's data found indicators */
429: nOnlADDRESSId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
430: nOnlFSKCUSTOMERID CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;
432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
434: sThisFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;

Line 431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;

427: SELECT ORIG_SYS_REF, FSK_CUSTOMER_1_1, ROWID FROM CZ_IMP_ADDRESS WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY ORIG_SYS_REF,FSK_CUSTOMER_1_1, ROWID;
428: /* cursor's data found indicators */
429: nOnlADDRESSId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
430: nOnlFSKCUSTOMERID CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;
432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
434: sThisFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
435: sRecStatus CZ_IMP_ADDRESS.REC_STATUS%TYPE;

Line 432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;

428: /* cursor's data found indicators */
429: nOnlADDRESSId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
430: nOnlFSKCUSTOMERID CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;
432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
434: sThisFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
435: sRecStatus CZ_IMP_ADDRESS.REC_STATUS%TYPE;
436: sDisposition CZ_IMP_ADDRESS.DISPOSITION%TYPE;

Line 433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;

429: nOnlADDRESSId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
430: nOnlFSKCUSTOMERID CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;
432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
434: sThisFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
435: sRecStatus CZ_IMP_ADDRESS.REC_STATUS%TYPE;
436: sDisposition CZ_IMP_ADDRESS.DISPOSITION%TYPE;
437: /* Column Vars */

Line 434: sThisFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;

430: nOnlFSKCUSTOMERID CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;
432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
434: sThisFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
435: sRecStatus CZ_IMP_ADDRESS.REC_STATUS%TYPE;
436: sDisposition CZ_IMP_ADDRESS.DISPOSITION%TYPE;
437: /* Column Vars */
438: x_imp_address_f BOOLEAN:=FALSE;

Line 435: sRecStatus CZ_IMP_ADDRESS.REC_STATUS%TYPE;

431: sImpOrigSysRef CZ_IMP_ADDRESS.ORIG_SYS_REF%TYPE;
432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
434: sThisFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
435: sRecStatus CZ_IMP_ADDRESS.REC_STATUS%TYPE;
436: sDisposition CZ_IMP_ADDRESS.DISPOSITION%TYPE;
437: /* Column Vars */
438: x_imp_address_f BOOLEAN:=FALSE;
439: x_onl_address_f BOOLEAN:=FALSE;

Line 436: sDisposition CZ_IMP_ADDRESS.DISPOSITION%TYPE;

432: sFSKCUSTOMER11 CZ_IMP_ADDRESS.FSK_CUSTOMER_1_1%TYPE;
433: sLastFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
434: sThisFSK1 CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
435: sRecStatus CZ_IMP_ADDRESS.REC_STATUS%TYPE;
436: sDisposition CZ_IMP_ADDRESS.DISPOSITION%TYPE;
437: /* Column Vars */
438: x_imp_address_f BOOLEAN:=FALSE;
439: x_onl_address_f BOOLEAN:=FALSE;
440: x_onl_CUSTOMER_CUSTOMERid_f BOOLEAN:=FALSE;

Line 548: UPDATE CZ_IMP_ADDRESS SET ADDRESS_ID=DECODE(sDISPOSITION,

544: END;
545: END IF;
546: END;
547: END IF;
548: UPDATE CZ_IMP_ADDRESS SET ADDRESS_ID=DECODE(sDISPOSITION,
549: 'R',ADDRESS_ID,'I',nNextValue+nAllocateCounter,
550: nOnlADDRESSId),
551: CUSTOMER_ID=DECODE(sDISPOSITION,'R',CUSTOMER_ID,
552: nOnlFSKCUSTOMERId),DISPOSITION=sDisposition, REC_STATUS=sRecStatus

Line 589: FROM CZ_IMP_ADDRESS_USE

585: BEGIN
586: DECLARE
587: CURSOR c_imp_address_uses IS
588: SELECT orig_sys_ref, fsk_address_1_1, ROWID
589: FROM CZ_IMP_ADDRESS_USE
590: WHERE rec_status IS NULL AND Run_ID = inRUN_ID
591: ORDER BY orig_sys_ref, fsk_address_1_1, ROWID;
592:
593: /* cursor's data found indicator */

Line 599: nOnladdressusesId CZ_IMP_ADDRESS_USE.ADDRESS_USE_ID%TYPE;

595: x_onl_address_uses_f BOOLEAN:=FALSE;
596: x_onl_address_addressid_f BOOLEAN:=FALSE;
597: x_error BOOLEAN:=FALSE;
598:
599: nOnladdressusesId CZ_IMP_ADDRESS_USE.ADDRESS_USE_ID%TYPE;
600: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
601: sImpOrigSysRef CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;
603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;

Line 600: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;

596: x_onl_address_addressid_f BOOLEAN:=FALSE;
597: x_error BOOLEAN:=FALSE;
598:
599: nOnladdressusesId CZ_IMP_ADDRESS_USE.ADDRESS_USE_ID%TYPE;
600: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
601: sImpOrigSysRef CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;
603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
604: sLastFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;

Line 601: sImpOrigSysRef CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;

597: x_error BOOLEAN:=FALSE;
598:
599: nOnladdressusesId CZ_IMP_ADDRESS_USE.ADDRESS_USE_ID%TYPE;
600: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
601: sImpOrigSysRef CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;
603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
604: sLastFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
605: sRecStatus CZ_IMP_ADDRESS_USE.REC_STATUS%TYPE;

Line 602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;

598:
599: nOnladdressusesId CZ_IMP_ADDRESS_USE.ADDRESS_USE_ID%TYPE;
600: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
601: sImpOrigSysRef CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;
603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
604: sLastFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
605: sRecStatus CZ_IMP_ADDRESS_USE.REC_STATUS%TYPE;
606: sDisposition CZ_IMP_ADDRESS_USE.DISPOSITION%TYPE;

Line 603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;

599: nOnladdressusesId CZ_IMP_ADDRESS_USE.ADDRESS_USE_ID%TYPE;
600: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
601: sImpOrigSysRef CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;
603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
604: sLastFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
605: sRecStatus CZ_IMP_ADDRESS_USE.REC_STATUS%TYPE;
606: sDisposition CZ_IMP_ADDRESS_USE.DISPOSITION%TYPE;
607:

Line 604: sLastFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;

600: nOnladdressId CZ_IMP_ADDRESS.ADDRESS_ID%TYPE;
601: sImpOrigSysRef CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;
603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
604: sLastFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
605: sRecStatus CZ_IMP_ADDRESS_USE.REC_STATUS%TYPE;
606: sDisposition CZ_IMP_ADDRESS_USE.DISPOSITION%TYPE;
607:
608: /* Internal vars */

Line 605: sRecStatus CZ_IMP_ADDRESS_USE.REC_STATUS%TYPE;

601: sImpOrigSysRef CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;
603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
604: sLastFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
605: sRecStatus CZ_IMP_ADDRESS_USE.REC_STATUS%TYPE;
606: sDisposition CZ_IMP_ADDRESS_USE.DISPOSITION%TYPE;
607:
608: /* Internal vars */
609: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 606: sDisposition CZ_IMP_ADDRESS_USE.DISPOSITION%TYPE;

602: sFSKaddress CZ_IMP_ADDRESS_USE.FSK_ADDRESS_1_1%TYPE;
603: sThisFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
604: sLastFSK1 CZ_IMP_ADDRESS_USE.ORIG_SYS_REF%TYPE;
605: sRecStatus CZ_IMP_ADDRESS_USE.REC_STATUS%TYPE;
606: sDisposition CZ_IMP_ADDRESS_USE.DISPOSITION%TYPE;
607:
608: /* Internal vars */
609: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
610: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 719: UPDATE CZ_IMP_ADDRESS_USE SET

715: END IF;
716: END;
717: END IF;
718:
719: UPDATE CZ_IMP_ADDRESS_USE SET
720: ADDRESS_USE_ID=DECODE(sDisposition,'R',ADDRESS_USE_ID,'I',nNextValue+nAllocateCounter,nOnladdressusesId),
721: ADDRESS_ID=DECODE(sDisposition,'R',ADDRESS_ID,nOnladdressid),
722: DISPOSITION=sDisposition,
723: REC_STATUS=sRecStatus