APPS.CZ_IMP_PS_NODE dependencies on CZ_IMP_ITEM_PROPERTY_VALUE

Line 267: ---Checking first if the TL text property exists in CZ_IMP_ITEM_PROPERTY_VALUES table -- MASCO R12 Bug - 8226777

263: END;
264:
265: -- Bug8519380 FIx.
266:
267: ---Checking first if the TL text property exists in CZ_IMP_ITEM_PROPERTY_VALUES table -- MASCO R12 Bug - 8226777
268: ---conditionalize the cursor only if the the relevent data available in imp_item_property table.
269: -- FSK_LOCALIZEDTEXT_3_1 will be NOT NULL for data type 8 (TL text property)
270:
271: BEGIN

Line 272: SELECT COUNT(*) INTO var_tl_prop FROM cz_imp_item_property_value

268: ---conditionalize the cursor only if the the relevent data available in imp_item_property table.
269: -- FSK_LOCALIZEDTEXT_3_1 will be NOT NULL for data type 8 (TL text property)
270:
271: BEGIN
272: SELECT COUNT(*) INTO var_tl_prop FROM cz_imp_item_property_value
273: WHERE run_id = inRUN_ID
274: AND FSK_LOCALIZEDTEXT_3_1 IS NOT NULL
275: AND FSK_LOCALIZEDTEXT_3_1=sImpOrigSysRef(i) AND rownum<2;
276:

Line 288: AND EXISTS(SELECT NULL FROM cz_imp_item_property_value

284: CURSOR c_tl_onl_intl_text IS
285: SELECT ol.intl_text_id,ol.localized_str, ol.orig_sys_ref,ol.language
286: FROM cz_localized_texts ol
287: WHERE ol.orig_sys_ref = sImpOrigSysRef(i)
288: AND EXISTS(SELECT NULL FROM cz_imp_item_property_value
289: WHERE run_id = inRUN_ID
290: AND FSK_LOCALIZEDTEXT_3_1 IS NOT NULL
291: AND FSK_LOCALIZEDTEXT_3_1=ol.ORIG_SYS_REF)
292: AND ol.deleted_flag = '0';

Line 349: SELECT COUNT(*) INTO var_tl_prop FROM cz_imp_item_property_value

345: ELSE /* insert */
346:
347: BEGIN --#####
348:
349: SELECT COUNT(*) INTO var_tl_prop FROM cz_imp_item_property_value
350: WHERE run_id = inRUN_ID
351: AND FSK_LOCALIZEDTEXT_3_1 IS NOT NULL
352: AND FSK_LOCALIZEDTEXT_3_1=sImpOrigSysRef(i)
353: AND rownum<2;