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.AHL_OSP_PO_PVT dependencies on AHL_GLOBAL

Line 526: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

522: DELETE FROM po_interface_errors
523: WHERE INTERFACE_TRANSACTION_ID in
524: (SELECT transaction_id
525: FROM po_requisitions_interface_all
526: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
527: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID);
528: DELETE FROM po_requisitions_interface_all
529: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
530: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID;

Line 529: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

525: FROM po_requisitions_interface_all
526: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
527: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID);
528: DELETE FROM po_requisitions_interface_all
529: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
530: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID;
531: END IF;
532: -- End Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
533: --dbms_output.put_line('Purged error records ');

Line 1806: AHL_GLOBAL.AHL_APP_SHORT_NAME, -- INTERFACE_SOURCE_CODE = 'AHL'

1802: ORG_ID -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1803: ) VALUES (
1804: l_intf_hdr_id,
1805: l_batch_id,
1806: AHL_GLOBAL.AHL_APP_SHORT_NAME, -- INTERFACE_SOURCE_CODE = 'AHL'
1807: G_PROCESS_CODE, -- 'PENDING'
1808: G_ACTION_CODE, -- 'ORIGINAL'
1809: G_DOC_TYPE_CODE, -- 'STANDARD'
1810: l_currency_code,

Line 1816: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,

1812: p_po_header_rec.VENDOR_ID,
1813: p_po_header_rec.VENDOR_SITE_ID,
1814: p_po_header_rec.VENDOR_CONTACT_ID, -- Added by jaramana on May 27, 2005 for Inventory Service Orders
1815: l_description,
1816: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1817: AHL_GLOBAL.AHL_APPLICATION_ID,
1818: p_po_header_rec.OSP_ORDER_ID,
1819: l_manual_po_number, -- SATHAPLI::Bug 8583364, 21-Aug-2009, l_manual_po_number to be passed - either NULL or created
1820: l_curr_org_id -- Added by jaramana on Sep 9, 2005 for MOAC Uptake

Line 1817: AHL_GLOBAL.AHL_APPLICATION_ID,

1813: p_po_header_rec.VENDOR_SITE_ID,
1814: p_po_header_rec.VENDOR_CONTACT_ID, -- Added by jaramana on May 27, 2005 for Inventory Service Orders
1815: l_description,
1816: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1817: AHL_GLOBAL.AHL_APPLICATION_ID,
1818: p_po_header_rec.OSP_ORDER_ID,
1819: l_manual_po_number, -- SATHAPLI::Bug 8583364, 21-Aug-2009, l_manual_po_number to be passed - either NULL or created
1820: l_curr_org_id -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1821: );

Line 1942: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,

1938: p_po_line_tbl(i).NEED_BY_DATE,
1939: p_po_line_tbl(i).OSP_LINE_ID,
1940: p_po_line_tbl(i).SHIP_TO_ORG_ID,
1941: p_po_line_tbl(i).SHIP_TO_LOC_ID,
1942: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1943: AHL_GLOBAL.AHL_APPLICATION_ID
1944: );
1945: -- Added by jaramana on Jan 5, 2006 for ER 4736326
1946: -- Check the profile OSP Default PO Distribution Creation to see if the Distribution is to be created

Line 1943: AHL_GLOBAL.AHL_APPLICATION_ID

1939: p_po_line_tbl(i).OSP_LINE_ID,
1940: p_po_line_tbl(i).SHIP_TO_ORG_ID,
1941: p_po_line_tbl(i).SHIP_TO_LOC_ID,
1942: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1943: AHL_GLOBAL.AHL_APPLICATION_ID
1944: );
1945: -- Added by jaramana on Jan 5, 2006 for ER 4736326
1946: -- Check the profile OSP Default PO Distribution Creation to see if the Distribution is to be created
1947: IF (NVL(FND_PROFILE.VALUE('AHL_OSP_DEF_PO_DIST'), 'N') = 'Y') THEN

Line 2003: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,

1999: p_intf_header_id,
2000: l_intf_line_id,
2001: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL,
2002: p_po_line_tbl(i).QUANTITY,
2003: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
2004: AHL_GLOBAL.AHL_APPLICATION_ID,
2005: SYSDATE,
2006: FND_GLOBAL.USER_ID
2007: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740

Line 2004: AHL_GLOBAL.AHL_APPLICATION_ID,

2000: l_intf_line_id,
2001: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL,
2002: p_po_line_tbl(i).QUANTITY,
2003: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
2004: AHL_GLOBAL.AHL_APPLICATION_ID,
2005: SYSDATE,
2006: FND_GLOBAL.USER_ID
2007: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740
2008: ,p_po_line_tbl(i).wip_entity_id

Line 2128: INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;

2124: /*
2125: CURSOR l_get_po_hdr_csr(p_osp_order_id IN NUMBER) IS
2126: SELECT PO_HEADER_ID FROM PO_HEADERS_ALL
2127: WHERE REFERENCE_NUM = p_osp_order_id AND
2128: INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;
2129: */
2130: -- Changes made by jaramana on December 19, 2005
2131: -- to improve the performace of this SQL by removing the Full Table Access
2132: CURSOR l_get_po_hdr_csr(p_osp_order_id IN NUMBER) IS

Line 2138: PO.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;

2134: WHERE PO.REFERENCE_NUM = p_osp_order_id AND
2135: OSP.OSP_ORDER_ID = p_osp_order_id AND
2136: PO.VENDOR_ID = OSP.VENDOR_ID AND
2137: PO.VENDOR_SITE_ID = OSP.VENDOR_SITE_ID AND
2138: PO.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;
2139:
2140: CURSOR l_get_osp_lines_csr(p_osp_order_id IN NUMBER) IS
2141: SELECT OSP_ORDER_LINE_ID FROM AHL_OSP_ORDER_LINES
2142: WHERE PO_LINE_ID IS NULL

Line 2265: PO.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME AND -- AHL Created PO

2261: FROM PO_LINES_ALL PL, PO_HEADERS_ALL PO, AHL_OSP_ORDER_LINES OL,
2262: AHL_OSP_ORDERS_B OSP
2263: WHERE PL.CANCEL_FLAG = 'Y' AND -- Canceled PO Line
2264: PL.PO_HEADER_ID = PO.PO_HEADER_ID AND
2265: PO.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME AND -- AHL Created PO
2266: PO.REFERENCE_NUM = OL.OSP_ORDER_ID AND -- Related to the OSP Order
2267: OSP.OSP_ORDER_ID = PO.REFERENCE_NUM AND
2268: -- Added by jaramana on April 7, 2008 for bug 6609988
2269: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND