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_MASTER

Line 19: FROM CZ_IMP_ITEM_MASTER

15: DECLARE
16: CURSOR c_imp_itemmaster(x_usesurr_itemtype pls_integer) IS
17: SELECT ORIG_SYS_REF, SRC_APPLICATION_ID, SRC_TYPE_CODE,
18: DECODE(x_usesurr_itemtype,0,FSK_ITEMTYPE_1_1,1,FSK_ITEMTYPE_1_EXT), ROWID
19: FROM CZ_IMP_ITEM_MASTER
20: WHERE REC_STATUS IS NULL AND RUN_ID=inRUN_ID
21: ORDER BY 1,2,ROWID;
22:
23: v_settings_id VARCHAR2(40);

Line 42: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;

38: x_onl_itemmaster_itemid_f BOOLEAN:=FALSE;
39: x_onl_default_itemtypeid_f BOOLEAN:=FALSE;
40: x_error BOOLEAN:=FALSE;
41: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
42: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
43: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
44: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;

Line 43: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;

39: x_onl_default_itemtypeid_f BOOLEAN:=FALSE;
40: x_error BOOLEAN:=FALSE;
41: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
42: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
43: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
44: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

Line 44: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;

40: x_error BOOLEAN:=FALSE;
41: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
42: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
43: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
44: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

Line 45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;

41: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
42: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
43: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
44: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;

Line 46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;

42: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
43: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
44: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
50: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;

Line 47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

43: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
44: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
50: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
51: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;

Line 48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

44: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
50: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
51: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
52: nImpSrcTypeCode CZ_IMP_ITEM_MASTER.SRC_TYPE_CODE%TYPE;

Line 49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;

45: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
50: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
51: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
52: nImpSrcTypeCode CZ_IMP_ITEM_MASTER.SRC_TYPE_CODE%TYPE;
53:

Line 50: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;

46: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
50: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
51: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
52: nImpSrcTypeCode CZ_IMP_ITEM_MASTER.SRC_TYPE_CODE%TYPE;
53:
54: p_onl_itemtype_itemtypeid CHAR(1);

Line 51: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;

47: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
50: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
51: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
52: nImpSrcTypeCode CZ_IMP_ITEM_MASTER.SRC_TYPE_CODE%TYPE;
53:
54: p_onl_itemtype_itemtypeid CHAR(1);
55: /* Internal vars */

Line 52: nImpSrcTypeCode CZ_IMP_ITEM_MASTER.SRC_TYPE_CODE%TYPE;

48: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
49: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
50: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
51: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
52: nImpSrcTypeCode CZ_IMP_ITEM_MASTER.SRC_TYPE_CODE%TYPE;
53:
54: p_onl_itemtype_itemtypeid CHAR(1);
55: /* Internal vars */
56: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 199: UPDATE CZ_IMP_ITEM_MASTER

195: END;
196: END IF;
197: END;
198: END IF;
199: UPDATE CZ_IMP_ITEM_MASTER
200: SET ITEM_ID=DECODE(sDISPOSITION,'R',ITEM_ID,'I',nNextValue+nAllocateCounter, nOnlItemId),
201: ITEM_TYPE_ID=DECODE(sDISPOSITION,'R',ITEM_TYPE_ID,nOnlItemTypeId),
202: DISPOSITION=sDisposition,
203: REC_STATUS=sRecStatus

Line 498: (SELECT NULL FROM cz_imp_item_master

494: WHERE run_id = inRUN_ID AND deleted_flag = '0'
495: AND item_id = iv.item_id
496: AND property_id = iv.property_id)
497: AND EXISTS
498: (SELECT NULL FROM cz_imp_item_master
499: WHERE item_id = iv.item_id
500: AND run_id = inRUN_ID)
501: AND EXISTS
502: (SELECT NULL FROM cz_properties