DBA Data[Home] [Help]

APPS.OE_SCHEDULE_UTIL dependencies on OE_ATP

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

12: /*-- 3288805 -- */ -- moved to spec.
13: --G_HEADER_ID NUMBER := null;
14: --G_DATE_TYPE VARCHAR2(30) := null;
15:
16: --G_ATP_TBL OE_ATP.atp_tbl_type; -- 2434807 - moved to package spec.
17:
18: -- INVCONV below procedure not used now because of OPM inventory convergence
19: /*PROCEDURE get_process_query_quantities
20: ( p_org_id IN NUMBER

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

60: Procedure Name : Get_Atp_Table_Count
61: Description : This procedure returns the count of record in g_atp_tbl
62: along with the contents in the table.
63: --------------------------------------------------------------------------*/
64: PROCEDURE Get_Atp_Table_Count(p_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
65: p_atp_tbl_cnt OUT NOCOPY NUMBER)
66: IS
67: BEGIN
68: p_atp_tbl_cnt := g_atp_tbl.count;

Line 12291: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,

12287: Procedure ATP_Check
12288: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
12289: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
12290: p_validate IN VARCHAR2 := FND_API.G_TRUE,
12291: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
12292:
12293: x_return_status OUT NOCOPY VARCHAR2
12294:
12295: )

Line 12411: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,

12407: --------------------------------------------------------*/
12408: PROCEDURE Multi_ATP_Check
12409: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
12410: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
12411: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
12412:
12413: x_return_status OUT NOCOPY VARCHAR2
12414:
12415: )

Line 13050: l_out_atp_tbl OE_ATP.atp_tbl_type;

13046: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
13047: mrp_msg_data VARCHAR2(200);
13048: l_on_hand_qty NUMBER;
13049: l_avail_to_reserve NUMBER;
13050: l_out_atp_tbl OE_ATP.atp_tbl_type;
13051: l_found BOOLEAN := FALSE;
13052: l_buffer VARCHAR2(2000);
13053: l_msg_count NUMBER;
13054: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 15906: l_atp_tbl OE_ATP.Atp_Tbl_Type;

15902: IS
15903:
15904: l_status VARCHAR2(1);
15905: j NUMBER;
15906: l_atp_tbl OE_ATP.Atp_Tbl_Type;
15907: l_return_status VARCHAR2(1);
15908: l_msg_count NUMBER;
15909: l_msg_data VARCHAR2(2000);
15910: l_line_tbl OE_ORDER_PUB.Line_tbl_type;