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 AHL_OSP_ORDERS_PVT

Line 2283: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;

2279: l_table_index NUMBER := 0;
2280: l_return_status VARCHAR2(1);
2281: l_msg_count NUMBER;
2282: l_msg_data VARCHAR2(1000);
2283: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2284: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2285: l_commit_flag BOOLEAN := true;
2286: l_osp_obj_ver_num NUMBER;
2287: l_ol_obj_ver_num NUMBER;

Line 2284: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;

2280: l_return_status VARCHAR2(1);
2281: l_msg_count NUMBER;
2282: l_msg_data VARCHAR2(1000);
2283: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2284: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2285: l_commit_flag BOOLEAN := true;
2286: l_osp_obj_ver_num NUMBER;
2287: l_ol_obj_ver_num NUMBER;
2288:

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

2309: -- Cancel all OSP Lines pertaining to the previous OSP Order
2310: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2311: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Cancelling OSP Line for Order ' || l_prev_osp_order_id);
2312: END IF;
2313: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2314: p_init_msg_list => FND_API.G_FALSE,
2315: p_commit => FND_API.G_FALSE,
2316: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2317: p_x_osp_order_rec => l_osp_order_rec,

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

2340: l_osp_order_lines_tbl(l_table_index).OBJECT_VERSION_NUMBER := l_ol_obj_ver_num;
2341: -- Set OSP Line Status to G_OL_PO_CANCELLED_STATUS in API's Line Table
2342: l_osp_order_lines_tbl(l_table_index).STATUS_CODE := G_OL_PO_CANCELLED_STATUS;
2343: -- Set Operation to Update in the line rec
2344: l_osp_order_lines_tbl(l_table_index).OPERATION_FLAG := AHL_OSP_ORDERS_PVT.G_OP_UPDATE;
2345:
2346: l_table_index := l_table_index + 1;
2347: END LOOP;
2348: CLOSE l_get_cancelled_po_lines_csr;

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

2350: -- Save the Last Cancellation
2351: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Cancelling OSP Line for Order ' || l_prev_osp_order_id);
2353: END IF;
2354: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2355: p_init_msg_list => FND_API.G_FALSE,
2356: p_commit => FND_API.G_FALSE,
2357: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2358: p_x_osp_order_rec => l_osp_order_rec,

Line 2433: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;

2429: l_table_index NUMBER := 0;
2430: l_return_status VARCHAR2(1);
2431: l_msg_count NUMBER;
2432: l_msg_data VARCHAR2(1000);
2433: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2434: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2435: l_commit_flag BOOLEAN := true;
2436: l_osp_obj_ver_num NUMBER;
2437: l_ol_obj_ver_num NUMBER;

Line 2434: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;

2430: l_return_status VARCHAR2(1);
2431: l_msg_count NUMBER;
2432: l_msg_data VARCHAR2(1000);
2433: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2434: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2435: l_commit_flag BOOLEAN := true;
2436: l_osp_obj_ver_num NUMBER;
2437: l_ol_obj_ver_num NUMBER;
2438:

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

2458: -- PO Delete all OSP Lines pertaining to the previous OSP Order
2459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleting OSP Line for Order ' || l_prev_osp_order_id);
2461: END IF;
2462: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2463: p_init_msg_list => FND_API.G_FALSE,
2464: p_commit => FND_API.G_FALSE,
2465: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2466: p_x_osp_order_rec => l_osp_order_rec,

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

2489: l_osp_order_lines_tbl(l_table_index).OBJECT_VERSION_NUMBER := l_ol_obj_ver_num;
2490: -- Set OSP Line Status to G_OL_PO_DELETED_STATUS in API's Line Table
2491: l_osp_order_lines_tbl(l_table_index).STATUS_CODE := G_OL_PO_DELETED_STATUS;
2492: -- Set Operation to Update in the line rec
2493: l_osp_order_lines_tbl(l_table_index).OPERATION_FLAG := AHL_OSP_ORDERS_PVT.G_OP_UPDATE;
2494: l_table_index := l_table_index + 1;
2495: END LOOP;
2496: CLOSE l_get_deleted_po_lines_csr;
2497: IF (l_prev_osp_order_id <> -1) THEN

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

2498: -- Save the Last Deletion
2499: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleting OSP Line for Order ' || l_prev_osp_order_id);
2501: END IF;
2502: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2503: p_init_msg_list => FND_API.G_FALSE,
2504: p_commit => FND_API.G_FALSE,
2505: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2506: p_x_osp_order_rec => l_osp_order_rec,