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_CUSTOMER_END_USER

Line 764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;

760: ) IS
761: BEGIN
762: DECLARE
763: CURSOR c_imp_CUSTOMERenduser(x_usesurr_enduser PLS_INTEGER) IS
764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;
765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;

Line 766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;

762: DECLARE
763: CURSOR c_imp_CUSTOMERenduser(x_usesurr_enduser PLS_INTEGER) IS
764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;
765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;

Line 767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

763: CURSOR c_imp_CUSTOMERenduser(x_usesurr_enduser PLS_INTEGER) IS
764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;
765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;

Line 768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;

764: SELECT FSK_CUSTOMER_1_1,DECODE(x_usesurr_enduser,0,FSK_ENDUSER_2_1,1,FSK_ENDUSER_2_EXT), ROWID FROM CZ_IMP_CUSTOMER_END_USER WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1,2, ROWID;
765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

Line 769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;

765: /* cursor's data found indicators */
766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

Line 770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;

766: sFSKCUSTOMER CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;

Line 771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;

767: sFskEndUser CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;

Line 772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

768: nOnlCUSTOMERId CZ_IMP_CUSTOMER_END_USER.CUSTOMER_ID%TYPE;
769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;
776: /* Column Vars */

Line 773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;

769: nOnlEndUserId CZ_IMP_CUSTOMER_END_USER.END_USER_ID%TYPE;
770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;
776: /* Column Vars */
777: x_imp_CUSTOMERenduser_f BOOLEAN:=FALSE;

Line 774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;

770: sLastFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;
776: /* Column Vars */
777: x_imp_CUSTOMERenduser_f BOOLEAN:=FALSE;
778: x_onl_CUSTOMER_CUSTOMERid_f BOOLEAN:=FALSE;

Line 775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;

771: sThisFSK1 CZ_IMP_CUSTOMER_END_USER.FSK_CUSTOMER_1_1%TYPE;
772: sLastFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
773: sThisFSK2 CZ_IMP_CUSTOMER_END_USER.FSK_ENDUSER_2_1%TYPE;
774: sRecStatus CZ_IMP_CUSTOMER_END_USER.REC_STATUS%TYPE;
775: sDisposition CZ_IMP_CUSTOMER_END_USER.DISPOSITION%TYPE;
776: /* Column Vars */
777: x_imp_CUSTOMERenduser_f BOOLEAN:=FALSE;
778: x_onl_CUSTOMER_CUSTOMERid_f BOOLEAN:=FALSE;
779: x_onl_enduser_enduserid_f BOOLEAN:=FALSE;

Line 896: UPDATE CZ_IMP_CUSTOMER_END_USER

892: END IF;
893: END;
894: END IF;
895:
896: UPDATE CZ_IMP_CUSTOMER_END_USER
897: SET CUSTOMER_ID=DECODE(sDISPOSITION,'R',CUSTOMER_ID,nOnlCUSTOMERId),
898: END_USER_ID=DECODE(sDISPOSITION,'R',END_USER_ID,nOnlendUserId),
899: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
900: WHERE ROWID = thisRowId;