DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MRP_ATP_PUB

Line 6: G_VENDOR_SITE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

2: /* $Header: MSCPATPS.pls 120.4.12010000.2 2009/09/13 18:13:00 sbnaik ship $ */
3:
4:
5: -- For supplier intransit LT project
6: G_VENDOR_SITE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
7: G_latest_ship_date_set DATE; --4460369
8: G_latest_arr_date_set DATE; --4460369
9:
10: PROCEDURE add_inf_time_fence_to_period(

Line 20: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ

16: p_organization_id IN NUMBER,
17: p_supplier_id IN NUMBER,
18: p_supplier_site_id IN NUMBER,
19: p_infinite_time_fence_date IN DATE,
20: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
21: );
22:
23: PROCEDURE get_period_data_from_SD_temp(
24: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ

Line 24: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ

20: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
21: );
22:
23: PROCEDURE get_period_data_from_SD_temp(
24: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
25: );
26:
27: -- New procedure added as part of time_phased_atp to fix the
28: -- issue of not displaying correct quantities in ATP SD Window when

Line 31: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

27: -- New procedure added as part of time_phased_atp to fix the
28: -- issue of not displaying correct quantities in ATP SD Window when
29: -- user opens ATP SD window from ATP pegging in allocated scenarios
30: PROCEDURE Get_Alloc_Data_From_Sd_Temp(
31: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
32: x_return_status OUT NOCOPY VARCHAR2
33: );
34:
35: PROCEDURE Atp_Sources (

Line 47: --p_ship_set_item IN MRP_ATP_PUB.number_arr,

43: --s_cto_rearch
44: p_Item_Sourcing_Info_Rec IN MSC_ATP_CTO.Item_Sourcing_Info_Rec,
45: p_session_id IN NUMBER,
46: --e_cto_rearch
47: --p_ship_set_item IN MRP_ATP_PUB.number_arr,
48: x_atp_sources OUT NoCopy MRP_ATP_PVT.Atp_Source_Typ,
49: x_return_status OUT NoCopy VARCHAR2,
50: p_partner_type IN NUMBER DEFAULT NULL, --2814895
51: p_party_site_id IN NUMBER DEFAULT NULL, --2814895

Line 59: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,

55: PROCEDURE item_sources_extend(p_item_sourcing_rec
56: IN OUT NOCOPY MSC_ATP_CTO.Item_Sourcing_Info_Rec);
57:
58: PROCEDURE Atp_Consume_Range (
59: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
60: p_start_idx IN NUMBER,
61: p_end_idx IN NUMBER
62: );
63:

Line 65: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,

61: p_end_idx IN NUMBER
62: );
63:
64: PROCEDURE Atp_Consume (
65: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
66: p_counter IN NUMBER
67: );
68:
69:

Line 71: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

67: );
68:
69:
70: PROCEDURE Details_Output (
71: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
72: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
73: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
74: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
75: x_return_status OUT NoCopy VARCHAR2

Line 72: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

68:
69:
70: PROCEDURE Details_Output (
71: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
72: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
73: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
74: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
75: x_return_status OUT NoCopy VARCHAR2
76: );

Line 73: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

69:
70: PROCEDURE Details_Output (
71: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
72: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
73: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
74: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
75: x_return_status OUT NoCopy VARCHAR2
76: );
77:

Line 74: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

70: PROCEDURE Details_Output (
71: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
72: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
73: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
74: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
75: x_return_status OUT NoCopy VARCHAR2
76: );
77:
78:

Line 90: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

86: );
87:
88:
89: PROCEDURE Get_SD_Period_Rec(
90: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
91: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
92: p_identifier IN NUMBER,
93: p_scenario_id IN NUMBER,
94: p_new_scenario_id IN NUMBER,

Line 91: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

87:
88:
89: PROCEDURE Get_SD_Period_Rec(
90: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
91: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
92: p_identifier IN NUMBER,
93: p_scenario_id IN NUMBER,
94: p_new_scenario_id IN NUMBER,
95: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

Line 95: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

91: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
92: p_identifier IN NUMBER,
93: p_scenario_id IN NUMBER,
94: p_new_scenario_id IN NUMBER,
95: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
96: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
97: x_return_status OUT NoCopy VARCHAR2
98: );
99:

Line 96: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

92: p_identifier IN NUMBER,
93: p_scenario_id IN NUMBER,
94: p_new_scenario_id IN NUMBER,
95: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
96: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
97: x_return_status OUT NoCopy VARCHAR2
98: );
99:
100:

