PACKAGE: APPS.JL_JLCLGCAL_XMLP_PKG

Source

1 PACKAGE JL_JLCLGCAL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLCLGCALS.pls 120.1 2007/12/25 16:43:16 dwkrishn noship $ */
3   P_SET_OF_BOOKS_ID NUMBER;
4 
5   P_CHART_OF_ACCTS_ID NUMBER;
6 
7   P_START_PERIOD VARCHAR2(15);
8 
9   P_END_PERIOD VARCHAR2(15);
10 
11   P_CONC_REQUEST_ID NUMBER;
12 
13   P_COMPANY_INFO VARCHAR2(1);
14 
15   P_MODEL_ID NUMBER;
16 
17   P_FLEXDATA VARCHAR2(1000);
18 
19   P_MIN_FLEX VARCHAR2(1000);
20 
21   P_MAX_FLEX VARCHAR2(1000);
22 
23   P_DEBUG_SWITCH VARCHAR2(1);
24 
25   P_MIN_PRECISION NUMBER;
26 
27   P_TRACE_SWITCH VARCHAR2(1);
28 
29   P_COMPANY_ID NUMBER;
30 
31   P_DYNAMIC_WHERE VARCHAR2(10000);
32 
33   P_LEGAL_ENTITY_ID NUMBER;
34 
35   STRUCT_NUM VARCHAR2(15) := '101';
36 
37   C_ACCOUNT_START VARCHAR2(1000) := '(amr.SEGMENT1_LOW)';
38 
39   C_ACCOUNT_END VARCHAR2(1000) := '(amr.SEGMENT1_HIGH)';
40 
41   WHERE_FLEX VARCHAR2(1000) := 'CC.SEGMENT11 BETWEEN ''00'' AND ''11''';
42 
43   C_ACCT VARCHAR2(500) := '(cc.SEGMENT1||''.''||SEGMENT2)';
44 
45   SET_OF_BOOKS_NAME VARCHAR2(30);
46 
47   CP_COMP_NAME VARCHAR2(150);
48 
49   CP_COMP_ADDRESS1 VARCHAR2(480);
50 
51   CP_COMP_TAXPAYER_ID VARCHAR2(30);
52 
53   CP_COMP_ESTAB_TYPE VARCHAR2(100);
54 
55   CP_COMP_ADDRESS2 VARCHAR2(270);
56 
57   DELIMITER VARCHAR2(1);
58 
59   CP_DATE4_FORMAT VARCHAR2(20);
60 
61   CP_MODEL_NAME VARCHAR2(80);
62 
63   FUNCTION AFTERREPORT RETURN BOOLEAN;
64 
65   FUNCTION C_DOC_NUMFORMULA(SOURCE IN VARCHAR2
66                            ,REFERENCE_6 IN VARCHAR2
67                            ,REFERENCE_4 IN VARCHAR2
68                            ,REFERENCE_5 IN VARCHAR2
69                            ,REFERENCE_8 IN VARCHAR2) RETURN VARCHAR2;
70 
71   FUNCTION C_DOCUMENTFORMULA(SOURCE_ID IN VARCHAR2
72                             ,REFERENCE_10 IN VARCHAR2
73                             ,REFERENCE_9 IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION START_EFFECTIVE_PERIOD_NUMFORM RETURN NUMBER;
76 
77   FUNCTION END_EFFECTIVE_PERIOD_NUMFORMUL RETURN NUMBER;
78 
79   FUNCTION CF_1FORMULA(BEGIN_BAL_DR IN NUMBER
80                       ,BEGIN_BAL_CR IN NUMBER) RETURN NUMBER;
81 
82   FUNCTION C_END_BALFORMULA(END_BAL_DR IN NUMBER
83                            ,END_BAL_CR IN NUMBER) RETURN NUMBER;
84 
85   FUNCTION GET_DYNAMIC_WHERE RETURN BOOLEAN;
86 
87   FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
88 
89   FUNCTION C_ACCOUNT_START_P RETURN VARCHAR2;
90 
91   FUNCTION C_ACCOUNT_END_P RETURN VARCHAR2;
92 
93   FUNCTION WHERE_FLEX_P RETURN VARCHAR2;
94 
95   FUNCTION C_ACCT_P RETURN VARCHAR2;
96 
97   FUNCTION SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
98 
99   FUNCTION CP_COMP_NAME_P RETURN VARCHAR2;
100 
101   FUNCTION CP_COMP_ADDRESS1_P RETURN VARCHAR2;
102 
103   FUNCTION CP_COMP_TAXPAYER_ID_P RETURN VARCHAR2;
104 
105   FUNCTION CP_COMP_ESTAB_TYPE_P RETURN VARCHAR2;
106 
107   FUNCTION CP_COMP_ADDRESS2_P RETURN VARCHAR2;
108 
109   FUNCTION DELIMITER_P RETURN VARCHAR2;
110 
111   FUNCTION CP_DATE4_FORMAT_P RETURN VARCHAR2;
112 
113   FUNCTION CP_MODEL_NAME_P RETURN VARCHAR2;
114 
115   FUNCTION BEFOREREPORT RETURN BOOLEAN;
116 
117 END JL_JLCLGCAL_XMLP_PKG;
118 
119 
120