PACKAGE: APPS.FII_GL_BIS_MSC_PKG

Source

1 Package FII_GL_BIS_MSC_PKG AS
2 /* $Header: FIIGLBSS.pls 120.1 2005/09/27 14:41:08 sgautam noship $ */
3 --
4 -- Function
5 --   get_description_sql
6 -- Purpose
7 --   wrapper function to call gl_flexfields_pkg.get_description_sql
8 --   to get segemnt vale description for glfv_gl_accounts_descr
9 -- History
10 --   Apr-25-2003    SGAUTAM      Created
11 -- Arguments
12 --   p_coa_id       Number       Chart of account id
13 --   p_column_name  Varchar2     Segment Name
14 --   p_seg_val      Varchar2     Segment Value
15 -- Returns
16 --   Segment value description (Varchar2)
17 -- Example
18 --   FII_GL_BIS_MSC_PKG.get_description_sql(101, 'SEGMENT10', SEGMENT10);
19 -- Notes
20 --
21 
22 FUNCTION get_description_sql(
23             p_coa_id      IN NUMBER,
24             p_column_name IN VARCHAR2,
25             p_seg_val     IN VARCHAR2) RETURN VARCHAR2;
26 
27 END FII_GL_BIS_MSC_PKG;