APPS.CZ_IMP_AC_XFR dependencies on CZ_IMP_ADDRESS

Line 408: SELECT * FROM CZ_IMP_ADDRESS

404: inXFR_GROUP IN VARCHAR2
405: ) IS
406: BEGIN
407: DECLARE CURSOR c_xfr_ADDRESS IS
408: SELECT * FROM CZ_IMP_ADDRESS
409: WHERE CZ_IMP_ADDRESS.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
410: x_xfr_ADDRESS_f BOOLEAN:=FALSE;
411: x_error BOOLEAN:=FALSE;
412: p_xfr_ADDRESS c_xfr_ADDRESS%ROWTYPE;

Line 409: WHERE CZ_IMP_ADDRESS.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

405: ) IS
406: BEGIN
407: DECLARE CURSOR c_xfr_ADDRESS IS
408: SELECT * FROM CZ_IMP_ADDRESS
409: WHERE CZ_IMP_ADDRESS.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
410: x_xfr_ADDRESS_f BOOLEAN:=FALSE;
411: x_error BOOLEAN:=FALSE;
412: p_xfr_ADDRESS c_xfr_ADDRESS%ROWTYPE;
413: -- Internal vars --

Line 490: UPDATE CZ_IMP_address

486: SYSDATE,SYSDATE,1,1,p_xfr_ADDRESS.DELETED_FLAG
487: );
488: nInsertCount:=nInsertCount+1;
489: BEGIN
490: UPDATE CZ_IMP_address
491: SET REC_STATUS='OK'
492: WHERE ADDRESS_ID=p_xfr_address.ADDRESS_ID AND RUN_ID=inRUN_ID;
493: END;
494: EXCEPTION

Line 498: UPDATE CZ_IMP_address

494: EXCEPTION
495: WHEN OTHERS THEN
496: nFailed:=nFailed +1;
497: BEGIN
498: UPDATE CZ_IMP_address
499: SET REC_STATUS='ERR'
500: WHERE ADDRESS_ID=p_xfr_address.ADDRESS_ID AND RUN_ID=inRUN_ID;
501: END;
502: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_ADDRESS',11276);

Line 530: UPDATE CZ_IMP_address

526: nFailed:=nFailed+1;
527: ELSE
528: nUpdateCount:=nUpdateCount+1;
529: BEGIN
530: UPDATE CZ_IMP_address
531: SET REC_STATUS='OK'
532: WHERE ADDRESS_ID=p_xfr_address.ADDRESS_ID AND RUN_ID=inRUN_ID;
533: END;
534: END IF;

Line 539: UPDATE CZ_IMP_address

535: EXCEPTION
536: WHEN OTHERS THEN
537: nFailed:=nFailed +1;
538: BEGIN
539: UPDATE CZ_IMP_address
540: SET REC_STATUS='ERR'
541: WHERE ADDRESS_ID=p_xfr_address.ADDRESS_ID AND RUN_ID=inRUN_ID;
542: END;
543: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_AC_XFR.XFR_ADDRESS',11276);

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);