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 AUTHID CURRENT_USER AS
2 /* $Header: RCVTHCS.pls 120.1.12020000.2 2012/11/18 03:09:05 liayang 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   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,
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,
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,
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,
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,
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,
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 
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);
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,
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);
243 
244 /*===========================================================================
245   PROCEDURE NAME:	create_shipment_line()
246 
247   DESCRIPTION:          Creates the receiving shipment object, namely new rows in the
248 			RCV_SHIPMENT_LINES tables
249 
250   PARAMETERS:           Line record type
251 			Header identifier (new)
252 			Asn type
253 			Lines fatal flag
254 
255   DESIGN REFERENCES:
256 
257   ALGORITHM:
258 
259   NOTES:
260 
261   OPEN ISSUES:
262 
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);
272 
273  END RCV_SHIPMENT_LINE_SV;
274