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_USE

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 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