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.CLN_PO_SYNC_CAT_PKG dependencies on PO_HEADERS_ALL

Line 140: FROM PO_HEADERS_ALL

136: BEGIN
137: x_operation := 'UPDATE';
138: SELECT po_header_id
139: INTO x_po_hdr_id
140: FROM PO_HEADERS_ALL
141: WHERE VENDOR_ORDER_NUM = l_ctg_name
142: AND vendor_id = p_tp_id -- Bug #5006663
143: AND NVL(CANCEL_FLAG, 'N') = 'N'
144: AND NVL(CLOSED_CODE, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED');

Line 638: -- (SELECT PO_HEADER_ID FROM PO_HEADERS_ALL WHERE VENDOR_ORDER_NUM = l_ctg_name)

634: AND NVL(MIS.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID)
635: = FSP.INVENTORY_ORGANIZATION_ID
636: AND FSP.ORG_ID = POL.ORG_ID
637: AND POL.PO_HEADER_ID = p_hdr_id
638: -- (SELECT PO_HEADER_ID FROM PO_HEADERS_ALL WHERE VENDOR_ORDER_NUM = l_ctg_name)
639: AND upper(MIS.CONCATENATED_SEGMENTS) = upper(p_item)
640: AND upper(POL.UNIT_MEAS_LOOKUP_CODE) = upper(p_uom);
641: -- NO need to compare category
642: -- AND MCT.CATEGORY_ID = POL.CATEGORY_ID

Line 1390: FROM po_headers_all

1386:
1387: BEGIN
1388: SELECT po_header_id
1389: INTO l_po_header_id
1390: FROM po_headers_all
1391: WHERE vendor_order_num = p_catalog_name
1392: AND vendor_id = p_vendor_id;
1393: EXCEPTION
1394: WHEN NO_DATA_FOUND THEN

Line 1397: cln_debug_pub.Add('PO not found in po_headers_all', 1);

1393: EXCEPTION
1394: WHEN NO_DATA_FOUND THEN
1395: l_po_header_id := NULL;
1396: IF (l_Debug_Level <= 1) THEN
1397: cln_debug_pub.Add('PO not found in po_headers_all', 1);
1398: END IF;
1399: END;
1400:
1401: IF (l_Debug_Level <= 1) THEN

Line 1447: FROM po_headers_all

1443: ELSE
1444: BEGIN
1445: SELECT po_header_id
1446: INTO l_po_header_id
1447: FROM po_headers_all
1448: WHERE vendor_order_num = p_catalog_name
1449: AND vendor_id = p_vendor_id;
1450: EXCEPTION
1451: WHEN NO_DATA_FOUND THEN

Line 1454: cln_debug_pub.Add('PO not found in po_headers_all', 1);

1450: EXCEPTION
1451: WHEN NO_DATA_FOUND THEN
1452: l_po_header_id := NULL;
1453: IF (l_Debug_Level <= 1) THEN
1454: cln_debug_pub.Add('PO not found in po_headers_all', 1);
1455: END IF;
1456: END;
1457:
1458: IF (l_Debug_Level <= 1) THEN

Line 1757: --Get BPO Number from po headers all

1753: -- and add them to collaboration message
1754: IF l_count = 0 THEN
1755:
1756: --Bug : 3732150
1757: --Get BPO Number from po headers all
1758: IF (l_Debug_Level <= 1) THEN
1759: cln_debug_pub.Add('Trying to get BPO Number from PO Headers All', 1);
1760: END IF;
1761:

Line 1759: cln_debug_pub.Add('Trying to get BPO Number from PO Headers All', 1);

1755:
1756: --Bug : 3732150
1757: --Get BPO Number from po headers all
1758: IF (l_Debug_Level <= 1) THEN
1759: cln_debug_pub.Add('Trying to get BPO Number from PO Headers All', 1);
1760: END IF;
1761:
1762: l_catalog_name := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);
1763: IF (l_Debug_Level <= 1) THEN

Line 1786: FROM PO_HEADERS_ALL

1782: -- Canceled and Closed BPO are not taken into consideration
1783: BEGIN
1784: SELECT segment1
1785: INTO l_bpo_number
1786: FROM PO_HEADERS_ALL
1787: WHERE VENDOR_ORDER_NUM = l_catalog_name
1788: AND vendor_id = l_vendor_id -- Bug #5006663
1789: AND NVL(CANCEL_FLAG, 'N') = 'N'
1790: AND NVL(CLOSED_CODE, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED');