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_OSP_ORDER_LINES

Line 122: -- This Procedure updates AHL_OSP_ORDER_LINES.P_PO_REQ_LINE_ID

118: PROCEDURE Set_PO_Req_Header_ID(
119: p_osp_order_id IN NUMBER,
120: p_po_req_header_id IN NUMBER);
121:
122: -- This Procedure updates AHL_OSP_ORDER_LINES.P_PO_REQ_LINE_ID
123: PROCEDURE Update_Osp_Order_Lines(
124: p_osp_order_line_id IN NUMBER,
125: p_po_req_line_id IN NUMBER := NULL);
126:

Line 258: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU, WIP_DISCRETE_JOBS WDJ

254: DECODE(OL.WORKORDER_ID, NULL, HAOU.LOCATION_ID, BOM.LOCATION_ID),
255: WO.WIP_ENTITY_ID,
256: WDJ.PROJECT_ID,
257: WDJ.TASK_ID
258: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU, WIP_DISCRETE_JOBS WDJ
259: WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
260: WO.WORKORDER_ID (+) = OL.WORKORDER_ID AND
261: WDJ.WIP_ENTITY_ID (+) = WO.WIP_ENTITY_ID AND
262: BOM.DEPARTMENT_ID (+) = WDJ.OWNING_DEPARTMENT AND

Line 268: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU

264: ORDER BY OL.OSP_LINE_NUMBER;
265:
266: CURSOR get_return_to_org_csr(p_osp_line_id IN NUMBER) IS
267: SELECT oola.ship_from_org_id, HAOU.LOCATION_ID
268: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU
269: WHERE oola.line_id = aool.oe_return_line_id and
270: HAOU.ORGANIZATION_ID = oola.ship_from_org_id and
271: aool.osp_order_line_id = p_osp_line_id;
272:

Line 712: -- AHL_OSP_ORDER_LINES.PO_REQ_LINE_ID with REQUISITION_HEADER_ID and

708: -- Start of Comments --
709: -- Procedure name : Associate_All_New_Reqs
710: -- Type : Private
711: -- Function : Updates AHL_OSP_ORDERS_B.PO_REQ_HEADER_ID and
712: -- AHL_OSP_ORDER_LINES.PO_REQ_LINE_ID with REQUISITION_HEADER_ID and
713: -- REQUISITION_LINE_ID respectively for all submitted OSP Orders (for Requisitions).
714: -- Pre-reqs :
715: -- Parameters :
716: --

Line 1564: SELECT OSP_ORDER_LINE_ID FROM AHL_OSP_ORDER_LINES

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
1566: AND OSP_ORDER_ID = p_osp_order_id;
1567:
1568: CURSOR l_get_po_req_line_csr(p_osp_order_line_id IN NUMBER, p_po_req_header_id IN NUMBER) IS

Line 1579: (select count(*) from AHL_OSP_ORDER_LINES where OSP_ORDER_ID = p_osp_order_id) =

1575: WHERE OSP_ORDER_ID = p_osp_order_id;
1576:
1577: CURSOR check_req_completeness_csr(c_po_req_header_id IN NUMBER) IS
1578: select 1 from dual where
1579: (select count(*) from AHL_OSP_ORDER_LINES where OSP_ORDER_ID = p_osp_order_id) =
1580: (select count(*) from
1581: PO_REQUISITION_LINES_ALL REQL, AHL_OSP_ORDER_LINES OSPL
1582: where OSPL.OSP_ORDER_ID = p_osp_order_id
1583: AND REQL.REFERENCE_NUM = OSPL.osp_order_line_id

Line 1581: PO_REQUISITION_LINES_ALL REQL, AHL_OSP_ORDER_LINES OSPL

1577: CURSOR check_req_completeness_csr(c_po_req_header_id IN NUMBER) IS
1578: select 1 from dual where
1579: (select count(*) from AHL_OSP_ORDER_LINES where OSP_ORDER_ID = p_osp_order_id) =
1580: (select count(*) from
1581: PO_REQUISITION_LINES_ALL REQL, AHL_OSP_ORDER_LINES OSPL
1582: where OSPL.OSP_ORDER_ID = p_osp_order_id
1583: AND REQL.REFERENCE_NUM = OSPL.osp_order_line_id
1584: AND REQL.REQUISITION_HEADER_ID = c_po_req_header_id);
1585:

Line 1749: FROM AHL_OSP_ORDER_LINES

1745: ATTRIBUTE12,
1746: ATTRIBUTE13,
1747: ATTRIBUTE14,
1748: ATTRIBUTE15
1749: FROM AHL_OSP_ORDER_LINES
1750: WHERE OSP_ORDER_LINE_ID = p_osp_order_line_id;
1751:
1752: l_osp_line_dtls_rec l_osp_line_dtls_csr%ROWTYPE;
1753: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_Osp_Order_Lines';

Line 1781: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW(

1777: l_osp_line_dtls_rec.PO_REQ_LINE_ID := p_po_req_line_id;
1778: END IF;
1779:
1780: -- Call Table Handler
1781: AHL_OSP_ORDER_LINES_PKG.UPDATE_ROW(
1782: P_OSP_ORDER_LINE_ID => p_osp_order_line_id,
1783: P_OBJECT_VERSION_NUMBER => l_osp_line_dtls_rec.OBJECT_VERSION_NUMBER + 1, -- Updated
1784: P_OSP_ORDER_ID => l_osp_line_dtls_rec.OSP_ORDER_ID,
1785: P_OSP_LINE_NUMBER => l_osp_line_dtls_rec.OSP_LINE_NUMBER,

Line 1855: -- This procedure does a direct update of the AHL_OSP_ORDERS_B and the AHL_OSP_ORDER_LINES

1851: -- we need to change the OSP order to bring it to a consistent state.
1852: -- This procedure basically looks for OSP Orders for which the Requisition has been deleted
1853: -- and resets some values and corrects the status of the order as well as the lines
1854: -- so that the OSP Order can be resubmitted and a different Requisition can be created.
1855: -- This procedure does a direct update of the AHL_OSP_ORDERS_B and the AHL_OSP_ORDER_LINES
1856: -- tables and does not call the process_osp_order API to avoid unwanted validations
1857: ----------------------------------------
1858: PROCEDURE Handle_Deleted_Req_Headers(
1859: p_commit IN VARCHAR2,

Line 1881: FROM ahl_osp_order_lines ospl

1877: ospl.osp_order_line_id,
1878: ospl.object_version_number,
1879: ospl.status_code,
1880: ospl.po_req_line_id
1881: FROM ahl_osp_order_lines ospl
1882: WHERE ospl.osp_order_id = c_osp_order_id;
1883:
1884: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Handle_Deleted_Req_Headers';
1885: l_temp_num NUMBER := 0;

Line 1918: update ahl_osp_order_lines

1914: -- Reset the value of PO_REQ_LINE_ID and increment OVN (status_code is already null)
1915: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Updating OSP Line with Id ' || l_osp_line_details_rec.osp_order_line_id);
1917: END IF;
1918: update ahl_osp_order_lines
1919: set po_req_line_id = null,
1920: object_version_number = l_osp_line_details_rec.object_version_number + 1,
1921: last_update_date = TRUNC(sysdate),
1922: last_updated_by = fnd_global.user_id,

Line 1931: DELETE FROM ahl_osp_order_lines

1927: -- Physically delete this line (REQ_DELETED, REQ_CANCELLED)
1928: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1929: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleting OSP Line with Id ' || l_osp_line_details_rec.osp_order_line_id);
1930: END IF;
1931: DELETE FROM ahl_osp_order_lines
1932: WHERE osp_order_line_id = l_osp_line_details_rec.osp_order_line_id;
1933: END IF;
1934: END LOOP;
1935: CLOSE get_osp_line_dtls_csr;

Line 2002: AHL_OSP_ORDER_LINES OL,

1998: OL.OBJECT_VERSION_NUMBER,
1999: OSP.OBJECT_VERSION_NUMBER
2000: FROM PO_REQUISITION_LINES_ALL REQL,
2001: PO_REQUISITION_HEADERS_ALL REQH,
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

Line 2157: FROM AHL_OSP_ORDER_LINES OL, AHL_OSP_ORDERS_B OSP

2153:
2154: CURSOR l_get_deleted_req_lines_csr IS
2155: SELECT OL.OSP_ORDER_ID, OL.OSP_ORDER_LINE_ID,
2156: OL.OBJECT_VERSION_NUMBER, OSP.OBJECT_VERSION_NUMBER
2157: FROM AHL_OSP_ORDER_LINES OL, AHL_OSP_ORDERS_B OSP
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