DBA Data[Home] [Help]

PACKAGE: APPS.JE_PT_GL_PFTLS_PKG

Source


1 PACKAGE JE_PT_GL_PFTLS_PKG AUTHID CURRENT_USER AS
2 -- $Header: jeptglps.pls 120.0.12000000.1 2007/10/24 09:50:01 sgudupat noship $
3 --
4 -- Parameters defined in the data template
5 --
6 P_ACCESS_SET_ID                  NUMBER ;
7 P_LEDGER_ID                      NUMBER ;
8 P_LEDGER                         VARCHAR2(300);
9 P_COA_ID                         NUMBER;
10 P_NATURAL_ACCOUNT                VARCHAR2(30);
11 P_BALANCE_SEGMENT                VARCHAR2(25);
12 P_BAL_SEG_VALUE                  VARCHAR2(25);
13 P_START_PERIOD                   VARCHAR2(30);
14 P_END_PERIOD                     VARCHAR2(30);
15 P_IRC_TAX                        NUMBER;
16 P_CURR_UNIT                      VARCHAR2(10);
17 P_CURR_UNIT_VALUE                VARCHAR2(10);
18 P_CUSTOM_PARAMETER_1             VARCHAR2(20);
19 P_CUSTOM_PARAMETER_2             VARCHAR2(20);
20 
21 -- Global Variables
22 GN_CUR_AMT                       NUMBER(20);
23 GN_PRE_AMT                       NUMBER(20);
24 GN_CURR_YEAR                     VARCHAR2(10);
25 GN_PREV_YEAR                     VARCHAR2(10);
26 GC_ACCESS_WHERE                  VARCHAR2(1000);
27 GD_START_DATE                    DATE;
28 GD_END_DATE                      DATE;
29 GD_PRIOR_START_DATE              DATE;
30 GD_PRIOR_END_DATE                DATE;
31 GN_PRE_TAX_AMT                   NUMBER(20);
32 GN_CUR_TAX_AMT                   NUMBER(20);
33 GN_FLEX_VALUE_SET_ID             NUMBER(10);
34 GC_NATURAL_ACCOUNT               VARCHAR2(30);
35 GC_BAL_SEG_FILTER                VARCHAR2(120);
36 GC_DEBUG_VAR                     VARCHAR2(1000);
37 GN_ITERATION                     NUMBER :=0;
38 
39 TYPE parent_tab_type IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
40 
41  parent_value_rec parent_tab_type;
42 
43 FUNCTION beforeReport RETURN BOOLEAN;
44 
45 END JE_PT_GL_PFTLS_PKG;