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_ORDERS_PVT

Line 2024: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;

2020: l_table_index NUMBER := 0;
2021: l_return_status VARCHAR2(1);
2022: l_msg_count NUMBER;
2023: l_msg_data VARCHAR2(1000);
2024: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2025: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2026: l_commit_flag BOOLEAN := true;
2027: l_osp_obj_ver_num NUMBER;
2028: l_ol_obj_ver_num NUMBER;

Line 2025: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;

2021: l_return_status VARCHAR2(1);
2022: l_msg_count NUMBER;
2023: l_msg_data VARCHAR2(1000);
2024: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2025: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2026: l_commit_flag BOOLEAN := true;
2027: l_osp_obj_ver_num NUMBER;
2028: l_ol_obj_ver_num NUMBER;
2029:

Line 2054: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,

2050: -- Cancel all OSP Lines pertaining to the previous OSP Order
2051: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Cancelling OSP Line for Order ' || l_prev_osp_order_id);
2053: END IF;
2054: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2055: p_init_msg_list => FND_API.G_FALSE,
2056: p_commit => FND_API.G_FALSE,
2057: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2058: p_x_osp_order_rec => l_osp_order_rec,

Line 2085: l_osp_order_lines_tbl(l_table_index).OPERATION_FLAG := AHL_OSP_ORDERS_PVT.G_OP_UPDATE;

2081: l_osp_order_lines_tbl(l_table_index).OBJECT_VERSION_NUMBER := l_ol_obj_ver_num;
2082: -- Set OSP Line Status to G_OL_REQ_CANCELLED_STATUS in API's Line Table
2083: l_osp_order_lines_tbl(l_table_index).STATUS_CODE := G_OL_REQ_CANCELLED_STATUS;
2084: -- Set Operation to Update in the line rec
2085: l_osp_order_lines_tbl(l_table_index).OPERATION_FLAG := AHL_OSP_ORDERS_PVT.G_OP_UPDATE;
2086:
2087: l_table_index := l_table_index + 1;
2088: END LOOP;
2089: CLOSE l_get_cancelled_req_lines_csr;

Line 2095: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,

2091: -- Save the Last Cancellation
2092: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2093: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Cancelling OSP Line for Order ' || l_prev_osp_order_id);
2094: END IF;
2095: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2096: p_init_msg_list => FND_API.G_FALSE,
2097: p_commit => FND_API.G_FALSE,
2098: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2099: p_x_osp_order_rec => l_osp_order_rec,

Line 2174: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;

2170: l_table_index NUMBER := 0;
2171: l_return_status VARCHAR2(1);
2172: l_msg_count NUMBER;
2173: l_msg_data VARCHAR2(1000);
2174: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2175: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2176: l_commit_flag BOOLEAN := true;
2177: l_osp_obj_ver_num NUMBER;
2178: l_ol_obj_ver_num NUMBER;

Line 2175: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;

2171: l_return_status VARCHAR2(1);
2172: l_msg_count NUMBER;
2173: l_msg_data VARCHAR2(1000);
2174: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2175: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2176: l_commit_flag BOOLEAN := true;
2177: l_osp_obj_ver_num NUMBER;
2178: l_ol_obj_ver_num NUMBER;
2179:

Line 2203: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,

2199: -- Req Delete all OSP Lines pertaining to the previous OSP Order
2200: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleting OSP Line for Order ' || l_prev_osp_order_id);
2202: END IF;
2203: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2204: p_init_msg_list => FND_API.G_FALSE,
2205: p_commit => FND_API.G_FALSE,
2206: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2207: p_x_osp_order_rec => l_osp_order_rec,

Line 2234: l_osp_order_lines_tbl(l_table_index).OPERATION_FLAG := AHL_OSP_ORDERS_PVT.G_OP_UPDATE;

2230: l_osp_order_lines_tbl(l_table_index).OBJECT_VERSION_NUMBER := l_ol_obj_ver_num;
2231: -- Set OSP Line Status to G_OL_REQ_DELETED_STATUS in API's Line Table
2232: l_osp_order_lines_tbl(l_table_index).STATUS_CODE := G_OL_REQ_DELETED_STATUS;
2233: -- Set Operation to Update in the line rec
2234: l_osp_order_lines_tbl(l_table_index).OPERATION_FLAG := AHL_OSP_ORDERS_PVT.G_OP_UPDATE;
2235: l_table_index := l_table_index + 1;
2236: END LOOP;
2237: CLOSE l_get_deleted_req_lines_csr;
2238: IF (l_prev_osp_order_id <> -1) THEN

Line 2243: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,

2239: -- Save the Last Deletion
2240: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleting OSP Line for Order ' || l_prev_osp_order_id);
2242: END IF;
2243: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2244: p_init_msg_list => FND_API.G_FALSE,
2245: p_commit => FND_API.G_FALSE,
2246: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2247: p_x_osp_order_rec => l_osp_order_rec,