APPS.AHL_OSP_PO_REQ_PVT dependencies on MO_GLOBAL

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

749: WHERE STATUS_CODE = G_OSP_REQ_SUBMITTED_STATUS
750: AND PO_REQ_HEADER_ID IS NULL
751: AND PO_BATCH_ID IS NOT NULL
752: -- Added by jaramana on April 7, 2008 for bug 6609988
753: AND OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id();
754:
755: l_api_version CONSTANT NUMBER := 1.0;
756: l_api_name CONSTANT VARCHAR2(30) := 'Associate_All_New_Reqs';
757: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Associate_All_New_Reqs';

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

891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
892: END IF;
893:
894: -- Get the current Org to get Item Price
895: l_org_id := MO_GLOBAL.get_current_org_id();
896:
897: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'p_po_req_line_tbl.count: '|| p_po_req_line_tbl.count);
899: END IF;

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

1067: l_curr_org_id NUMBER;
1068:
1069: BEGIN
1070: -- Added by jaramana on Feb 7, 2008
1071: l_curr_org_id := MO_GLOBAL.get_current_org_id();
1072: FND_REQUEST.SET_ORG_ID(l_curr_org_id);
1073:
1074: x_request_id := FND_REQUEST.SUBMIT_REQUEST(
1075: application => G_PO_APP_CODE,

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

1277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1278: END IF;
1279:
1280: -- Get the current Org
1281: l_org_id := MO_GLOBAL.get_current_org_id();
1282: IF (l_org_id IS NULL) THEN
1283: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');
1284: FND_MSG_PUB.ADD;
1285: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1868: FROM ahl_osp_orders_b osp
1869: WHERE osp.status_code = G_OSP_REQ_CREATED_STATUS AND
1870: osp.order_type_code in ('SERVICE', 'EXCHANGE') AND
1871: -- Added by jaramana on April 7, 2008 for bug 6609988
1872: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND
1873: NOT EXISTS (SELECT 1 FROM po_requisition_headers_all where requisition_header_id = osp.po_req_header_id);
1874:
1875: CURSOR get_osp_line_dtls_csr(c_osp_order_id IN NUMBER) IS
1876: SELECT ospl.osp_order_id,

Line 2010: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_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
2011: OL.PO_REQ_LINE_ID = REQL.REQUISITION_LINE_ID AND
2012: NVL(OL.STATUS_CODE, ' ') <> G_OL_REQ_CANCELLED_STATUS -- Not yet updated
2013: ORDER BY REQH.INTERFACE_SOURCE_LINE_ID; -- One OSP Order at a time
2014:

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

2158: WHERE OL.PO_REQ_LINE_ID IS NOT NULL AND -- PO Created
2159: NVL(OL.STATUS_CODE, ' ') <> G_OL_REQ_DELETED_STATUS AND -- Not yet updated
2160: OSP.OSP_ORDER_ID = OL.OSP_ORDER_ID AND
2161: -- Added by jaramana on April 7, 2008 for bug 6609988
2162: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND
2163: NOT EXISTS (SELECT REQUISITION_LINE_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_LINE_ID = OL.PO_REQ_LINE_ID) -- Req Line Deleted
2164: ORDER BY OL.OSP_ORDER_ID; -- One OSP Order at a time
2165:
2166: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Deleted_Req_Lines';