APPS.MRP_ATP_PVT dependencies on MRP_ATP_PUB

Line 7: Organization_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

3:
4: INFINITE_NUMBER CONSTANT NUMBER := 1.0e+10;
5:
6: TYPE Atp_Source_Typ is RECORD (
7: Organization_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: Instance_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
9: Supplier_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 8: Instance_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

4: INFINITE_NUMBER CONSTANT NUMBER := 1.0e+10;
5:
6: TYPE Atp_Source_Typ is RECORD (
7: Organization_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: Instance_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
9: Supplier_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 9: Supplier_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

5:
6: TYPE Atp_Source_Typ is RECORD (
7: Organization_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: Instance_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
9: Supplier_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

6: TYPE Atp_Source_Typ is RECORD (
7: Organization_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: Instance_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
9: Supplier_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),

Line 11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

7: Organization_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
8: Instance_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
9: Supplier_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
15: Preferred MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

8: Instance_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
9: Supplier_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
15: Preferred MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
16: make_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),

Line 13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

9: Supplier_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
15: Preferred MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
16: make_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
17: -- ship_rec_cal

Line 14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),

10: Supplier_Site_Id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
15: Preferred MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
16: make_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
17: -- ship_rec_cal
18: Sup_Cap_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()

Line 15: Preferred MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

11: Rank MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
15: Preferred MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
16: make_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
17: -- ship_rec_cal
18: Sup_Cap_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
19: );

Line 16: make_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),

12: Source_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
13: Lead_Time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
15: Preferred MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
16: make_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
17: -- ship_rec_cal
18: Sup_Cap_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
19: );
20:

Line 18: Sup_Cap_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()

14: Ship_Method MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr(),
15: Preferred MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
16: make_flag MRP_ATP_PUB.char1_arr := MRP_ATP_PUB.char1_arr(),
17: -- ship_rec_cal
18: Sup_Cap_Type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
19: );
20:
21: TYPE AtpRec is RECORD (
22: instance_id NUMBER,

Line 132: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

128:
129:
130:
131: TYPE Atp_Res_Typ is RECORD (
132: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: owning_department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 133: owning_department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

129:
130:
131: TYPE Atp_Res_Typ is RECORD (
132: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: owning_department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

Line 134: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

130:
131: TYPE Atp_Res_Typ is RECORD (
132: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: owning_department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

131: TYPE Atp_Res_Typ is RECORD (
132: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: owning_department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

132: department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
133: owning_department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

133: owning_department_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
134: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

134: resource_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

135: basis_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

136: resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),

Line 141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

137: requested_date MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),

Line 142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

138: lead_time MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

139: efficiency MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),

Line 144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),

140: utilization MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),
148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),

141: batch_flag MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),
148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

142: max_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),
148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),

143: required_unit_capacity MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),
148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: reverse_cumulative_yield MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

Line 148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

144: required_capacity_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),
148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: reverse_cumulative_yield MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: department_code MRP_ATP_PUB.char10_arr := MRP_ATP_PUB.char10_arr(),

Line 149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

145: res_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(),
146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),
148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: reverse_cumulative_yield MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: department_code MRP_ATP_PUB.char10_arr := MRP_ATP_PUB.char10_arr(),
153: resource_code MRP_ATP_PUB.char16_arr := MRP_ATP_PUB.char16_arr()--4774169

Line 150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

146: res_uom_type MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),
148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: reverse_cumulative_yield MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: department_code MRP_ATP_PUB.char10_arr := MRP_ATP_PUB.char10_arr(),
153: resource_code MRP_ATP_PUB.char16_arr := MRP_ATP_PUB.char16_arr()--4774169
154:

Line 151: reverse_cumulative_yield MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

147: std_op_code MRP_ATP_PUB.char7_arr := MRP_ATP_PUB.char7_arr(),
148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: reverse_cumulative_yield MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: department_code MRP_ATP_PUB.char10_arr := MRP_ATP_PUB.char10_arr(),
153: resource_code MRP_ATP_PUB.char16_arr := MRP_ATP_PUB.char16_arr()--4774169
154:
155:

Line 152: department_code MRP_ATP_PUB.char10_arr := MRP_ATP_PUB.char10_arr(),

148: resource_offset_percent MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: reverse_cumulative_yield MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: department_code MRP_ATP_PUB.char10_arr := MRP_ATP_PUB.char10_arr(),
153: resource_code MRP_ATP_PUB.char16_arr := MRP_ATP_PUB.char16_arr()--4774169
154:
155:
156: );

Line 153: resource_code MRP_ATP_PUB.char16_arr := MRP_ATP_PUB.char16_arr()--4774169

149: operation_sequence MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
150: actual_resource_usage MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
151: reverse_cumulative_yield MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
152: department_code MRP_ATP_PUB.char10_arr := MRP_ATP_PUB.char10_arr(),
153: resource_code MRP_ATP_PUB.char16_arr := MRP_ATP_PUB.char16_arr()--4774169
154:
155:
156: );
157:

Line 159: inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

155:
156: );
157:
158: TYPE Atp_Comp_Typ is RECORD (
159: inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
160: comp_usage MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
161: requested_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 160: comp_usage MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

156: );
157:
158: TYPE Atp_Comp_Typ is RECORD (
159: inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
160: comp_usage MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
161: requested_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 161: requested_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),

157:
158: TYPE Atp_Comp_Typ is RECORD (
159: inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
160: comp_usage MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
161: requested_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
165: component_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

158: TYPE Atp_Comp_Typ is RECORD (
159: inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
160: comp_usage MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
161: requested_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
165: component_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
166: pre_process_lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

159: inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
160: comp_usage MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
161: requested_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
165: component_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
166: pre_process_lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
167: --diag_atp

Line 164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

160: comp_usage MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
161: requested_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
165: component_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
166: pre_process_lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
167: --diag_atp
168: reverse_cumulative_yield MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 165: component_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

161: requested_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
165: component_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
166: pre_process_lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
167: --diag_atp
168: reverse_cumulative_yield MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
169: -- 2462661 -- atp flag value from MSC_BOM_TEMP passsed by CTO

Line 166: pre_process_lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

162: lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
163: wip_supply_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
165: component_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
166: pre_process_lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
167: --diag_atp
168: reverse_cumulative_yield MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
169: -- 2462661 -- atp flag value from MSC_BOM_TEMP passsed by CTO
170: src_atp_flag MRP_ATP_PUB.char1_arr:=MRP_ATP_PUB.char1_arr(),

Line 168: reverse_cumulative_yield MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

164: assembly_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
165: component_identifier MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
166: pre_process_lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
167: --diag_atp
168: reverse_cumulative_yield MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
169: -- 2462661 -- atp flag value from MSC_BOM_TEMP passsed by CTO
170: src_atp_flag MRP_ATP_PUB.char1_arr:=MRP_ATP_PUB.char1_arr(),
171: --s_cto_rearch
172: match_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 170: src_atp_flag MRP_ATP_PUB.char1_arr:=MRP_ATP_PUB.char1_arr(),

166: pre_process_lead_time MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
167: --diag_atp
168: reverse_cumulative_yield MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
169: -- 2462661 -- atp flag value from MSC_BOM_TEMP passsed by CTO
170: src_atp_flag MRP_ATP_PUB.char1_arr:=MRP_ATP_PUB.char1_arr(),
171: --s_cto_rearch
172: match_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
173: bom_item_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 172: match_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

168: reverse_cumulative_yield MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
169: -- 2462661 -- atp flag value from MSC_BOM_TEMP passsed by CTO
170: src_atp_flag MRP_ATP_PUB.char1_arr:=MRP_ATP_PUB.char1_arr(),
171: --s_cto_rearch
172: match_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
173: bom_item_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 173: bom_item_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

169: -- 2462661 -- atp flag value from MSC_BOM_TEMP passsed by CTO
170: src_atp_flag MRP_ATP_PUB.char1_arr:=MRP_ATP_PUB.char1_arr(),
171: --s_cto_rearch
172: match_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
173: bom_item_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

170: src_atp_flag MRP_ATP_PUB.char1_arr:=MRP_ATP_PUB.char1_arr(),
171: --s_cto_rearch
172: match_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
173: bom_item_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

171: --s_cto_rearch
172: match_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
173: bom_item_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

172: match_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
173: bom_item_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

173: bom_item_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

174: parent_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

175: top_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),

Line 180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

176: ato_parent_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),

Line 181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

177: ato_model_line_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
185: -- time_phased_atp

Line 182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

178: MAND_COMP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
185: -- time_phased_atp
186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),

179: parent_so_quantity MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
185: -- time_phased_atp
186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),

Line 184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),

180: fixed_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
181: variable_lt MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
185: -- time_phased_atp
186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
188: match_item_family_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

182: oss_error_code MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
185: -- time_phased_atp
186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
188: match_item_family_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
189: dest_inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),

183: atp_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
185: -- time_phased_atp
186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
188: match_item_family_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
189: dest_inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023

Line 188: match_item_family_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

184: atp_components_flag MRP_ATP_PUB.char1_arr:= MRP_ATP_PUB.char1_arr(),
185: -- time_phased_atp
186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
188: match_item_family_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
189: dest_inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023
192: --4570421

Line 189: dest_inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

185: -- time_phased_atp
186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
188: match_item_family_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
189: dest_inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023
192: --4570421
193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

186: request_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
188: match_item_family_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
189: dest_inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023
192: --4570421
193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023

187: atf_date MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr(),
188: match_item_family_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
189: dest_inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023
192: --4570421
193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

Line 193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

189: dest_inventory_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023
192: --4570421
193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
196: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
197: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421

Line 194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

190: parent_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023
192: --4570421
193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
196: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
197: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
198: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920

Line 195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

191: comp_uom MRP_ATP_PUB.char3_arr := MRP_ATP_PUB.char3_arr(), --bug3110023
192: --4570421
193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
196: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
197: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
198: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
199: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920

Line 196: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),

192: --4570421
193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
196: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
197: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
198: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
199: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
200: );

Line 197: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421

193: scaling_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
196: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
197: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
198: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
199: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
200: );
201:

Line 198: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920

194: scale_multiple MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
196: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
197: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
198: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
199: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
200: );
201:
202: TYPE ATP_COMP_REC IS RECORD

Line 199: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920

195: scale_rounding_variance MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
196: rounding_direction MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(),
197: component_yield_factor MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4570421
198: usage_qty MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr(), --4775920
199: organization_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr() --4775920
200: );
201:
202: TYPE ATP_COMP_REC IS RECORD
203: (

Line 251: atp_period MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),

247:
248: TYPE SourceCurTyp IS REF CURSOR;
249:
250: TYPE Atp_Info is RECORD (
251: atp_period MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
252: atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
253: limit_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
254: );
255:

Line 252: atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),

248: TYPE SourceCurTyp IS REF CURSOR;
249:
250: TYPE Atp_Info is RECORD (
251: atp_period MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
252: atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
253: limit_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
254: );
255:
256:

Line 253: limit_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()

249:
250: TYPE Atp_Info is RECORD (
251: atp_period MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr(),
252: atp_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(),
253: limit_qty MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr()
254: );
255:
256:
257: PROCEDURE Extend_Atp (

Line 258: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

254: );
255:
256:
257: PROCEDURE Extend_Atp (
258: p_atp_tab IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
259: x_return_status OUT NoCopy VARCHAR2
260: );
261:
262:

Line 264: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

260: );
261:
262:
263: PROCEDURE Assign_Atp_Input_Rec (
264: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
265: p_index IN NUMBER,
266: x_atp_table IN OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
267: x_return_status OUT NoCopy VARCHAR2
268: );

Line 266: x_atp_table IN OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

262:
263: PROCEDURE Assign_Atp_Input_Rec (
264: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
265: p_index IN NUMBER,
266: x_atp_table IN OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
267: x_return_status OUT NoCopy VARCHAR2
268: );
269:
270: PROCEDURE Assign_Atp_Output_Rec (

Line 271: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

267: x_return_status OUT NoCopy VARCHAR2
268: );
269:
270: PROCEDURE Assign_Atp_Output_Rec (
271: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
272: x_atp_table IN OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
273: x_return_status OUT NoCopy VARCHAR2
274: );
275:

Line 272: x_atp_table IN OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

268: );
269:
270: PROCEDURE Assign_Atp_Output_Rec (
271: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
272: x_atp_table IN OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
273: x_return_status OUT NoCopy VARCHAR2
274: );
275:
276: