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

Line 66: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

62: p_uom IN VARCHAR2,
63: p_need_by_date IN VARCHAR2
64: ) IS
65:
66: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
67: p_instance_id integer := -1;
68: p_session_id number := 1;
69: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
70: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 69: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

65:
66: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
67: p_instance_id integer := -1;
68: p_session_id number := 1;
69: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
70: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
71: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
72: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
73: x_return_status VARCHAR2(1);

Line 70: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

66: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
67: p_instance_id integer := -1;
68: p_session_id number := 1;
69: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
70: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
71: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
72: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
73: x_return_status VARCHAR2(1);
74: x_msg_data VARCHAR2(200);

Line 71: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;

67: p_instance_id integer := -1;
68: p_session_id number := 1;
69: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
70: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
71: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
72: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
73: x_return_status VARCHAR2(1);
74: x_msg_data VARCHAR2(200);
75: x_msg_count NUMBER;

Line 72: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

68: p_session_id number := 1;
69: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
70: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
71: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
72: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
73: x_return_status VARCHAR2(1);
74: x_msg_data VARCHAR2(200);
75: x_msg_count NUMBER;
76: i number ;

Line 80: p_atp_table.Inventory_Item_Id := MRP_ATP_PUB.number_arr(p_inventory_item_id);

76: i number ;
77:
78: BEGIN
79:
80: p_atp_table.Inventory_Item_Id := MRP_ATP_PUB.number_arr(p_inventory_item_id);
81: p_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(p_organization_id);
82: p_atp_table.Identifier := MRP_ATP_PUB.number_arr(11);
83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);
84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);

Line 81: p_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(p_organization_id);

77:
78: BEGIN
79:
80: p_atp_table.Inventory_Item_Id := MRP_ATP_PUB.number_arr(p_inventory_item_id);
81: p_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(p_organization_id);
82: p_atp_table.Identifier := MRP_ATP_PUB.number_arr(11);
83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);
84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);
85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);

Line 82: p_atp_table.Identifier := MRP_ATP_PUB.number_arr(11);

78: BEGIN
79:
80: p_atp_table.Inventory_Item_Id := MRP_ATP_PUB.number_arr(p_inventory_item_id);
81: p_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(p_organization_id);
82: p_atp_table.Identifier := MRP_ATP_PUB.number_arr(11);
83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);
84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);
85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);
86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);

Line 83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);

79:
80: p_atp_table.Inventory_Item_Id := MRP_ATP_PUB.number_arr(p_inventory_item_id);
81: p_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(p_organization_id);
82: p_atp_table.Identifier := MRP_ATP_PUB.number_arr(11);
83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);
84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);
85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);
86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);
87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);

Line 84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);

80: p_atp_table.Inventory_Item_Id := MRP_ATP_PUB.number_arr(p_inventory_item_id);
81: p_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(p_organization_id);
82: p_atp_table.Identifier := MRP_ATP_PUB.number_arr(11);
83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);
84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);
85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);
86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);
87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);
88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);

Line 85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);

81: p_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(p_organization_id);
82: p_atp_table.Identifier := MRP_ATP_PUB.number_arr(11);
83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);
84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);
85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);
86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);
87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);
88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);
89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);

Line 86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);

82: p_atp_table.Identifier := MRP_ATP_PUB.number_arr(11);
83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);
84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);
85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);
86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);
87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);
88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);
89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);
90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));

Line 87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);

83: p_atp_table.Calling_Module := MRP_ATP_PUB.number_arr(660);
84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);
85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);
86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);
87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);
88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);
89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);
90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));

Line 88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);

84: p_atp_table.Customer_Id := MRP_ATP_PUB.number_arr(p_customer_id);
85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);
86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);
87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);
88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);
89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);
90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);

Line 89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);

85: p_atp_table.Customer_Site_Id := MRP_ATP_PUB.number_arr(p_customer_site_id);
86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);
87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);
88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);
89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);
90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);
93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);

Line 90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));

86: p_atp_table.Destination_Time_Zone := MRP_ATP_PUB.char30_arr(null);
87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);
88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);
89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);
90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);
93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);
94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);

Line 91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));

87: p_atp_table.Quantity_Ordered := MRP_ATP_PUB.number_arr(p_input_quantity);
88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);
89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);
90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);
93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);
94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);
95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);

Line 92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);

88: p_atp_table.Quantity_UOM := MRP_ATP_PUB.char3_arr(p_uom);
89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);
90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);
93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);
94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);
95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);
96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);

Line 93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);

89: p_atp_table.Requested_Ship_Date := MRP_ATP_PUB.date_arr(null);
90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);
93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);
94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);
95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);
96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);
97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);

Line 94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);

90: p_atp_table.Requested_Arrival_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);
93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);
94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);
95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);
96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);
97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);
98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);

Line 95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);

91: p_atp_table.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr(to_date(p_need_by_date,'DD-MON-YYYY'));
92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);
93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);
94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);
95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);
96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);
97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);
98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);
99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);

Line 96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);

92: p_atp_table.Delivery_Lead_Time := MRP_ATP_PUB.number_arr(null);
93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);
94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);
95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);
96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);
97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);
98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);
99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);
100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);

Line 97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);

93: p_atp_table.Freight_Carrier := MRP_ATP_PUB.char30_arr(null);
94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);
95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);
96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);
97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);
98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);
99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);
100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);
101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);

Line 98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);

94: p_atp_table.Ship_Method := MRP_ATP_PUB.char30_arr(null);
95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);
96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);
97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);
98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);
99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);
100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);
101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);
102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);

Line 99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);

95: p_atp_table.Demand_Class := MRP_ATP_PUB.char30_arr(null);
96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);
97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);
98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);
99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);
100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);
101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);
102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);
103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);

Line 100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);

96: p_atp_table.Ship_Set_Name := MRP_ATP_PUB.char30_arr(null);
97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);
98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);
99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);
100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);
101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);
102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);
103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);
104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);

Line 101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);

97: p_atp_table.Arrival_Set_Name := MRP_ATP_PUB.char30_arr(null);
98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);
99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);
100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);
101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);
102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);
103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);
104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);
105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);

Line 102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);

98: p_atp_table.Override_Flag := MRP_ATP_PUB.char1_arr(null);
99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);
100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);
101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);
102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);
103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);
104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);
105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);
106: p_atp_table.Insert_Flag := MRP_ATP_PUB.number_arr(null);

Line 103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);

99: p_atp_table.Action := MRP_ATP_PUB.number_arr(100);
100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);
101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);
102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);
103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);
104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);
105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);
106: p_atp_table.Insert_Flag := MRP_ATP_PUB.number_arr(null);
107: p_atp_table.Error_Code := MRP_ATP_PUB.number_arr(null);

Line 104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);

100: p_atp_table.Ship_Date := MRP_ATP_PUB.date_arr(null);
101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);
102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);
103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);
104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);
105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);
106: p_atp_table.Insert_Flag := MRP_ATP_PUB.number_arr(null);
107: p_atp_table.Error_Code := MRP_ATP_PUB.number_arr(null);
108: p_atp_table.Message := MRP_ATP_PUB.char2000_arr(null);

Line 105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);

101: p_atp_table.Available_Quantity := MRP_ATP_PUB.number_arr(null);
102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);
103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);
104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);
105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);
106: p_atp_table.Insert_Flag := MRP_ATP_PUB.number_arr(null);
107: p_atp_table.Error_Code := MRP_ATP_PUB.number_arr(null);
108: p_atp_table.Message := MRP_ATP_PUB.char2000_arr(null);
109:

Line 106: p_atp_table.Insert_Flag := MRP_ATP_PUB.number_arr(null);

102: p_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(null);
103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);
104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);
105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);
106: p_atp_table.Insert_Flag := MRP_ATP_PUB.number_arr(null);
107: p_atp_table.Error_Code := MRP_ATP_PUB.number_arr(null);
108: p_atp_table.Message := MRP_ATP_PUB.char2000_arr(null);
109:
110: -- call atp module

Line 107: p_atp_table.Error_Code := MRP_ATP_PUB.number_arr(null);

103: p_atp_table.Group_Ship_Date := MRP_ATP_PUB.date_arr(null);
104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);
105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);
106: p_atp_table.Insert_Flag := MRP_ATP_PUB.number_arr(null);
107: p_atp_table.Error_Code := MRP_ATP_PUB.number_arr(null);
108: p_atp_table.Message := MRP_ATP_PUB.char2000_arr(null);
109:
110: -- call atp module
111: MRP_ATP_PUB.Call_ATP(

Line 108: p_atp_table.Message := MRP_ATP_PUB.char2000_arr(null);

104: p_atp_table.Vendor_Id := MRP_ATP_PUB.number_arr(null);
105: p_atp_table.Vendor_Site_Id := MRP_ATP_PUB.number_arr(null);
106: p_atp_table.Insert_Flag := MRP_ATP_PUB.number_arr(null);
107: p_atp_table.Error_Code := MRP_ATP_PUB.number_arr(null);
108: p_atp_table.Message := MRP_ATP_PUB.char2000_arr(null);
109:
110: -- call atp module
111: MRP_ATP_PUB.Call_ATP(
112: p_session_id,

Line 111: MRP_ATP_PUB.Call_ATP(

107: p_atp_table.Error_Code := MRP_ATP_PUB.number_arr(null);
108: p_atp_table.Message := MRP_ATP_PUB.char2000_arr(null);
109:
110: -- call atp module
111: MRP_ATP_PUB.Call_ATP(
112: p_session_id,
113: p_atp_table,
114: x_atp_table,
115: x_atp_supply_demand,