APPS.MSC_ATP_UTILS dependencies on MRP_ATP_UTILS

Line 157: sched_cv mrp_atp_utils.SchedCurTyp;

153: x_msg_count OUT NoCopy NUMBER,
154: p_details_flag IN NUMBER
155: ) IS
156:
157: sched_cv mrp_atp_utils.SchedCurTyp;
158: sched_rec mrp_atp_utils.Schedule_Temp;
159: details_rec mrp_atp_utils.Details_Temp;
160: i PLS_INTEGER := 1;
161: j PLS_INTEGER := 1;

Line 158: sched_rec mrp_atp_utils.Schedule_Temp;

154: p_details_flag IN NUMBER
155: ) IS
156:
157: sched_cv mrp_atp_utils.SchedCurTyp;
158: sched_rec mrp_atp_utils.Schedule_Temp;
159: details_rec mrp_atp_utils.Details_Temp;
160: i PLS_INTEGER := 1;
161: j PLS_INTEGER := 1;
162: l_dynstring VARCHAR2(128) := NULL;

Line 159: details_rec mrp_atp_utils.Details_Temp;

155: ) IS
156:
157: sched_cv mrp_atp_utils.SchedCurTyp;
158: sched_rec mrp_atp_utils.Schedule_Temp;
159: details_rec mrp_atp_utils.Details_Temp;
160: i PLS_INTEGER := 1;
161: j PLS_INTEGER := 1;
162: l_dynstring VARCHAR2(128) := NULL;
163: sql_stmt VARCHAR2(10000);

Line 1197: PROCEDURE extend_mast( mast_rec IN OUT NoCopy mrp_atp_utils.mrp_atp_schedule_temp_typ,

1193: p_err_message := substr(sqlerrm,1,100);
1194: return(INV_EXTATP_GRP.G_RETURN_ERROR);
1195: End Call_ATP_11;
1196:
1197: PROCEDURE extend_mast( mast_rec IN OUT NoCopy mrp_atp_utils.mrp_atp_schedule_temp_typ,
1198: x_ret_code OUT NoCopy varchar2,
1199: x_ret_status OUT NoCopy varchar2) IS
1200: BEGIN
1201: mast_rec.rowid_char.extend(1);

Line 1235: PROCEDURE trim_mast( mast_rec IN OUT NoCopy mrp_atp_utils.mrp_atp_schedule_temp_typ,

1231: END IF;
1232: END extend_mast;
1233:
1234:
1235: PROCEDURE trim_mast( mast_rec IN OUT NoCopy mrp_atp_utils.mrp_atp_schedule_temp_typ,
1236: x_ret_code OUT NoCopy varchar2,
1237: x_ret_status OUT NoCopy varchar2) IS
1238: BEGIN
1239: mast_rec.rowid_char.trim(1);

Line 1874: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;

1870: l_status_flag NUMBER := 99; -- bug 2974324. Initialize l_status_flag to 99 here.
1871: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- for bug 2974324.
1872: found NUMBER;
1873:
1874: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;
1875: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;
1876: TYPE mastcurtyp IS REF CURSOR;
1877: mast_cursor mastcurtyp;
1878: l_ret_code VARCHAR2(1);

Line 1875: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;

1871: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- for bug 2974324.
1872: found NUMBER;
1873:
1874: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;
1875: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;
1876: TYPE mastcurtyp IS REF CURSOR;
1877: mast_cursor mastcurtyp;
1878: l_ret_code VARCHAR2(1);
1879: l_ret_status VARCHAR2(100);

Line 2366: sched_cv mrp_atp_utils.SchedCurTyp;

2362: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ)
2363: IS
2364: j PLS_INTEGER := 1;
2365: sql_stmt VARCHAR2(10000);
2366: sched_cv mrp_atp_utils.SchedCurTyp;
2367: details_rec mrp_atp_utils.Details_Temp;
2368: l_dynstring VARCHAR2(128) := NULL;
2369:
2370: BEGIN

Line 2367: details_rec mrp_atp_utils.Details_Temp;

2363: IS
2364: j PLS_INTEGER := 1;
2365: sql_stmt VARCHAR2(10000);
2366: sched_cv mrp_atp_utils.SchedCurTyp;
2367: details_rec mrp_atp_utils.Details_Temp;
2368: l_dynstring VARCHAR2(128) := NULL;
2369:
2370: BEGIN
2371:

Line 3242: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;

3238: l_status_flag NUMBER := 99; -- bug 2974324. Initialize l_status_flag to 99 here.
3239: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- for bug 2974324.
3240: found NUMBER;
3241:
3242: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;
3243: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;
3244: TYPE mastcurtyp IS REF CURSOR;
3245: mast_cursor mastcurtyp;
3246: l_ret_code VARCHAR2(1);

Line 3243: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;

3239: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- for bug 2974324.
3240: found NUMBER;
3241:
3242: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;
3243: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;
3244: TYPE mastcurtyp IS REF CURSOR;
3245: mast_cursor mastcurtyp;
3246: l_ret_code VARCHAR2(1);
3247: l_ret_status VARCHAR2(1000);