APPS.ICX_ITEM_DIAG_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP

Line 519: from po_attribute_values_tlp

515: and org_id = g_org_id;
516:
517: cursor po_attr_tlp(j number) is
518: select INVENTORY_ITEM_ID,ORG_ID,LANGUAGE,PO_LINE_ID,REQ_TEMPLATE_NAME,REQ_TEMPLATE_LINE_NUM,IP_CATEGORY_ID,DESCRIPTION,MANUFACTURER,LONG_DESCRIPTION
519: from po_attribute_values_tlp
520: WHERE INVENTORY_ITEM_ID =g_source_ids(j)
521: and org_id = g_org_id;
522:
523: cursor icx_attr(j number) is

Line 932: elsif p_table_name = 'PO_ATTRIBUTE_VALUES_TLP' then

928: p_row_num:=p_row_num-1;
929: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
930:
931:
932: elsif p_table_name = 'PO_ATTRIBUTE_VALUES_TLP' then
933: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'10');
934: p_col_val(1):='INVENTORY_ITEM_ID';
935: p_col_val(2):='ORG_ID';
936: p_col_val(3):='LANGUAGE';

Line 1423: l_long_description PO_ATTRIBUTE_VALUES_TLP.LONG_DESCRIPTION%TYPE;

1419:
1420: rec_MI icx_cat_items_ctx_hdrs_tlp%ROWTYPE;
1421: l_organization_id NUMBER;
1422: l_master_organization_id NUMBER;
1423: l_long_description PO_ATTRIBUTE_VALUES_TLP.LONG_DESCRIPTION%TYPE;
1424: l_api_name VARCHAR2(50) := 'PO_ATTRIBUTE_VALUES_DATA_FIX';
1425: l_progress VARCHAR2(4);
1426: l_counter NUMBER := 0;
1427: l_message VARCHAR2(4000);

Line 1657: FROM po_attribute_values_tlp

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
1660: AND req_template_name = '-2'
1661: AND req_template_line_num = -2

Line 1908: where po_header_id in ( select distinct pol.po_header_id from po_attribute_values_tlp po , icx_cat_items_ctx_hdrs_tlp ctx, po_lines_all pol

1904: if p_source_type = 'BLANKET' then
1905: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,p_source_type);
1906:
1907: update po_headers_all set last_update_date = sysdate
1908: where po_header_id in ( select distinct pol.po_header_id from po_attribute_values_tlp po , icx_cat_items_ctx_hdrs_tlp ctx, po_lines_all pol
1909: where po.po_line_id=ctx.po_line_id
1910: and po.po_line_id=pol.po_line_id
1911: and ctx.source_type in ('BLANKET','QUOTATION','GLOBAL_BLANKET')
1912: and (po.ip_category_id <> ctx.ip_category_id or pol.unit_price <> ctx.unit_price)