[Home] [Help]
PACKAGE: APPS.JE_PT_GL_PFTLS_PKG
Source
1 PACKAGE JE_PT_GL_PFTLS_PKG 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;