PACKAGE: APPS.JAI_GENERAL_PKG

Source

1 PACKAGE jai_general_pkg AS
2 /* $Header: jai_general.pls 120.2 2006/02/06 10:41:50 avallabh ship $ */
3 
4   YES       CONSTANT VARCHAR2(1) := 'Y';
5   NO        CONSTANT VARCHAR2(1) := 'N';
6 
7   gd_ass_value_date CONSTANT DATE DEFAULT SYSDATE ; -- --rpokkula for File.Sql.35
8 
9   INDIAN_CURRENCY  CONSTANT VARCHAR2(3) := 'INR';
10 
11   FUNCTION get_fin_year( p_organization_id IN NUMBER) RETURN NUMBER;
12 
13   PROCEDURE get_range_division(  p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER,
14     p_range_no OUT NOCOPY VARCHAR2, p_division_no OUT NOCOPY VARCHAR2);
15 
16   PROCEDURE update_rg_balances(  p_organization_id IN NUMBER, p_location_id IN NUMBER,
17     p_register IN VARCHAR2, p_amount IN NUMBER, p_transaction_source IN VARCHAR2, p_called_from IN VARCHAR2);
18 
19   FUNCTION get_currency_precision(p_organization_id IN NUMBER) RETURN NUMBER;
20 
21   FUNCTION get_gl_concatenated_segments(p_code_combination_id IN NUMBER) RETURN VARCHAR2;
22 
23   FUNCTION get_organization_code( p_organization_id IN NUMBER) RETURN VARCHAR2;
24 
25   FUNCTION get_rg_register_type(p_item_class IN VARCHAR2) RETURN VARCHAR2;
26 
27   FUNCTION get_primary_uom_code(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) RETURN VARCHAR2;
28 
29   FUNCTION get_uom_code(p_uom IN VARCHAR2) RETURN VARCHAR2;
30 
31   FUNCTION get_orgn_master_flag(p_organization_id IN NUMBER, p_location_id IN NUMBER) RETURN VARCHAR2;
32 
33   FUNCTION trxn_to_primary_conv_rate(
34     p_transaction_uom_code  IN  MTL_UNITS_OF_MEASURE.uom_code%TYPE,
35     p_primary_uom_code      IN  MTL_UNITS_OF_MEASURE.uom_code%TYPE,
36     p_inventory_item_id     IN  MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
37   ) RETURN NUMBER;
38 
39   FUNCTION get_matched_boe_no(p_transaction_id IN  NUMBER ) RETURN VARCHAR2;
40 
41   FUNCTION get_last_record_of_rg(
42     p_register_name     IN VARCHAR2,
43     p_organization_id   IN NUMBER,
44     p_location_id       IN NUMBER,
45     p_inventory_item_id IN NUMBER,
46     p_fin_year          IN NUMBER   DEFAULT NULL
47   ) RETURN NUMBER;
48 
49   FUNCTION plot_codepath (
50     p_statement_id                            in      varchar2,
51     p_codepath                                in      varchar2,
52     p_calling_procedure                       in      varchar2 default null,
53     p_special_call                            in      varchar2  default null
54   ) RETURN VARCHAR2;
55 
56   /* added by Vijay Shankar for Bug#4068823 */
57   FUNCTION is_item_an_expense(
58     p_organization_id   IN  NUMBER,
59     p_item_id           IN  NUMBER
60   ) RETURN VARCHAR2;
61 
62   -- added, Harshita for bug #4245062
63  FUNCTION JA_IN_VAT_ASSESSABLE_VALUE(
64     p_party_id IN NUMBER,
65     p_party_site_id IN NUMBER,
66     p_inventory_item_id IN NUMBER,
67     p_uom_code IN VARCHAR2,
68     p_default_price IN NUMBER,
69     p_ass_value_date IN DATE,    -- DEFAULT SYSDATE, -- Added global variable gd_ass_value_date in package spec. by rpokkula for File.Sql.35
70     p_party_type IN VARCHAR2
71 ) RETURN NUMBER ;
72 
73 END jai_general_pkg;