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

Line 51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191

47:
48: -- For summary enhancement
49: G_TIME_PHASED_SET VARCHAR2(1);
50:
51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
54:
55: l_sys_next_omc_date DATE; -- Bug 12672787

Line 52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191

48: -- For summary enhancement
49: G_TIME_PHASED_SET VARCHAR2(1);
50:
51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
54:
55: l_sys_next_omc_date DATE; -- Bug 12672787
56:

Line 53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191

49: G_TIME_PHASED_SET VARCHAR2(1);
50:
51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
54:
55: l_sys_next_omc_date DATE; -- Bug 12672787
56:
57: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

Line 57: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
54:
55: l_sys_next_omc_date DATE; -- Bug 12672787
56:
57: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
58: p_instance_id IN NUMBER,
59: p_assign_set_id IN NUMBER,
60: p_refresh_number IN NUMBER,
61: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

Line 61: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

57: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
58: p_instance_id IN NUMBER,
59: p_assign_set_id IN NUMBER,
60: p_refresh_number IN NUMBER,
61: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
62: x_return_status OUT NoCopy VARCHAR2,
63: x_msg_data OUT NoCopy VARCHAR2,
64: x_msg_count OUT NoCopy NUMBER,
65: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

Line 65: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

61: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
62: x_return_status OUT NoCopy VARCHAR2,
63: x_msg_data OUT NoCopy VARCHAR2,
64: x_msg_count OUT NoCopy NUMBER,
65: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
66: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
67: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
68: ) IS
69:

Line 66: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

62: x_return_status OUT NoCopy VARCHAR2,
63: x_msg_data OUT NoCopy VARCHAR2,
64: x_msg_count OUT NoCopy NUMBER,
65: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
66: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
67: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
68: ) IS
69:
70: i PLS_INTEGER := 1;

Line 67: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ

63: x_msg_data OUT NoCopy VARCHAR2,
64: x_msg_count OUT NoCopy NUMBER,
65: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
66: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
67: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
68: ) IS
69:
70: i PLS_INTEGER := 1;
71: j PLS_INTEGER := 1;

Line 80: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- this is for ship set items

76: l_temp NUMBER;
77: l_plan_id NUMBER;
78: l_temp_plan_id NUMBER; -- this is for ship set items
79: --Bug 1661545, array to store old plan id for undoing unscheduling in case of failure.
80: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- this is for ship set items
81: l_process_item_id NUMBER;
82: l_process_org_id NUMBER;
83: l_ship_count NUMBER;
84: l_arrival_count NUMBER;

Line 102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

98: l_process_arrival_set VARCHAR2(30) := '@@@';
99: l_sources MRP_ATP_PVT.Atp_Source_Typ;
100: l_atp_rec MRP_ATP_PVT.AtpRec;
101: l_future_atp_rec MRP_ATP_PVT.AtpRec;
102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

99: l_sources MRP_ATP_PVT.Atp_Source_Typ;
100: l_atp_rec MRP_ATP_PVT.AtpRec;
101: l_future_atp_rec MRP_ATP_PVT.AtpRec;
102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

100: l_atp_rec MRP_ATP_PVT.AtpRec;
101: l_future_atp_rec MRP_ATP_PVT.AtpRec;
102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

Line 105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;

101: l_future_atp_rec MRP_ATP_PVT.AtpRec;
102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

102: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

104: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

Line 109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;

105: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

106: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;

107: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
115: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

108: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
115: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
116: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;

109: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
115: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
116: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
117: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

110: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
115: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
116: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
117: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
118: l_complete_scatp VARCHAR2(1) := 'N';

Line 115: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;

111: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
115: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
116: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
117: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
118: l_complete_scatp VARCHAR2(1) := 'N';
119: l_multi_scenario NUMBER;

Line 116: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;

112: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
115: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
116: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
117: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
118: l_complete_scatp VARCHAR2(1) := 'N';
119: l_multi_scenario NUMBER;
120: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 117: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

113: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
114: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
115: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
116: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
117: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
118: l_complete_scatp VARCHAR2(1) := 'N';
119: l_multi_scenario NUMBER;
120: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
121: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 120: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

116: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
117: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
118: l_complete_scatp VARCHAR2(1) := 'N';
119: l_multi_scenario NUMBER;
120: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
121: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
122: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
123: l_set_element_success PLS_INTEGER;
124: l_oe_demand_flag VARCHAR2(1) := 'N';

Line 121: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

117: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
118: l_complete_scatp VARCHAR2(1) := 'N';
119: l_multi_scenario NUMBER;
120: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
121: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
122: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
123: l_set_element_success PLS_INTEGER;
124: l_oe_demand_flag VARCHAR2(1) := 'N';
125: my_sqlcode NUMBER;

Line 122: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;

118: l_complete_scatp VARCHAR2(1) := 'N';
119: l_multi_scenario NUMBER;
120: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
121: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
122: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
123: l_set_element_success PLS_INTEGER;
124: l_oe_demand_flag VARCHAR2(1) := 'N';
125: my_sqlcode NUMBER;
126: temp NUMBER;

Line 142: l_fst_src_pegging_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

138: l_default_demand_class VARCHAR2(34);
139: l_sd_qty NUMBER;
140: l_inv_item_id NUMBER;
141: --l_ship_date DATE; -- ship_rec_cal changes
142: l_fst_src_pegging_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
143: l_date_higher_src varchar2(1) := 'Y';
144: l_peg_count NUMBER;
145: l_dblink VARCHAR2(128);
146: l_sys_next_date DATE;

Line 163: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

159: l_summary_flag number;
160: -- Bug 2085071: Assignment Set
161: lv_assign_set_id NUMBER;
162: --2152184
163: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
164: --l_old_org_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
165:
166: ---subst
167: l_item_substitute_rec MSC_ATP_SUBST.Item_Info_Rec_Typ;

Line 164: --l_old_org_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

160: -- Bug 2085071: Assignment Set
161: lv_assign_set_id NUMBER;
162: --2152184
163: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
164: --l_old_org_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
165:
166: ---subst
167: l_item_substitute_rec MSC_ATP_SUBST.Item_Info_Rec_Typ;
168: l_null_item_sub_rec MSC_ATP_SUBST.Item_Info_Rec_Typ;

Line 182: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

178: L_DELIVERY_LEAD_TIME number;
179: L_REQUESTED_SHIP_DATE date;
180: L_FROM_LOCATION_ID number;
181: L_SHIP_METHOD varchar2(50);
182: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
183: l_old_pf_item_id number;
184: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
185:
186: l_org_code VARCHAR2(7);

Line 184: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

180: L_FROM_LOCATION_ID number;
181: L_SHIP_METHOD varchar2(50);
182: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
183: l_old_pf_item_id number;
184: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
185:
186: l_org_code VARCHAR2(7);
187: l_counter NUMBER; -- defined for Bug 2368426
188:

Line 199: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

195: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
196: l_bkwd_pass_atf_date_qty NUMBER; --bug3397904
197:
198: --bug 2384224
199: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
202: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
203: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro

Line 200: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

196: l_bkwd_pass_atf_date_qty NUMBER; --bug3397904
197:
198: --bug 2384224
199: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
202: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
203: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
204: l_delete_demand_flag PLS_INTEGER;

Line 201: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

197:
198: --bug 2384224
199: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
202: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
203: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
204: l_delete_demand_flag PLS_INTEGER;
205:

Line 202: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

198: --bug 2384224
199: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
202: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
203: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
204: l_delete_demand_flag PLS_INTEGER;
205:
206: --diag_atp

Line 203: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro

199: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
202: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
203: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
204: l_delete_demand_flag PLS_INTEGER;
205:
206: --diag_atp
207: l_pegging_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 207: l_pegging_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

203: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
204: l_delete_demand_flag PLS_INTEGER;
205:
206: --diag_atp
207: l_pegging_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
208: l_highest_rev NUMBER;
209:
210: -- ATP Override rajjain begin
211: l_latest_acceptable_date DATE;

Line 231: l_req_atp_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();

227: -- bug 2795053-reopen (ssurendr)
228: l_dmd_satisfied_date DATE;
229:
230: -- 2902265
231: l_req_atp_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
232: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
233: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
234:
235: --s_cto_rearch

Line 232: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

228: l_dmd_satisfied_date DATE;
229:
230: -- 2902265
231: l_req_atp_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
232: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
233: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
234:
235: --s_cto_rearch
236: l_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;

Line 233: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

229:
230: -- 2902265
231: l_req_atp_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
232: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
233: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
234:
235: --s_cto_rearch
236: l_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;
237:

Line 247: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

243: l_pf_atp VARCHAR2(1) := 'N';
244: l_time_phased_atp VARCHAR2(1) := 'N';
245: l_atf_date DATE;
246: l_time_phased_set VARCHAR2(1) := 'N';
247: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
248: l_match_item_family_id NUMBER;
249:
250: -- For summary enhancement
251: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

Line 251: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

247: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
248: l_match_item_family_id NUMBER;
249:
250: -- For summary enhancement
251: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
252: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
253: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
254:
255:

Line 252: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

248: l_match_item_family_id NUMBER;
249:
250: -- For summary enhancement
251: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
252: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
253: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
254:
255:
256: -- CTO ODR and Simplified Pegging

Line 253: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

249:
250: -- For summary enhancement
251: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
252: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
253: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
254:
255:
256: -- CTO ODR and Simplified Pegging
257: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;

Line 257: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;

253: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
254:
255:
256: -- CTO ODR and Simplified Pegging
257: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
259: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

Line 258: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;

254:
255:
256: -- CTO ODR and Simplified Pegging
257: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
259: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

Line 259: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;

255:
256: -- CTO ODR and Simplified Pegging
257: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
259: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

Line 260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;

256: -- CTO ODR and Simplified Pegging
257: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
259: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

257: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
259: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

258: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
259: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

259: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

260: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

261: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

262: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

263: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

264: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

265: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
273: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

266: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
273: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
274: -- END CTO ODR and Simplified Pegging

Line 271: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

267: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
273: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
274: -- END CTO ODR and Simplified Pegging
275: --plan by request date enhancment

Line 272: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

268: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
273: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
274: -- END CTO ODR and Simplified Pegging
275: --plan by request date enhancment
276: l_original_req_arrival_date DATE;

Line 273: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

269: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
273: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
274: -- END CTO ODR and Simplified Pegging
275: --plan by request date enhancment
276: l_original_req_arrival_date DATE;
277: l_req_arr_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();

Line 277: l_req_arr_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();

273: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
274: -- END CTO ODR and Simplified Pegging
275: --plan by request date enhancment
276: l_original_req_arrival_date DATE;
277: l_req_arr_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
278: -- ship_rec_cal changes
279: l_shipping_cal_code VARCHAR2(14);
280: l_receiving_cal_code VARCHAR2(14);
281: l_manufacturing_cal_code VARCHAR2(14);

Line 333: l_ctp_parent_peg_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

329: l_last_success_atp_rec MRP_ATP_PVT.AtpRec;
330:
331: --Pegging ids used for deletion and hide/un-hide.
332: l_atp_peg_id NUMBER;
333: l_ctp_parent_peg_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
334: l_steal_atp_peg_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
335: l_forward_atp VARCHAR2(1); --5221865
336: --optional_fw end
337: l_org_collected NUMBER; --13032665

Line 334: l_steal_atp_peg_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

330:
331: --Pegging ids used for deletion and hide/un-hide.
332: l_atp_peg_id NUMBER;
333: l_ctp_parent_peg_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
334: l_steal_atp_peg_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
335: l_forward_atp VARCHAR2(1); --5221865
336: --optional_fw end
337: l_org_collected NUMBER; --13032665
338: BEGIN

Line 1096: --MRP_ATP_PUB.number_arr(NULL),

1092: p_atp_table.Customer_Site_Id(k),
1093: l_assign_set_id,
1094: --s_cto_rearch
1095: l_item_sourcing_info_rec,
1096: --MRP_ATP_PUB.number_arr(NULL),
1097: MSC_ATP_PVT.G_SESSION_ID,
1098: l_sources,
1099: l_return_status,
1100: l_partner_type, --2814895

Line 1198: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);

1194: RAISE NO_DATA_FOUND;
1195: END IF;
1196:
1197: ELSE
1198: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1199: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1200: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1201: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1202: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);

Line 1199: l_sources.Rank := MRP_ATP_PUB.number_arr(1);

1195: END IF;
1196:
1197: ELSE
1198: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1199: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1200: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1201: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1202: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1203: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);

Line 1200: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);

1196:
1197: ELSE
1198: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1199: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1200: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1201: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1202: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1203: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);
1204: END IF;

Line 1201: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);

1197: ELSE
1198: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1199: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1200: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1201: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1202: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1203: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);
1204: END IF;
1205: --e_cto_rearch

Line 1202: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);

1198: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1199: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1200: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1201: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1202: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1203: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);
1204: END IF;
1205: --e_cto_rearch
1206: END IF;

Line 1203: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);

1199: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1200: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1201: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1202: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1203: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);
1204: END IF;
1205: --e_cto_rearch
1206: END IF;
1207:

Line 6653: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

6649: p_search IN NUMBER,
6650: p_refresh_number IN NUMBER,
6651: p_parent_pegging_id IN NUMBER,
6652: p_assign_set_id IN NUMBER,
6653: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
6654: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
6655: x_return_status OUT NoCopy VARCHAR2,
6656: p_pre_processing_lead_time IN NUMBER :=0
6657: )

Line 6654: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

6650: p_refresh_number IN NUMBER,
6651: p_parent_pegging_id IN NUMBER,
6652: p_assign_set_id IN NUMBER,
6653: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
6654: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
6655: x_return_status OUT NoCopy VARCHAR2,
6656: p_pre_processing_lead_time IN NUMBER :=0
6657: )
6658: IS

Line 6684: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6680: l_atp_rec MRP_ATP_PVT.AtpRec;
6681: l_net_demand NUMBER := 0; --5478124
6682: l_sched_status BOOLEAN;
6683: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6684: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6685: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 6685: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;

6681: l_net_demand NUMBER := 0; --5478124
6682: l_sched_status BOOLEAN;
6683: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6684: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6685: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6682: l_sched_status BOOLEAN;
6683: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6684: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6685: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6683: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6684: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6685: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6684: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6685: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6692: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6685: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6692: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6693: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6686: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6692: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6693: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6694: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6687: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6692: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6693: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6694: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6695:

Line 6692: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6688: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6692: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6693: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6694: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6695:
6696: l_inv_item_id NUMBER;

Line 6693: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6689: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6692: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6693: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6694: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6695:
6696: l_inv_item_id NUMBER;
6697:

Line 6694: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6690: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6691: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6692: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6693: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6694: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6695:
6696: l_inv_item_id NUMBER;
6697:
6698: temp NUMBER;

Line 6757: l_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

6753: l_ptf_date_for_child DATE; -- Bug 3782472
6754: l_req_date_qty NUMBER;
6755: l_item_attribute_rec MSC_ATP_PVT.item_attribute_rec; -- Obsoleted
6756: l_substitution_window NUMBER;
6757: l_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
6758: -- Only specific to this procedure
6759: PF_ITEM_INFO_REC MSC_ATP_PVT.item_attribute_rec; -- Only for PF info
6760: C_ITEM_INFO_REC MSC_ATP_PVT.item_attribute_rec; -- Copy of the global.
6761: -- Added for bug 2392456

Line 10772: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make

10768: msc_sch_wb.atp_debug('ATP_Check: ' || 'ods atp, we always make');
10769: END IF;
10770:
10771: --we should come here only for ATO models or ATO items
10772: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10773: l_sources.Organization_Id:=
10774: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10775: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10776: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);

Line 10774: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);

10770:
10771: --we should come here only for ATO models or ATO items
10772: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10773: l_sources.Organization_Id:=
10774: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10775: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10776: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10777: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10778: l_sources.instance_id :=

Line 10775: l_sources.Rank := MRP_ATP_PUB.number_arr(1);

