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_UTILS dependencies on MRP_ATP_PUB

Line 14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

10: PROCEDURE put_into_temp_table
11: (
12: x_dblink IN VARCHAR2,
13: x_session_id IN NUMBER,
14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18: x_mode IN NUMBER,

Line 15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

11: (
12: x_dblink IN VARCHAR2,
13: x_session_id IN NUMBER,
14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18: x_mode IN NUMBER,
19: x_return_status OUT NoCopy VARCHAR2,

Line 16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

12: x_dblink IN VARCHAR2,
13: x_session_id IN NUMBER,
14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18: x_mode IN NUMBER,
19: x_return_status OUT NoCopy VARCHAR2,
20: x_msg_data OUT NoCopy VARCHAR2,

Line 17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,

13: x_session_id IN NUMBER,
14: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
15: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
17: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,
18: x_mode IN NUMBER,
19: x_return_status OUT NoCopy VARCHAR2,
20: x_msg_data OUT NoCopy VARCHAR2,
21: x_msg_count OUT NoCopy NUMBER

Line 146: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,

142: PROCEDURE get_from_temp_table
143: (
144: x_dblink IN VARCHAR2,
145: x_session_id IN NUMBER,
146: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
147: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
148: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
149: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
150: x_mode IN NUMBER,

Line 147: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

143: (
144: x_dblink IN VARCHAR2,
145: x_session_id IN NUMBER,
146: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
147: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
148: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
149: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
150: x_mode IN NUMBER,
151: x_return_status OUT NoCopy VARCHAR2,

Line 148: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

144: x_dblink IN VARCHAR2,
145: x_session_id IN NUMBER,
146: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
147: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
148: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
149: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
150: x_mode IN NUMBER,
151: x_return_status OUT NoCopy VARCHAR2,
152: x_msg_data OUT NoCopy VARCHAR2,

Line 149: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,

145: x_session_id IN NUMBER,
146: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,
147: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
148: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
149: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,
150: x_mode IN NUMBER,
151: x_return_status OUT NoCopy VARCHAR2,
152: x_msg_data OUT NoCopy VARCHAR2,
153: x_msg_count OUT NoCopy NUMBER,

Line 862: x_atp_rec MRP_ATP_PUB.atp_rec_typ;

858: p_err_message IN OUT NoCopy VARCHAR2)
859: RETURN NUMBER is
860:
861: v_dummy NUMBER := 0;
862: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
863: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
864: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
865: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
866: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 863: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;

859: RETURN NUMBER is
860:
861: v_dummy NUMBER := 0;
862: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
863: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
864: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
865: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
866: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
867: x_return_status VARCHAR2(1);

Line 864: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

860:
861: v_dummy NUMBER := 0;
862: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
863: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
864: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
865: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
866: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
867: x_return_status VARCHAR2(1);
868: x_msg_data VARCHAR2(200);

Line 865: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;

861: v_dummy NUMBER := 0;
862: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
863: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
864: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
865: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
866: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
867: x_return_status VARCHAR2(1);
868: x_msg_data VARCHAR2(200);
869: x_msg_count NUMBER;

Line 866: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

862: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
863: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
864: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
865: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
866: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
867: x_return_status VARCHAR2(1);
868: x_msg_data VARCHAR2(200);
869: x_msg_count NUMBER;
870: x_session_id NUMBER;

Line 1281: p_atp_bom_rec IN MRP_ATP_PUB.ATP_BOM_Rec_Typ,

1277:
1278: PROCEDURE put_into_bom_temp_table(
1279: p_session_id IN NUMBER,
1280: p_dblink IN VARCHAR2,
1281: p_atp_bom_rec IN MRP_ATP_PUB.ATP_BOM_Rec_Typ,
1282: x_return_status OUT NoCopy VARCHAR2,
1283: x_msg_data OUT NoCopy VARCHAR2,
1284: x_msg_count OUT NoCopy NUMBER)
1285: IS

Line 1461: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

1457: END put_into_bom_temp_table;
1458:
1459:
1460: PROCEDURE Put_Period_Data (
1461: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
1462: p_dblink IN VARCHAR2,
1463: p_session_id IN NUMBER )
1464: IS
1465: sql_stmt VARCHAR2(10000);

Line 1859: Procedure Put_Scheduling_data(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

1855:
1856: END IF;
1857: END Put_Pegging_data;
1858:
1859: Procedure Put_Scheduling_data(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
1860: p_mode IN NUMBER,
1861: p_dblink IN VARCHAR2,
1862: p_session_id IN NUMBER
1863: )

Line 1869: l_atp_rec MRP_ATP_PUB.atp_rec_typ;

1865:
1866: j NUMBER;
1867: l_dynstring VARCHAR2(128) := NULL;
1868: sql_stmt VARCHAR2(10000);
1869: l_atp_rec MRP_ATP_PUB.atp_rec_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:

Line 1871: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- for bug 2974324.

1867: l_dynstring VARCHAR2(128) := NULL;
1868: sql_stmt VARCHAR2(10000);
1869: l_atp_rec MRP_ATP_PUB.atp_rec_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;

Line 1913: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

1909: END Put_Scheduling_data;
1910:
1911: PROCEDURE Retrieve_Period_and_SD_Data(
1912: p_session_id IN NUMBER,
1913: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1914: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ
1915: ) IS
1916:
1917: BEGIN

Line 1914: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ

1910:
1911: PROCEDURE Retrieve_Period_and_SD_Data(
1912: p_session_id IN NUMBER,
1913: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1914: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ
1915: ) IS
1916:
1917: BEGIN
1918:

Line 2362: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ)

2358: END Copy_MRP_SD_Recs;
2359:
2360: Procedure Process_Supply_Demand_details( p_dblink IN varchar2,
2361: p_session_id IN number,
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;

Line 2481: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

2477: * since sd data is never stored in pl/sql tables during processing
2478: *
2479: */
2480: PROCEDURE Put_SD_Data (
2481: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
2482: p_dblink IN VARCHAR2,
2483: p_session_id IN NUMBER )
2484: IS
2485:

Line 2847: procedure Put_Sch_data_Request_Mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

2843: END IF;
2844:
2845: END Update_Line_Item_Properties_WS;
2846:
2847: procedure Put_Sch_data_Request_Mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
2848: p_session_id IN NUMBER)
2849: IS
2850: l_status_flag NUMBER := 99;
2851: j NUMBER;

Line 2853: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

2849: IS
2850: l_status_flag NUMBER := 99;
2851: j NUMBER;
2852: l_user_id number;
2853: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2854: l_count number;
2855:
2856: begin
2857:

Line 3230: Procedure Put_Sch_data_result_mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

3226: msc_sch_wb.atp_debug('Sql Err := ' || sqlerrm);
3227:
3228: END Put_Sch_Data_Request_Mode;
3229:
3230: Procedure Put_Sch_data_result_mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
3231: p_dblink IN VARCHAR2,
3232: p_session_id IN NUMBER)
3233: IS
3234: j NUMBER;

Line 3237: l_atp_rec MRP_ATP_PUB.atp_rec_typ;

3233: IS
3234: j NUMBER;
3235: l_dynstring VARCHAR2(128) := NULL;
3236: sql_stmt VARCHAR2(10000);
3237: l_atp_rec MRP_ATP_PUB.atp_rec_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:

Line 3239: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- for bug 2974324.

3235: l_dynstring VARCHAR2(128) := NULL;
3236: sql_stmt VARCHAR2(10000);
3237: l_atp_rec MRP_ATP_PUB.atp_rec_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;