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.AHL_LTP_MATRL_AVAL_PVT dependencies on MRP_ATP_PUB

Line 78: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;

74: L_API_NAME CONSTANT VARCHAR2(30) := 'CHECK_AVAILABILITY';
75: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
76: L_API_VERSION CONSTANT NUMBER := 1.0;
77:
78: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
79: l_instance_id INTEGER;
80: l_session_id NUMBER;
81: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
82: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;

Line 81: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;

77:
78: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
79: l_instance_id INTEGER;
80: l_session_id NUMBER;
81: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
82: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
83: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
84: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
85: l_uom_code VARCHAR2(10);

Line 82: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;

78: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
79: l_instance_id INTEGER;
80: l_session_id NUMBER;
81: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
82: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
83: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
84: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
85: l_uom_code VARCHAR2(10);
86: l_calling_module NUMBER;

Line 83: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;

79: l_instance_id INTEGER;
80: l_session_id NUMBER;
81: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
82: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
83: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
84: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
85: l_uom_code VARCHAR2(10);
86: l_calling_module NUMBER;
87: l_need_by_date DATE;

Line 84: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;

80: l_session_id NUMBER;
81: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
82: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
83: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
84: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
85: l_uom_code VARCHAR2(10);
86: l_calling_module NUMBER;
87: l_need_by_date DATE;
88: l_return_status VARCHAR2(1);

Line 152: l_atp_table.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(p_inventory_item_id);

148:
149: MSC_ATP_GLOBAL.Extend_ATP(l_atp_table, x_return_status);
150:
151: --Assign values to input record
152: l_atp_table.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(p_inventory_item_id);
153: l_atp_table.Source_Organization_Id := Mrp_Atp_Pub.number_arr(p_organization_id);
154: l_atp_table.Identifier := Mrp_Atp_Pub.number_arr(l_identifier);
155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);
156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);

Line 153: l_atp_table.Source_Organization_Id := Mrp_Atp_Pub.number_arr(p_organization_id);

149: MSC_ATP_GLOBAL.Extend_ATP(l_atp_table, x_return_status);
150:
151: --Assign values to input record
152: l_atp_table.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(p_inventory_item_id);
153: l_atp_table.Source_Organization_Id := Mrp_Atp_Pub.number_arr(p_organization_id);
154: l_atp_table.Identifier := Mrp_Atp_Pub.number_arr(l_identifier);
155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);
156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);
157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);

Line 154: l_atp_table.Identifier := Mrp_Atp_Pub.number_arr(l_identifier);

150:
151: --Assign values to input record
152: l_atp_table.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(p_inventory_item_id);
153: l_atp_table.Source_Organization_Id := Mrp_Atp_Pub.number_arr(p_organization_id);
154: l_atp_table.Identifier := Mrp_Atp_Pub.number_arr(l_identifier);
155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);
156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);
157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);
158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);

Line 155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);

151: --Assign values to input record
152: l_atp_table.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(p_inventory_item_id);
153: l_atp_table.Source_Organization_Id := Mrp_Atp_Pub.number_arr(p_organization_id);
154: l_atp_table.Identifier := Mrp_Atp_Pub.number_arr(l_identifier);
155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);
156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);
157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);
158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);

Line 156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);

152: l_atp_table.Inventory_Item_Id := Mrp_Atp_Pub.number_arr(p_inventory_item_id);
153: l_atp_table.Source_Organization_Id := Mrp_Atp_Pub.number_arr(p_organization_id);
154: l_atp_table.Identifier := Mrp_Atp_Pub.number_arr(l_identifier);
155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);
156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);
157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);
158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);
160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);

Line 157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);

153: l_atp_table.Source_Organization_Id := Mrp_Atp_Pub.number_arr(p_organization_id);
154: l_atp_table.Identifier := Mrp_Atp_Pub.number_arr(l_identifier);
155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);
156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);
157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);
158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);
160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);
161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);

Line 158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);

154: l_atp_table.Identifier := Mrp_Atp_Pub.number_arr(l_identifier);
155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);
156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);
157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);
158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);
160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);
161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);
162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));

Line 159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);

155: l_atp_table.Instance_Id := MRP_ATP_PUB.number_arr(l_instance_id) ; --223);
156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);
157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);
158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);
160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);
161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);
162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));
163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);

Line 160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);

156: l_atp_table.Calling_Module := Mrp_Atp_Pub.number_arr(p_calling_module);
157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);
158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);
160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);
161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);
162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));
163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);
164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);

Line 161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);

157: l_atp_table.Customer_Id := Mrp_Atp_Pub.number_arr(NULL);
158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);
160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);
161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);
162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));
163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);
164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);
165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);

Line 162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));

158: l_atp_table.Customer_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);
160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);
161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);
162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));
163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);
164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);
165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);
166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);

Line 163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);

159: l_atp_table.Destination_Time_Zone := Mrp_Atp_Pub.char30_arr(NULL);
160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);
161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);
162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));
163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);
164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);
165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);
166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);
167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);

Line 164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);

160: l_atp_table.Quantity_Ordered := Mrp_Atp_Pub.number_arr(p_quantity_required);
161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);
162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));
163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);
164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);
165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);
166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);
167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);
168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);

Line 165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);

161: l_atp_table.Quantity_UOM := Mrp_Atp_Pub.char3_arr(p_uom);
162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));
163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);
164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);
165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);
166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);
167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);
168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);
169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);

Line 166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);

162: l_atp_table.Requested_Ship_Date := Mrp_Atp_Pub.date_arr(to_date(p_requested_date,'DD-MM-YYYY'));
163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);
164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);
165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);
166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);
167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);
168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);
169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);

Line 167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);

163: l_atp_table.Requested_Arrival_Date := Mrp_Atp_Pub.date_arr(null);
164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);
165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);
166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);
167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);
168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);
169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);

Line 168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);

164: l_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(null);
165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);
166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);
167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);
168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);
169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);
172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);

Line 169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);

165: l_atp_table.Delivery_Lead_Time := Mrp_Atp_Pub.number_arr(NULL);
166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);
167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);
168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);
169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);
172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);
173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);

Line 170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);

166: l_atp_table.Freight_Carrier := Mrp_Atp_Pub.char30_arr(NULL);
167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);
168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);
169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);
172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);
173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);
174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);

Line 171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);

167: l_atp_table.Ship_Method := Mrp_Atp_Pub.char30_arr(NULL);
168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);
169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);
172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);
173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);
174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);
175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);

Line 172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);

168: l_atp_table.Demand_Class := Mrp_Atp_Pub.char30_arr(NULL);
169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);
172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);
173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);
174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);
175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);
176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);

Line 173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);

169: l_atp_table.Ship_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);
172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);
173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);
174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);
175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);
176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);
177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);

Line 174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);

170: l_atp_table.Arrival_Set_Name := Mrp_Atp_Pub.char30_arr(NULL);
171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);
172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);
173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);
174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);
175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);
176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);
177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);
178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);

Line 175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);

171: l_atp_table.Override_Flag := Mrp_Atp_Pub.char1_arr(NULL);
172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);
173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);
174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);
175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);
176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);
177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);
178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
179: l_atp_table.Insert_Flag := Mrp_Atp_Pub.number_arr(NULL);

Line 176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);

172: l_atp_table.Action := Mrp_Atp_Pub.number_arr(100);
173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);
174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);
175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);
176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);
177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);
178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
179: l_atp_table.Insert_Flag := Mrp_Atp_Pub.number_arr(NULL);
180: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);

Line 177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);

173: l_atp_table.Ship_Date := Mrp_Atp_Pub.date_arr(sysdate);
174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);
175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);
176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);
177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);
178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
179: l_atp_table.Insert_Flag := Mrp_Atp_Pub.number_arr(NULL);
180: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);
181: l_atp_table.Message := Mrp_Atp_Pub.char2000_arr(NULL);

Line 178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);

174: l_atp_table.Available_Quantity := Mrp_Atp_Pub.number_arr(NULL);
175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);
176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);
177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);
178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
179: l_atp_table.Insert_Flag := Mrp_Atp_Pub.number_arr(NULL);
180: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);
181: l_atp_table.Message := Mrp_Atp_Pub.char2000_arr(NULL);
182:

Line 179: l_atp_table.Insert_Flag := Mrp_Atp_Pub.number_arr(NULL);

175: l_atp_table.Requested_Date_Quantity := Mrp_Atp_Pub.number_arr(NULL);
176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);
177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);
178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
179: l_atp_table.Insert_Flag := Mrp_Atp_Pub.number_arr(NULL);
180: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);
181: l_atp_table.Message := Mrp_Atp_Pub.char2000_arr(NULL);
182:
183: IF (l_log_statement >= l_log_current_level) THEN

Line 180: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);

176: l_atp_table.Group_Ship_Date := Mrp_Atp_Pub.date_arr(NULL);
177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);
178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
179: l_atp_table.Insert_Flag := Mrp_Atp_Pub.number_arr(NULL);
180: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);
181: l_atp_table.Message := Mrp_Atp_Pub.char2000_arr(NULL);
182:
183: IF (l_log_statement >= l_log_current_level) THEN
184: fnd_log.string(l_log_statement,

Line 181: l_atp_table.Message := Mrp_Atp_Pub.char2000_arr(NULL);

177: l_atp_table.Vendor_Id := Mrp_Atp_Pub.number_arr(NULL);
178: l_atp_table.Vendor_Site_Id := Mrp_Atp_Pub.number_arr(NULL);
179: l_atp_table.Insert_Flag := Mrp_Atp_Pub.number_arr(NULL);
180: l_atp_table.Error_Code := Mrp_Atp_Pub.number_arr(NULL);
181: l_atp_table.Message := Mrp_Atp_Pub.char2000_arr(NULL);
182:
183: IF (l_log_statement >= l_log_current_level) THEN
184: fnd_log.string(l_log_statement,
185: L_DEBUG_KEY,

Line 207: 'Before calling Mrp Atp Pub.Call_ATP');

203:
204: IF (l_log_statement >= l_log_current_level) THEN
205: fnd_log.string(l_log_statement,
206: L_DEBUG_KEY,
207: 'Before calling Mrp Atp Pub.Call_ATP');
208: END IF;
209:
210: -- call atp module
211: Mrp_Atp_Pub.Call_ATP

Line 211: Mrp_Atp_Pub.Call_ATP

207: 'Before calling Mrp Atp Pub.Call_ATP');
208: END IF;
209:
210: -- call atp module
211: Mrp_Atp_Pub.Call_ATP
212: (l_session_id,
213: l_atp_table,
214: x_atp_table,
215: x_atp_supply_demand,

Line 225: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| l_return_status);

221:
222: IF (l_log_statement >= l_log_current_level) THEN
223: fnd_log.string(l_log_statement,
224: L_DEBUG_KEY,
225: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| l_return_status);
226: END IF;
227:
228: -- Check Error Message stack.
229: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 292: 'After Calling Mrp Atp Pub. Error Code = ' || x_error_code ||

288:
289: IF (l_log_statement >= l_log_current_level) THEN
290: fnd_log.string(l_log_statement,
291: L_DEBUG_KEY,
292: 'After Calling Mrp Atp Pub. Error Code = ' || x_error_code ||
293: ', Available Quantity : '||x_available_qty);
294: END IF;
295:
296: --Get from mfg lookups

Line 304: 'After Calling Mrp Atp Pub Error Message : '||x_error_message);

300:
301: IF (l_log_statement >= l_log_current_level) THEN
302: fnd_log.string(l_log_statement,
303: L_DEBUG_KEY,
304: 'After Calling Mrp Atp Pub Error Message : '||x_error_message);
305: END IF;
306: ELSE
307: MSC_ATP_GLOBAL.Extend_ATP(x_atp_table, l_return_status);
308:

Line 343: 'Derived from Mrp Atp Pub Available Quantity : '||x_available_qty);

339:
340: IF (l_log_statement >= l_log_current_level) THEN
341: fnd_log.string(l_log_statement,
342: L_DEBUG_KEY,
343: 'Derived from Mrp Atp Pub Available Quantity : '||x_available_qty);
344: END IF;
345:
346: -- Check Error Message stack.
347: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 824: (p_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

820: p_data => l_msg_data);
821: END Get_Visit_Task_Materials;
822: --
823: PROCEDURE Extend_ATP
824: (p_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
825: x_return_status OUT NOCOPY VARCHAR2)
826: IS
827:
828: L_API_NAME CONSTANT VARCHAR2(30) := 'Extend_ATP';

Line 981: --Varibales to call mrp atp pub

977: l_api_version CONSTANT NUMBER := 1.0;
978: l_return_status VARCHAR2(1);
979: l_msg_data VARCHAR2(2000);
980: l_msg_count NUMBER;
981: --Varibales to call mrp atp pub
982: l_session_id NUMBER;
983: l_instance_id NUMBER;
984: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
985: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;

Line 984: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;

980: l_msg_count NUMBER;
981: --Varibales to call mrp atp pub
982: l_session_id NUMBER;
983: l_instance_id NUMBER;
984: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
985: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
986: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
987: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
988: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;

Line 985: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;

981: --Varibales to call mrp atp pub
982: l_session_id NUMBER;
983: l_instance_id NUMBER;
984: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
985: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
986: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
987: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
988: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
989: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;

Line 986: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;

982: l_session_id NUMBER;
983: l_instance_id NUMBER;
984: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
985: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
986: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
987: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
988: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
989: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
990: l_error_msg VARCHAR2(2000);

Line 987: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;

983: l_instance_id NUMBER;
984: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
985: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
986: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
987: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
988: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
989: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
990: l_error_msg VARCHAR2(2000);
991: l_error_message VARCHAR2(80);

Line 988: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;

984: l_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
985: x_atp_table Mrp_Atp_Pub.ATP_Rec_Typ;
986: x_atp_supply_demand Mrp_Atp_Pub.ATP_Supply_Demand_Typ;
987: x_atp_period Mrp_Atp_Pub.ATP_Period_Typ;
988: x_atp_details Mrp_Atp_Pub.ATP_Details_Typ;
989: l_temp_atp_table AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
990: l_error_msg VARCHAR2(2000);
991: l_error_message VARCHAR2(80);
992: l_planned_matrl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl := p_x_planned_matrl_tbl;

Line 1143: 'Before calling Mrp Atp Pub.Call_ATP. Calling Module count: '||

1139:
1140: IF (l_log_statement >= l_log_current_level) THEN
1141: fnd_log.string(l_log_statement,
1142: L_DEBUG_KEY,
1143: 'Before calling Mrp Atp Pub.Call_ATP. Calling Module count: '||
1144: l_atp_table.Calling_module.count);
1145: END IF;
1146:
1147: -- Call ATP to Schedule

Line 1148: MRP_ATP_PUB.CALL_ATP(l_session_id,

1144: l_atp_table.Calling_module.count);
1145: END IF;
1146:
1147: -- Call ATP to Schedule
1148: MRP_ATP_PUB.CALL_ATP(l_session_id,
1149: l_atp_table,
1150: x_atp_table,
1151: x_atp_supply_demand,
1152: x_atp_period,

Line 1161: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| x_return_status);

1157:
1158: IF (l_log_statement >= l_log_current_level) THEN
1159: fnd_log.string(l_log_statement,
1160: L_DEBUG_KEY,
1161: 'After calling Mrp Atp Pub.Call_ATP. Return Status : '|| x_return_status);
1162: END IF;
1163:
1164: -- Check Error Message stack.
1165: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN