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_XFR dependencies on CZ_ADDRESS_USES

Line 595: NOUPDATE_SITE_USE_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','SITE_USER_CODE',inXFR_GROUP);

591:
592: -- Make sure that the DataSet exists
593: BEGIN
594: -- Get the Update Flags for each column
595: NOUPDATE_SITE_USE_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','SITE_USER_CODE',inXFR_GROUP);
596: NOUPDATE_ADDRESS_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ADDRESS_ID',inXFR_GROUP);
597: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','WAREHOUSE_ID',inXFR_GROUP);
598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);
599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);

Line 596: NOUPDATE_ADDRESS_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ADDRESS_ID',inXFR_GROUP);

592: -- Make sure that the DataSet exists
593: BEGIN
594: -- Get the Update Flags for each column
595: NOUPDATE_SITE_USE_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','SITE_USER_CODE',inXFR_GROUP);
596: NOUPDATE_ADDRESS_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ADDRESS_ID',inXFR_GROUP);
597: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','WAREHOUSE_ID',inXFR_GROUP);
598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);
599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);
600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);

Line 597: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','WAREHOUSE_ID',inXFR_GROUP);

593: BEGIN
594: -- Get the Update Flags for each column
595: NOUPDATE_SITE_USE_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','SITE_USER_CODE',inXFR_GROUP);
596: NOUPDATE_ADDRESS_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ADDRESS_ID',inXFR_GROUP);
597: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','WAREHOUSE_ID',inXFR_GROUP);
598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);
599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);
600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);
601: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATED_BY',inXFR_GROUP);

Line 598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);

594: -- Get the Update Flags for each column
595: NOUPDATE_SITE_USE_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','SITE_USER_CODE',inXFR_GROUP);
596: NOUPDATE_ADDRESS_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ADDRESS_ID',inXFR_GROUP);
597: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','WAREHOUSE_ID',inXFR_GROUP);
598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);
599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);
600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);
601: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATED_BY',inXFR_GROUP);
602: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATED_BY',inXFR_GROUP);

Line 599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);

595: NOUPDATE_SITE_USE_CODE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','SITE_USER_CODE',inXFR_GROUP);
596: NOUPDATE_ADDRESS_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ADDRESS_ID',inXFR_GROUP);
597: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','WAREHOUSE_ID',inXFR_GROUP);
598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);
599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);
600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);
601: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATED_BY',inXFR_GROUP);
602: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATED_BY',inXFR_GROUP);
603: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','DELETED_FLAG',inXFR_GROUP);

Line 600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);

596: NOUPDATE_ADDRESS_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ADDRESS_ID',inXFR_GROUP);
597: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','WAREHOUSE_ID',inXFR_GROUP);
598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);
599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);
600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);
601: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATED_BY',inXFR_GROUP);
602: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATED_BY',inXFR_GROUP);
603: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','DELETED_FLAG',inXFR_GROUP);
604:

Line 601: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATED_BY',inXFR_GROUP);

597: NOUPDATE_WAREHOUSE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','WAREHOUSE_ID',inXFR_GROUP);
598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);
599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);
600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);
601: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATED_BY',inXFR_GROUP);
602: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATED_BY',inXFR_GROUP);
603: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','DELETED_FLAG',inXFR_GROUP);
604:
605: OPEN c_xfr_address_uses;

Line 602: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATED_BY',inXFR_GROUP);

598: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','ORIG_SYS_REF',inXFR_GROUP);
599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);
600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);
601: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATED_BY',inXFR_GROUP);
602: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATED_BY',inXFR_GROUP);
603: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','DELETED_FLAG',inXFR_GROUP);
604:
605: OPEN c_xfr_address_uses;
606: LOOP

Line 603: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','DELETED_FLAG',inXFR_GROUP);

599: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATION_DATE',inXFR_GROUP);
600: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATE_DATE',inXFR_GROUP);
601: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','CREATED_BY',inXFR_GROUP);
602: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','LAST_UPDATED_BY',inXFR_GROUP);
603: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_ADDRESS_USES','DELETED_FLAG',inXFR_GROUP);
604:
605: OPEN c_xfr_address_uses;
606: LOOP
607: IF(nCommitCount>= COMMIT_SIZE) THEN

Line 622: INSERT INTO cz_address_uses (address_use_id, address_id, site_user_code,

618: EXIT WHEN (NOT x_xfr_address_uses_f OR nFailed >= Max_Err);
619:
620: IF(p_xfr_address_uses.disposition = 'I') THEN
621: BEGIN
622: INSERT INTO cz_address_uses (address_use_id, address_id, site_user_code,
623: warehouse_id, orig_sys_ref, CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY,
624: deleted_flag)
625: VALUES
626: (p_xfr_address_uses.address_use_id,

Line 651: UPDATE cz_address_uses SET

647: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_ADDRESS_USES',11276);
648: END ;
649: ELSIF(p_xfr_address_uses.disposition = 'M') THEN
650: BEGIN
651: UPDATE cz_address_uses SET
652: address_id=DECODE(NOUPDATE_ADDRESS_ID,0,p_xfr_address_uses.address_id ,address_id),
653: site_user_code=DECODE(NOUPDATE_SITE_USE_CODE,0,p_xfr_address_uses.site_use_code,site_user_code),
654: warehouse_id=DECODE(NOUPDATE_WAREHOUSE_ID,0,p_xfr_address_uses.warehouse_id,warehouse_id),
655: orig_sys_ref=DECODE(NOUPDATE_ORIG_SYS_REF,0,p_xfr_address_uses.orig_sys_ref,orig_sys_ref),