APPS.CZ_IMP_IM_XFR dependencies on CZ_IMP_ITEM_TYPE

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

440: DECLARE CURSOR c_xfr_itemtype IS
441: SELECT ITEM_TYPE_ID,DESC_TEXT,NAME,RUN_ID ,REC_STATUS ,DISPOSITION ,DELETED_FLAG ,
442: CHECKOUT_USER, USER_STR01,USER_STR02,USER_STR03,
443: USER_STR04,USER_NUM01,USER_NUM02, USER_NUM03, USER_NUM04,ORIG_SYS_REF,SRC_APPLICATION_ID
444: FROM CZ_IMP_ITEM_TYPE WHERE CZ_IMP_ITEM_TYPE.RUN_ID = inRUN_ID AND REC_STATUS='PASS';
445: x_xfr_itemtype_f BOOLEAN:=FALSE;
446: x_error BOOLEAN:=FALSE;
447:
448: p_xfr_itemtype c_xfr_itemtype%ROWTYPE;

Line 530: UPDATE CZ_IMP_item_type

526: 1, 1, NULL, p_xfr_itemtype.CHECKOUT_USER,
527: p_xfr_itemtype.ORIG_SYS_REF,p_xfr_itemtype.SRC_APPLICATION_ID);
528: nInsertCount:=nInsertCount+1;
529: BEGIN
530: UPDATE CZ_IMP_item_type
531: SET REC_STATUS='OK'
532: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
533: AND DISPOSITION='I';
534: END;

Line 539: UPDATE CZ_IMP_item_type

535: EXCEPTION
536: WHEN OTHERS THEN
537: FAILED:=FAILED +1;
538: BEGIN
539: UPDATE CZ_IMP_item_type
540: SET REC_STATUS='ERR'
541: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
542: AND DISPOSITION='I';
543: END;

Line 571: UPDATE CZ_IMP_item_type

567: FAILED:=FAILED+1;
568: ELSE
569: nUpdateCount:=nUpdateCount+1;
570: BEGIN
571: UPDATE CZ_IMP_item_type
572: SET REC_STATUS='OK'
573: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
574: AND DISPOSITION='M';
575: END;

Line 581: UPDATE CZ_IMP_item_type

577: EXCEPTION
578: WHEN OTHERS THEN
579: FAILED:=FAILED +1;
580: BEGIN
581: UPDATE CZ_IMP_item_type
582: SET REC_STATUS='ERR'
583: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
584: AND DISPOSITION='M';
585: END;

Line 590: UPDATE CZ_IMP_item_type

586: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_XFR.XFR_ITEM_TYPE',11276,inRUN_ID);
587: END ;
588:
589: ELSIF (p_xfr_itemtype.DISPOSITION = 'N') THEN
590: UPDATE CZ_IMP_item_type
591: SET REC_STATUS='OK'
592: WHERE ITEM_TYPE_ID=p_xfr_itemtype.ITEM_TYPE_ID AND RUN_ID=inRUN_ID
593: AND DISPOSITION='N';
594:

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