PACKAGE: APPS.JE_JEHUFAMS_XMLP_PKG

Source

1 PACKAGE JE_JEHUFAMS_XMLP_PKG AS
2 /* $Header: JEHUFAMSS.pls 120.1 2007/12/25 16:54:01 dwkrishn noship $ */
3   P_BOOK VARCHAR2(15);
4 
5   P_PERIOD1 VARCHAR2(15);
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_PERIOD2 VARCHAR2(15);
10 
11   P_MIN_PRECISION NUMBER;
12 
13   P_REPORT_TYPE VARCHAR2(30);
14 
15   P_ADJ_MODE VARCHAR2(32767);
16 
17   P_COMPANY VARCHAR2(50);
18 
19   ACCT_BAL_APROMPT VARCHAR2(222);
20 
21   ACCT_CC_APROMPT VARCHAR2(222);
22 
23   CAT_MAJ_RPROMPT VARCHAR2(222);
24 
25   PERIOD1_POD DATE;
26 
27   PERIOD1_PCD DATE;
28 
29   PERIOD1_FY NUMBER;
30 
31   PERIOD2_POD DATE;
32 
33   PERIOD2_PCD DATE;
34 
35   PERIOD2_FY NUMBER;
36 
37   RP_COMPANY_NAME VARCHAR2(30);
38 
39   RP_REPORT_NAME VARCHAR2(80);
40 
41   RP_BAL_LPROMPT VARCHAR2(222);
42 
43   RP_CTR_APROMPT VARCHAR2(222);
44 
45   CP_DISTRIBUTION_SOURCE_BOOK VARCHAR2(20);
46 
47   CP_PERIOD1_PC NUMBER;
48 
49   CP_PERIOD1_POD DATE;
50 
51   CP_PERIOD1_PCD DATE;
52 
53   CP_PERIOD2_PC NUMBER;
54 
55   CP_PERIOD2_PCD DATE;
56 
57   CP_BALANCE_TYPE VARCHAR2(20);
58 
59   CP_BEGIN_OR_END VARCHAR2(20);
60 
61   CP_PERIOD_PC NUMBER;
62 
63   CP_PERIOD_POD DATE;
64 
65   CP_PERIOD_PCD DATE;
66 
67   CP_FDRCSID VARCHAR2(100);
68 
69   CP_END_PERIOD_OPEN VARCHAR2(3);
70 
71   CP_END_DATE DATE;
72 
73   FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION BEFOREREPORT RETURN BOOLEAN;
76 
77   FUNCTION AFTERREPORT RETURN BOOLEAN;
78 
79   FUNCTION PERIOD1_PCFORMULA RETURN NUMBER;
80 
81   FUNCTION PERIOD2_PCFORMULA RETURN NUMBER;
82 
83   FUNCTION DO_INSERTFORMULA RETURN NUMBER;
84 
85   FUNCTION OUT_OF_BALANCEFORMULA(BEGIN1 IN NUMBER
86                                 ,ADDITION IN NUMBER
87                                 ,REVALUATION IN NUMBER
88                                 ,RECLASS IN NUMBER
89                                 ,RETIREMENT IN NUMBER
90                                 ,ADJUSTMENT IN NUMBER
91                                 ,TRANSFER IN NUMBER
92                                 ,CAPITALIZATION IN NUMBER
93                                 ,END1 IN NUMBER) RETURN VARCHAR2;
94 
95   FUNCTION ACCT_OUT_OF_BALANCEFORMULA(ACCT_BEGIN IN NUMBER
96                                      ,ACCT_ADD IN NUMBER
97                                      ,ACCT_REVAL IN NUMBER
98                                      ,ACCT_RECLASS IN NUMBER
99                                      ,ACCT_RETIRE IN NUMBER
100                                      ,ACCT_ADJUST IN NUMBER
101                                      ,ACCT_TRANS IN NUMBER
102                                      ,ACCT_CAPITAL IN NUMBER
103                                      ,ACCT_END IN NUMBER) RETURN VARCHAR2;
104 
105   FUNCTION BAL_OUT_OF_BALANCEFORMULA(BAL_BEGIN IN NUMBER
106                                     ,BAL_ADD IN NUMBER
107                                     ,BAL_REVAL IN NUMBER
108                                     ,BAL_RECLASS IN NUMBER
109                                     ,BAL_RETIRE IN NUMBER
110                                     ,BAL_ADJUST IN NUMBER
111                                     ,BAL_TRANS IN NUMBER
112                                     ,BAL_CAPITAL IN NUMBER
113                                     ,BAL_END IN NUMBER) RETURN VARCHAR2;
114 
115   FUNCTION CAPREVALFORMULA(REVALUATION IN NUMBER
116                           ,CAPITALIZATION IN NUMBER) RETURN NUMBER;
117 
118   FUNCTION CF_REPORT_DATEFORMULA RETURN CHAR;
119 
120   PROCEDURE GET_ADJUSTMENTS;
121 
122   PROCEDURE GET_DEPRN_EFFECTS;
123 
124   PROCEDURE INSERT_INFO;
125 
126   PROCEDURE GET_BALANCE;
127 
128   PROCEDURE VERSION;
129 
130   FUNCTION ACCT_BAL_APROMPT_P RETURN VARCHAR2;
131 
132   FUNCTION ACCT_CC_APROMPT_P RETURN VARCHAR2;
133 
134   FUNCTION CAT_MAJ_RPROMPT_P RETURN VARCHAR2;
135 
136   FUNCTION PERIOD1_POD_P RETURN DATE;
137 
138   FUNCTION PERIOD1_PCD_P RETURN DATE;
139 
140   FUNCTION PERIOD1_FY_P RETURN NUMBER;
141 
142   FUNCTION PERIOD2_POD_P RETURN DATE;
143 
144   FUNCTION PERIOD2_PCD_P RETURN DATE;
145 
146   FUNCTION PERIOD2_FY_P RETURN NUMBER;
147 
148   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
149 
150   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
151 
152   FUNCTION RP_BAL_LPROMPT_P RETURN VARCHAR2;
153 
154   FUNCTION RP_CTR_APROMPT_P RETURN VARCHAR2;
155 
156   FUNCTION CP_DISTRIBUTION_SOURCE_BOOK_P RETURN VARCHAR2;
157 
158   FUNCTION CP_PERIOD1_PC_P RETURN NUMBER;
159 
160   FUNCTION CP_PERIOD1_POD_P RETURN DATE;
161 
162   FUNCTION CP_PERIOD1_PCD_P RETURN DATE;
163 
164   FUNCTION CP_PERIOD2_PC_P RETURN NUMBER;
165 
166   FUNCTION CP_PERIOD2_PCD_P RETURN DATE;
167 
168   FUNCTION CP_BALANCE_TYPE_P RETURN VARCHAR2;
169 
170   FUNCTION CP_BEGIN_OR_END_P RETURN VARCHAR2;
171 
172   FUNCTION CP_PERIOD_PC_P RETURN NUMBER;
173 
174   FUNCTION CP_PERIOD_POD_P RETURN DATE;
175 
176   FUNCTION CP_PERIOD_PCD_P RETURN DATE;
177 
178   FUNCTION CP_FDRCSID_P RETURN VARCHAR2;
179 
180   FUNCTION CP_END_PERIOD_OPEN_P RETURN VARCHAR2;
181 
182   FUNCTION CP_END_DATE_P RETURN DATE;
183 
184 END JE_JEHUFAMS_XMLP_PKG;
185 
186