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_REQ_PVT dependencies on AHL_GLOBAL

Line 386: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

382: DELETE FROM po_interface_errors
383: WHERE INTERFACE_TRANSACTION_ID in
384: (SELECT transaction_id
385: FROM po_requisitions_interface_all
386: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
387: AND INTERFACE_SOURCE_LINE_ID = l_po_req_header.OSP_ORDER_ID);
388: DELETE FROM po_requisitions_interface_all
389: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
390: AND INTERFACE_SOURCE_LINE_ID = l_po_req_header.OSP_ORDER_ID;

Line 389: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

385: FROM po_requisitions_interface_all
386: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
387: AND INTERFACE_SOURCE_LINE_ID = l_po_req_header.OSP_ORDER_ID);
388: DELETE FROM po_requisitions_interface_all
389: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
390: AND INTERFACE_SOURCE_LINE_ID = l_po_req_header.OSP_ORDER_ID;
391:
392: ELSIF(l_status = G_OSP_SUB_FAILED_STATUS and l_old_intf_header_id IS NOT NULL) THEN
393: -- Earlier, User tried to create a PO (not a requisition) and that failed.

Line 992: AHL_GLOBAL.AHL_APP_SHORT_NAME, --INTERFACE_SOURCE_CODE

988: --Project related fields End
989: )
990: VALUES
991: (
992: AHL_GLOBAL.AHL_APP_SHORT_NAME, --INTERFACE_SOURCE_CODE
993: p_po_req_hdr_rec.OSP_ORDER_ID, --INTERFACE_SOURCE_LINE_ID
994: p_po_req_line_tbl(i).OSP_LINE_ID, --REFERENCE_NUM
995: p_po_req_line_tbl(i).PO_LINE_TYPE_ID, --LINE_TYPE_ID
996: 'VENDOR', --SOURCE_TYPE_CODE

Line 1024: AHL_GLOBAL.AHL_OSP_PROGRAM_ID, --PROGRAM_ID

1020:
1021: p_po_req_hdr_rec.OSP_ORDER_ID, --GROUP_CODE
1022: p_po_req_hdr_rec.OSP_ORDER_ID, --BATCH_ID
1023: p_po_req_hdr_rec.OPERATING_UNIT_ID, --ORG_ID
1024: AHL_GLOBAL.AHL_OSP_PROGRAM_ID, --PROGRAM_ID
1025: AHL_GLOBAL.AHL_APPLICATION_ID, --PROGRAM_APPLICATION_ID
1026: l_charge_acct_id, --CHARGE_ACCOUNT_ID
1027:
1028: decode(p_po_req_line_tbl(i).PROJECT_ID, null, null, 'Y'), --PROJECT_ACCOUNTING_CONTEXT

Line 1025: AHL_GLOBAL.AHL_APPLICATION_ID, --PROGRAM_APPLICATION_ID

1021: p_po_req_hdr_rec.OSP_ORDER_ID, --GROUP_CODE
1022: p_po_req_hdr_rec.OSP_ORDER_ID, --BATCH_ID
1023: p_po_req_hdr_rec.OPERATING_UNIT_ID, --ORG_ID
1024: AHL_GLOBAL.AHL_OSP_PROGRAM_ID, --PROGRAM_ID
1025: AHL_GLOBAL.AHL_APPLICATION_ID, --PROGRAM_APPLICATION_ID
1026: l_charge_acct_id, --CHARGE_ACCOUNT_ID
1027:
1028: decode(p_po_req_line_tbl(i).PROJECT_ID, null, null, 'Y'), --PROJECT_ACCOUNTING_CONTEXT
1029: decode(p_po_req_line_tbl(i).PROJECT_ID, null, null, l_expenditure_item_type), --EXPENDITURE_TYPE

Line 1077: argument1 => AHL_GLOBAL.AHL_APP_SHORT_NAME, -- Origin of requisition (INTERFACE_SOURCE_CODE)

1073:
1074: x_request_id := FND_REQUEST.SUBMIT_REQUEST(
1075: application => G_PO_APP_CODE,
1076: program => G_REQIMPORT_PROG_CODE,
1077: argument1 => AHL_GLOBAL.AHL_APP_SHORT_NAME, -- Origin of requisition (INTERFACE_SOURCE_CODE)
1078: argument2 => p_osp_order_id, -- ID of batch to be imported (BATCH_ID)
1079: argument3 => p_osp_order_id, -- Parameter to group reqs by (GROUP_BY)
1080: argument4 => NULL, -- Last Requisition Number
1081: argument5 => 'N', -- Speicfies if Multiple Distributions are to be created

Line 1561: POREQ.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;

1557: FROM PO_REQUISITION_HEADERS_ALL POREQ, AHL_OSP_ORDERS_B OSP
1558: WHERE POREQ.INTERFACE_SOURCE_LINE_ID = p_osp_order_id AND
1559: OSP.OSP_ORDER_ID = p_osp_order_id AND
1560: OSP.OPERATING_UNIT_ID = POREQ.ORG_ID AND
1561: POREQ.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME;
1562:
1563: CURSOR l_get_osp_lines_csr(p_osp_order_id IN NUMBER) IS
1564: SELECT OSP_ORDER_LINE_ID FROM AHL_OSP_ORDER_LINES
1565: WHERE PO_REQ_LINE_ID IS NULL

Line 2006: REQH.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME AND -- AHL Created Req

2002: AHL_OSP_ORDER_LINES OL,
2003: AHL_OSP_ORDERS_B OSP
2004: WHERE nvl(REQL.CANCEL_FLAG,'N') = 'Y' AND -- Canceled Req Line
2005: REQL.REQUISITION_HEADER_ID = REQH.REQUISITION_HEADER_ID AND
2006: REQH.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME AND -- AHL Created Req
2007: REQH.INTERFACE_SOURCE_LINE_ID = OSP.OSP_ORDER_ID AND -- Related to the OSP Order
2008: OSP.OSP_ORDER_ID = OL.OSP_ORDER_ID AND
2009: -- Added by jaramana on April 7, 2008 for bug 6609988
2010: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND