APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_ITEM_TYPE_PROPERTY

Line 634: FROM CZ_IMP_ITEM_TYPE_PROPERTY

630: USER_NUM02,USER_NUM03, USER_NUM04, ORIG_SYS_REF,
631: NVL(FSK_ITEMTYPE_1_1, FSK_ITEMTYPE_1_EXT) AS FSK_ITEMTYPE,
632: NVL(FSK_PROPERTY_2_1, FSK_PROPERTY_2_EXT) AS FSK_PROPERTY,
633: SRC_APPLICATION_ID
634: FROM CZ_IMP_ITEM_TYPE_PROPERTY
635: WHERE CZ_IMP_ITEM_TYPE_PROPERTY.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
636: x_xfr_itemtypeprop_f BOOLEAN:=FALSE;
637: x_error BOOLEAN:=FALSE;
638:

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

631: NVL(FSK_ITEMTYPE_1_1, FSK_ITEMTYPE_1_EXT) AS FSK_ITEMTYPE,
632: NVL(FSK_PROPERTY_2_1, FSK_PROPERTY_2_EXT) AS FSK_PROPERTY,
633: SRC_APPLICATION_ID
634: FROM CZ_IMP_ITEM_TYPE_PROPERTY
635: WHERE CZ_IMP_ITEM_TYPE_PROPERTY.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
636: x_xfr_itemtypeprop_f BOOLEAN:=FALSE;
637: x_error BOOLEAN:=FALSE;
638:
639: p_xfr_itemtypeprop c_xfr_itemtypeprop%ROWTYPE;

Line 702: UPDATE CZ_IMP_item_type_property

698: p_xfr_itemtypeprop.USER_STR01,p_xfr_itemtypeprop.USER_STR02,p_xfr_itemtypeprop.USER_STR03,p_xfr_itemtypeprop.USER_STR04,
699: */ SYSDATE, SYSDATE, p_xfr_itemtypeprop.DELETED_FLAG , 1, 1, NULL, sOrigSysRef, p_xfr_itemtypeprop.SRC_APPLICATION_ID);
700: nInsertCount:=nInsertCount+1;
701: BEGIN
702: UPDATE CZ_IMP_item_type_property
703: SET REC_STATUS='OK'
704: WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
705: AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
706: AND DISPOSITION='I';

Line 712: UPDATE CZ_IMP_item_type_property

708: EXCEPTION
709: WHEN OTHERS THEN
710: FAILED:=FAILED +1;
711: BEGIN
712: UPDATE CZ_IMP_item_type_property
713: SET REC_STATUS='ERR'
714: WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
715: AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
716: AND DISPOSITION='I';

Line 746: UPDATE CZ_IMP_item_type_property

742: FAILED:=FAILED+1;
743: ELSE
744: nUpdateCount:=nUpdateCount+1;
745: BEGIN
746: UPDATE CZ_IMP_item_type_property
747: SET REC_STATUS='OK'
748: WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
749: AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
750: AND DISPOSITION='M';

Line 758: UPDATE CZ_IMP_item_type_property

754: EXCEPTION
755: WHEN OTHERS THEN
756: FAILED:=FAILED +1;
757: BEGIN
758: UPDATE CZ_IMP_item_type_property
759: SET REC_STATUS='ERR'
760: WHERE ITEM_TYPE_ID=p_xfr_itemtypeprop.ITEM_TYPE_ID
761: AND PROPERTY_ID=p_xfr_itemtypeprop.PROPERTY_ID AND RUN_ID=inRUN_ID
762: AND DISPOSITION='M';