PACKAGE: APPS.JAI_OM_UTILS_PKG

Source

1 PACKAGE jai_om_utils_pkg  AUTHID CURRENT_USER AS
2 /* $Header: jai_om_utils.pls 120.2 2006/03/27 14:24:57 hjujjuru ship $ */
3 
4 gd_ass_value_date CONSTANT DATE DEFAULT SYSDATE ;  --Added rpokkula for  File.Sql.35
5 
6 procedure get_ato_pricelist_value
7 (
8  NEW_LIST NUMBER,
9  UNIT_CODE NUMBER,
10  INVENTORY_ID NUMBER,
11  IL6 NUMBER,
12  NAMOUNT OUT NOCOPY NUMBER
13 );
14 
15 function get_oe_assessable_value
16 (
17   p_customer_id IN NUMBER,
18   p_ship_to_site_use_id IN NUMBER,
19   p_inventory_item_id IN NUMBER,
20   p_uom_code IN VARCHAR2,
21   p_default_price IN NUMBER,
22   p_ass_value_date IN DATE,    --DEFAULT SYSDATE -- Added global variable gd_ass_value_date in package spec. by rpokkula for File.Sql.35
23   /* Bug 5096787. Added the following parameters */
24   p_sob_id           IN NUMBER   ,
25   p_curr_conv_code   IN VARCHAR2 ,
26   p_conv_rate        IN NUMBER
27 )
28 RETURN NUMBER ;
29 
30 procedure get_ato_assessable_value
31 (
32   NEW_ASSESS_LIST NUMBER,
33   IL6 NUMBER ,
34   NAMOUNT OUT NOCOPY NUMBER
35 );
36 
37 function validate_excise_exemption
38 (
39   p_line_id                   JAI_OM_OE_SO_LINES.LINE_ID%TYPE               ,
40   p_excise_exempt_type        JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE    ,
41   p_line_number               JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE           ,
42   p_shipment_line_number      JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE  ,
43   p_error_msg       OUT NOCOPY VARCHAR2
44 )
45 RETURN VARCHAR2 ;
46 
47 END jai_om_utils_pkg;