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_CUSTOMER_END_USERS

Line 727: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','DELETED_FLAG',inXFR_GROUP);

723: NOUPDATE_CHECKOUT_USER NUMBER;
724: -- Make sure that the DataSet exists
725: BEGIN
726: -- Get the Update Flags for each column
727: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','DELETED_FLAG',inXFR_GROUP);
728: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATION_DATE',inXFR_GROUP);
729: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATE_DATE',inXFR_GROUP);
730: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATED_BY',inXFR_GROUP);
731: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATED_BY',inXFR_GROUP);

Line 728: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATION_DATE',inXFR_GROUP);

724: -- Make sure that the DataSet exists
725: BEGIN
726: -- Get the Update Flags for each column
727: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','DELETED_FLAG',inXFR_GROUP);
728: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATION_DATE',inXFR_GROUP);
729: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATE_DATE',inXFR_GROUP);
730: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATED_BY',inXFR_GROUP);
731: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATED_BY',inXFR_GROUP);
732: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','SECURITY_MASK',inXFR_GROUP);

Line 729: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATE_DATE',inXFR_GROUP);

725: BEGIN
726: -- Get the Update Flags for each column
727: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','DELETED_FLAG',inXFR_GROUP);
728: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATION_DATE',inXFR_GROUP);
729: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATE_DATE',inXFR_GROUP);
730: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATED_BY',inXFR_GROUP);
731: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATED_BY',inXFR_GROUP);
732: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','SECURITY_MASK',inXFR_GROUP);
733: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CHECKOUT_USER',inXFR_GROUP);

Line 730: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATED_BY',inXFR_GROUP);

726: -- Get the Update Flags for each column
727: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','DELETED_FLAG',inXFR_GROUP);
728: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATION_DATE',inXFR_GROUP);
729: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATE_DATE',inXFR_GROUP);
730: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATED_BY',inXFR_GROUP);
731: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATED_BY',inXFR_GROUP);
732: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','SECURITY_MASK',inXFR_GROUP);
733: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CHECKOUT_USER',inXFR_GROUP);
734:

Line 731: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATED_BY',inXFR_GROUP);

727: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','DELETED_FLAG',inXFR_GROUP);
728: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATION_DATE',inXFR_GROUP);
729: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATE_DATE',inXFR_GROUP);
730: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATED_BY',inXFR_GROUP);
731: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATED_BY',inXFR_GROUP);
732: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','SECURITY_MASK',inXFR_GROUP);
733: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CHECKOUT_USER',inXFR_GROUP);
734:
735: OPEN c_xfr_CUSTOMER_END_USER;

Line 732: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','SECURITY_MASK',inXFR_GROUP);

728: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATION_DATE',inXFR_GROUP);
729: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATE_DATE',inXFR_GROUP);
730: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATED_BY',inXFR_GROUP);
731: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATED_BY',inXFR_GROUP);
732: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','SECURITY_MASK',inXFR_GROUP);
733: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CHECKOUT_USER',inXFR_GROUP);
734:
735: OPEN c_xfr_CUSTOMER_END_USER;
736: LOOP

Line 733: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CHECKOUT_USER',inXFR_GROUP);

729: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATE_DATE',inXFR_GROUP);
730: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CREATED_BY',inXFR_GROUP);
731: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','LAST_UPDATED_BY',inXFR_GROUP);
732: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','SECURITY_MASK',inXFR_GROUP);
733: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_CUSTOMER_END_USERS','CHECKOUT_USER',inXFR_GROUP);
734:
735: OPEN c_xfr_CUSTOMER_END_USER;
736: LOOP
737: IF (nCommitCount>= COMMIT_SIZE) THEN

Line 750: INSERT INTO CZ_CUSTOMER_END_USERS (

746: x_xfr_CUSTOMER_END_USER_f:=c_xfr_CUSTOMER_END_USER%FOUND;
747: EXIT WHEN (NOT x_xfr_CUSTOMER_END_USER_f Or nFailed >= Max_Err);
748: IF (p_xfr_CUSTOMER_END_USER.DISPOSITION = 'I') THEN
749: BEGIN
750: INSERT INTO CZ_CUSTOMER_END_USERS (
751: CUSTOMER_ID,END_USER_ID, DELETED_FLAG,
752: CREATION_DATE,
753: LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY,SECURITY_MASK,CHECKOUT_USER) VALUES
754: (p_xfr_CUSTOMER_END_USER.CUSTOMER_ID,p_xfr_CUSTOMER_END_USER.END_USER_ID,

Line 777: UPDATE CZ_CUSTOMER_END_USERS SET

773: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.XFR_CUSTOMER_END_USER',11276);
774: END ;
775: ELSIF (p_xfr_CUSTOMER_END_USER.DISPOSITION = 'M') THEN
776: BEGIN
777: UPDATE CZ_CUSTOMER_END_USERS SET
778: DELETED_FLAG= DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_CUSTOMER_END_USER.DELETED_FLAG ,DELETED_FLAG),
779: CREATION_DATE= DECODE(NOUPDATE_CREATION_DATE,0,SYSDATE,CREATION_DATE),
780: LAST_UPDATE_DATE= DECODE(NOUPDATE_LAST_UPDATE_DATE,0,SYSDATE,LAST_UPDATE_DATE),
781: CREATED_BY= DECODE(NOUPDATE_CREATED_BY,0,1,CREATED_BY),