APPS.MSC_SATP_FUNC dependencies on MRP_ATP_PUB

Line 403: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

399: -- ngoel 7/31/2001, modified to accept p_index as a parameter to determine
400: -- index length by which ATP_REC_TYP needs to be extended, default is 1.
401:
402: PROCEDURE Extend_Atp (
403: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
404: x_return_status OUT NoCopy VARCHAR2,
405: p_index IN NUMBER := 1
406: ) IS
407: Begin

Line 505: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

501: END Extend_Atp;
502:
503:
504: PROCEDURE Assign_Atp_Input_Rec (
505: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
506: p_index IN NUMBER,
507: x_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
508: x_return_status OUT NoCopy VARCHAR2
509: ) IS

Line 507: x_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

503:
504: PROCEDURE Assign_Atp_Input_Rec (
505: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
506: p_index IN NUMBER,
507: x_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
508: x_return_status OUT NoCopy VARCHAR2
509: ) IS
510:
511: l_count PLS_INTEGER;

Line 1096: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

1092: END Assign_Atp_Input_Rec;
1093:
1094:
1095: PROCEDURE Assign_Atp_Output_Rec (
1096: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
1097: x_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
1098: x_return_status OUT NoCopy VARCHAR2
1099: ) IS
1100:

Line 1097: x_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

1093:
1094:
1095: PROCEDURE Assign_Atp_Output_Rec (
1096: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
1097: x_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
1098: x_return_status OUT NoCopy VARCHAR2
1099: ) IS
1100:
1101: l_atp_count PLS_INTEGER;

Line 1446: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

1442: END Assign_Atp_Output_Rec;
1443:
1444:
1445: PROCEDURE Extend_Atp_Period (
1446: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1447: x_return_status OUT NoCopy VARCHAR2
1448: ) IS
1449:
1450: Begin

Line 1507: p_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

1503: END Extend_Atp_Period;
1504:
1505:
1506: PROCEDURE Extend_Atp_Supply_Demand (
1507: p_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1508: x_return_status OUT NoCopy VARCHAR2,
1509: p_index IN NUMBER -- added by rajjain 12/10/2002
1510: ) IS
1511: Begin

Line 1566: p_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

1562: END Extend_Atp_Supply_Demand;
1563:
1564: -- rajjain begin 12/10/2002
1565: PROCEDURE Trim_Atp_Supply_Demand (
1566: p_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1567: x_return_status OUT NoCopy VARCHAR2,
1568: p_index IN NUMBER
1569: ) IS
1570: Begin

Line 2938: MRP_ATP_PUB.atp_rec_typ to extend

2934: /* New Extend ATP API
2935: krajan: 05-Aug-2003
2936:
2937: Inputs:
2938: MRP_ATP_PUB.atp_rec_typ to extend
2939: p_tot_size : total size to extend to
2940:
2941: Working:
2942: p_tot_size is used to calculate the length of the final array:

Line 2948: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.atp_rec_typ,

2944: value = 0 : extend everything to inv. item id + 1 (extend by 1)
2945: value < 0 : extend everything to inv. item id size
2946: */
2947: procedure new_extend_atp (
2948: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.atp_rec_typ,
2949: p_tot_size IN number,
2950: x_return_status OUT NOCOPY varchar2
2951: )
2952: IS

Line 4423: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr();

4419: p_session_id IN NUMBER,
4420: x_return_status OUT NoCopy VARCHAR2
4421: ) IS
4422:
4423: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr();
4424: j NUMBER := 1;
4425: l_user_id number;
4426: l_count number;
4427: l_sysdate DATE := TRUNC(sysdate);

Line 4514: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr();

4510: p_session_id IN NUMBER,
4511: x_return_status OUT NoCopy VARCHAR2
4512: ) IS
4513:
4514: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr();
4515: j NUMBER;
4516: l_dynstring VARCHAR2(128) := NULL;
4517: l_user_id number;
4518: l_sql_stmt varchar2(2000);