[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
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: error_record rcv_shipment_object_sv.ErrorRecType);
156:
157: TYPE locator_id_record_type IS RECORD
158: (locator rcv_transactions_interface.locator%type,
159: locator_id rcv_transactions_interface.locator_id%type,
158: (locator rcv_transactions_interface.locator%type,
159: locator_id rcv_transactions_interface.locator_id%type,
160: subinventory rcv_transactions_interface.subinventory%type,
161: to_organization_id rcv_transactions_interface.to_organization_id%type,
162: error_record rcv_shipment_object_sv.ErrorRecType);
163:
164: TYPE location_id_record_type IS RECORD
165: (location_code rcv_transactions_interface.location_code%type,
166: location_id rcv_transactions_interface.location_id%type,
163:
164: TYPE location_id_record_type IS RECORD
165: (location_code rcv_transactions_interface.location_code%type,
166: location_id rcv_transactions_interface.location_id%type,
167: error_record rcv_shipment_object_sv.ErrorRecType);
168:
169: TYPE reason_id_record_type IS RECORD
170: (reason_name rcv_transactions_interface.reason_name%type,
171: reason_id rcv_transactions_interface.reason_id%type,
168:
169: TYPE reason_id_record_type IS RECORD
170: (reason_name rcv_transactions_interface.reason_name%type,
171: reason_id rcv_transactions_interface.reason_id%type,
172: error_record rcv_shipment_object_sv.ErrorRecType);
173:
174: TYPE quantity_shipped_record_type IS RECORD
175: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
176: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,
182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
183: primary_quantity rcv_transactions_interface.primary_quantity%type,
184: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
185: error_record rcv_shipment_object_sv.ErrorRecType);
186:
187: TYPE expected_receipt_record_type IS RECORD
188: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,
189: line_location_id rcv_transactions_interface.po_line_location_id%type,
186:
187: TYPE expected_receipt_record_type IS RECORD
188: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,
189: line_location_id rcv_transactions_interface.po_line_location_id%type,
190: error_record rcv_shipment_object_sv.ErrorRecType);
191:
192: TYPE quantity_invoiced_record_type IS RECORD
193: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,
194: error_record rcv_shipment_object_sv.ErrorRecType);
190: error_record rcv_shipment_object_sv.ErrorRecType);
191:
192: TYPE quantity_invoiced_record_type IS RECORD
193: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,
194: error_record rcv_shipment_object_sv.ErrorRecType);
195:
196: TYPE ref_integrity_record_type IS RECORD
197: (to_organization_id rcv_transactions_interface.to_organization_id%type,
198: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
204: po_revision_num rcv_transactions_interface.po_revision_num%type,
205: item_id mtl_system_items_kfv.inventory_item_id%type,
206: error_record rcv_shipment_object_sv.ErrorRecType,
207: parent_txn_id rcv_transactions_interface.parent_transaction_id%TYPE);
208: /*
209: Added the 'parent_txn_id' column to above rec so as to handle bug 6447564 issue.
210: */
212: TYPE freight_carrier_record_type IS RECORD
213: (to_organization_id rcv_transactions_interface.to_organization_id%type,
214: freight_carrier_code rcv_transactions_interface.freight_carrier_code%type,
215: po_header_id po_headers.po_header_id%type,
216: error_record rcv_shipment_object_sv.ErrorRecType);
217:
218: TYPE tax_name_record_type IS RECORD
219: (tax_name rcv_transactions_interface.tax_name%type,
220: error_record rcv_shipment_object_sv.ErrorRecType);
216: error_record rcv_shipment_object_sv.ErrorRecType);
217:
218: TYPE tax_name_record_type IS RECORD
219: (tax_name rcv_transactions_interface.tax_name%type,
220: error_record rcv_shipment_object_sv.ErrorRecType);
221:
222: --FRKHAN 12/18/98 add new record type for country of origin
223: TYPE country_of_origin_record_type IS RECORD
224: (country_of_origin_code rcv_transactions_interface.country_of_origin_code%type,
221:
222: --FRKHAN 12/18/98 add new record type for country of origin
223: TYPE country_of_origin_record_type IS RECORD
224: (country_of_origin_code rcv_transactions_interface.country_of_origin_code%type,
225: error_record rcv_shipment_object_sv.ErrorRecType);
226:
227: TYPE cum_quantity_record_type IS RECORD
228: (to_organization_id rcv_transactions_interface.to_organization_id%type,
229: po_header_id rcv_transactions_interface.po_header_id%type,
234: item_id rcv_transactions_interface.item_id%type,
235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
236: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
237: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
238: error_record rcv_shipment_object_sv.ErrorRecType);
239:
240: /*===========================================================================
241: PROCEDURE NAME: create_shipment_line()
242:
259: CLOSED ISSUES:
260:
261: CHANGE HISTORY: DFong 09/23/96 Created
262: ===========================================================================*/
263: PROCEDURE create_shipment_line (X_cascaded_table IN OUT NOCOPY rcv_shipment_object_sv.cascaded_trans_tab_type,
264: n IN OUT NOCOPY binary_integer,
265: X_header_id IN rcv_headers_interface.header_interface_id%type,
266: X_asn_type IN rcv_headers_interface.asn_type%type,
267: V_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype);