PACKAGE: APPS.GML_OPM_ROI_GRP

Source

1 PACKAGE GML_OPM_ROI_GRP AUTHID CURRENT_USER AS
2 /* $Header: GMLGROIS.pls 115.5 2004/06/03 20:18:55 mchandak ship $*/
3 
4 TYPE opm_record_type IS RECORD
5  (receipt_source_code		rcv_transactions_interface.receipt_source_code%TYPE,
6   to_organization_id		rcv_transactions_interface.to_organization_id%TYPE,
7   item_num			rcv_transactions_interface.item_num%TYPE,
8   item_id			rcv_transactions_interface.item_id%TYPE,
9   unit_of_measure		rcv_transactions_interface.unit_of_measure%TYPE,
10   secondary_unit_of_measure	rcv_transactions_interface.secondary_unit_of_measure%TYPE,
11   secondary_uom_code		rcv_transactions_interface.secondary_uom_code%TYPE,
12   quantity			rcv_transactions_interface.quantity%TYPE,
13   secondary_quantity		rcv_transactions_interface.secondary_quantity%TYPE,
14   qc_grade			rcv_transactions_interface.qc_grade%TYPE,
15   transaction_type		rcv_transactions_interface.transaction_type%TYPE,
16   destination_type_code		rcv_transactions_interface.destination_type_code%TYPE,
17   locator_id			rcv_transactions_interface.locator_id%TYPE,
18   header_interface_id		rcv_transactions_interface.header_interface_id%TYPE,
19   group_id			rcv_transactions_interface.group_id%TYPE,
20   primary_quantity		rcv_transactions_interface.primary_quantity%TYPE,
21   from_locator_id		rcv_transactions_interface.from_locator_id%TYPE,
22   rti_id			NUMBER,
23   error_record			rcv_shipment_object_sv.ErrorRecType);
24 
25 
26 TYPE lot_attributes_rec_type IS RECORD
27 (item_no	 VARCHAR2(32),
28  opm_item_id 	 NUMBER,
29  lot_id		 NUMBER,
30  lot_no  	 VARCHAR2(32),
31  sublot_no  	 VARCHAR2(32),
32  expiration_date DATE,
33  reason_code	 VARCHAR2(4),
34  new_lot	 VARCHAR2(1));
35 
36 g_default_lot		VARCHAR2(32);
37 g_moved_diff_stat	NUMBER(2);
38 
39 
40 PROCEDURE validate_opm_parameters(x_opm_record	IN OUT NOCOPY gml_opm_roi_grp.opm_record_type);
41 
42 PROCEDURE validate_opm_lot( p_api_version	 	IN  NUMBER,
43 			    p_init_msg_lst	 	IN  VARCHAR2 := FND_API.G_FALSE,
44 			    p_mtlt_rowid	 	IN  ROWID,
45 			    p_new_lot		 	IN  VARCHAR2,
46 			    p_opm_item_id	 	IN  NUMBER,
47 			    p_item_no		 	IN  VARCHAR2,
48 			    p_lots_specified_on_parent	IN  VARCHAR2,
49 			    p_lot_id			IN  NUMBER,
50 			    p_parent_txn_type	 	IN  VARCHAR2 DEFAULT NULL,
51 			    p_grand_parent_txn_type	IN  VARCHAR2 DEFAULT NULL,
52 			    x_return_status      	OUT NOCOPY VARCHAR2,
53 			    x_msg_data           	OUT NOCOPY VARCHAR2,
54 			    x_msg_count          	OUT NOCOPY NUMBER) ;
55 
56 END GML_OPM_ROI_GRP;