APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_OSP_ORDERS_PVT

Line 1: PACKAGE BODY AHL_OSP_ORDERS_PVT AS

1: PACKAGE BODY AHL_OSP_ORDERS_PVT AS
2: /* $Header: AHLVOSPB.pls 120.28.12020000.2 2012/12/07 01:32:16 sareepar ship $ */
3:
4: --G_DEBUG varchar2(1) := FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_ORDERS_PVT';

2: /* $Header: AHLVOSPB.pls 120.28.12020000.2 2012/12/07 01:32:16 sareepar ship $ */
3:
4: --G_DEBUG varchar2(1) := FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_ORDERS_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
8: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.';
9: G_OAF_MODULE CONSTANT VARCHAR2(3) := 'OAF';
10:

Line 144: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,

140: FUNCTION can_convert_order(
141: p_osp_order_id IN NUMBER,
142: p_old_type_code IN VARCHAR2,
143: p_new_type_code IN VARCHAR2
144: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
145: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
146: ) RETURN BOOLEAN;
147: FUNCTION vendor_id_exist_in_PO(
148: p_po_header_id IN NUMBER,

Line 145: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type

141: p_osp_order_id IN NUMBER,
142: p_old_type_code IN VARCHAR2,
143: p_new_type_code IN VARCHAR2
144: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
145: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
146: ) RETURN BOOLEAN;
147: FUNCTION vendor_id_exist_in_PO(
148: p_po_header_id IN NUMBER,
149: p_vendor_id IN NUMBER

Line 3313: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,

3309: -----------------------------------------------------------------------------------------------------
3310: FUNCTION can_convert_order(p_osp_order_id IN NUMBER,
3311: p_old_type_code IN VARCHAR2,
3312: p_new_type_code IN VARCHAR2
3313: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
3314: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
3315: ) RETURN BOOLEAN IS
3316: CURSOR order_has_ship_return_csr(p_osp_order_id IN NUMBER) IS
3317: SELECT 'x' FROM ahl_osp_order_lines ol --, oe_order_lines_all oel

Line 3314: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type

3310: FUNCTION can_convert_order(p_osp_order_id IN NUMBER,
3311: p_old_type_code IN VARCHAR2,
3312: p_new_type_code IN VARCHAR2
3313: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
3314: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
3315: ) RETURN BOOLEAN IS
3316: CURSOR order_has_ship_return_csr(p_osp_order_id IN NUMBER) IS
3317: SELECT 'x' FROM ahl_osp_order_lines ol --, oe_order_lines_all oel
3318: WHERE ol.osp_order_id = p_osp_order_id

Line 3531: IF (JTF_USR_HKS.Ok_to_execute('AHL_OSP_ORDERS_PVT', 'PROCESS_OSP_ORDER', 'B', 'C' )) then

3527: g_module_type := p_module_type;
3528:
3529: /* Customer pre-processing section, Mandatory */
3530:
3531: IF (JTF_USR_HKS.Ok_to_execute('AHL_OSP_ORDERS_PVT', 'PROCESS_OSP_ORDER', 'B', 'C' )) then
3532: ahl_osp_orders_CUHK.process_osp_order_pre(
3533: p_osp_order_rec => p_x_osp_order_rec,
3534: p_osp_order_lines_tbl => p_x_osp_order_lines_tbl,
3535: x_msg_count => l_msg_count,

Line 4201: IF (JTF_USR_HKS.Ok_to_execute('AHL_OSP_ORDERS_PVT', 'PROCESS_OSP_ORDER', 'A', 'C' )) then

4197: 'API End: at the end of the procedure');
4198: END IF;
4199:
4200: /* Customer Post Processing section - mandatory */
4201: IF (JTF_USR_HKS.Ok_to_execute('AHL_OSP_ORDERS_PVT', 'PROCESS_OSP_ORDER', 'A', 'C' )) then
4202: ahl_osp_orders_CUHK. process_osp_order_Post(
4203: p_osp_order_rec => p_x_osp_order_rec,
4204: p_osp_order_lines_tbl => p_x_osp_order_lines_tbl,
4205: x_msg_count => l_msg_count,

Line 5933: p_osp_order_type => AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE,

5929: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5930: x_return_status => l_return_status,
5931: x_msg_count => l_msg_count,
5932: x_msg_data => l_msg_data,
5933: p_osp_order_type => AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE,
5934: p_oe_line_type => 'RETURN',
5935: p_oe_line_id => p_x_osp_order_line_rec.oe_return_line_id,
5936: p_csi_instance_id => p_x_osp_order_line_rec.exchange_instance_id);
5937:

Line 8221: END ahl_osp_orders_pvt;

8217: END IF;
8218: END Get_Entl_rec_for_Delete;
8219: --salogan added the following for supplier warranty ends
8220:
8221: END ahl_osp_orders_pvt;
8222:
8223: /*
8224: PROCEDURE nullify_exchange_instance(
8225: p_osp_order_id IN NUMBER,