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 518: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

514: DELETE FROM po_interface_errors
515: WHERE INTERFACE_TRANSACTION_ID in
516: (SELECT transaction_id
517: FROM po_requisitions_interface_all
518: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
519: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID);
520: DELETE FROM po_requisitions_interface_all
521: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
522: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID;

Line 521: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

517: FROM po_requisitions_interface_all
518: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
519: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID);
520: DELETE FROM po_requisitions_interface_all
521: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
522: AND INTERFACE_SOURCE_LINE_ID = l_po_header.OSP_ORDER_ID;
523: END IF;
524: -- End Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
525: --dbms_output.put_line('Purged error records ');

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

1789: ORG_ID -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1790: ) VALUES (
1791: l_intf_hdr_id,
1792: l_batch_id,
1793: AHL_GLOBAL.AHL_APP_SHORT_NAME, -- INTERFACE_SOURCE_CODE = 'AHL'
1794: G_PROCESS_CODE, -- 'PENDING'
1795: G_ACTION_CODE, -- 'ORIGINAL'
1796: G_DOC_TYPE_CODE, -- 'STANDARD'
1797: l_currency_code,

Line 1803: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,

1799: p_po_header_rec.VENDOR_ID,
1800: p_po_header_rec.VENDOR_SITE_ID,
1801: p_po_header_rec.VENDOR_CONTACT_ID, -- Added by jaramana on May 27, 2005 for Inventory Service Orders
1802: l_description,
1803: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1804: AHL_GLOBAL.AHL_APPLICATION_ID,
1805: p_po_header_rec.OSP_ORDER_ID,
1806: l_curr_org_id -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1807: );

Line 1804: AHL_GLOBAL.AHL_APPLICATION_ID,

1800: p_po_header_rec.VENDOR_SITE_ID,
1801: p_po_header_rec.VENDOR_CONTACT_ID, -- Added by jaramana on May 27, 2005 for Inventory Service Orders
1802: l_description,
1803: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1804: AHL_GLOBAL.AHL_APPLICATION_ID,
1805: p_po_header_rec.OSP_ORDER_ID,
1806: l_curr_org_id -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1807: );
1808:

Line 1928: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,

1924: p_po_line_tbl(i).NEED_BY_DATE,
1925: p_po_line_tbl(i).OSP_LINE_ID,
1926: p_po_line_tbl(i).SHIP_TO_ORG_ID,
1927: p_po_line_tbl(i).SHIP_TO_LOC_ID,
1928: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1929: AHL_GLOBAL.AHL_APPLICATION_ID
1930: );
1931: -- Added by jaramana on Jan 5, 2006 for ER 4736326
1932: -- Check the profile OSP Default PO Distribution Creation to see if the Distribution is to be created

Line 1929: AHL_GLOBAL.AHL_APPLICATION_ID

1925: p_po_line_tbl(i).OSP_LINE_ID,
1926: p_po_line_tbl(i).SHIP_TO_ORG_ID,
1927: p_po_line_tbl(i).SHIP_TO_LOC_ID,
1928: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1929: AHL_GLOBAL.AHL_APPLICATION_ID
1930: );
1931: -- Added by jaramana on Jan 5, 2006 for ER 4736326
1932: -- Check the profile OSP Default PO Distribution Creation to see if the Distribution is to be created
1933: IF (NVL(FND_PROFILE.VALUE('AHL_OSP_DEF_PO_DIST'), 'N') = 'Y') THEN

Line 1989: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,

1985: p_intf_header_id,
1986: l_intf_line_id,
1987: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL,
1988: p_po_line_tbl(i).QUANTITY,
1989: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1990: AHL_GLOBAL.AHL_APPLICATION_ID,
1991: SYSDATE,
1992: FND_GLOBAL.USER_ID
1993: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740

Line 1990: AHL_GLOBAL.AHL_APPLICATION_ID,

1986: l_intf_line_id,
1987: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL,
1988: p_po_line_tbl(i).QUANTITY,
1989: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1990: AHL_GLOBAL.AHL_APPLICATION_ID,
1991: SYSDATE,
1992: FND_GLOBAL.USER_ID
1993: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740
1994: ,p_po_line_tbl(i).wip_entity_id

Line 2095: INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;

2091: /*
2092: CURSOR l_get_po_hdr_csr(p_osp_order_id IN NUMBER) IS
2093: SELECT PO_HEADER_ID FROM PO_HEADERS_ALL
2094: WHERE REFERENCE_NUM = p_osp_order_id AND
2095: INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;
2096: */
2097: -- Changes made by jaramana on December 19, 2005
2098: -- to improve the performace of this SQL by removing the Full Table Access
2099: CURSOR l_get_po_hdr_csr(p_osp_order_id IN NUMBER) IS

Line 2105: PO.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;

2101: WHERE PO.REFERENCE_NUM = p_osp_order_id AND
2102: OSP.OSP_ORDER_ID = p_osp_order_id AND
2103: PO.VENDOR_ID = OSP.VENDOR_ID AND
2104: PO.VENDOR_SITE_ID = OSP.VENDOR_SITE_ID AND
2105: PO.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;
2106:
2107: CURSOR l_get_osp_lines_csr(p_osp_order_id IN NUMBER) IS
2108: SELECT OSP_ORDER_LINE_ID FROM AHL_OSP_ORDER_LINES
2109: WHERE PO_LINE_ID IS NULL

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

2228: FROM PO_LINES_ALL PL, PO_HEADERS_ALL PO, AHL_OSP_ORDER_LINES OL,
2229: AHL_OSP_ORDERS_B OSP
2230: WHERE PL.CANCEL_FLAG = 'Y' AND -- Canceled PO Line
2231: PL.PO_HEADER_ID = PO.PO_HEADER_ID AND
2232: PO.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME AND -- AHL Created PO
2233: PO.REFERENCE_NUM = OL.OSP_ORDER_ID AND -- Related to the OSP Order
2234: OSP.OSP_ORDER_ID = PO.REFERENCE_NUM AND
2235: -- Added by jaramana on April 7, 2008 for bug 6609988
2236: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND