APPS.ICX_ITEM_DIAG_PVT dependencies on ICX_CAT_ATTRIBUTE_VALUES_TLP

Line 532: from icx_cat_attribute_values_tlp

528: and org_id = g_org_id;
529:
530: cursor icx_attr_tlp(j number) is
531: select INVENTORY_ITEM_ID,ORG_ID,LANGUAGE,PO_LINE_ID,REQ_TEMPLATE_NAME,REQ_TEMPLATE_LINE_NUM,IP_CATEGORY_ID,DESCRIPTION,MANUFACTURER,LONG_DESCRIPTION
532: from icx_cat_attribute_values_tlp
533: WHERE INVENTORY_ITEM_ID =g_source_ids(j)
534: and org_id = g_org_id;
535:
536: cursor po_gt is

Line 1008: elsif p_table_name = 'ICX_CAT_ATTRIBUTE_VALUES_TLP' then

1004: p_row_num:=p_row_num-1;
1005: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
1006:
1007:
1008: elsif p_table_name = 'ICX_CAT_ATTRIBUTE_VALUES_TLP' then
1009: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'12');
1010: p_col_val(1):='INVENTORY_ITEM_ID';
1011: p_col_val(2):='ORG_ID';
1012: p_col_val(3):='LANGUAGE';

Line 1655: MERGE INTO icx_cat_attribute_values_tlp icavt

1651:
1652:
1653: logStatement(g_pkg_name, l_api_name ,'Num. of rows inserted into icx_cat_attribute_values:' ||SQL%ROWCOUNT);
1654:
1655: MERGE INTO icx_cat_attribute_values_tlp icavt
1656: USING (SELECT *
1657: FROM po_attribute_values_tlp
1658: WHERE inventory_item_id = rec_MI.INVENTORY_ITEM_ID
1659: AND po_line_id = -2

Line 1732: logStatement(g_pkg_name, l_api_name ,'Num. of rows inserted into icx_cat_attribute_values_tlp:' ||SQL%ROWCOUNT);

1728: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
1729:
1730:
1731:
1732: logStatement(g_pkg_name, l_api_name ,'Num. of rows inserted into icx_cat_attribute_values_tlp:' ||SQL%ROWCOUNT);
1733: END IF;
1734: end if;
1735: END LOOP;
1736: