[Home] [Help]
862: WHERE STATUS_CODE = G_OSP_SUBMITTED_STATUS
863: AND PO_HEADER_ID IS NULL
864: AND PO_BATCH_ID IS NOT NULL
865: -- Added by jaramana on April 7, 2008 for bug 6609988
866: AND OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id();
867:
868: l_api_version CONSTANT NUMBER := 1.0;
869: l_api_name CONSTANT VARCHAR2(30) := 'Associate_All_OSP_POs';
870: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Associate_All_OSP_POs';
1025: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.PO_Synch_All_OSPs';
1026:
1027: BEGIN
1028: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure. Operating Unit = ' || MO_GLOBAL.get_current_org_id());
1030: END IF;
1031:
1032: -- No need of a Savepoint: Individual procedures commit or rollback
1033: -- within themselves.
1533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1534: END IF;
1535:
1536: -- Get the current Org
1537: l_org_id := MO_GLOBAL.get_current_org_id();
1538:
1539: IF (l_org_id IS NULL) THEN
1540: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');
1541: FND_MSG_PUB.ADD;
1766: RAISE;
1767: END;
1768:
1769: -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
1770: l_curr_org_id := MO_GLOBAL.get_current_org_id();
1771:
1772: -- Insert row into PO_HEADERS_INTERFACE
1773: INSERT INTO PO_HEADERS_INTERFACE (
1774: INTERFACE_HEADER_ID,
1875: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1876: END IF;
1877:
1878: -- Get the current Org to get Item Price
1879: l_org_id := MO_GLOBAL.get_current_org_id();
1880:
1881: FOR i IN p_po_line_tbl.FIRST..p_po_line_tbl.LAST LOOP
1882: IF (p_po_line_tbl(i).ITEM_ID IS NULL) THEN
1883: -- One time items defaulting
2032: l_curr_org_id NUMBER;
2033:
2034: BEGIN
2035: -- Added by jaramana on Sep 9, 2005 for MOAC Uptake
2036: l_curr_org_id := MO_GLOBAL.get_current_org_id();
2037: FND_REQUEST.SET_ORG_ID(l_curr_org_id);
2038:
2039: x_request_id := FND_REQUEST.SUBMIT_REQUEST(
2040: application => G_PO_APP_CODE,
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
2237: OL.PO_LINE_ID = PL.PO_LINE_ID AND
2238: NVL(OL.STATUS_CODE, ' ') <> G_OL_PO_CANCELLED_STATUS -- Not yet updated
2239: ORDER BY PO.REFERENCE_NUM; -- One OSP Order at a time
2240:
2384: WHERE OL.PO_LINE_ID IS NOT NULL AND -- PO Created
2385: NVL(OL.STATUS_CODE, ' ') <> G_OL_PO_DELETED_STATUS AND -- Not yet updated
2386: OSP.OSP_ORDER_ID = OL.OSP_ORDER_ID AND
2387: -- Added by jaramana on April 7, 2008 for bug 6609988
2388: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND
2389: NOT EXISTS (SELECT PO_LINE_ID FROM PO_LINES_ALL WHERE PO_LINE_ID = OL.PO_LINE_ID) -- PO Line Deleted
2390: ORDER BY OL.OSP_ORDER_ID; -- One OSP Order at a time
2391:
2392: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Deleted_PO_Lines';
2531: FROM AHL_OSP_ORDERS_B OSP, PO_HEADERS_ALL PO
2532: WHERE OSP.STATUS_CODE = G_OSP_PO_CREATED_STATUS AND -- PO Created
2533: OSP.PO_HEADER_ID = PO.PO_HEADER_ID AND -- Join
2534: -- Added by jaramana on April 7, 2008 for bug 6609988
2535: OSP.OPERATING_UNIT_ID = MO_GLOBAL.get_current_org_id() AND
2536: PO.APPROVED_FLAG = G_YES_FLAG AND -- Approved PO
2537: NVL(PO.CANCEL_FLAG, G_NO_FLAG) <> G_YES_FLAG AND -- Not Cancelled
2538: NVL(PO.CLOSED_CODE, G_PO_OPEN) NOT LIKE '%CLOSED'; -- Not Closed
2539:
2659: FROM ahl_osp_orders_b osp
2660: WHERE osp.status_code = G_OSP_PO_CREATED_STATUS AND
2661: osp.order_type_code in ('SERVICE', 'EXCHANGE') AND
2662: -- Added by jaramana on April 7, 2008 for bug 6609988
2663: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND
2664: NOT EXISTS (SELECT 1 FROM po_headers_all where po_header_id = osp.po_header_id);
2665:
2666: CURSOR get_osp_line_dtls_csr(c_osp_order_id IN NUMBER) IS
2667: SELECT ospl.osp_order_id,
2796: FROM ahl_osp_orders_b osp
2797: WHERE osp.status_code <> 'CLOSED' AND
2798: osp.oe_header_id IS NOT NULL AND
2799: -- Added by jaramana on April 7, 2008 for bug 6609988
2800: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND
2801: NOT EXISTS (SELECT 1 FROM oe_order_headers_all where header_id = osp.oe_header_id);
2802:
2803: CURSOR get_osp_line_dtls_csr(c_osp_order_id IN NUMBER) IS
2804: SELECT ospl.osp_order_line_id,