10771: --we should come here only for ATO models or ATO items
10772: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10773: l_sources.Organization_Id:=
10774: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10775: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10776: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10777: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10778: l_sources.instance_id :=
10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

Line 10776: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);

10772: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10773: l_sources.Organization_Id:=
10774: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10775: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10776: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10777: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10778: l_sources.instance_id :=
10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

Line 10777: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);

10773: l_sources.Organization_Id:=
10774: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10775: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10776: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10777: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10778: l_sources.instance_id :=
10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10781: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

Line 10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

10775: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10776: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10777: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10778: l_sources.instance_id :=
10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10781: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10782: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10783: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

Line 10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

10776: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10777: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10778: l_sources.instance_id :=
10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10781: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10782: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10783: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10784: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

Line 10781: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

10777: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10778: l_sources.instance_id :=
10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10781: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10782: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10783: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10784: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10785:

Line 10782: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal

10778: l_sources.instance_id :=
10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10781: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10782: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10783: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10784: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10785:
10786: --do not get sources for phantom model

Line 10783: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

10779: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10781: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10782: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10783: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10784: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10785:
10786: --do not get sources for phantom model
10787: ELSIF NOT (C_ITEM_INFO_REC.bom_item_type = 1 and NVL(p_atp_record.wip_supply_type,2) = 6 and

Line 10784: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

10780: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10781: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10782: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10783: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10784: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10785:
10786: --do not get sources for phantom model
10787: ELSIF NOT (C_ITEM_INFO_REC.bom_item_type = 1 and NVL(p_atp_record.wip_supply_type,2) = 6 and
10788: C_ITEM_INFO_REC.replenish_to_ord_flag = 'Y') THEN

Line 10799: --MRP_ATP_PUB.number_arr(NULL),

10795: NULL,
10796: NULL,
10797: p_assign_set_id,
10798: l_item_sourcing_info_rec,
10799: --MRP_ATP_PUB.number_arr(NULL),
10800: MSC_ATP_PVT.G_SESSION_ID,
10801: l_sources,
10802: l_return_status);
10803:

Line 10847: l_sources.Source_Type := MRP_ATP_PUB.number_arr(3); --- BUY

10843: WHEN OTHERS THEN
10844: l_make_buy_cd := 1; --- make 'make' default
10845: END;
10846: IF (l_make_buy_cd = 2) THEN --- buy
10847: l_sources.Source_Type := MRP_ATP_PUB.number_arr(3); --- BUY
10848: l_sources.Organization_Id:=
10849: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10850: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10851: ----- Since supplier id and supplier site id is no known

Line 10849: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);

10845: END;
10846: IF (l_make_buy_cd = 2) THEN --- buy
10847: l_sources.Source_Type := MRP_ATP_PUB.number_arr(3); --- BUY
10848: l_sources.Organization_Id:=
10849: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10850: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10851: ----- Since supplier id and supplier site id is no known
10852: ---- we set it to -99. We cant set it to null because
10853: ---- when atp_check procedure is called from buy logic below

Line 10850: l_sources.Rank := MRP_ATP_PUB.number_arr(1);

10846: IF (l_make_buy_cd = 2) THEN --- buy
10847: l_sources.Source_Type := MRP_ATP_PUB.number_arr(3); --- BUY
10848: l_sources.Organization_Id:=
10849: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10850: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10851: ----- Since supplier id and supplier site id is no known
10852: ---- we set it to -99. We cant set it to null because
10853: ---- when atp_check procedure is called from buy logic below
10854: ---- then it will go into inventory org to do atp check rather

Line 10856: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);

10852: ---- we set it to -99. We cant set it to null because
10853: ---- when atp_check procedure is called from buy logic below
10854: ---- then it will go into inventory org to do atp check rather
10855: ----- then calling get_supplier_atp_info
10856: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);
10857: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10858: l_sources.instance_id :=
10859: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

Line 10857: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);

10853: ---- when atp_check procedure is called from buy logic below
10854: ---- then it will go into inventory org to do atp check rather
10855: ----- then calling get_supplier_atp_info
10856: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);
10857: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10858: l_sources.instance_id :=
10859: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10861: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

