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_PROPERTY_VALUE

Line 240: TYPE tFskItemMaster21 IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;

236: DUPS OUT NOCOPY PLS_INTEGER,
237: inXFR_GROUP IN VARCHAR2
238: ) IS
239:
240: TYPE tFskItemMaster21 IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;
241: TYPE tFskItemMaster2Ext IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_EXT%TYPE INDEX BY BINARY_INTEGER;
242: TYPE tFskProperty11 IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
243: TYPE tFskProperty1Ext IS TABLE OF cz_imp_item_property_value.fsk_property_1_EXT%TYPE INDEX BY BINARY_INTEGER;
244: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 241: TYPE tFskItemMaster2Ext IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_EXT%TYPE INDEX BY BINARY_INTEGER;

237: inXFR_GROUP IN VARCHAR2
238: ) IS
239:
240: TYPE tFskItemMaster21 IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;
241: TYPE tFskItemMaster2Ext IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_EXT%TYPE INDEX BY BINARY_INTEGER;
242: TYPE tFskProperty11 IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
243: TYPE tFskProperty1Ext IS TABLE OF cz_imp_item_property_value.fsk_property_1_EXT%TYPE INDEX BY BINARY_INTEGER;
244: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
245: TYPE tItemId IS TABLE OF cz_imp_item_property_value.item_id%TYPE INDEX BY BINARY_INTEGER;

Line 242: TYPE tFskProperty11 IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;

238: ) IS
239:
240: TYPE tFskItemMaster21 IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;
241: TYPE tFskItemMaster2Ext IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_EXT%TYPE INDEX BY BINARY_INTEGER;
242: TYPE tFskProperty11 IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
243: TYPE tFskProperty1Ext IS TABLE OF cz_imp_item_property_value.fsk_property_1_EXT%TYPE INDEX BY BINARY_INTEGER;
244: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
245: TYPE tItemId IS TABLE OF cz_imp_item_property_value.item_id%TYPE INDEX BY BINARY_INTEGER;
246: TYPE tPropertyId IS TABLE OF cz_imp_item_property_value.property_id%TYPE INDEX BY BINARY_INTEGER;

Line 243: TYPE tFskProperty1Ext IS TABLE OF cz_imp_item_property_value.fsk_property_1_EXT%TYPE INDEX BY BINARY_INTEGER;

239:
240: TYPE tFskItemMaster21 IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;
241: TYPE tFskItemMaster2Ext IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_EXT%TYPE INDEX BY BINARY_INTEGER;
242: TYPE tFskProperty11 IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
243: TYPE tFskProperty1Ext IS TABLE OF cz_imp_item_property_value.fsk_property_1_EXT%TYPE INDEX BY BINARY_INTEGER;
244: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
245: TYPE tItemId IS TABLE OF cz_imp_item_property_value.item_id%TYPE INDEX BY BINARY_INTEGER;
246: TYPE tPropertyId IS TABLE OF cz_imp_item_property_value.property_id%TYPE INDEX BY BINARY_INTEGER;
247:

Line 244: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

240: TYPE tFskItemMaster21 IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_1%TYPE INDEX BY BINARY_INTEGER;
241: TYPE tFskItemMaster2Ext IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_EXT%TYPE INDEX BY BINARY_INTEGER;
242: TYPE tFskProperty11 IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
243: TYPE tFskProperty1Ext IS TABLE OF cz_imp_item_property_value.fsk_property_1_EXT%TYPE INDEX BY BINARY_INTEGER;
244: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
245: TYPE tItemId IS TABLE OF cz_imp_item_property_value.item_id%TYPE INDEX BY BINARY_INTEGER;
246: TYPE tPropertyId IS TABLE OF cz_imp_item_property_value.property_id%TYPE INDEX BY BINARY_INTEGER;
247:
248: iFskItemMaster21 tFskItemMaster21;

Line 245: TYPE tItemId IS TABLE OF cz_imp_item_property_value.item_id%TYPE INDEX BY BINARY_INTEGER;

241: TYPE tFskItemMaster2Ext IS TABLE OF cz_imp_item_property_value.fsk_itemmaster_2_EXT%TYPE INDEX BY BINARY_INTEGER;
242: TYPE tFskProperty11 IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
243: TYPE tFskProperty1Ext IS TABLE OF cz_imp_item_property_value.fsk_property_1_EXT%TYPE INDEX BY BINARY_INTEGER;
244: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
245: TYPE tItemId IS TABLE OF cz_imp_item_property_value.item_id%TYPE INDEX BY BINARY_INTEGER;
246: TYPE tPropertyId IS TABLE OF cz_imp_item_property_value.property_id%TYPE INDEX BY BINARY_INTEGER;
247:
248: iFskItemMaster21 tFskItemMaster21;
249: iFskItemMaster2Ext tFskItemMaster2Ext;

Line 246: TYPE tPropertyId IS TABLE OF cz_imp_item_property_value.property_id%TYPE INDEX BY BINARY_INTEGER;

242: TYPE tFskProperty11 IS TABLE OF cz_imp_item_property_value.fsk_property_1_1%TYPE INDEX BY BINARY_INTEGER;
243: TYPE tFskProperty1Ext IS TABLE OF cz_imp_item_property_value.fsk_property_1_EXT%TYPE INDEX BY BINARY_INTEGER;
244: TYPE tOrigSysRef IS TABLE OF cz_imp_item_property_value.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
245: TYPE tItemId IS TABLE OF cz_imp_item_property_value.item_id%TYPE INDEX BY BINARY_INTEGER;
246: TYPE tPropertyId IS TABLE OF cz_imp_item_property_value.property_id%TYPE INDEX BY BINARY_INTEGER;
247:
248: iFskItemMaster21 tFskItemMaster21;
249: iFskItemMaster2Ext tFskItemMaster2Ext;
250: iFskProperty11 tFskProperty11;

Line 264: FROM cz_imp_item_property_value a, cz_item_masters b, cz_properties c

260: -- passing records
261: CURSOR C1 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
262: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext,
263: b.item_id, c.property_id, a.orig_sys_ref
264: FROM cz_imp_item_property_value a, cz_item_masters b, cz_properties c
265: WHERE b.orig_sys_ref=DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
266: AND c.orig_sys_ref=DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
267: AND b.deleted_flag = '0'
268: AND c.deleted_flag = '0'

Line 276: FROM cz_imp_item_property_value a, cz_item_masters b

272: -- invalid fsk_property
273: CURSOR C2 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
274: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext,
275: a.orig_sys_ref, b.item_id
276: FROM cz_imp_item_property_value a, cz_item_masters b
277: WHERE b.orig_sys_ref=DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
278: AND b.deleted_flag = '0'
279: AND NOT EXISTS (SELECT NULL FROM cz_properties
280: WHERE orig_sys_ref = DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)

Line 289: FROM cz_imp_item_property_value a, cz_properties b

285: -- invalid fsk_itemmaster
286: CURSOR C3 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
287: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext,
288: a.orig_sys_ref, b.property_id
289: FROM cz_imp_item_property_value a, cz_properties b
290: WHERE b.orig_sys_ref=DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
291: AND b.deleted_flag = '0'
292: AND NOT EXISTS (SELECT NULL FROM cz_item_masters
293: WHERE orig_sys_ref = DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)

Line 301: FROM cz_imp_item_property_value a

297:
298: -- invalid fsk_property and fsk_itemmaster
299: CURSOR C4 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
300: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext, a.orig_sys_ref
301: FROM cz_imp_item_property_value a
302: WHERE NOT EXISTS (SELECT NULL FROM cz_item_masters
303: WHERE orig_sys_ref = DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
304: AND deleted_flag = '0')
305: AND NOT EXISTS (SELECT NULL FROM cz_properties

Line 313: SELECT orig_sys_ref FROM cz_imp_item_property_value a

309: AND a.run_id=inRUN_ID;
310:
311: -- invalid fsk_localizedtext_3_1
312: CURSOR C5(x_usesurr_itempropertyvalue PLS_INTEGER) IS
313: SELECT orig_sys_ref FROM cz_imp_item_property_value a
314: WHERE run_id=inRUN_ID AND EXISTS(SELECT NULL FROM cz_imp_property
315: WHERE run_id=inRUN_ID AND property_id=a.property_id AND
316: data_type=8 AND deleted_flag='0')
317: AND NOT EXISTS (SELECT NULL FROM cz_imp_localized_texts

Line 344: UPDATE cz_imp_item_property_value a

340:
341: IF iOrigSysRef.COUNT > 0 THEN
342:
343: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
344: UPDATE cz_imp_item_property_value a
345: SET item_id=iItemId(i),
346: property_id=iPropertyId(i),
347: disposition='M',
348: rec_status='PASS'

Line 360: UPDATE cz_imp_item_property_value a

356:
357: --------------------- New code ------------------------------------
358:
359: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
360: UPDATE cz_imp_item_property_value a
361: SET property_num_value=(SELECT DISTINCT intl_text_id FROM cz_imp_localized_texts
362: WHERE run_id=inRUN_ID AND orig_sys_ref = a.FSK_LOCALIZEDTEXT_3_1
363: AND deleted_flag='0'),
364: disposition='M',

Line 380: UPDATE cz_imp_item_property_value a

376:
377: --------------------- End of new code ------------------------------
378:
379: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
380: UPDATE cz_imp_item_property_value a
381: SET item_id=iItemId(i),
382: property_id=iPropertyId(i),
383: disposition='I',
384: rec_status='PASS'

Line 407: UPDATE cz_imp_item_property_value

403:
404: IF iOrigSysRef.COUNT > 0 THEN
405:
406: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
407: UPDATE cz_imp_item_property_value
408: SET item_id=iItemId(i),
409: disposition='R',
410: rec_status='I0P1'
411: WHERE run_id=inRUN_ID

Line 430: UPDATE cz_imp_item_property_value

426: EXIT WHEN C3%NOTFOUND AND iOrigSysRef.COUNT = 0;
427: IF iOrigSysRef.COUNT > 0 THEN
428:
429: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
430: UPDATE cz_imp_item_property_value
431: SET property_id=iPropertyId(i),
432: disposition='R',
433: rec_status='I1P0'
434: WHERE run_id=inRUN_ID

Line 453: UPDATE cz_imp_item_property_value

449: EXIT WHEN C4%NOTFOUND AND iOrigSysRef.COUNT = 0;
450: IF iOrigSysRef.COUNT > 0 THEN
451:
452: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
453: UPDATE cz_imp_item_property_value
454: SET disposition='R',
455: rec_status='I1P1'
456: WHERE run_id=inRUN_ID
457: AND orig_sys_ref=iOrigSysRef(i);

Line 474: UPDATE cz_imp_item_property_value

470: EXIT WHEN C5%NOTFOUND AND iOrigSysRef.COUNT = 0;
471: IF iOrigSysRef.COUNT > 0 THEN
472:
473: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
474: UPDATE cz_imp_item_property_value
475: SET disposition='R',
476: rec_status='I1P2'
477: WHERE run_id=inRUN_ID
478: AND orig_sys_ref=iOrigSysRef(i);

Line 493: (SELECT NULL FROM cz_imp_item_property_value

489: UPDATE cz_item_property_values iv
490: SET deleted_flag = '1'
491: WHERE deleted_flag = '0'
492: AND NOT EXISTS
493: (SELECT NULL FROM cz_imp_item_property_value
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