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 12: x_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

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

Line 13: x_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

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

Line 14: x_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

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

Line 15: x_atp_details IN MRP_ATP_PUB.ATP_Details_Typ,

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

Line 144: x_atp_rec OUT NoCopy MRP_ATP_PUB.atp_rec_typ,

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

Line 145: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

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

Line 146: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

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

Line 147: x_atp_details OUT NoCopy MRP_ATP_PUB.ATP_Details_Typ,

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

Line 860: x_atp_rec MRP_ATP_PUB.atp_rec_typ;

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

Line 861: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;

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

Line 862: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

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

Line 863: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;

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

Line 864: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

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

Line 1279: p_atp_bom_rec IN MRP_ATP_PUB.ATP_BOM_Rec_Typ,

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

Line 1459: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

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

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

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

Line 1867: l_atp_rec MRP_ATP_PUB.atp_rec_typ;

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

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

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

Line 1911: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

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

Line 1912: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ

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

Line 2360: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ)

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

Line 2479: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

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

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

2794: -- 3720018
2795:
2796: END Update_Line_item_properties;
2797:
2798: procedure Put_Sch_data_Request_Mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
2799: p_session_id IN NUMBER)
2800: IS
2801: l_status_flag NUMBER := 99;
2802: j NUMBER;

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

2800: IS
2801: l_status_flag NUMBER := 99;
2802: j NUMBER;
2803: l_user_id number;
2804: l_sequence_number MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2805: l_count number;
2806:
2807: begin
2808:

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

3172: msc_sch_wb.atp_debug('Sql Err := ' || sqlerrm);
3173:
3174: END Put_Sch_Data_Request_Mode;
3175:
3176: Procedure Put_Sch_data_result_mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,
3177: p_dblink IN VARCHAR2,
3178: p_session_id IN NUMBER)
3179: IS
3180: j NUMBER;

Line 3183: l_atp_rec MRP_ATP_PUB.atp_rec_typ;

3179: IS
3180: j NUMBER;
3181: l_dynstring VARCHAR2(128) := NULL;
3182: sql_stmt VARCHAR2(10000);
3183: l_atp_rec MRP_ATP_PUB.atp_rec_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:

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

3181: l_dynstring VARCHAR2(128) := NULL;
3182: sql_stmt VARCHAR2(10000);
3183: l_atp_rec MRP_ATP_PUB.atp_rec_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;