APPS.CZ_IMP_AC_XFR dependencies on CZ_IMP_CUSTOMER

Line 226: FROM CZ_IMP_CUSTOMER

222: ) IS
223: BEGIN
224: DECLARE CURSOR c_xfr_CUSTOMER IS
225: SELECT *
226: FROM CZ_IMP_CUSTOMER
227: WHERE CZ_IMP_CUSTOMER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
228: x_xfr_CUSTOMER_f BOOLEAN:=FALSE;
229: x_error BOOLEAN:=FALSE;
230: p_xfr_CUSTOMER c_xfr_CUSTOMER%ROWTYPE;

Line 227: WHERE CZ_IMP_CUSTOMER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

223: BEGIN
224: DECLARE CURSOR c_xfr_CUSTOMER IS
225: SELECT *
226: FROM CZ_IMP_CUSTOMER
227: WHERE CZ_IMP_CUSTOMER.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
228: x_xfr_CUSTOMER_f BOOLEAN:=FALSE;
229: x_error BOOLEAN:=FALSE;
230: p_xfr_CUSTOMER c_xfr_CUSTOMER%ROWTYPE;
231: -- Internal vars --

Line 324: UPDATE CZ_IMP_customer

320: p_xfr_CUSTOMER.CHECKOUT_USER,p_xfr_CUSTOMER.WAREHOUSE_ID/*,
321: p_xfr_CUSTOMER.PRICE_LIST_ID*/);
322: nInsertCount:=nInsertCount+1;
323: BEGIN
324: UPDATE CZ_IMP_customer
325: SET REC_STATUS='OK'
326: WHERE CUSTOMER_ID=p_xfr_customer.CUSTOMER_ID AND RUN_ID=inRUN_ID;
327: END;
328: EXCEPTION

Line 332: UPDATE CZ_IMP_customer

328: EXCEPTION
329: WHEN OTHERS THEN
330: nFailed:=nFailed +1;
331: BEGIN
332: UPDATE CZ_IMP_customer
333: SET REC_STATUS='ERR'
334: WHERE CUSTOMER_ID=p_xfr_customer.CUSTOMER_ID AND RUN_ID=inRUN_ID;
335: END;
336: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_CUSTOMER',11276);

Line 370: UPDATE CZ_IMP_customer

366: nFailed:=nFailed+1;
367: ELSE
368: nUpdateCount:=nUpdateCount+1;
369: BEGIN
370: UPDATE CZ_IMP_customer
371: SET REC_STATUS='OK'
372: WHERE CUSTOMER_ID=p_xfr_customer.CUSTOMER_ID AND RUN_ID=inRUN_ID;
373: END;
374: END IF;

Line 379: UPDATE CZ_IMP_customer

375: EXCEPTION
376: WHEN OTHERS THEN
377: nFailed:=nFailed +1;
378: BEGIN
379: UPDATE CZ_IMP_customer
380: SET REC_STATUS='ERR'
381: WHERE CUSTOMER_ID=p_xfr_customer.CUSTOMER_ID AND RUN_ID=inRUN_ID;
382: END;
383: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_CUSTOMER',11276);

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;