APPS.HXC_LAYOUTS_UPLOAD_PKG dependencies on HXC_LAYOUTS_TL

Line 181: FROM hxc_layouts_tl

177:
178: SELECT 'yes'
179: FROM dual
180: WHERE EXISTS (SELECT 'x'
181: FROM hxc_layouts_tl
182: WHERE layout_id = p_layout_id
183: and DISPLAY_LAYOUT_NAME <> P_DISPLAY_LAYOUT_NAME --added
184: AND userenv('LANG') in ( language, source_lang )
185: );

Line 337: FROM hxc_layouts_tl

333: SELECT 'yes'
334: INTO l_dummy
335: FROM dual
336: WHERE EXISTS (SELECT 'x'
337: FROM hxc_layouts_tl
338: WHERE layout_id = l_layout_id
339: and DISPLAY_LAYOUT_NAME <> P_DISPLAY_LAYOUT_NAME --added
340: AND userenv('LANG') in ( language, source_lang )
341: );

Line 1022: FROM hxc_layouts_tl

1018: IS
1019: SELECT 'yes'
1020: FROM dual
1021: WHERE EXISTS( SELECT 'x'
1022: FROM hxc_layouts_tl
1023: WHERE layout_id = p_layout_id
1024: AND display_layout_name <>
1025: p_display_layout_name --added
1026: AND userenv('LANG') IN (LANGUAGE, source_lang));

Line 1216: FROM hxc_layouts_tl

1212: SELECT 'yes'
1213: INTO l_dummy
1214: FROM dual
1215: WHERE EXISTS( SELECT 'x'
1216: FROM hxc_layouts_tl
1217: WHERE layout_id = l_layout_id
1218: AND display_layout_name <>
1219: p_display_layout_name --added
1220: AND userenv('LANG') IN (LANGUAGE, source_lang));

Line 1227: FROM hxc_layouts_tl

1223: SELECT last_update_date,
1224: last_updated_by
1225: INTO l_last_update_date_db,
1226: l_last_updated_by_db
1227: FROM hxc_layouts_tl
1228: WHERE layout_id = l_layout_id
1229: AND display_layout_name <> p_display_layout_name --added
1230: AND userenv('LANG') = LANGUAGE;
1231: