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 528: SELECT ORIG_SYS_REF, ROWID FROM CZ_IMP_ITEM_TYPE

524: ) IS
525: BEGIN
526: DECLARE
527: CURSOR c_imp_itemtype IS
528: SELECT ORIG_SYS_REF, ROWID FROM CZ_IMP_ITEM_TYPE
529: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
530: ORDER BY 1,ROWID;
531: /* cursor's data found indicators */
532: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;

Line 532: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;

528: SELECT ORIG_SYS_REF, ROWID FROM CZ_IMP_ITEM_TYPE
529: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
530: ORDER BY 1,ROWID;
531: /* cursor's data found indicators */
532: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
533: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
534: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
535: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
536: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;

Line 533: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;

529: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
530: ORDER BY 1,ROWID;
531: /* cursor's data found indicators */
532: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
533: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
534: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
535: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
536: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
537: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;

Line 534: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;

530: ORDER BY 1,ROWID;
531: /* cursor's data found indicators */
532: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
533: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
534: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
535: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
536: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
537: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
538: /* Column Vars */

Line 535: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;

531: /* cursor's data found indicators */
532: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
533: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
534: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
535: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
536: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
537: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
538: /* Column Vars */
539: x_imp_itemtype_f BOOLEAN:=FALSE;

Line 536: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;

532: sImpName CZ_IMP_ITEM_TYPE.NAME%TYPE;
533: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
534: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
535: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
536: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
537: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
538: /* Column Vars */
539: x_imp_itemtype_f BOOLEAN:=FALSE;
540: x_onl_itemtype_itemtypeid_f BOOLEAN:=FALSE;

Line 537: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;

533: nItemTypeId CZ_IMP_ITEM_TYPE.ITEM_TYPE_ID%TYPE;
534: sLastFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
535: sThisFSK CZ_IMP_ITEM_TYPE.NAME%TYPE;
536: sRecStatus CZ_IMP_ITEM_TYPE.REC_STATUS%TYPE;
537: sDisposition CZ_IMP_ITEM_TYPE.DISPOSITION%TYPE;
538: /* Column Vars */
539: x_imp_itemtype_f BOOLEAN:=FALSE;
540: x_onl_itemtype_itemtypeid_f BOOLEAN:=FALSE;
541: x_error BOOLEAN:=FALSE;

Line 636: UPDATE CZ_IMP_ITEM_TYPE SET

632: END IF;
633: END;
634: END IF;
635:
636: UPDATE CZ_IMP_ITEM_TYPE SET
637: ITEM_TYPE_ID=DECODE(sDISPOSITION,'R',ITEM_TYPE_ID,'I',nNextValue+nAllocateCounter, nItemTypeId ),
638: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
639: WHERE ROWID = thisRowId;
640: sLastFSK:=sImpName;

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

672: CURSOR c_imp_itemtypeprop(x_usesurr_itemtype PLS_INTEGER,
673: x_usesurr_property PLS_INTEGER) IS
674: SELECT DECODE(x_usesurr_itemtype,0,FSK_ITEMTYPE_1_1,1,FSK_ITEMTYPE_1_EXT),
675: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
676: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
677: /* cursor's data found indicators */
678: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
679: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 678: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;

674: SELECT DECODE(x_usesurr_itemtype,0,FSK_ITEMTYPE_1_1,1,FSK_ITEMTYPE_1_EXT),
675: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
676: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
677: /* cursor's data found indicators */
678: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
679: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 679: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;

675: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
676: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
677: /* cursor's data found indicators */
678: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
679: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

676: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
677: /* cursor's data found indicators */
678: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
679: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

Line 681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

677: /* cursor's data found indicators */
678: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
679: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
685: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

Line 682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

678: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
679: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
685: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
686: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;

Line 683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

679: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
685: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
686: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
687: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;

Line 684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

680: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
685: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
686: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
687: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
688: /* Column Vars */

Line 685: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

681: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
685: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
686: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
687: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
688: /* Column Vars */
689: x_imp_itemtypeprop_f BOOLEAN:=FALSE;

Line 686: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;

682: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
685: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
686: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
687: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
688: /* Column Vars */
689: x_imp_itemtypeprop_f BOOLEAN:=FALSE;
690: x_onl_itemtypeprop_f BOOLEAN:=FALSE;

Line 687: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;

683: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
684: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
685: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
686: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
687: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
688: /* Column Vars */
689: x_imp_itemtypeprop_f BOOLEAN:=FALSE;
690: x_onl_itemtypeprop_f BOOLEAN:=FALSE;
691: x_onl_itemtype_itemtypeid_f BOOLEAN:=FALSE;

Line 811: UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET

807: END;
808: END IF;
809: END;
810: END IF;
811: UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET
812: ITEM_TYPE_ID=DECODE(sDISPOSITION,'R',ITEM_TYPE_ID,nOnlItemTypeId),
813: PROPERTY_ID=DECODE(sDISPOSITION,'R',PROPERTY_ID,nOnlPropertyId ),
814: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
815: WHERE ROWID = thisRowId;

Line 832: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE

828: has been deleted in APPS */
829: BEGIN
830: UPDATE CZ_ITEM_TYPE_PROPERTIES
831: SET DELETED_FLAG = '1'
832: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE
833: WHERE RUN_ID = inRUN_ID
834: AND DELETED_FLAG = '0')
835: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
836: WHERE RUN_ID = inRUN_ID

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

831: SET DELETED_FLAG = '1'
832: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE
833: WHERE RUN_ID = inRUN_ID
834: AND DELETED_FLAG = '0')
835: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
836: WHERE RUN_ID = inRUN_ID
837: AND ITEM_TYPE_ID = CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID
838: AND DELETED_FLAG = '0')
839: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES