[Home] [Help]
16:
17: ===========================================================================*/
18:
19: TYPE transaction_record_type IS RECORD
20: (transaction_record rcv_shipment_object_sv.c2%rowtype,
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,
17: ===========================================================================*/
18:
19: TYPE transaction_record_type IS RECORD
20: (transaction_record rcv_shipment_object_sv.c2%rowtype,
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,
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:
37: TYPE document_num_record_type IS RECORD
38: (document_num po_headers.segment1%type,
39: po_header_id po_headers.po_header_id%type,
36:
37: TYPE document_num_record_type IS RECORD
38: (document_num po_headers.segment1%type,
39: po_header_id po_headers.po_header_id%type,
40: error_record rcv_shipment_object_sv.ErrorRecType);
41:
42: TYPE release_id_record_type IS RECORD
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
52: (document_line_num po_lines.line_num%type,
53: document_num po_headers.segment1%type,
53: document_num po_headers.segment1%type,
54: po_header_id po_headers.po_header_id%type,
55: po_line_id po_lines.po_line_id%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,
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
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,
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),
73: substitute_item_id mtl_system_items_kfv.inventory_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
82: (displayed_field po_lookup_codes.displayed_field%Type,
83: lookup_code po_lookup_codes.lookup_code%Type,
81: TYPE po_lookup_code_record_type IS RECORD
82: (displayed_field po_lookup_codes.displayed_field%Type,
83: lookup_code po_lookup_codes.lookup_code%Type,
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,
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,
94: routing_header_id rcv_transactions_interface.routing_header_id%type,
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,
99: routing_step_id rcv_transactions_interface.routing_step_id%type,
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,
104: deliver_to_person_id rcv_transactions_interface.deliver_to_person_id%type,
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,
109: employee_id rcv_transactions_interface.deliver_to_location_id%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,
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,
126: to_organization_id rcv_transactions_interface.to_organization_id%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
137: ** added subinventory and to_organization_id the record
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,
163: locator_id rcv_transactions_interface.locator_id%type,
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,
170: location_id rcv_transactions_interface.location_id%type,
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,
175: reason_id rcv_transactions_interface.reason_id%type,
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,
180: unit_of_measure rcv_transactions_interface.unit_of_measure%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,
193: line_location_id rcv_transactions_interface.po_line_location_id%type,
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,
198: error_record rcv_shipment_object_sv.ErrorRecType);
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,
202: po_line_location_id rcv_transactions_interface.po_line_location_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: /*
213: Added the 'parent_txn_id' column to above rec so as to handle bug 6447564 issue.
214: */
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
223: (tax_name rcv_transactions_interface.tax_name%type,
224: error_record rcv_shipment_object_sv.ErrorRecType);
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
228: (country_of_origin_code rcv_transactions_interface.country_of_origin_code%type,
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,
233: po_header_id rcv_transactions_interface.po_header_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()
246:
263: CLOSED ISSUES:
264:
265: CHANGE HISTORY: DFong 09/23/96 Created
266: ===========================================================================*/
267: PROCEDURE create_shipment_line (X_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
268: n IN OUT NOCOPY binary_integer,
269: X_header_id IN rcv_headers_interface.header_interface_id%type,
270: X_asn_type IN rcv_headers_interface.asn_type%type,
271: V_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype);