APPS.MSC_ATP_UTILS dependencies on MRP_ATP_UTILS

Line 155: sched_cv mrp_atp_utils.SchedCurTyp;

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

Line 156: sched_rec mrp_atp_utils.Schedule_Temp;

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

Line 157: details_rec mrp_atp_utils.Details_Temp;

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

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

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

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

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

Line 1872: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;

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

Line 1873: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;

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

Line 2364: sched_cv mrp_atp_utils.SchedCurTyp;

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

Line 2365: details_rec mrp_atp_utils.Details_Temp;

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

Line 3188: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;

3184: l_status_flag NUMBER := 99; -- bug 2974324. Initialize l_status_flag to 99 here.
3185: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- for bug 2974324.
3186: found NUMBER;
3187:
3188: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;
3189: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;
3190: TYPE mastcurtyp IS REF CURSOR;
3191: mast_cursor mastcurtyp;
3192: l_ret_code VARCHAR2(1);

Line 3189: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;

3185: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- for bug 2974324.
3186: found NUMBER;
3187:
3188: mast_rec mrp_atp_utils.mrp_atp_schedule_temp_typ;
3189: mast_rec_insert mrp_atp_utils.mrp_atp_schedule_temp_typ;
3190: TYPE mastcurtyp IS REF CURSOR;
3191: mast_cursor mastcurtyp;
3192: l_ret_code VARCHAR2(1);
3193: l_ret_status VARCHAR2(1000);