APPS.CZ_IMP_AC_XFR dependencies on CZ_IMP_ADDRESS_USE

Line 569: SELECT * FROM CZ_IMP_ADDRESS_USE

565: ) IS
566: BEGIN
567: DECLARE
568: CURSOR c_xfr_address_uses IS
569: SELECT * FROM CZ_IMP_ADDRESS_USE
570: WHERE Run_ID=inRUN_ID AND rec_status='PASS';
571:
572: x_xfr_address_uses_f BOOLEAN:=FALSE;
573: x_error BOOLEAN:=FALSE;

Line 635: UPDATE CZ_IMP_address_use

631: sysdate, sysdate, 1, 1,
632: p_xfr_address_uses.deleted_flag);
633: nInsertCount:=nInsertCount+1;
634: BEGIN
635: UPDATE CZ_IMP_address_use
636: SET REC_STATUS='OK'
637: WHERE ADDRESS_USE_ID=p_xfr_address_uses.ADDRESS_USE_ID AND RUN_ID=inRUN_ID;
638: END;
639: EXCEPTION

Line 643: UPDATE CZ_IMP_address_use

639: EXCEPTION
640: WHEN OTHERS THEN
641: nFailed:=nFailed +1;
642: BEGIN
643: UPDATE CZ_IMP_address_use
644: SET REC_STATUS='ERR'
645: WHERE ADDRESS_USE_ID=p_xfr_address_uses.ADDRESS_USE_ID AND RUN_ID=inRUN_ID;
646: END;
647: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_ADDRESS_USES',11276);

Line 668: UPDATE CZ_IMP_address_use

664: nFailed:=nFailed+1;
665: ELSE
666: nUpdateCount:=nUpdateCount+1;
667: BEGIN
668: UPDATE CZ_IMP_address_use
669: SET REC_STATUS='OK'
670: WHERE ADDRESS_USE_ID=p_xfr_address_uses.ADDRESS_USE_ID AND RUN_ID=inRUN_ID;
671: END;
672: END IF;

Line 677: UPDATE CZ_IMP_address_use

673: EXCEPTION
674: WHEN OTHERS THEN
675: nFailed:=nFailed +1;
676: BEGIN
677: UPDATE CZ_IMP_address_use
678: SET REC_STATUS='ERR'
679: WHERE ADDRESS_USE_ID=p_xfr_address_uses.ADDRESS_USE_ID AND RUN_ID=inRUN_ID;
680: END;
681: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_ADDRESS_USES',11276);