eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_ITEM_DIAG_PVT dependencies on PO_ATTRIBUTE_VALUES

Line 241: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'PO_ATTRIBUTE_VALUES_PVT.plb'; g_file_versions_tbl(l_ctr) := '120.30.12010000.7';

237: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXVPPSB.pls'; g_file_versions_tbl(l_ctr) := '120.6.12010000.2';
238: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXVPPSS.pls'; g_file_versions_tbl(l_ctr) := '120.6.12010000.1';
239: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXVUTLB.pls'; g_file_versions_tbl(l_ctr) := '120.18.12010000.8';
240: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXVUTLS.pls'; g_file_versions_tbl(l_ctr) := '120.14.12010000.2';
241: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'PO_ATTRIBUTE_VALUES_PVT.plb'; g_file_versions_tbl(l_ctr) := '120.30.12010000.7';
242: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'PO_ATTRIBUTE_VALUES_PVT.pls'; g_file_versions_tbl(l_ctr) := '120.12.12010000.3';
243:
244:
245: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_file_tbl.count '|| g_file_tbl.count );

Line 242: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'PO_ATTRIBUTE_VALUES_PVT.pls'; g_file_versions_tbl(l_ctr) := '120.12.12010000.3';

238: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXVPPSS.pls'; g_file_versions_tbl(l_ctr) := '120.6.12010000.1';
239: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXVUTLB.pls'; g_file_versions_tbl(l_ctr) := '120.18.12010000.8';
240: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'ICXVUTLS.pls'; g_file_versions_tbl(l_ctr) := '120.14.12010000.2';
241: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'PO_ATTRIBUTE_VALUES_PVT.plb'; g_file_versions_tbl(l_ctr) := '120.30.12010000.7';
242: l_ctr:=l_ctr+1; g_file_tbl(l_ctr) := 'PO_ATTRIBUTE_VALUES_PVT.pls'; g_file_versions_tbl(l_ctr) := '120.12.12010000.3';
243:
244:
245: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'g_file_tbl.count '|| g_file_tbl.count );
246: FOR idx IN 1 .. g_file_tbl.count

Line 513: from po_attribute_values

509:
510: cursor po_attr(j number) is
511: select
512: 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
513: from po_attribute_values
514: WHERE INVENTORY_ITEM_ID =g_source_ids(j)
515: and org_id = g_org_id;
516:
517: cursor po_attr_tlp(j number) is

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 890: elsif p_table_name = 'PO_ATTRIBUTE_VALUES' then

886: p_col_num :=4;
887: p_row_num:=p_row_num-1;
888: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
889:
890: elsif p_table_name = 'PO_ATTRIBUTE_VALUES' then
891: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'9');
892: p_col_val(1):='INVENTORY_ITEM_ID';
893: p_col_val(2):='ORG_ID';
894: p_col_val(3):='PO_LINE_ID';

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 1402: procedure PO_ATTRIBUTE_VALUES_DATA_FIX is

1398: logUnexpectedException(g_pkg_name, l_api_name,'create_missing_data '||sqlerrm||' code='||sqlcode);
1399:
1400: end create_missing_data;
1401:
1402: procedure PO_ATTRIBUTE_VALUES_DATA_FIX is
1403:
1404: CURSOR master_csr IS
1405: SELECT *
1406: FROM icx_cat_items_ctx_hdrs_tlp ctx

Line 1412: FROM po_attribute_values poav

1408: AND ctx.REQ_TEMPLATE_NAME='-2'
1409: AND ctx.REQ_TEMPLATE_LINE_NUM = -2
1410: AND ctx.SOURCE_TYPE = 'MASTER_ITEM'
1411: AND NOT EXISTS ( SELECT 'Row Found for inventory item id'
1412: FROM po_attribute_values poav
1413: WHERE poav.INVENTORY_ITEM_ID = ctx.INVENTORY_ITEM_ID
1414: AND poav.ORG_ID = ctx.ORG_ID
1415: AND poav.PO_LINE_ID=-2
1416: AND poav.REQ_TEMPLATE_NAME='-2'

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 1424: l_api_name VARCHAR2(50) := 'PO_ATTRIBUTE_VALUES_DATA_FIX';

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);
1428: l_item_invalid BOOLEAN := FALSE;

Line 1494: PO_ATTRIBUTE_VALUES_PVT.create_default_attributes_MI

1490:
1491: END;
1492:
1493: IF NOT l_item_invalid THEN
1494: PO_ATTRIBUTE_VALUES_PVT.create_default_attributes_MI
1495: (
1496: p_ip_category_id => rec_MI.IP_CATEGORY_ID,
1497: p_inventory_item_id => rec_MI.INVENTORY_ITEM_ID,
1498: p_org_id => rec_MI.ORG_ID,

Line 1515: PO_ATTRIBUTE_VALUES_PVT.create_attributes_tlp_MI

1511: EXCEPTION
1512: WHEN No_Data_Found THEN
1513: l_long_description:='';
1514: END;
1515: PO_ATTRIBUTE_VALUES_PVT.create_attributes_tlp_MI
1516: (
1517: p_inventory_item_id => rec_MI.INVENTORY_ITEM_ID,
1518: p_ip_category_id => rec_MI.IP_CATEGORY_ID,
1519: p_org_id => rec_MI.ORG_ID,

Line 1529: FROM po_attribute_values

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
1532: AND req_template_name = '-2'
1533: AND req_template_line_num = -2

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 1746: END PO_ATTRIBUTE_VALUES_DATA_FIX;

1742:
1743: exception when others then
1744: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'exception '||sqlerrm||' code='||sqlcode);
1745:
1746: END PO_ATTRIBUTE_VALUES_DATA_FIX;
1747:
1748: procedure sync_sources(p_org_id in number,
1749: p_source_type in varchar2,
1750: x_return_status out NOCOPY varchar2 )

Line 1892: PO_ATTRIBUTE_VALUES_DATA_FIX;

1888: l_err_loc := 400;
1889: ICX_CAT_UTIL_PVT.setWhoColumns(g_request_id);
1890: if p_source_type = 'MASTER_ITEM' then
1891:
1892: PO_ATTRIBUTE_VALUES_DATA_FIX;
1893:
1894: open master_item_sync;
1895: loop
1896: fetch master_item_sync into l_inv_item_id,l_organization_id;

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)