Line 141: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr

137: );
138:
139:
140: PROCEDURE Atp_Backward_Consume(
141: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr
142: );
143:
144:
145: PROCEDURE Atp_Accumulate(

Line 146: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr

142: );
143:
144:
145: PROCEDURE Atp_Accumulate(
146: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr
147: );
148:
149: PROCEDURE ADD_COPRODUCTS(
150: p_plan_id IN NUMBER,

Line 308: p_set IN MRP_ATP_PUB.ATP_Rec_Typ,

304: -- FND_API.G_RET_STS_UNEXP_ERROR - on unexpected error
305: );
306:
307: PROCEDURE Initialize_Set_Processing(
308: p_set IN MRP_ATP_PUB.ATP_Rec_Typ,
309: p_start IN NUMBER DEFAULT 1
310: );
311:
312: PROCEDURE Process_Set_Line(

Line 313: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

309: p_start IN NUMBER DEFAULT 1
310: );
311:
312: PROCEDURE Process_Set_Line(
313: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
314: i IN NUMBER,
315: x_line_status OUT NOCOPY NUMBER
316: );
317:

Line 319: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

315: x_line_status OUT NOCOPY NUMBER
316: );
317:
318: PROCEDURE Process_Set_Dates_Errors(
319: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
320: p_src_dest IN VARCHAR2,
321: x_set_status OUT NOCOPY NUMBER,
322: p_start IN NUMBER DEFAULT NULL,
323: p_end IN NUMBER DEFAULT NULL

Line 327: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

323: p_end IN NUMBER DEFAULT NULL
324: );
325:
326: PROCEDURE Update_Set_SD_Dates(
327: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
328: p_arrival_set IN mrp_atp_pub.date_arr
329: );
330:
331: PROCEDURE get_transit_time (

Line 328: p_arrival_set IN mrp_atp_pub.date_arr

324: );
325:
326: PROCEDURE Update_Set_SD_Dates(
327: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
328: p_arrival_set IN mrp_atp_pub.date_arr
329: );
330:
331: PROCEDURE get_transit_time (
332: p_from_loc_id IN NUMBER,

Line 368: p1 IN OUT NOCOPY mrp_atp_pub.number_arr,

364: );
365:
366: -- append p2 to p1
367: PROCEDURE number_arr_cat (
368: p1 IN OUT NOCOPY mrp_atp_pub.number_arr,
369: p2 IN mrp_atp_pub.number_arr
370: );
371:
372: -- append p2 to p1

Line 369: p2 IN mrp_atp_pub.number_arr

365:
366: -- append p2 to p1
367: PROCEDURE number_arr_cat (
368: p1 IN OUT NOCOPY mrp_atp_pub.number_arr,
369: p2 IN mrp_atp_pub.number_arr
370: );
371:
372: -- append p2 to p1
373: PROCEDURE date_arr_cat (

Line 374: p1 IN OUT NOCOPY mrp_atp_pub.date_arr,

370: );
371:
372: -- append p2 to p1
373: PROCEDURE date_arr_cat (
374: p1 IN OUT NOCOPY mrp_atp_pub.date_arr,
375: p2 IN mrp_atp_pub.date_arr
376: );
377:
378: -- loop through peg_ids and remove s/d recs

Line 375: p2 IN mrp_atp_pub.date_arr

371:
372: -- append p2 to p1
373: PROCEDURE date_arr_cat (
374: p1 IN OUT NOCOPY mrp_atp_pub.date_arr,
375: p2 IN mrp_atp_pub.date_arr
376: );
377:
378: -- loop through peg_ids and remove s/d recs
379: PROCEDURE cleanup_set(

Line 382: peg_ids IN mrp_atp_pub.number_arr,

378: -- loop through peg_ids and remove s/d recs
379: PROCEDURE cleanup_set(
380: p_instance_id IN number,
381: p_plan_id IN number,
382: peg_ids IN mrp_atp_pub.number_arr,
383: dmd_class_flag IN mrp_atp_pub.number_arr
384: );
385:
386: -- supplier intransit LT

Line 383: dmd_class_flag IN mrp_atp_pub.number_arr

379: PROCEDURE cleanup_set(
380: p_instance_id IN number,
381: p_plan_id IN number,
382: peg_ids IN mrp_atp_pub.number_arr,
383: dmd_class_flag IN mrp_atp_pub.number_arr
384: );
385:
386: -- supplier intransit LT
387: PROCEDURE Get_Supplier_Regions (p_vendor_site_id IN NUMBER,