APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 630: -- we need to update the category name in icx_cat_items_ctx_hdrs_tlp

626: AND language = l_lang_table(i);
627:
628: l_err_loc := 300;
629:
630: -- we need to update the category name in icx_cat_items_ctx_hdrs_tlp
631: -- if it is an item category
632:
633: IF (p_type = 2) THEN
634: FORALL i in 1..l_lang_table.COUNT

Line 635: UPDATE icx_cat_items_ctx_hdrs_tlp

631: -- if it is an item category
632:
633: IF (p_type = 2) THEN
634: FORALL i in 1..l_lang_table.COUNT
635: UPDATE icx_cat_items_ctx_hdrs_tlp
636: SET ip_category_name = p_name
637: WHERE ip_category_id = p_category_id
638: AND language = l_lang_table(i);
639: END IF;

Line 1023: FROM icx_cat_items_ctx_hdrs_tlp

1019: SELECT 1
1020: INTO l_category_referenced
1021: FROM dual
1022: WHERE EXISTS (SELECT 1
1023: FROM icx_cat_items_ctx_hdrs_tlp
1024: WHERE ip_category_id = p_ip_category_id);
1025:
1026: l_err_loc := 150;
1027: