APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_ITEM_TYPE

Line 418: FROM CZ_IMP_ITEM_TYPE WHERE CZ_IMP_ITEM_TYPE.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

414: DECLARE CURSOR c_xfr_itemtype IS
415: SELECT ITEM_TYPE_ID,DESC_TEXT,NAME,RUN_ID ,REC_STATUS ,DISPOSITION ,DELETED_FLAG ,
416: CHECKOUT_USER, USER_STR01,USER_STR02,USER_STR03,
417: USER_STR04,USER_NUM01,USER_NUM02, USER_NUM03, USER_NUM04,ORIG_SYS_REF,SRC_APPLICATION_ID
418: FROM CZ_IMP_ITEM_TYPE WHERE CZ_IMP_ITEM_TYPE.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
419: x_xfr_itemtype_f BOOLEAN:=FALSE;
420: x_error BOOLEAN:=FALSE;
421:
422: p_xfr_itemtype c_xfr_itemtype%ROWTYPE;

Line 503: UPDATE CZ_IMP_item_type

499: 1, 1, NULL, p_xfr_itemtype.CHECKOUT_USER,
500: p_xfr_itemtype.ORIG_SYS_REF,p_xfr_itemtype.SRC_APPLICATION_ID);
501: nInsertCount:=nInsertCount+1;
502: BEGIN
503: UPDATE CZ_IMP_item_type
504: SET REC_STATUS='OK'
505: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
506: AND DISPOSITION='I';
507: END;

Line 512: UPDATE CZ_IMP_item_type

508: EXCEPTION
509: WHEN OTHERS THEN
510: FAILED:=FAILED +1;
511: BEGIN
512: UPDATE CZ_IMP_item_type
513: SET REC_STATUS='ERR'
514: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
515: AND DISPOSITION='I';
516: END;

Line 544: UPDATE CZ_IMP_item_type

540: FAILED:=FAILED+1;
541: ELSE
542: nUpdateCount:=nUpdateCount+1;
543: BEGIN
544: UPDATE CZ_IMP_item_type
545: SET REC_STATUS='OK'
546: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
547: AND DISPOSITION='M';
548: END;

Line 554: UPDATE CZ_IMP_item_type

550: EXCEPTION
551: WHEN OTHERS THEN
552: FAILED:=FAILED +1;
553: BEGIN
554: UPDATE CZ_IMP_item_type
555: SET REC_STATUS='ERR'
556: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
557: AND DISPOSITION='M';
558: END;

Line 596: FROM CZ_IMP_ITEM_TYPE_PROPERTY

592: USER_NUM02,USER_NUM03, USER_NUM04, ORIG_SYS_REF,
593: NVL(FSK_ITEMTYPE_1_1, FSK_ITEMTYPE_1_EXT) AS FSK_ITEMTYPE,
594: NVL(FSK_PROPERTY_2_1, FSK_PROPERTY_2_EXT) AS FSK_PROPERTY,
595: SRC_APPLICATION_ID
596: FROM CZ_IMP_ITEM_TYPE_PROPERTY
597: WHERE CZ_IMP_ITEM_TYPE_PROPERTY.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
598: x_xfr_itemtypeprop_f BOOLEAN:=FALSE;
599: x_error BOOLEAN:=FALSE;
600:

Line 597: WHERE CZ_IMP_ITEM_TYPE_PROPERTY.RUN_ID = inRUN_ID AND REC_STATUS='PASS';

593: NVL(FSK_ITEMTYPE_1_1, FSK_ITEMTYPE_1_EXT) AS FSK_ITEMTYPE,
594: NVL(FSK_PROPERTY_2_1, FSK_PROPERTY_2_EXT) AS FSK_PROPERTY,
595: SRC_APPLICATION_ID
596: FROM CZ_IMP_ITEM_TYPE_PROPERTY
597: WHERE CZ_IMP_ITEM_TYPE_PROPERTY.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
598: x_xfr_itemtypeprop_f BOOLEAN:=FALSE;
599: x_error BOOLEAN:=FALSE;
600:
601: p_xfr_itemtypeprop c_xfr_itemtypeprop%ROWTYPE;

Line 664: UPDATE CZ_IMP_item_type_property

660: p_xfr_itemtypeprop.USER_STR01,p_xfr_itemtypeprop.USER_STR02,p_xfr_itemtypeprop.USER_STR03,p_xfr_itemtypeprop.USER_STR04,
661: */ SYSDATE, SYSDATE, p_xfr_itemtypeprop.DELETED_FLAG , 1, 1, NULL, sOrigSysRef, p_xfr_itemtypeprop.SRC_APPLICATION_ID);
662: nInsertCount:=nInsertCount+1;
663: BEGIN
664: UPDATE CZ_IMP_item_type_property
665: SET REC_STATUS='OK'
666: WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
667: AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
668: AND DISPOSITION='I';

Line 674: UPDATE CZ_IMP_item_type_property

670: EXCEPTION
671: WHEN OTHERS THEN
672: FAILED:=FAILED +1;
673: BEGIN
674: UPDATE CZ_IMP_item_type_property
675: SET REC_STATUS='ERR'
676: WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
677: AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
678: AND DISPOSITION='I';

Line 708: UPDATE CZ_IMP_item_type_property

704: FAILED:=FAILED+1;
705: ELSE
706: nUpdateCount:=nUpdateCount+1;
707: BEGIN
708: UPDATE CZ_IMP_item_type_property
709: SET REC_STATUS='OK'
710: WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
711: AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
712: AND DISPOSITION='M';

Line 720: UPDATE CZ_IMP_item_type_property

716: EXCEPTION
717: WHEN OTHERS THEN
718: FAILED:=FAILED +1;
719: BEGIN
720: UPDATE CZ_IMP_item_type_property
721: SET REC_STATUS='ERR'
722: WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
723: AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
724: AND DISPOSITION='M';