eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_24X7 dependencies on MRP_ATP_PUB

Line 21: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

17: ERRBUF OUT NOCOPY VARCHAR2
18: );
19:
20: PROCEDURE Synchronize_Call_To_ATP (
21: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
22: p_session_id IN number,
23: x_total_time OUT NOCOPY number,
24: x_return_status OUT NOCOPY varchar2
25: );

Line 33: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

29:
30: PROCEDURE Get_Records_Pre_Collections (
31: p_old_plan_id IN number,
32: p_new_plan_id IN number,
33: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
34: x_record_count OUT NOCOPY number,
35: x_return_status OUT NOCOPY varchar2
36: );
37:

Line 42: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

38: PROCEDURE Get_Records_Post_Collections (
39: p_old_plan_id IN number,
40: p_new_plan_id IN number,
41: p_session_id IN number,
42: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
43: x_record_count OUT NOCOPY number,
44: x_return_status OUT NOCOPY varchar2
45: );
46:

Line 48: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

44: x_return_status OUT NOCOPY varchar2
45: );
46:
47: PROCEDURE Update_Sync_flag (
48: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
49: p_old_plan_id IN number,
50: x_return_status OUT NOCOPY varchar2
51: );
52:

Line 86: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

82: );
83:
84: -- CTO Re-arch changes, this procedure will not be used anymore, instead MSC_SATP_FUNC.New_Extend_Atp is used.
85: PROCEDURE extend_atp_rec_typ (
86: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
87: p_size IN number
88: );
89:
90: PROCEDURE Extended_Sync_Wait (

Line 96: x_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

92: x_return_status OUT NOCOPY varchar2
93: );
94:
95: PROCEDURE Print_Input_Rec (
96: x_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
97: );
98:
99: PROCEDURE Refresh_Snapshot (
100: x_return_status OUT NOCOPY varchar2

Line 174: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

170: x_return_status OUT NOCOPY VARCHAR2,
171: ERRBUF OUT NOCOPY VARCHAR2
172: ) IS
173:
174: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
175: l_atp_rec1 MRP_ATP_PUB.ATP_Rec_Typ;
176: l_session_id number;
177: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
178: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 175: l_atp_rec1 MRP_ATP_PUB.ATP_Rec_Typ;

171: ERRBUF OUT NOCOPY VARCHAR2
172: ) IS
173:
174: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
175: l_atp_rec1 MRP_ATP_PUB.ATP_Rec_Typ;
176: l_session_id number;
177: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
178: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
179: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 177: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

173:
174: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
175: l_atp_rec1 MRP_ATP_PUB.ATP_Rec_Typ;
176: l_session_id number;
177: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
178: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
179: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
180: l_msg_count number;
181: l_msg_data varchar2(3000);

Line 178: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

174: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
175: l_atp_rec1 MRP_ATP_PUB.ATP_Rec_Typ;
176: l_session_id number;
177: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
178: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
179: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
180: l_msg_count number;
181: l_msg_data varchar2(3000);
182: l_return_status varchar2(1);

Line 179: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

175: l_atp_rec1 MRP_ATP_PUB.ATP_Rec_Typ;
176: l_session_id number;
177: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
178: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
179: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
180: l_msg_count number;
181: l_msg_data varchar2(3000);
182: l_return_status varchar2(1);
183: l_record_count number;

Line 192: l_demand_id_arr MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

188: l_downtime_end number;
189: l_downtime_total number;
190: l_counter number;
191:
192: l_demand_id_arr MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
193: l_demand_id_arr_nl MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
194:
195: BEGIN
196:

Line 193: l_demand_id_arr_nl MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

189: l_downtime_total number;
190: l_counter number;
191:
192: l_demand_id_arr MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
193: l_demand_id_arr_nl MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
194:
195: BEGIN
196:
197: conc_log ('-------ATP 24x7 Synchronization ------------');

Line 521: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

517: ---------------------------------------------------------------------------------
518:
519: -- CTO Re-arch changes, changed session_id to an IN param, as it will now be retrieved in ATP_Synchronize
520: PROCEDURE Synchronize_Call_To_ATP (
521: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
522: p_session_id IN number,
523: x_total_time OUT NOCOPY number,
524: x_return_status OUT NOCOPY varchar2
525: ) IS

Line 532: l_atp_table MRP_ATP_PUB.Atp_Rec_Typ;

528: -- CTO Re-arch, don't need anymore as its passed as IN param.
529: --l_session_id number;
530: l_timer_start number;
531: l_timer_end number;
532: l_atp_table MRP_ATP_PUB.Atp_Rec_Typ;
533: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
534: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
535: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
536: l_return_status varchar2(1);

Line 533: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

529: --l_session_id number;
530: l_timer_start number;
531: l_timer_end number;
532: l_atp_table MRP_ATP_PUB.Atp_Rec_Typ;
533: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
534: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
535: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
536: l_return_status varchar2(1);
537: l_msg_data varchar2(100);

Line 534: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

530: l_timer_start number;
531: l_timer_end number;
532: l_atp_table MRP_ATP_PUB.Atp_Rec_Typ;
533: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
534: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
535: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
536: l_return_status varchar2(1);
537: l_msg_data varchar2(100);
538: l_msg_count number;

Line 535: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

531: l_timer_end number;
532: l_atp_table MRP_ATP_PUB.Atp_Rec_Typ;
533: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
534: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
535: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
536: l_return_status varchar2(1);
537: l_msg_data varchar2(100);
538: l_msg_count number;
539: l_instance_id number;

Line 677: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

673:
674: PROCEDURE Get_Records_Pre_Collections (
675: p_old_plan_id IN number,
676: p_new_plan_id IN number,
677: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
678: x_record_count OUT NOCOPY number,
679: x_return_status OUT NOCOPY varchar2
680: ) IS
681: BEGIN

Line 913: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

909: PROCEDURE Get_Records_Post_Collections (
910: p_old_plan_id IN number,
911: p_new_plan_id IN number,
912: p_session_id IN number,
913: x_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
914: x_record_count OUT NOCOPY number,
915: x_return_status OUT NOCOPY varchar2
916: ) IS
917:

Line 1234: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

1230:
1231: ---------------------------------------------------------------------------------
1232:
1233: PROCEDURE Update_Sync_flag (
1234: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
1235: p_old_plan_id IN number,
1236: x_return_status OUT NOCOPY varchar2
1237: ) IS
1238:

Line 1550: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

1546: ---------------------------------------------------------------------------------
1547:
1548: -- CTO Re-arch changes, this procedure will not be used anymore, instead MSC_SATP_FUNC.New_Extend_Atp is used.
1549: PROCEDURE extend_atp_rec_typ (
1550: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
1551: p_size IN number
1552: ) IS
1553: BEGIN
1554:

Line 1667: x_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

1663: END Extended_Sync_Wait;
1664: ---------------------------------------------------------------------------------
1665:
1666: PROCEDURE Print_Input_Rec (
1667: x_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
1668: ) IS
1669:
1670: l_counter number;
1671: