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.24 2008/03/14 14:41:52 mpothuku 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.24 2008/03/14 14:41:52 mpothuku 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 3275: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,

3271: -----------------------------------------------------------------------------------------------------
3272: FUNCTION can_convert_order(p_osp_order_id IN NUMBER,
3273: p_old_type_code IN VARCHAR2,
3274: p_new_type_code IN VARCHAR2
3275: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
3276: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
3277: ) RETURN BOOLEAN IS
3278: CURSOR order_has_ship_return_csr(p_osp_order_id IN NUMBER) IS
3279: SELECT 'x' FROM ahl_osp_order_lines ol --, oe_order_lines_all oel

Line 3276: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type

3272: FUNCTION can_convert_order(p_osp_order_id IN NUMBER,
3273: p_old_type_code IN VARCHAR2,
3274: p_new_type_code IN VARCHAR2
3275: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
3276: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
3277: ) RETURN BOOLEAN IS
3278: CURSOR order_has_ship_return_csr(p_osp_order_id IN NUMBER) IS
3279: SELECT 'x' FROM ahl_osp_order_lines ol --, oe_order_lines_all oel
3280: WHERE ol.osp_order_id = p_osp_order_id

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

3484: g_module_type := p_module_type;
3485:
3486: /* Customer pre-processing section, Mandatory */
3487:
3488: IF (JTF_USR_HKS.Ok_to_execute('AHL_OSP_ORDERS_PVT', 'PROCESS_OSP_ORDER', 'B', 'C' )) then
3489: ahl_osp_orders_CUHK.process_osp_order_pre(
3490: p_osp_order_rec => p_x_osp_order_rec,
3491: p_osp_order_lines_tbl => p_x_osp_order_lines_tbl,
3492: x_msg_count => l_msg_count,

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

3855: 'API End: at the end of the procedure');
3856: END IF;
3857:
3858: /* Customer Post Processing section - mandatory */
3859: IF (JTF_USR_HKS.Ok_to_execute('AHL_OSP_ORDERS_PVT', 'PROCESS_OSP_ORDER', 'A', 'C' )) then
3860: ahl_osp_orders_CUHK. process_osp_order_Post(
3861: p_osp_order_rec => p_x_osp_order_rec,
3862: p_osp_order_lines_tbl => p_x_osp_order_lines_tbl,
3863: x_msg_count => l_msg_count,

Line 7303: END ahl_osp_orders_pvt;

7299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_LOG_PREFIX||'process_order_type_change', 'End');
7300: END IF;
7301: END process_order_type_change;
7302:
7303: END ahl_osp_orders_pvt;
7304:
7305: /*
7306: PROCEDURE nullify_exchange_instance(
7307: p_osp_order_id IN NUMBER,