DBA Data[Home] [Help]

APPS.ICX_ITEM_DIAG_PVT dependencies on ICX_CAT_ATTRIBUTE_VALUES

Line 526: from icx_cat_attribute_values

522:
523: cursor icx_attr(j number) is
524: select
525: INVENTORY_ITEM_ID,ORG_ID,PO_LINE_ID,REQ_TEMPLATE_NAME,REQ_TEMPLATE_LINE_NUM,IP_CATEGORY_ID,MANUFACTURER_PART_NUM,LEAD_TIME,PICTURE,THUMBNAIL_IMAGE,SUPPLIER_URL,MANUFACTURER_URL,ATTACHMENT_URL,UNSPSC,AVAILABILITY
526: from icx_cat_attribute_values
527: WHERE INVENTORY_ITEM_ID =g_source_ids(j)
528: and org_id = g_org_id;
529:
530: cursor icx_attr_tlp(j number) is

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 966: elsif p_table_name = 'ICX_CAT_ATTRIBUTE_VALUES' then

962: p_col_num :=10;
963: p_row_num:=p_row_num-1;
964: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
965:
966: elsif p_table_name = 'ICX_CAT_ATTRIBUTE_VALUES' then
967: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'11');
968: p_col_val(1):='INVENTORY_ITEM_ID';
969: p_col_val(2):='ORG_ID';
970: p_col_val(3):='PO_LINE_ID';

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 1527: MERGE INTO icx_cat_attribute_values icav

1523: p_organization_id => l_organization_id,
1524: p_master_organization_id => l_master_organization_id
1525: );
1526:
1527: MERGE INTO icx_cat_attribute_values icav
1528: USING (SELECT *
1529: FROM po_attribute_values
1530: WHERE inventory_item_id = rec_MI.INVENTORY_ITEM_ID
1531: AND po_line_id = -2

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

1649: temp.creation_date, temp.request_id, temp.program_application_id, temp.program_id,
1650: temp.program_update_date, temp.last_updated_program, temp.rebuild_search_index_flag);
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

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: