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_END_USER_GROUP

Line 1093: FROM CZ_IMP_END_USER_GROUP

1089: DECLARE
1090: CURSOR c_imp_endusergroup (x_usesurr_enduser PLS_INTEGER,
1091: x_usesurr_usergroup PLS_INTEGER) IS
1092: SELECT DECODE(x_usesurr_enduser,0,FSK_ENDUSER_1_1,1,FSK_ENDUSER_1_EXT),DECODE(x_usesurr_usergroup,0,FSK_USERGROUP_2_1,1,FSK_USERGROUP_2_EXT), ROWID
1093: FROM CZ_IMP_END_USER_GROUP
1094: WHERE REC_STATUS IS NULL AND RUN_ID=inRUN_ID ORDER BY 1,2,ROWID;
1095:
1096: /* cursor's data found indicators */
1097: nOnlFSKUserId CZ_IMP_END_USER_GROUP.END_USER_ID%TYPE;

Line 1097: nOnlFSKUserId CZ_IMP_END_USER_GROUP.END_USER_ID%TYPE;

1093: FROM CZ_IMP_END_USER_GROUP
1094: WHERE REC_STATUS IS NULL AND RUN_ID=inRUN_ID ORDER BY 1,2,ROWID;
1095:
1096: /* cursor's data found indicators */
1097: nOnlFSKUserId CZ_IMP_END_USER_GROUP.END_USER_ID%TYPE;
1098: nOnlFSKGroupId CZ_IMP_END_USER_GROUP.USER_GROUP_ID%TYPE;
1099: sFSKENDUSER CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;

Line 1098: nOnlFSKGroupId CZ_IMP_END_USER_GROUP.USER_GROUP_ID%TYPE;

1094: WHERE REC_STATUS IS NULL AND RUN_ID=inRUN_ID ORDER BY 1,2,ROWID;
1095:
1096: /* cursor's data found indicators */
1097: nOnlFSKUserId CZ_IMP_END_USER_GROUP.END_USER_ID%TYPE;
1098: nOnlFSKGroupId CZ_IMP_END_USER_GROUP.USER_GROUP_ID%TYPE;
1099: sFSKENDUSER CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;

Line 1099: sFSKENDUSER CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;

1095:
1096: /* cursor's data found indicators */
1097: nOnlFSKUserId CZ_IMP_END_USER_GROUP.END_USER_ID%TYPE;
1098: nOnlFSKGroupId CZ_IMP_END_USER_GROUP.USER_GROUP_ID%TYPE;
1099: sFSKENDUSER CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;

Line 1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;

1096: /* cursor's data found indicators */
1097: nOnlFSKUserId CZ_IMP_END_USER_GROUP.END_USER_ID%TYPE;
1098: nOnlFSKGroupId CZ_IMP_END_USER_GROUP.USER_GROUP_ID%TYPE;
1099: sFSKENDUSER CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1104: sThisFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;

Line 1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;

1097: nOnlFSKUserId CZ_IMP_END_USER_GROUP.END_USER_ID%TYPE;
1098: nOnlFSKGroupId CZ_IMP_END_USER_GROUP.USER_GROUP_ID%TYPE;
1099: sFSKENDUSER CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1104: sThisFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1105: sRecStatus CZ_IMP_END_USER_GROUP.REC_STATUS%TYPE;

Line 1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;

1098: nOnlFSKGroupId CZ_IMP_END_USER_GROUP.USER_GROUP_ID%TYPE;
1099: sFSKENDUSER CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1104: sThisFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1105: sRecStatus CZ_IMP_END_USER_GROUP.REC_STATUS%TYPE;
1106: sDisposition CZ_IMP_END_USER_GROUP.DISPOSITION%TYPE;

Line 1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;

1099: sFSKENDUSER CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1104: sThisFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1105: sRecStatus CZ_IMP_END_USER_GROUP.REC_STATUS%TYPE;
1106: sDisposition CZ_IMP_END_USER_GROUP.DISPOSITION%TYPE;
1107: /* Column Vars */

Line 1104: sThisFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;

1100: sFSKUSERGROUP CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1104: sThisFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1105: sRecStatus CZ_IMP_END_USER_GROUP.REC_STATUS%TYPE;
1106: sDisposition CZ_IMP_END_USER_GROUP.DISPOSITION%TYPE;
1107: /* Column Vars */
1108: x_imp_endusergroup_f BOOLEAN:=FALSE;

Line 1105: sRecStatus CZ_IMP_END_USER_GROUP.REC_STATUS%TYPE;

1101: sLastFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1104: sThisFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1105: sRecStatus CZ_IMP_END_USER_GROUP.REC_STATUS%TYPE;
1106: sDisposition CZ_IMP_END_USER_GROUP.DISPOSITION%TYPE;
1107: /* Column Vars */
1108: x_imp_endusergroup_f BOOLEAN:=FALSE;
1109: x_onl_endusergroup_f BOOLEAN:=FALSE;

Line 1106: sDisposition CZ_IMP_END_USER_GROUP.DISPOSITION%TYPE;

1102: sThisFSK1 CZ_IMP_END_USER_GROUP.FSK_ENDUSER_1_1%TYPE;
1103: sLastFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1104: sThisFSK2 CZ_IMP_END_USER_GROUP.FSK_USERGROUP_2_1%TYPE;
1105: sRecStatus CZ_IMP_END_USER_GROUP.REC_STATUS%TYPE;
1106: sDisposition CZ_IMP_END_USER_GROUP.DISPOSITION%TYPE;
1107: /* Column Vars */
1108: x_imp_endusergroup_f BOOLEAN:=FALSE;
1109: x_onl_endusergroup_f BOOLEAN:=FALSE;
1110: x_onl_enduser_userid_f BOOLEAN:=FALSE;

Line 1231: UPDATE CZ_IMP_END_USER_GROUP SET

1227: END;
1228: END IF;
1229:
1230:
1231: UPDATE CZ_IMP_END_USER_GROUP SET
1232: END_USER_ID=DECODE(sDISPOSITION,'R',END_USER_ID,nOnlFSKUserId),
1233: USER_GROUP_ID=DECODE(sDISPOSITION,'R',USER_GROUP_ID,nOnlFSKGroupId),
1234: DISPOSITION=sDisposition,
1235: REC_STATUS=sRecStatus