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_END_USER_GROUPS

Line 1093: NOUPDATE_DATE_ADDED_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DATE_ADDED_USER',inXFR_GROUP);

1089:
1090: -- Make sure that the DataSet exists
1091: BEGIN
1092: -- Get the Update Flags for each column
1093: NOUPDATE_DATE_ADDED_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DATE_ADDED_USER',inXFR_GROUP);
1094: NOUPDATE_USER_ADDEDBY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','USER_ADDEDBY',inXFR_GROUP);
1095: NOUPDATE_GROUP_PRIORITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','GROUP_PRIORITY',inXFR_GROUP);
1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);
1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);

Line 1094: NOUPDATE_USER_ADDEDBY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','USER_ADDEDBY',inXFR_GROUP);

1090: -- Make sure that the DataSet exists
1091: BEGIN
1092: -- Get the Update Flags for each column
1093: NOUPDATE_DATE_ADDED_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DATE_ADDED_USER',inXFR_GROUP);
1094: NOUPDATE_USER_ADDEDBY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','USER_ADDEDBY',inXFR_GROUP);
1095: NOUPDATE_GROUP_PRIORITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','GROUP_PRIORITY',inXFR_GROUP);
1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);
1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);
1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);

Line 1095: NOUPDATE_GROUP_PRIORITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','GROUP_PRIORITY',inXFR_GROUP);

1091: BEGIN
1092: -- Get the Update Flags for each column
1093: NOUPDATE_DATE_ADDED_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DATE_ADDED_USER',inXFR_GROUP);
1094: NOUPDATE_USER_ADDEDBY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','USER_ADDEDBY',inXFR_GROUP);
1095: NOUPDATE_GROUP_PRIORITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','GROUP_PRIORITY',inXFR_GROUP);
1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);
1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);
1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);
1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);

Line 1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);

1092: -- Get the Update Flags for each column
1093: NOUPDATE_DATE_ADDED_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DATE_ADDED_USER',inXFR_GROUP);
1094: NOUPDATE_USER_ADDEDBY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','USER_ADDEDBY',inXFR_GROUP);
1095: NOUPDATE_GROUP_PRIORITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','GROUP_PRIORITY',inXFR_GROUP);
1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);
1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);
1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);
1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);
1100: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATED_BY',inXFR_GROUP);

Line 1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);

1093: NOUPDATE_DATE_ADDED_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DATE_ADDED_USER',inXFR_GROUP);
1094: NOUPDATE_USER_ADDEDBY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','USER_ADDEDBY',inXFR_GROUP);
1095: NOUPDATE_GROUP_PRIORITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','GROUP_PRIORITY',inXFR_GROUP);
1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);
1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);
1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);
1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);
1100: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATED_BY',inXFR_GROUP);
1101: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','SECURITY_MASK',inXFR_GROUP);

Line 1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);

1094: NOUPDATE_USER_ADDEDBY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','USER_ADDEDBY',inXFR_GROUP);
1095: NOUPDATE_GROUP_PRIORITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','GROUP_PRIORITY',inXFR_GROUP);
1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);
1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);
1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);
1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);
1100: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATED_BY',inXFR_GROUP);
1101: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','SECURITY_MASK',inXFR_GROUP);
1102: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CHECKOUT_USER',inXFR_GROUP);

Line 1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);

1095: NOUPDATE_GROUP_PRIORITY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','GROUP_PRIORITY',inXFR_GROUP);
1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);
1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);
1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);
1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);
1100: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATED_BY',inXFR_GROUP);
1101: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','SECURITY_MASK',inXFR_GROUP);
1102: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CHECKOUT_USER',inXFR_GROUP);
1103:

Line 1100: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATED_BY',inXFR_GROUP);

1096: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','DELETED_FLAG',inXFR_GROUP);
1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);
1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);
1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);
1100: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATED_BY',inXFR_GROUP);
1101: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','SECURITY_MASK',inXFR_GROUP);
1102: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CHECKOUT_USER',inXFR_GROUP);
1103:
1104:

Line 1101: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','SECURITY_MASK',inXFR_GROUP);

1097: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATION_DATE',inXFR_GROUP);
1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);
1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);
1100: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATED_BY',inXFR_GROUP);
1101: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','SECURITY_MASK',inXFR_GROUP);
1102: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CHECKOUT_USER',inXFR_GROUP);
1103:
1104:
1105: OPEN c_xfr_endusergroup;

Line 1102: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CHECKOUT_USER',inXFR_GROUP);

1098: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATE_DATE',inXFR_GROUP);
1099: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CREATED_BY',inXFR_GROUP);
1100: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','LAST_UPDATED_BY',inXFR_GROUP);
1101: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','SECURITY_MASK',inXFR_GROUP);
1102: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_END_USER_GROUPS','CHECKOUT_USER',inXFR_GROUP);
1103:
1104:
1105: OPEN c_xfr_endusergroup;
1106: LOOP

Line 1120: INSERT INTO CZ_END_USER_GROUPS (END_USER_ID,

1116: x_xfr_endusergroup_f:=c_xfr_endusergroup%FOUND;
1117: EXIT WHEN (NOT x_xfr_endusergroup_f Or nFailed >= Max_Err);
1118: IF (p_xfr_endusergroup.DISPOSITION = 'I') THEN
1119: BEGIN
1120: INSERT INTO CZ_END_USER_GROUPS (END_USER_ID,
1121: USER_GROUP_ID,
1122: DATE_ADDED_USER,
1123: USER_ADDEDBY,
1124: GROUP_PRIORITY,

Line 1165: UPDATE CZ_END_USER_GROUPS SET DATE_ADDED_USER=DECODE(NOUPDATE_DATE_ADDED_USER,0,p_xfr_endusergroup.DATE_ADDED_USER,DATE_ADDED_USER),

1161: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_END_USER_GROUP',11276);
1162: END ;
1163: ELSIF (p_xfr_endusergroup.DISPOSITION = 'M') THEN
1164: BEGIN
1165: UPDATE CZ_END_USER_GROUPS SET DATE_ADDED_USER=DECODE(NOUPDATE_DATE_ADDED_USER,0,p_xfr_endusergroup.DATE_ADDED_USER,DATE_ADDED_USER),
1166: USER_ADDEDBY=DECODE(NOUPDATE_USER_ADDEDBY,0,p_xfr_endusergroup.USER_ADDEDBY,USER_ADDEDBY),
1167: GROUP_PRIORITY=DECODE(NOUPDATE_GROUP_PRIORITY,0,p_xfr_endusergroup.GROUP_PRIORITY,GROUP_PRIORITY),
1168: DELETED_FLAG= DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_endusergroup.DELETED_FLAG ,DELETED_FLAG),
1169: CREATION_DATE= DECODE(NOUPDATE_CREATION_DATE,0,SYSDATE,CREATION_DATE),