1 PACKAGE PO_GML_DB_COMMON AUTHID CURRENT_USER AS
2 /* $Header: GMLPOXCS.pls 115.4 2002/12/17 22:35:41 mchandak ship $ */
3 FUNCTION check_process_org(X_inventory_org_id IN NUMBER) RETURN VARCHAR2;
4 FUNCTION get_opm_uom_code(X_apps_unit_meas_lookup_code IN VARCHAR2) RETURN VARCHAR2;
5 FUNCTION get_apps_uom_code(X_opm_um_code IN VARCHAR2) RETURN VARCHAR2;
6 FUNCTION get_quantity_onhand( pitem_id IN NUMBER
7 ,plot_no IN VARCHAR2
8 ,psublot_no IN VARCHAR2
9 ,porg_id IN NUMBER
10 ,plocator_id IN NUMBER
11 ) RETURN NUMBER;
12
13 PROCEDURE create_inv_trans_opm( P_interface_trx_id IN NUMBER,
14 P_Line_Id IN NUMBER,
15 X_Return_Status IN OUT NOCOPY VARCHAR2) ;
16
17 PROCEDURE get_secondary_tran_qty ( p_transaction_id IN NUMBER,
18 p_secondary_available_qty IN OUT NOCOPY NUMBER);
19
20 PROCEDURE validate_quantity(
21 x_opm_item_id IN NUMBER,
22 x_opm_dual_uom_type IN NUMBER,
23 x_quantity IN NUMBER,
24 x_opm_um_code IN VARCHAR2,
25 x_opm_secondary_uom IN VARCHAR2,
26 x_secondary_quantity IN OUT NOCOPY NUMBER );
27
28 PROCEDURE create_lot_specific_conversion(
29 x_item_number IN VARCHAR2,
30 x_lot_number IN VARCHAR2,
31 x_sublot_number IN VARCHAR2,
32 x_from_uom IN VARCHAR2,
33 x_to_uom IN VARCHAR2,
34 x_type_factor IN NUMBER,
35 x_status IN OUT NOCOPY VARCHAR2,
36 x_data IN OUT NOCOPY VARCHAR2);
37
38 --Bug 1968305 Trans date in ic_tran_pnd does not have time stamp
39 G_USE_CREATION_DATE VARCHAR2(3) := fnd_profile.value('GML_USE_CREATION_DATE');
40
41 END PO_GML_DB_COMMON;