1: PACKAGE BODY OE_ATP AS
2: /* $Header: OEXVATPB.pls 120.1 2005/12/15 02:27:37 pkannan noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_ATP';
5:
1: PACKAGE BODY OE_ATP AS
2: /* $Header: OEXVATPB.pls 120.1 2005/12/15 02:27:37 pkannan noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_ATP';
5:
6:
7: /*-----------------------------------------------------------------------------
8: Procedure Name : ATP_Check
16: )
17: IS
18: l_line_rec OE_ORDER_PUB.line_rec_type;
19: l_old_line_rec OE_ORDER_PUB.line_rec_type;
20: l_atp_tbl OE_ATP.atp_tbl_type;
21: --- 2697690 --
22: l_scheduling_level_code VARCHAR2(30) := NULL;
23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
311: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
312: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ ATP_TBL_TYPE)
313: IS
314: l_line_atp_rec OE_ORDER_PUB.line_rec_type;
315: l_out_atp_rec OE_ATP.atp_rec_type;
316: l_out_atp_tbl OE_ATP.atp_tbl_type;
317:
318: l_return_status VARCHAR2(1);
319: l_entity_type VARCHAR2(30);
312: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ ATP_TBL_TYPE)
313: IS
314: l_line_atp_rec OE_ORDER_PUB.line_rec_type;
315: l_out_atp_rec OE_ATP.atp_rec_type;
316: l_out_atp_tbl OE_ATP.atp_tbl_type;
317:
318: l_return_status VARCHAR2(1);
319: l_entity_type VARCHAR2(30);
320: l_entity_id NUMBER;
395: END IF;
396:
397: END ATP_Inquiry;
398:
399: END OE_ATP;