APPS.CZ_IMP_AC_XFR dependencies on CZ_IMP_CUSTOMER_END_USER

Line 707: SELECT * FROM CZ_IMP_CUSTOMER_END_USER

703: inXFR_GROUP IN VARCHAR2
704: ) IS
705: BEGIN
706: DECLARE CURSOR c_xfr_CUSTOMER_END_USER IS
707: SELECT * FROM CZ_IMP_CUSTOMER_END_USER
708: WHERE CZ_IMP_CUSTOMER_END_USER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
709: x_xfr_CUSTOMER_END_USER_f BOOLEAN:=FALSE;
710: x_error BOOLEAN:=FALSE;
711: p_xfr_CUSTOMER_END_USER c_xfr_CUSTOMER_END_USER%ROWTYPE;

Line 708: WHERE CZ_IMP_CUSTOMER_END_USER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

704: ) IS
705: BEGIN
706: DECLARE CURSOR c_xfr_CUSTOMER_END_USER IS
707: SELECT * FROM CZ_IMP_CUSTOMER_END_USER
708: WHERE CZ_IMP_CUSTOMER_END_USER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
709: x_xfr_CUSTOMER_END_USER_f BOOLEAN:=FALSE;
710: x_error BOOLEAN:=FALSE;
711: p_xfr_CUSTOMER_END_USER c_xfr_CUSTOMER_END_USER%ROWTYPE;
712: -- Internal vars --

Line 759: UPDATE CZ_IMP_customer_end_user

755: p_xfr_CUSTOMER_END_USER.DELETED_FLAG ,
756: SYSDATE,SYSDATE, 1, 1, NULL,p_xfr_CUSTOMER_END_USER.CHECKOUT_USER);
757: nInsertCount:=nInsertCount+1;
758: BEGIN
759: UPDATE CZ_IMP_customer_end_user
760: SET REC_STATUS='OK'
761: WHERE CUSTOMER_ID=p_xfr_customer_end_user.CUSTOMER_ID
762: AND END_USER_ID=p_xfr_CUSTOMER_END_USER.END_USER_ID AND RUN_ID=inRUN_ID;
763: END;

Line 768: UPDATE CZ_IMP_customer_end_user

764: EXCEPTION
765: WHEN OTHERS THEN
766: nFailed:=nFailed +1;
767: BEGIN
768: UPDATE CZ_IMP_customer_end_user
769: SET REC_STATUS='ERR'
770: WHERE CUSTOMER_ID=p_xfr_customer_end_user.CUSTOMER_ID
771: AND END_USER_ID=p_xfr_CUSTOMER_END_USER.END_USER_ID AND RUN_ID=inRUN_ID;
772: END;

Line 793: UPDATE CZ_IMP_customer_end_user

789: nFailed:=nFailed+1;
790: ELSE
791: nUpdateCount:=nUpdateCount+1;
792: BEGIN
793: UPDATE CZ_IMP_customer_end_user
794: SET REC_STATUS='OK'
795: WHERE CUSTOMER_ID=p_xfr_customer_end_user.CUSTOMER_ID
796: AND END_USER_ID=p_xfr_CUSTOMER_END_USER.END_USER_ID AND RUN_ID=inRUN_ID;
797: END;

Line 803: UPDATE CZ_IMP_customer_end_user

799: EXCEPTION
800: WHEN OTHERS THEN
801: nFailed:=nFailed +1;
802: BEGIN
803: UPDATE CZ_IMP_customer_end_user
804: SET REC_STATUS='ERR'
805: WHERE CUSTOMER_ID=p_xfr_customer_end_user.CUSTOMER_ID
806: AND END_USER_ID=p_xfr_CUSTOMER_END_USER.END_USER_ID AND RUN_ID=inRUN_ID;
807: END;