Line 10859: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

10855: ----- then calling get_supplier_atp_info
10856: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);
10857: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10858: l_sources.instance_id :=
10859: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10861: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10862: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10863: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

Line 10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

10856: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);
10857: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10858: l_sources.instance_id :=
10859: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10861: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10862: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10863: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10864: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

Line 10861: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

10857: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10858: l_sources.instance_id :=
10859: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10861: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10862: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10863: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10864: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10865:

Line 10862: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal

10858: l_sources.instance_id :=
10859: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10861: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10862: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10863: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10864: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10865:
10866: -- dsting

Line 10863: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

10859: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10861: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10862: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10863: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10864: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10865:
10866: -- dsting
10867: IF PG_DEBUG in ('Y', 'C') THEN

Line 10864: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

10860: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10861: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10862: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10863: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10864: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10865:
10866: -- dsting
10867: IF PG_DEBUG in ('Y', 'C') THEN
10868: msc_sch_wb.atp_debug('ATP_Check: ' || 'MAKE_BUY_CHILDREN: have buy source');

Line 10872: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make

10868: msc_sch_wb.atp_debug('ATP_Check: ' || 'MAKE_BUY_CHILDREN: have buy source');
10869: END IF;
10870: p_atp_record.children_type := MAKE_BUY_CHILDREN;
10871: ELSE
10872: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10873: l_sources.Organization_Id:=
10874: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10875: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10876: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);

Line 10874: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);

10870: p_atp_record.children_type := MAKE_BUY_CHILDREN;
10871: ELSE
10872: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10873: l_sources.Organization_Id:=
10874: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10875: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10876: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10877: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10878: l_sources.instance_id :=

Line 10875: l_sources.Rank := MRP_ATP_PUB.number_arr(1);

10871: ELSE
10872: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10873: l_sources.Organization_Id:=
10874: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10875: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10876: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10877: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10878: l_sources.instance_id :=
10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

Line 10876: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);

10872: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10873: l_sources.Organization_Id:=
10874: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10875: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10876: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10877: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10878: l_sources.instance_id :=
10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

Line 10877: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);

10873: l_sources.Organization_Id:=
10874: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10875: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10876: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10877: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10878: l_sources.instance_id :=
10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10881: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

Line 10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

10875: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10876: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10877: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10878: l_sources.instance_id :=
10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10881: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10882: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10883: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

Line 10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

10876: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10877: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10878: l_sources.instance_id :=
10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10881: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10882: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10883: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10884: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

Line 10881: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

10877: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10878: l_sources.instance_id :=
10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10881: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10882: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10883: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10884: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10885:

Line 10882: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal

10878: l_sources.instance_id :=
10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10881: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10882: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10883: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10884: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10885:
10886: -- dsting

Line 10883: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

10879: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10881: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10882: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10883: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10884: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10885:
10886: -- dsting
10887: IF PG_DEBUG in ('Y', 'C') THEN

Line 10884: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

10880: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10881: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10882: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10883: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10884: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10885:
10886: -- dsting
10887: IF PG_DEBUG in ('Y', 'C') THEN
10888: msc_sch_wb.atp_debug('ATP_Check: ' || 'MAKE_BUY_CHILDREN: have make source');

Line 13405: l_atp_pegging_tab := MRP_ATP_PUB.Number_Arr(); --bug3581151

13401: -- Planned Pegging based AATP, l_atp_pegging_tab populated in
13402: -- MSC_AATP_REQ.Get_Forward_Material_Atp
13403:
13404: MSC_ATP_DB_UTILS.Remove_Invalid_Future_SD(l_atp_pegging_tab);
13405: l_atp_pegging_tab := MRP_ATP_PUB.Number_Arr(); --bug3581151
13406:
13407: ELSE -- IF l_atp_pegging_tab.COUNT > 0 THEN
13408: MSC_ATP_DB_UTILS.Update_Planned_Order(l_future_pegging_id,
13409: p_plan_id,

Line 15352: l_atp_pegging_tab := MRP_ATP_PUB.Number_Arr(); --bug3581151

15348: -- Planned Pegging based AATP, l_atp_pegging_tab populated in
15349: -- MSC_AATP_REQ.Get_Forward_Material_Atp
15350:
15351: MSC_ATP_DB_UTILS.Remove_Invalid_Future_SD(l_atp_pegging_tab);
15352: l_atp_pegging_tab := MRP_ATP_PUB.Number_Arr(); --bug3581151
15353:
15354: ELSE -- IF l_atp_pegging_tab.COUNT > 0 THEN
15355:
15356: MSC_ATP_DB_UTILS.Update_Planned_Order(l_future_pegging_id,

Line 17078: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

17074:
17075:
17076: PROCEDURE Call_Schedule (
17077: p_session_id IN NUMBER,
17078: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
17079: p_instance_id IN NUMBER,
17080: p_assign_set_id IN NUMBER,
17081: p_refresh_number IN NUMBER,
17082: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

Line 17082: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

17078: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
17079: p_instance_id IN NUMBER,
17080: p_assign_set_id IN NUMBER,
17081: p_refresh_number IN NUMBER,
17082: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
17083: x_return_status OUT NoCopy VARCHAR2,
17084: x_msg_data OUT NoCopy VARCHAR2,
17085: x_msg_count OUT NoCopy NUMBER,
17086: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

Line 17086: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

17082: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
17083: x_return_status OUT NoCopy VARCHAR2,
17084: x_msg_data OUT NoCopy VARCHAR2,
17085: x_msg_count OUT NoCopy NUMBER,
17086: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
17087: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
17088: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
17089: ) IS
17090:

Line 17087: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

17083: x_return_status OUT NoCopy VARCHAR2,
17084: x_msg_data OUT NoCopy VARCHAR2,
17085: x_msg_count OUT NoCopy NUMBER,
17086: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
17087: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
17088: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
17089: ) IS
17090:
17091: i PLS_INTEGER;

Line 17088: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ

17084: x_msg_data OUT NoCopy VARCHAR2,
17085: x_msg_count OUT NoCopy NUMBER,
17086: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
17087: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
17088: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
17089: ) IS
17090:
17091: i PLS_INTEGER;
17092: j PLS_INTEGER;

Line 17096: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;

17092: j PLS_INTEGER;
17093: k PLS_INTEGER;
17094: m PLS_INTEGER;
17095: l_return_status VARCHAR2(1);
17096: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
17097: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
17098: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 17097: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;

17093: k PLS_INTEGER;
17094: m PLS_INTEGER;
17095: l_return_status VARCHAR2(1);
17096: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
17097: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
17098: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

Line 17098: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

17094: m PLS_INTEGER;
17095: l_return_status VARCHAR2(1);
17096: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
17097: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
17098: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
17102: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

17095: l_return_status VARCHAR2(1);
17096: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
17097: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
17098: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
17102: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17103: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

17096: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
17097: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
17098: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
17102: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17103: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17104: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

17097: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
17098: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
17102: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17103: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17104: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17105: l_msg_data VARCHAR2(2000);

Line 17102: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

17098: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
17102: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17103: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17104: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17105: l_msg_data VARCHAR2(2000);
17106: l_msg_text VARCHAR2(2000);

Line 17103: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

17099: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
17102: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17103: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17104: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17105: l_msg_data VARCHAR2(2000);
17106: l_msg_text VARCHAR2(2000);
17107: l_msg_count NUMBER;

Line 17104: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;

17100: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17101: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
17102: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
17103: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
17104: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
17105: l_msg_data VARCHAR2(2000);
17106: l_msg_text VARCHAR2(2000);
17107: l_msg_count NUMBER;
17108: l_msg_number NUMBER;

Line 17149: l_included_item_table MRP_ATP_PUB.ATP_Rec_Typ;

17145: -- rajjain 02/03/2003 Bug 2766713
17146: l_set_fail_flag VARCHAR2(1) := 'N';
17147:
17148: --s_cto_rearch
17149: l_included_item_table MRP_ATP_PUB.ATP_Rec_Typ;
17150: l_included_item_cntr number;
17151: l_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
17152: l_null_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
17153: l_pto_cntr number;

Line 18565: MSC_ATP_PVT.G_COPY_DEMAND_ID := MRP_ATP_PUB.number_arr();

18561: MSC_ATP_PVT.G_COPY_DEMAND_PLAN_ID,
18562: G_TIME_PHASED_SET,
18563: l_return_status);
18564: END IF;
18565: MSC_ATP_PVT.G_COPY_DEMAND_ID := MRP_ATP_PUB.number_arr();
18566: MSC_ATP_PVT.G_COPY_DEMAND_PLAN_ID := MRP_ATP_PUB.number_arr();
18567:
18568: --Bug 3629191: Insert Offset Record to MRP_ATP_DETAILS_TEMP with record_type = 3
18569: -- and these will be inserted with NULL in all the three pegging_id columns

Line 18566: MSC_ATP_PVT.G_COPY_DEMAND_PLAN_ID := MRP_ATP_PUB.number_arr();

18562: G_TIME_PHASED_SET,
18563: l_return_status);
18564: END IF;
18565: MSC_ATP_PVT.G_COPY_DEMAND_ID := MRP_ATP_PUB.number_arr();
18566: MSC_ATP_PVT.G_COPY_DEMAND_PLAN_ID := MRP_ATP_PUB.number_arr();
18567:
18568: --Bug 3629191: Insert Offset Record to MRP_ATP_DETAILS_TEMP with record_type = 3
18569: -- and these will be inserted with NULL in all the three pegging_id columns
18570:

Line 18951: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

18947: ) IS
18948:
18949: i PLS_INTEGER;
18950: l_dblink VARCHAR2(128);
18951: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18952: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18953: x_return_status VARCHAR2(128);
18954: x_msg_data VARCHAR2(2000);
18955: x_msg_count NUMBER;

Line 18952: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

18948:
18949: i PLS_INTEGER;
18950: l_dblink VARCHAR2(128);
18951: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18952: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18953: x_return_status VARCHAR2(128);
18954: x_msg_data VARCHAR2(2000);
18955: x_msg_count NUMBER;
18956: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 18956: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

18952: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18953: x_return_status VARCHAR2(128);
18954: x_msg_data VARCHAR2(2000);
18955: x_msg_count NUMBER;
18956: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18957: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18958: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18959: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;
18960:

Line 18957: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;

18953: x_return_status VARCHAR2(128);
18954: x_msg_data VARCHAR2(2000);
18955: x_msg_count NUMBER;
18956: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18957: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18958: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18959: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;
18960:
18961: -- Bug 2387242 : krajan

Line 18958: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

18954: x_msg_data VARCHAR2(2000);
18955: x_msg_count NUMBER;
18956: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18957: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18958: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18959: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;
18960:
18961: -- Bug 2387242 : krajan
18962: -- Variables for SQL trace setup

Line 18959: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;

18955: x_msg_count NUMBER;
18956: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18957: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18958: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18959: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;
18960:
18961: -- Bug 2387242 : krajan
18962: -- Variables for SQL trace setup
18963: C INTEGER;

Line 18971: l_profile_value MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999

18967: -- rajjain 12/20/2002
18968: l_spid VARCHAR2(12);
18969:
18970: --bug3940999
18971: l_profile_value MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999
18972: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999
18973: l_use_ship_rec VARCHAR2(2); --bug3940999
18974: j NUMBER ; --bug3940999
18975:

Line 18972: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999

18968: l_spid VARCHAR2(12);
18969:
18970: --bug3940999
18971: l_profile_value MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999
18972: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999
18973: l_use_ship_rec VARCHAR2(2); --bug3940999
18974: j NUMBER ; --bug3940999
18975:
18976: BEGIN

Line 19390: PROCEDURE Process_Time_Stamp_Errors (l_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

19386: msc_sch_wb.atp_debug('***** End Call_Schedule_Remote Procedure *****');
19387: END IF;
19388:
19389: END Call_Schedule_Remote;
19390: PROCEDURE Process_Time_Stamp_Errors (l_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
19391: i NUMBER)
19392: IS
19393: BEGIN
19394: