DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on OE_ATP

Line 27: --G_ATP_TBL OE_ATP.atp_tbl_type; -- 2434807 - moved to package spec.

23: /*-- 3288805 -- */ -- moved to spec.
24: --G_HEADER_ID NUMBER := null;
25: --G_DATE_TYPE VARCHAR2(30) := null;
26:
27: --G_ATP_TBL OE_ATP.atp_tbl_type; -- 2434807 - moved to package spec.
28:
29: -- INVCONV below procedure not used now because of OPM inventory convergence
30: /*PROCEDURE get_process_query_quantities
31: ( p_org_id IN NUMBER

Line 89: PROCEDURE Get_Atp_Table_Count(p_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,

85: Procedure Name : Get_Atp_Table_Count
86: Description : This procedure returns the count of record in g_atp_tbl
87: along with the contents in the table.
88: --------------------------------------------------------------------------*/
89: PROCEDURE Get_Atp_Table_Count(p_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
90: p_atp_tbl_cnt OUT NOCOPY NUMBER)
91: IS
92: BEGIN
93: p_atp_tbl_cnt := g_atp_tbl.count;

Line 2611: l_atp_tbl OE_ATP.atp_tbl_type;

2607: )
2608: IS
2609:
2610: l_bckup_request_tbl OE_Order_PUB.Request_Tbl_Type;
2611: l_atp_tbl OE_ATP.atp_tbl_type;
2612: l_sch_recursion VARCHAR2(30);
2613:
2614: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2615: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 13898: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,

13894: Procedure ATP_Check
13895: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
13896: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
13897: p_validate IN VARCHAR2 := FND_API.G_TRUE,
13898: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
13899:
13900: x_return_status OUT NOCOPY VARCHAR2
13901:
13902: )

Line 14020: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,

14016: --------------------------------------------------------*/
14017: PROCEDURE Multi_ATP_Check
14018: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
14019: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
14020: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
14021:
14022: x_return_status OUT NOCOPY VARCHAR2
14023:
14024: )

Line 14896: l_out_atp_tbl OE_ATP.atp_tbl_type;

14892: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14893: mrp_msg_data VARCHAR2(200);
14894: l_on_hand_qty NUMBER;
14895: l_avail_to_reserve NUMBER;
14896: l_out_atp_tbl OE_ATP.atp_tbl_type;
14897: l_found BOOLEAN := FALSE;
14898: l_buffer VARCHAR2(2000);
14899: l_msg_count NUMBER;
14900: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 18575: l_atp_tbl OE_ATP.Atp_Tbl_Type;

18571:
18572: l_status VARCHAR2(1);
18573: j NUMBER;
18574: i NUMBER := 0 ;
18575: l_atp_tbl OE_ATP.Atp_Tbl_Type;
18576: l_return_status VARCHAR2(1);
18577: l_msg_count NUMBER;
18578: l_msg_data VARCHAR2(2000);
18579: l_line_tbl OE_ORDER_PUB.Line_tbl_type;