eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_IM_KRS dependencies on CZ_IMP_ITEM_TYPE

Line 598: SELECT ORIG_SYS_REF, ITEM_TYPE_ID,DESC_TEXT,NAME,DELETED_FLAG,SRC_APPLICATION_ID,ROWID FROM CZ_IMP_ITEM_TYPE

594: ) IS
595: BEGIN
596: DECLARE
597: CURSOR c_imp_itemtype IS
598: SELECT ORIG_SYS_REF, ITEM_TYPE_ID,DESC_TEXT,NAME,DELETED_FLAG,SRC_APPLICATION_ID,ROWID FROM CZ_IMP_ITEM_TYPE
599: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
600: ORDER BY 1,ROWID;
601: /* cursor's data found indicators */
602: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;

Line 602: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;

598: SELECT ORIG_SYS_REF, ITEM_TYPE_ID,DESC_TEXT,NAME,DELETED_FLAG,SRC_APPLICATION_ID,ROWID FROM CZ_IMP_ITEM_TYPE
599: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
600: ORDER BY 1,ROWID;
601: /* cursor's data found indicators */
602: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
603: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
604: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;

Line 603: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;

599: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
600: ORDER BY 1,ROWID;
601: /* cursor's data found indicators */
602: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
603: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
604: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;

Line 604: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;

600: ORDER BY 1,ROWID;
601: /* cursor's data found indicators */
602: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
603: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
604: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;

Line 605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;

601: /* cursor's data found indicators */
602: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
603: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
604: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;

Line 606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;

602: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
603: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
604: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;

Line 607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;

603: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
604: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;

Line 608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;

604: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;

Line 609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;

605: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;

Line 610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;

606: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;

Line 611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;

607: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;

Line 612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;

608: nImpItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
616: nOnlDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;

Line 613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;

609: nImpDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
616: nOnlDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
617: nOnlSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;

Line 614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;

610: nImpModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
616: nOnlDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
617: nOnlSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
618: nOnlName CZ_IMP_ITEM_TYPE.NAME%TYPE;

Line 615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;

611: nImpDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
616: nOnlDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
617: nOnlSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
618: nOnlName CZ_IMP_ITEM_TYPE.NAME%TYPE;
619:

Line 616: nOnlDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;

612: nImpSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
616: nOnlDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
617: nOnlSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
618: nOnlName CZ_IMP_ITEM_TYPE.NAME%TYPE;
619:
620: /* Column Vars */

Line 617: nOnlSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;

613: nOnlItemType CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
616: nOnlDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
617: nOnlSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
618: nOnlName CZ_IMP_ITEM_TYPE.NAME%TYPE;
619:
620: /* Column Vars */
621: x_imp_itemtype_f BOOLEAN:=FALSE;

Line 618: nOnlName CZ_IMP_ITEM_TYPE.NAME%TYPE;

614: nOnlDescText CZ_IMP_ITEM_TYPE.DESC_TEXT%TYPE;
615: nOnlModelName CZ_IMP_ITEM_TYPE.NAME%TYPE;
616: nOnlDeletedFlag CZ_IMP_ITEM_TYPE.DELETED_FLAG%TYPE;
617: nOnlSrcAppId CZ_IMP_ITEM_TYPE.SRC_APPLICATION_ID%TYPE;
618: nOnlName CZ_IMP_ITEM_TYPE.NAME%TYPE;
619:
620: /* Column Vars */
621: x_imp_itemtype_f BOOLEAN:=FALSE;
622: x_onl_itemtype_itemtypeid_f BOOLEAN:=FALSE;

Line 737: UPDATE CZ_IMP_ITEM_TYPE SET

733: END IF;
734: END;
735: END IF;
736:
737: UPDATE CZ_IMP_ITEM_TYPE SET
738: ITEM_TYPE_ID=DECODE(sDISPOSITION,'R',ITEM_TYPE_ID,'I',nNextValue+nAllocateCounter, nItemTypeId ),
739: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
740: WHERE ROWID = thisRowId;
741: sLastFSK:=sImpName;

Line 780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;

776: CURSOR c_imp_itemtypeprop(x_usesurr_itemtype PLS_INTEGER,
777: x_usesurr_property PLS_INTEGER) IS
778: SELECT DECODE(x_usesurr_itemtype,0,FSK_ITEMTYPE_1_1,1,FSK_ITEMTYPE_1_EXT),
779: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;

778: SELECT DECODE(x_usesurr_itemtype,0,FSK_ITEMTYPE_1_1,1,FSK_ITEMTYPE_1_EXT),
779: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;

779: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

Line 785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

Line 786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;

Line 787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;

Line 788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
792: /* Column Vars */

Line 789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
792: /* Column Vars */
793: x_imp_itemtypeprop_f BOOLEAN:=FALSE;

Line 790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;

786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
792: /* Column Vars */
793: x_imp_itemtypeprop_f BOOLEAN:=FALSE;
794: x_onl_itemtypeprop_f BOOLEAN:=FALSE;

Line 791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;

787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
792: /* Column Vars */
793: x_imp_itemtypeprop_f BOOLEAN:=FALSE;
794: x_onl_itemtypeprop_f BOOLEAN:=FALSE;
795: x_onl_itemtype_itemtypeid_f BOOLEAN:=FALSE;

Line 915: UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET

911: END;
912: END IF;
913: END;
914: END IF;
915: UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET
916: ITEM_TYPE_ID=DECODE(sDISPOSITION,'R',ITEM_TYPE_ID,nOnlItemTypeId),
917: PROPERTY_ID=DECODE(sDISPOSITION,'R',PROPERTY_ID,nOnlPropertyId ),
918: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
919: WHERE ROWID = thisRowId;

Line 936: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE

932: has been deleted in APPS */
933: BEGIN
934: UPDATE CZ_ITEM_TYPE_PROPERTIES
935: SET DELETED_FLAG = '1'
936: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE
937: WHERE RUN_ID = inRUN_ID
938: AND DELETED_FLAG = '0')
939: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
940: WHERE RUN_ID = inRUN_ID

Line 939: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY

935: SET DELETED_FLAG = '1'
936: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE
937: WHERE RUN_ID = inRUN_ID
938: AND DELETED_FLAG = '0')
939: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
940: WHERE RUN_ID = inRUN_ID
941: AND ITEM_TYPE_ID = CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID
942: AND DELETED_FLAG = '0')
943: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES