21: error_record rcv_shipment_object_sv.errorrectype);
22:
23: TYPE item_id_record_type IS RECORD
24: (item_id mtl_system_items_kfv.inventory_item_id%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
22:
23: TYPE item_id_record_type IS RECORD
24: (item_id mtl_system_items_kfv.inventory_item_id%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
23: TYPE item_id_record_type IS RECORD
24: (item_id mtl_system_items_kfv.inventory_item_id%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
24: (item_id mtl_system_items_kfv.inventory_item_id%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
33: item_num varchar2(2000),
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
33: item_num varchar2(2000),
34: vendor_item_num varchar2(2000),
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
33: item_num varchar2(2000),
34: vendor_item_num varchar2(2000),
35: error_record rcv_shipment_object_sv.ErrorRecType);
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
33: item_num varchar2(2000),
34: vendor_item_num varchar2(2000),
35: error_record rcv_shipment_object_sv.ErrorRecType);
36:
43: (release_num po_releases.release_num%type,
44: po_release_id po_releases.po_release_id%type,
45: po_line_id po_lines.po_line_id%type,
46: shipment_num po_line_locations.shipment_num%type,
47: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
48: po_header_id rcv_transactions_interface.po_header_id%type,
49: error_record rcv_shipment_object_sv.ErrorRecType);
50:
51: TYPE po_line_id_record_type IS RECORD
44: po_release_id po_releases.po_release_id%type,
45: po_line_id po_lines.po_line_id%type,
46: shipment_num po_line_locations.shipment_num%type,
47: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
48: po_header_id rcv_transactions_interface.po_header_id%type,
49: error_record rcv_shipment_object_sv.ErrorRecType);
50:
51: TYPE po_line_id_record_type IS RECORD
52: (document_line_num po_lines.line_num%type,
56: item_id mtl_system_items_kfv.inventory_item_id%type,
57: error_record rcv_shipment_object_sv.ErrorRecType);
58:
59: TYPE po_line_location_id_rtype IS RECORD
60: (po_header_id rcv_transactions_interface.po_header_id%type,
61: po_line_id rcv_transactions_interface.po_line_id%type,
62: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
63: item_id mtl_system_items_kfv.inventory_item_id%type,
64: error_record rcv_shipment_object_sv.ErrorRecType);
57: error_record rcv_shipment_object_sv.ErrorRecType);
58:
59: TYPE po_line_location_id_rtype IS RECORD
60: (po_header_id rcv_transactions_interface.po_header_id%type,
61: po_line_id rcv_transactions_interface.po_line_id%type,
62: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
63: item_id mtl_system_items_kfv.inventory_item_id%type,
64: error_record rcv_shipment_object_sv.ErrorRecType);
65:
58:
59: TYPE po_line_location_id_rtype IS RECORD
60: (po_header_id rcv_transactions_interface.po_header_id%type,
61: po_line_id rcv_transactions_interface.po_line_id%type,
62: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
63: item_id mtl_system_items_kfv.inventory_item_id%type,
64: error_record rcv_shipment_object_sv.ErrorRecType);
65:
66: TYPE intransit_owning_org_rtype IS RECORD
63: item_id mtl_system_items_kfv.inventory_item_id%type,
64: error_record rcv_shipment_object_sv.ErrorRecType);
65:
66: TYPE intransit_owning_org_rtype IS RECORD
67: (intransit_owning_org_id rcv_transactions_interface.intransit_owning_org_id%type,
68: intransit_owning_org_code rcv_transactions_interface.intransit_owning_org_code%type,
69: error_record rcv_shipment_object_sv.ErrorRecType);
70:
71: TYPE sub_item_id_record_type IS RECORD
64: error_record rcv_shipment_object_sv.ErrorRecType);
65:
66: TYPE intransit_owning_org_rtype IS RECORD
67: (intransit_owning_org_id rcv_transactions_interface.intransit_owning_org_id%type,
68: intransit_owning_org_code rcv_transactions_interface.intransit_owning_org_code%type,
69: error_record rcv_shipment_object_sv.ErrorRecType);
70:
71: TYPE sub_item_id_record_type IS RECORD
72: (substitute_item_num varchar2(2000),
71: TYPE sub_item_id_record_type IS RECORD
72: (substitute_item_num varchar2(2000),
73: substitute_item_id mtl_system_items_kfv.inventory_item_id%type,
74: related_item_id mtl_related_items.related_item_id%type,
75: po_line_id rcv_transactions_interface.po_line_id%type,
76: to_organization_id rcv_transactions_interface.to_organization_id%type,
77: vendor_id rcv_transactions_interface.vendor_id%type,
78: vendor_item_num varchar2(2000),
79: error_record rcv_shipment_object_sv.ErrorRecType);
72: (substitute_item_num varchar2(2000),
73: substitute_item_id mtl_system_items_kfv.inventory_item_id%type,
74: related_item_id mtl_related_items.related_item_id%type,
75: po_line_id rcv_transactions_interface.po_line_id%type,
76: to_organization_id rcv_transactions_interface.to_organization_id%type,
77: vendor_id rcv_transactions_interface.vendor_id%type,
78: vendor_item_num varchar2(2000),
79: error_record rcv_shipment_object_sv.ErrorRecType);
80:
73: substitute_item_id mtl_system_items_kfv.inventory_item_id%type,
74: related_item_id mtl_related_items.related_item_id%type,
75: po_line_id rcv_transactions_interface.po_line_id%type,
76: to_organization_id rcv_transactions_interface.to_organization_id%type,
77: vendor_id rcv_transactions_interface.vendor_id%type,
78: vendor_item_num varchar2(2000),
79: error_record rcv_shipment_object_sv.ErrorRecType);
80:
81: TYPE po_lookup_code_record_type IS RECORD
84: lookup_type po_lookup_codes.lookup_type%Type,
85: error_record rcv_shipment_object_sv.ErrorRecType);
86:
87: TYPE category_id_record_type IS RECORD
88: (item_category rcv_transactions_interface.item_category%type,
89: category_id rcv_transactions_interface.category_id%type,
90: error_record rcv_shipment_object_sv.ErrorRecType);
91:
92: TYPE routing_header_id_rec_type IS RECORD
85: error_record rcv_shipment_object_sv.ErrorRecType);
86:
87: TYPE category_id_record_type IS RECORD
88: (item_category rcv_transactions_interface.item_category%type,
89: category_id rcv_transactions_interface.category_id%type,
90: error_record rcv_shipment_object_sv.ErrorRecType);
91:
92: TYPE routing_header_id_rec_type IS RECORD
93: (routing_code rcv_transactions_interface.routing_code%type,
89: category_id rcv_transactions_interface.category_id%type,
90: error_record rcv_shipment_object_sv.ErrorRecType);
91:
92: TYPE routing_header_id_rec_type IS RECORD
93: (routing_code rcv_transactions_interface.routing_code%type,
94: routing_header_id rcv_transactions_interface.routing_header_id%type,
95: error_record rcv_shipment_object_sv.ErrorRecType);
96:
97: TYPE routing_step_id_rec_type IS RECORD
90: error_record rcv_shipment_object_sv.ErrorRecType);
91:
92: TYPE routing_header_id_rec_type IS RECORD
93: (routing_code rcv_transactions_interface.routing_code%type,
94: routing_header_id rcv_transactions_interface.routing_header_id%type,
95: error_record rcv_shipment_object_sv.ErrorRecType);
96:
97: TYPE routing_step_id_rec_type IS RECORD
98: (routing_step rcv_transactions_interface.routing_step%type,
94: routing_header_id rcv_transactions_interface.routing_header_id%type,
95: error_record rcv_shipment_object_sv.ErrorRecType);
96:
97: TYPE routing_step_id_rec_type IS RECORD
98: (routing_step rcv_transactions_interface.routing_step%type,
99: routing_step_id rcv_transactions_interface.routing_step_id%type,
100: error_record rcv_shipment_object_sv.ErrorRecType);
101:
102: TYPE deliver_to_person_id_rtype IS RECORD
95: error_record rcv_shipment_object_sv.ErrorRecType);
96:
97: TYPE routing_step_id_rec_type IS RECORD
98: (routing_step rcv_transactions_interface.routing_step%type,
99: routing_step_id rcv_transactions_interface.routing_step_id%type,
100: error_record rcv_shipment_object_sv.ErrorRecType);
101:
102: TYPE deliver_to_person_id_rtype IS RECORD
103: (deliver_to_person_name rcv_transactions_interface.deliver_to_person_name%type,
99: routing_step_id rcv_transactions_interface.routing_step_id%type,
100: error_record rcv_shipment_object_sv.ErrorRecType);
101:
102: TYPE deliver_to_person_id_rtype IS RECORD
103: (deliver_to_person_name rcv_transactions_interface.deliver_to_person_name%type,
104: deliver_to_person_id rcv_transactions_interface.deliver_to_person_id%type,
105: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD
100: error_record rcv_shipment_object_sv.ErrorRecType);
101:
102: TYPE deliver_to_person_id_rtype IS RECORD
103: (deliver_to_person_name rcv_transactions_interface.deliver_to_person_name%type,
104: deliver_to_person_id rcv_transactions_interface.deliver_to_person_id%type,
105: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
104: deliver_to_person_id rcv_transactions_interface.deliver_to_person_id%type,
105: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
105: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
115: TYPE location_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,
114:
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);
123:
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);
123:
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);
123:
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);
123:
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
123:
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
132: transaction_date rcv_transactions_interface.transaction_date%type,
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
132: transaction_date rcv_transactions_interface.transaction_date%type,
133: error_record rcv_shipment_object_sv.ErrorRecType);
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
132: transaction_date rcv_transactions_interface.transaction_date%type,
133: error_record rcv_shipment_object_sv.ErrorRecType);
134:
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
132: transaction_date rcv_transactions_interface.transaction_date%type,
133: error_record rcv_shipment_object_sv.ErrorRecType);
134:
135: /*
136: ** Bug 724495
139: */
140:
141:
142: TYPE locator_record_type IS RECORD
143: (locator rcv_transactions_interface.locator%type,
144: locator_id rcv_transactions_interface.locator_id%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
140:
141:
142: TYPE locator_record_type IS RECORD
143: (locator rcv_transactions_interface.locator%type,
144: locator_id rcv_transactions_interface.locator_id%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
141:
142: TYPE locator_record_type IS RECORD
143: (locator rcv_transactions_interface.locator%type,
144: locator_id rcv_transactions_interface.locator_id%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
144: locator_id rcv_transactions_interface.locator_id%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: po_distribution_id rcv_transactions_interface.po_distribution_id%type,--Bug13844195
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: po_distribution_id rcv_transactions_interface.po_distribution_id%type,--Bug13844195
156: receipt_source_code rcv_transactions_interface.receipt_source_code%type,--Bug13844195
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: po_distribution_id rcv_transactions_interface.po_distribution_id%type,--Bug13844195
156: receipt_source_code rcv_transactions_interface.receipt_source_code%type,--Bug13844195
157: project_id rcv_transactions_interface.project_id%type,--Bug13844195
158: task_id rcv_transactions_interface.task_id%type,--Bug13844195
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: po_distribution_id rcv_transactions_interface.po_distribution_id%type,--Bug13844195
156: receipt_source_code rcv_transactions_interface.receipt_source_code%type,--Bug13844195
157: project_id rcv_transactions_interface.project_id%type,--Bug13844195
158: task_id rcv_transactions_interface.task_id%type,--Bug13844195
159: error_record rcv_shipment_object_sv.ErrorRecType);
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: po_distribution_id rcv_transactions_interface.po_distribution_id%type,--Bug13844195
156: receipt_source_code rcv_transactions_interface.receipt_source_code%type,--Bug13844195
157: project_id rcv_transactions_interface.project_id%type,--Bug13844195
158: task_id rcv_transactions_interface.task_id%type,--Bug13844195
159: error_record rcv_shipment_object_sv.ErrorRecType);
160:
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: po_distribution_id rcv_transactions_interface.po_distribution_id%type,--Bug13844195
156: receipt_source_code rcv_transactions_interface.receipt_source_code%type,--Bug13844195
157: project_id rcv_transactions_interface.project_id%type,--Bug13844195
158: task_id rcv_transactions_interface.task_id%type,--Bug13844195
159: error_record rcv_shipment_object_sv.ErrorRecType);
160:
161: TYPE locator_id_record_type IS RECORD
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: po_distribution_id rcv_transactions_interface.po_distribution_id%type,--Bug13844195
156: receipt_source_code rcv_transactions_interface.receipt_source_code%type,--Bug13844195
157: project_id rcv_transactions_interface.project_id%type,--Bug13844195
158: task_id rcv_transactions_interface.task_id%type,--Bug13844195
159: error_record rcv_shipment_object_sv.ErrorRecType);
160:
161: TYPE locator_id_record_type IS RECORD
162: (locator rcv_transactions_interface.locator%type,
158: task_id rcv_transactions_interface.task_id%type,--Bug13844195
159: error_record rcv_shipment_object_sv.ErrorRecType);
160:
161: TYPE locator_id_record_type IS RECORD
162: (locator rcv_transactions_interface.locator%type,
163: locator_id rcv_transactions_interface.locator_id%type,
164: subinventory rcv_transactions_interface.subinventory%type,
165: to_organization_id rcv_transactions_interface.to_organization_id%type,
166: error_record rcv_shipment_object_sv.ErrorRecType);
159: error_record rcv_shipment_object_sv.ErrorRecType);
160:
161: TYPE locator_id_record_type IS RECORD
162: (locator rcv_transactions_interface.locator%type,
163: locator_id rcv_transactions_interface.locator_id%type,
164: subinventory rcv_transactions_interface.subinventory%type,
165: to_organization_id rcv_transactions_interface.to_organization_id%type,
166: error_record rcv_shipment_object_sv.ErrorRecType);
167:
160:
161: TYPE locator_id_record_type IS RECORD
162: (locator rcv_transactions_interface.locator%type,
163: locator_id rcv_transactions_interface.locator_id%type,
164: subinventory rcv_transactions_interface.subinventory%type,
165: to_organization_id rcv_transactions_interface.to_organization_id%type,
166: error_record rcv_shipment_object_sv.ErrorRecType);
167:
168: TYPE location_id_record_type IS RECORD
161: TYPE locator_id_record_type IS RECORD
162: (locator rcv_transactions_interface.locator%type,
163: locator_id rcv_transactions_interface.locator_id%type,
164: subinventory rcv_transactions_interface.subinventory%type,
165: to_organization_id rcv_transactions_interface.to_organization_id%type,
166: error_record rcv_shipment_object_sv.ErrorRecType);
167:
168: TYPE location_id_record_type IS RECORD
169: (location_code rcv_transactions_interface.location_code%type,
165: to_organization_id rcv_transactions_interface.to_organization_id%type,
166: error_record rcv_shipment_object_sv.ErrorRecType);
167:
168: TYPE location_id_record_type IS RECORD
169: (location_code rcv_transactions_interface.location_code%type,
170: location_id rcv_transactions_interface.location_id%type,
171: error_record rcv_shipment_object_sv.ErrorRecType);
172:
173: TYPE reason_id_record_type IS RECORD
166: error_record rcv_shipment_object_sv.ErrorRecType);
167:
168: TYPE location_id_record_type IS RECORD
169: (location_code rcv_transactions_interface.location_code%type,
170: location_id rcv_transactions_interface.location_id%type,
171: error_record rcv_shipment_object_sv.ErrorRecType);
172:
173: TYPE reason_id_record_type IS RECORD
174: (reason_name rcv_transactions_interface.reason_name%type,
170: location_id rcv_transactions_interface.location_id%type,
171: error_record rcv_shipment_object_sv.ErrorRecType);
172:
173: TYPE reason_id_record_type IS RECORD
174: (reason_name rcv_transactions_interface.reason_name%type,
175: reason_id rcv_transactions_interface.reason_id%type,
176: error_record rcv_shipment_object_sv.ErrorRecType);
177:
178: TYPE quantity_shipped_record_type IS RECORD
171: error_record rcv_shipment_object_sv.ErrorRecType);
172:
173: TYPE reason_id_record_type IS RECORD
174: (reason_name rcv_transactions_interface.reason_name%type,
175: reason_id rcv_transactions_interface.reason_id%type,
176: error_record rcv_shipment_object_sv.ErrorRecType);
177:
178: TYPE quantity_shipped_record_type IS RECORD
179: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
175: reason_id rcv_transactions_interface.reason_id%type,
176: error_record rcv_shipment_object_sv.ErrorRecType);
177:
178: TYPE quantity_shipped_record_type IS RECORD
179: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
180: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
181: item_id rcv_transactions_interface.item_id%type,
182: po_line_id rcv_transactions_interface.po_line_id%type,
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
176: error_record rcv_shipment_object_sv.ErrorRecType);
177:
178: TYPE quantity_shipped_record_type IS RECORD
179: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
180: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
181: item_id rcv_transactions_interface.item_id%type,
182: po_line_id rcv_transactions_interface.po_line_id%type,
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
177:
178: TYPE quantity_shipped_record_type IS RECORD
179: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
180: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
181: item_id rcv_transactions_interface.item_id%type,
182: po_line_id rcv_transactions_interface.po_line_id%type,
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
185: po_header_id rcv_transactions_interface.po_header_id%type,
178: TYPE quantity_shipped_record_type IS RECORD
179: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
180: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
181: item_id rcv_transactions_interface.item_id%type,
182: po_line_id rcv_transactions_interface.po_line_id%type,
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
185: po_header_id rcv_transactions_interface.po_header_id%type,
186: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
179: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
180: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
181: item_id rcv_transactions_interface.item_id%type,
182: po_line_id rcv_transactions_interface.po_line_id%type,
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
185: po_header_id rcv_transactions_interface.po_header_id%type,
186: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
187: primary_quantity rcv_transactions_interface.primary_quantity%type,
180: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
181: item_id rcv_transactions_interface.item_id%type,
182: po_line_id rcv_transactions_interface.po_line_id%type,
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
185: po_header_id rcv_transactions_interface.po_header_id%type,
186: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
187: primary_quantity rcv_transactions_interface.primary_quantity%type,
188: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
181: item_id rcv_transactions_interface.item_id%type,
182: po_line_id rcv_transactions_interface.po_line_id%type,
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
185: po_header_id rcv_transactions_interface.po_header_id%type,
186: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
187: primary_quantity rcv_transactions_interface.primary_quantity%type,
188: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
189: error_record rcv_shipment_object_sv.ErrorRecType);
182: po_line_id rcv_transactions_interface.po_line_id%type,
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
185: po_header_id rcv_transactions_interface.po_header_id%type,
186: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
187: primary_quantity rcv_transactions_interface.primary_quantity%type,
188: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
189: error_record rcv_shipment_object_sv.ErrorRecType);
190:
183: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
185: po_header_id rcv_transactions_interface.po_header_id%type,
186: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
187: primary_quantity rcv_transactions_interface.primary_quantity%type,
188: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
189: error_record rcv_shipment_object_sv.ErrorRecType);
190:
191: TYPE expected_receipt_record_type IS RECORD
184: to_organization_id rcv_transactions_interface.to_organization_id%type,
185: po_header_id rcv_transactions_interface.po_header_id%type,
186: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
187: primary_quantity rcv_transactions_interface.primary_quantity%type,
188: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
189: error_record rcv_shipment_object_sv.ErrorRecType);
190:
191: TYPE expected_receipt_record_type IS RECORD
192: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,
188: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
189: error_record rcv_shipment_object_sv.ErrorRecType);
190:
191: TYPE expected_receipt_record_type IS RECORD
192: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,
193: line_location_id rcv_transactions_interface.po_line_location_id%type,
194: error_record rcv_shipment_object_sv.ErrorRecType);
195:
196: TYPE quantity_invoiced_record_type IS RECORD
189: error_record rcv_shipment_object_sv.ErrorRecType);
190:
191: TYPE expected_receipt_record_type IS RECORD
192: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,
193: line_location_id rcv_transactions_interface.po_line_location_id%type,
194: error_record rcv_shipment_object_sv.ErrorRecType);
195:
196: TYPE quantity_invoiced_record_type IS RECORD
197: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,
193: line_location_id rcv_transactions_interface.po_line_location_id%type,
194: error_record rcv_shipment_object_sv.ErrorRecType);
195:
196: TYPE quantity_invoiced_record_type IS RECORD
197: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,
198: error_record rcv_shipment_object_sv.ErrorRecType);
199:
200: TYPE ref_integrity_record_type IS RECORD
201: (to_organization_id rcv_transactions_interface.to_organization_id%type,
197: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,
198: error_record rcv_shipment_object_sv.ErrorRecType);
199:
200: TYPE ref_integrity_record_type IS RECORD
201: (to_organization_id rcv_transactions_interface.to_organization_id%type,
202: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
203: po_header_id rcv_transactions_interface.po_header_id%type,
204: po_line_id rcv_transactions_interface.po_line_id%type,
205: vendor_id rcv_transactions_interface.vendor_id%type,
198: error_record rcv_shipment_object_sv.ErrorRecType);
199:
200: TYPE ref_integrity_record_type IS RECORD
201: (to_organization_id rcv_transactions_interface.to_organization_id%type,
202: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
203: po_header_id rcv_transactions_interface.po_header_id%type,
204: po_line_id rcv_transactions_interface.po_line_id%type,
205: vendor_id rcv_transactions_interface.vendor_id%type,
206: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
199:
200: TYPE ref_integrity_record_type IS RECORD
201: (to_organization_id rcv_transactions_interface.to_organization_id%type,
202: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
203: po_header_id rcv_transactions_interface.po_header_id%type,
204: po_line_id rcv_transactions_interface.po_line_id%type,
205: vendor_id rcv_transactions_interface.vendor_id%type,
206: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
207: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
200: TYPE ref_integrity_record_type IS RECORD
201: (to_organization_id rcv_transactions_interface.to_organization_id%type,
202: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
203: po_header_id rcv_transactions_interface.po_header_id%type,
204: po_line_id rcv_transactions_interface.po_line_id%type,
205: vendor_id rcv_transactions_interface.vendor_id%type,
206: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
207: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
208: po_revision_num rcv_transactions_interface.po_revision_num%type,
201: (to_organization_id rcv_transactions_interface.to_organization_id%type,
202: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
203: po_header_id rcv_transactions_interface.po_header_id%type,
204: po_line_id rcv_transactions_interface.po_line_id%type,
205: vendor_id rcv_transactions_interface.vendor_id%type,
206: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
207: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
208: po_revision_num rcv_transactions_interface.po_revision_num%type,
209: item_id mtl_system_items_kfv.inventory_item_id%type,
202: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
203: po_header_id rcv_transactions_interface.po_header_id%type,
204: po_line_id rcv_transactions_interface.po_line_id%type,
205: vendor_id rcv_transactions_interface.vendor_id%type,
206: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
207: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
208: po_revision_num rcv_transactions_interface.po_revision_num%type,
209: item_id mtl_system_items_kfv.inventory_item_id%type,
210: error_record rcv_shipment_object_sv.ErrorRecType,
203: po_header_id rcv_transactions_interface.po_header_id%type,
204: po_line_id rcv_transactions_interface.po_line_id%type,
205: vendor_id rcv_transactions_interface.vendor_id%type,
206: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
207: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
208: po_revision_num rcv_transactions_interface.po_revision_num%type,
209: item_id mtl_system_items_kfv.inventory_item_id%type,
210: error_record rcv_shipment_object_sv.ErrorRecType,
211: parent_txn_id rcv_transactions_interface.parent_transaction_id%TYPE);
204: po_line_id rcv_transactions_interface.po_line_id%type,
205: vendor_id rcv_transactions_interface.vendor_id%type,
206: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
207: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
208: po_revision_num rcv_transactions_interface.po_revision_num%type,
209: item_id mtl_system_items_kfv.inventory_item_id%type,
210: error_record rcv_shipment_object_sv.ErrorRecType,
211: parent_txn_id rcv_transactions_interface.parent_transaction_id%TYPE);
212: /*
207: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
208: po_revision_num rcv_transactions_interface.po_revision_num%type,
209: item_id mtl_system_items_kfv.inventory_item_id%type,
210: error_record rcv_shipment_object_sv.ErrorRecType,
211: parent_txn_id rcv_transactions_interface.parent_transaction_id%TYPE);
212: /*
213: Added the 'parent_txn_id' column to above rec so as to handle bug 6447564 issue.
214: */
215:
213: Added the 'parent_txn_id' column to above rec so as to handle bug 6447564 issue.
214: */
215:
216: TYPE freight_carrier_record_type IS RECORD
217: (to_organization_id rcv_transactions_interface.to_organization_id%type,
218: freight_carrier_code rcv_transactions_interface.freight_carrier_code%type,
219: po_header_id po_headers.po_header_id%type,
220: error_record rcv_shipment_object_sv.ErrorRecType);
221:
214: */
215:
216: TYPE freight_carrier_record_type IS RECORD
217: (to_organization_id rcv_transactions_interface.to_organization_id%type,
218: freight_carrier_code rcv_transactions_interface.freight_carrier_code%type,
219: po_header_id po_headers.po_header_id%type,
220: error_record rcv_shipment_object_sv.ErrorRecType);
221:
222: TYPE tax_name_record_type IS RECORD
219: po_header_id po_headers.po_header_id%type,
220: error_record rcv_shipment_object_sv.ErrorRecType);
221:
222: TYPE tax_name_record_type IS RECORD
223: (tax_name rcv_transactions_interface.tax_name%type,
224: error_record rcv_shipment_object_sv.ErrorRecType);
225:
226: --FRKHAN 12/18/98 add new record type for country of origin
227: TYPE country_of_origin_record_type IS RECORD
224: error_record rcv_shipment_object_sv.ErrorRecType);
225:
226: --FRKHAN 12/18/98 add new record type for country of origin
227: TYPE country_of_origin_record_type IS RECORD
228: (country_of_origin_code rcv_transactions_interface.country_of_origin_code%type,
229: error_record rcv_shipment_object_sv.ErrorRecType);
230:
231: TYPE cum_quantity_record_type IS RECORD
232: (to_organization_id rcv_transactions_interface.to_organization_id%type,
228: (country_of_origin_code rcv_transactions_interface.country_of_origin_code%type,
229: error_record rcv_shipment_object_sv.ErrorRecType);
230:
231: TYPE cum_quantity_record_type IS RECORD
232: (to_organization_id rcv_transactions_interface.to_organization_id%type,
233: po_header_id rcv_transactions_interface.po_header_id%type,
234: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
235: transaction_date rcv_transactions_interface.transaction_date%type,
236: vendor_id rcv_transactions_interface.vendor_id%type,
229: error_record rcv_shipment_object_sv.ErrorRecType);
230:
231: TYPE cum_quantity_record_type IS RECORD
232: (to_organization_id rcv_transactions_interface.to_organization_id%type,
233: po_header_id rcv_transactions_interface.po_header_id%type,
234: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
235: transaction_date rcv_transactions_interface.transaction_date%type,
236: vendor_id rcv_transactions_interface.vendor_id%type,
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
230:
231: TYPE cum_quantity_record_type IS RECORD
232: (to_organization_id rcv_transactions_interface.to_organization_id%type,
233: po_header_id rcv_transactions_interface.po_header_id%type,
234: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
235: transaction_date rcv_transactions_interface.transaction_date%type,
236: vendor_id rcv_transactions_interface.vendor_id%type,
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
238: item_id rcv_transactions_interface.item_id%type,
231: TYPE cum_quantity_record_type IS RECORD
232: (to_organization_id rcv_transactions_interface.to_organization_id%type,
233: po_header_id rcv_transactions_interface.po_header_id%type,
234: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
235: transaction_date rcv_transactions_interface.transaction_date%type,
236: vendor_id rcv_transactions_interface.vendor_id%type,
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
238: item_id rcv_transactions_interface.item_id%type,
239: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
232: (to_organization_id rcv_transactions_interface.to_organization_id%type,
233: po_header_id rcv_transactions_interface.po_header_id%type,
234: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
235: transaction_date rcv_transactions_interface.transaction_date%type,
236: vendor_id rcv_transactions_interface.vendor_id%type,
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
238: item_id rcv_transactions_interface.item_id%type,
239: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
240: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
233: po_header_id rcv_transactions_interface.po_header_id%type,
234: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
235: transaction_date rcv_transactions_interface.transaction_date%type,
236: vendor_id rcv_transactions_interface.vendor_id%type,
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
238: item_id rcv_transactions_interface.item_id%type,
239: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
240: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
241: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
234: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
235: transaction_date rcv_transactions_interface.transaction_date%type,
236: vendor_id rcv_transactions_interface.vendor_id%type,
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
238: item_id rcv_transactions_interface.item_id%type,
239: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
240: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
241: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
242: error_record rcv_shipment_object_sv.ErrorRecType);
235: transaction_date rcv_transactions_interface.transaction_date%type,
236: vendor_id rcv_transactions_interface.vendor_id%type,
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
238: item_id rcv_transactions_interface.item_id%type,
239: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
240: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
241: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
242: error_record rcv_shipment_object_sv.ErrorRecType);
243:
236: vendor_id rcv_transactions_interface.vendor_id%type,
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
238: item_id rcv_transactions_interface.item_id%type,
239: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
240: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
241: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
242: error_record rcv_shipment_object_sv.ErrorRecType);
243:
244: /*===========================================================================
237: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
238: item_id rcv_transactions_interface.item_id%type,
239: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
240: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
241: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
242: error_record rcv_shipment_object_sv.ErrorRecType);
243:
244: /*===========================================================================
245: PROCEDURE NAME: create_shipment_line()