APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_ITEM_TYPE_PROPERTY

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