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(
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
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
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 (
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
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:
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:
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
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: );
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:
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:
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,
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,
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:
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:
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(
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,
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(
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:
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
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 (
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,
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
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 (
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
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(
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
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,