eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.RCV_SHIPMENT_LINE_SV

Source


1 PACKAGE RCV_SHIPMENT_LINE_SV AS
2 /* $Header: RCVTHCS.pls 120.0.12000000.2 2007/10/03 08:51:45 mokhan ship $*/
3 
4 /*===========================================================================
5   PACKAGE NAME:		rcv_shipment_line_sv
6 
7   DESCRIPTION:          Contains the server side APIs
8 
9   CLIENT/SERVER:	Server
10 
11   LIBRARY NAME          NONE
12 
13   OWNER:                DFong
14 
15   PROCEDURES/FUNCTIONS:	create_shipment_line()
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,
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),
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,
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,
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,
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,
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,
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
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,
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,
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
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,
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,
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 
135   /*
136   ** Bug 724495
137   ** added subinventory and to_organization_id the record
138   **
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,
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   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,
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,
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,
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,
177   item_id			rcv_transactions_interface.item_id%type,
178   po_line_id			rcv_transactions_interface.po_line_id%type,
179   po_line_location_id		rcv_transactions_interface.po_line_location_id%type,
180   to_organization_id		rcv_transactions_interface.to_organization_id%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,
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,
199   po_header_id		rcv_transactions_interface.po_header_id%type,
200   po_line_id		rcv_transactions_interface.po_line_id%type,
201   vendor_id		rcv_transactions_interface.vendor_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 */
211 
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);
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,
230   vendor_cum_shipped_qty	rcv_transactions_interface.vendor_cum_shipped_qty%type,
231   transaction_date		rcv_transactions_interface.transaction_date%type,
232   vendor_id			rcv_transactions_interface.vendor_id%type,
233   vendor_site_id		rcv_transactions_interface.vendor_site_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 
243   DESCRIPTION:          Creates the receiving shipment object, namely new rows in the
244 			RCV_SHIPMENT_LINES tables
245 
246   PARAMETERS:           Line record type
247 			Header identifier (new)
248 			Asn type
249 			Lines fatal flag
250 
251   DESIGN REFERENCES:
252 
253   ALGORITHM:
254 
255   NOTES:
256 
257   OPEN ISSUES:
258 
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);
268 
269  END RCV_SHIPMENT_LINE_SV;
270