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 MO_GLOBAL

Line 874: AND OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id();

870: WHERE STATUS_CODE = G_OSP_SUBMITTED_STATUS
871: AND PO_HEADER_ID IS NULL
872: AND PO_BATCH_ID IS NOT NULL
873: -- Added by jaramana on April 7, 2008 for bug 6609988
874: AND OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id();
875:
876: l_api_version CONSTANT NUMBER := 1.0;
877: l_api_name CONSTANT VARCHAR2(30) := 'Associate_All_OSP_POs';
878: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Associate_All_OSP_POs';

Line 1037: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure. Operating Unit = ' || MO_GLOBAL.get_current_org_id());

1033: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.PO_Synch_All_OSPs';
1034:
1035: BEGIN
1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure. Operating Unit = ' || MO_GLOBAL.get_current_org_id());
1038: END IF;
1039:
1040: -- No need of a Savepoint: Individual procedures commit or rollback
1041: -- within themselves.

Line 1545: l_org_id := MO_GLOBAL.get_current_org_id();

1541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1542: END IF;
1543:
1544: -- Get the current Org
1545: l_org_id := MO_GLOBAL.get_current_org_id();
1546:
1547: IF (l_org_id IS NULL) THEN
1548: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');
1549: FND_MSG_PUB.ADD;

Line 1779: l_curr_org_id := MO_GLOBAL.get_current_org_id();

1775: RAISE;
1776: END;
1777:
1778: -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1779: l_curr_org_id := MO_GLOBAL.get_current_org_id();
1780:
1781: -- SATHAPLI::Bug 8583364, 21-Aug-2009, call create_manual_PO_Number to get the manual PO number
1782: l_manual_po_number := create_manual_PO_Number(l_curr_org_id, p_po_header_rec.OSP_ORDER_ID);
1783:

Line 1893: l_org_id := MO_GLOBAL.get_current_org_id();

1889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1890: END IF;
1891:
1892: -- Get the current Org to get Item Price
1893: l_org_id := MO_GLOBAL.get_current_org_id();
1894:
1895: FOR i IN p_po_line_tbl.FIRST..p_po_line_tbl.LAST LOOP
1896: IF (p_po_line_tbl(i).ITEM_ID IS NULL) THEN
1897: -- One time items defaulting

Line 2050: l_curr_org_id := MO_GLOBAL.get_current_org_id();

2046: l_curr_org_id NUMBER;
2047:
2048: BEGIN
2049: -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
2050: l_curr_org_id := MO_GLOBAL.get_current_org_id();
2051: FND_REQUEST.SET_ORG_ID(l_curr_org_id);
2052:
2053: x_request_id := FND_REQUEST.SUBMIT_REQUEST(
2054: application => G_PO_APP_CODE,

Line 2269: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_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
2270: OL.PO_LINE_ID = PL.PO_LINE_ID AND
2271: NVL(OL.STATUS_CODE, ' ') <> G_OL_PO_CANCELLED_STATUS -- Not yet updated
2272: ORDER BY PO.REFERENCE_NUM; -- One OSP Order at a time
2273:

Line 2421: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND

2417: WHERE OL.PO_LINE_ID IS NOT NULL AND -- PO Created
2418: NVL(OL.STATUS_CODE, ' ') <> G_OL_PO_DELETED_STATUS AND -- Not yet updated
2419: OSP.OSP_ORDER_ID = OL.OSP_ORDER_ID AND
2420: -- Added by jaramana on April 7, 2008 for bug 6609988
2421: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND
2422: NOT EXISTS (SELECT PO_LINE_ID FROM PO_LINES_ALL WHERE PO_LINE_ID = OL.PO_LINE_ID) -- PO Line Deleted
2423: ORDER BY OL.OSP_ORDER_ID; -- One OSP Order at a time
2424:
2425: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Deleted_PO_Lines';

Line 2568: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND

2564: FROM AHL_OSP_ORDERS_B OSP, PO_HEADERS_ALL PO
2565: WHERE OSP.STATUS_CODE = G_OSP_PO_CREATED_STATUS AND -- PO Created
2566: OSP.PO_HEADER_ID = PO.PO_HEADER_ID AND -- Join
2567: -- Added by jaramana on April 7, 2008 for bug 6609988
2568: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND
2569: PO.APPROVED_FLAG = G_YES_FLAG AND -- Approved PO
2570: NVL(PO.CANCEL_FLAG, G_NO_FLAG) <> G_YES_FLAG AND -- Not Cancelled
2571: NVL(PO.CLOSED_CODE, G_PO_OPEN) NOT LIKE '%CLOSED'; -- Not Closed
2572:

Line 2696: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND

2692: FROM ahl_osp_orders_b osp
2693: WHERE osp.status_code = G_OSP_PO_CREATED_STATUS AND
2694: osp.order_type_code in ('SERVICE', 'EXCHANGE') AND
2695: -- Added by jaramana on April 7, 2008 for bug 6609988
2696: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND
2697: NOT EXISTS (SELECT 1 FROM po_headers_all where po_header_id = osp.po_header_id);
2698:
2699: CURSOR get_osp_line_dtls_csr(c_osp_order_id IN NUMBER) IS
2700: SELECT ospl.osp_order_id,

Line 2833: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND

2829: FROM ahl_osp_orders_b osp
2830: WHERE osp.status_code <> 'CLOSED' AND
2831: osp.oe_header_id IS NOT NULL AND
2832: -- Added by jaramana on April 7, 2008 for bug 6609988
2833: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND
2834: NOT EXISTS (SELECT 1 FROM oe_order_headers_all where header_id = osp.oe_header_id);
2835:
2836: CURSOR get_osp_line_dtls_csr(c_osp_order_id IN NUMBER) IS
2837: SELECT ospl.osp_order_line_id,