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 2250: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;

2246: l_table_index NUMBER := 0;
2247: l_return_status VARCHAR2(1);
2248: l_msg_count NUMBER;
2249: l_msg_data VARCHAR2(1000);
2250: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2251: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2252: l_commit_flag BOOLEAN := true;
2253: l_osp_obj_ver_num NUMBER;
2254: l_ol_obj_ver_num NUMBER;

Line 2251: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;

2247: l_return_status VARCHAR2(1);
2248: l_msg_count NUMBER;
2249: l_msg_data VARCHAR2(1000);
2250: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2251: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2252: l_commit_flag BOOLEAN := true;
2253: l_osp_obj_ver_num NUMBER;
2254: l_ol_obj_ver_num NUMBER;
2255:

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

2276: -- Cancel all OSP Lines pertaining to the previous OSP Order
2277: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2278: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Cancelling OSP Line for Order ' || l_prev_osp_order_id);
2279: END IF;
2280: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2281: p_init_msg_list => FND_API.G_FALSE,
2282: p_commit => FND_API.G_FALSE,
2283: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2284: p_x_osp_order_rec => l_osp_order_rec,

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

2307: l_osp_order_lines_tbl(l_table_index).OBJECT_VERSION_NUMBER := l_ol_obj_ver_num;
2308: -- Set OSP Line Status to G_OL_PO_CANCELLED_STATUS in API's Line Table
2309: l_osp_order_lines_tbl(l_table_index).STATUS_CODE := G_OL_PO_CANCELLED_STATUS;
2310: -- Set Operation to Update in the line rec
2311: l_osp_order_lines_tbl(l_table_index).OPERATION_FLAG := AHL_OSP_ORDERS_PVT.G_OP_UPDATE;
2312:
2313: l_table_index := l_table_index + 1;
2314: END LOOP;
2315: CLOSE l_get_cancelled_po_lines_csr;

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

2317: -- Save the Last Cancellation
2318: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Cancelling OSP Line for Order ' || l_prev_osp_order_id);
2320: END IF;
2321: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2322: p_init_msg_list => FND_API.G_FALSE,
2323: p_commit => FND_API.G_FALSE,
2324: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2325: p_x_osp_order_rec => l_osp_order_rec,

Line 2400: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;

2396: l_table_index NUMBER := 0;
2397: l_return_status VARCHAR2(1);
2398: l_msg_count NUMBER;
2399: l_msg_data VARCHAR2(1000);
2400: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2401: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2402: l_commit_flag BOOLEAN := true;
2403: l_osp_obj_ver_num NUMBER;
2404: l_ol_obj_ver_num NUMBER;

Line 2401: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;

2397: l_return_status VARCHAR2(1);
2398: l_msg_count NUMBER;
2399: l_msg_data VARCHAR2(1000);
2400: l_osp_order_rec AHL_OSP_ORDERS_PVT.osp_order_rec_type;
2401: l_osp_order_lines_tbl AHL_OSP_ORDERS_PVT.osp_order_lines_tbl_type;
2402: l_commit_flag BOOLEAN := true;
2403: l_osp_obj_ver_num NUMBER;
2404: l_ol_obj_ver_num NUMBER;
2405:

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

2425: -- PO Delete all OSP Lines pertaining to the previous OSP Order
2426: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleting OSP Line for Order ' || l_prev_osp_order_id);
2428: END IF;
2429: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2430: p_init_msg_list => FND_API.G_FALSE,
2431: p_commit => FND_API.G_FALSE,
2432: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2433: p_x_osp_order_rec => l_osp_order_rec,

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

2456: l_osp_order_lines_tbl(l_table_index).OBJECT_VERSION_NUMBER := l_ol_obj_ver_num;
2457: -- Set OSP Line Status to G_OL_PO_DELETED_STATUS in API's Line Table
2458: l_osp_order_lines_tbl(l_table_index).STATUS_CODE := G_OL_PO_DELETED_STATUS;
2459: -- Set Operation to Update in the line rec
2460: l_osp_order_lines_tbl(l_table_index).OPERATION_FLAG := AHL_OSP_ORDERS_PVT.G_OP_UPDATE;
2461: l_table_index := l_table_index + 1;
2462: END LOOP;
2463: CLOSE l_get_deleted_po_lines_csr;
2464: IF (l_prev_osp_order_id <> -1) THEN

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

2465: -- Save the Last Deletion
2466: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2467: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleting OSP Line for Order ' || l_prev_osp_order_id);
2468: END IF;
2469: AHL_OSP_ORDERS_PVT.process_osp_order(p_api_version => 1.0,
2470: p_init_msg_list => FND_API.G_FALSE,
2471: p_commit => FND_API.G_FALSE,
2472: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2473: p_x_osp_order_rec => l_osp_order_rec,