PACKAGE: APPS.JE_JEHUFAMD_XMLP_PKG

Source

1 PACKAGE JE_JEHUFAMD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JEHUFAMDS.pls 120.1 2007/12/25 16:53:30 dwkrishn noship $ */
3   P_BOOK VARCHAR2(15);
4 
5   P_PERIOD1 VARCHAR2(15);
6 
7   P_CONC_REQUEST_ID NUMBER := 0;
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(40);
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_END_DATE DATE;
46 
47   CP_END_DATE_OPEN VARCHAR2(20);
48 
49   CP_PERIOD1_PC NUMBER;
50 
51   CP_PERIOD1_POD DATE;
52 
53   CP_PERIOD1_PCD DATE;
54 
55   CP_PERIOD2_PC NUMBER;
56 
57   CP_PERIOD2_PCD DATE;
58 
59   CP_DISTRIBUTION_SOURCE_BOOK VARCHAR2(30);
60 
61   CP_BALANCE_TYPE VARCHAR2(20);
62 
63   CP_FDRCSID VARCHAR2(20);
64 
65   CP_BEGIN_OR_END VARCHAR2(5);
66 
67   CP_PERIOD_PC NUMBER;
68 
69   CP_PERIOD_POD DATE;
70 
71   CP_PERIOD_PCD DATE;
72 
73   FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION BEFOREREPORT RETURN BOOLEAN;
76 
77   FUNCTION PERIOD1_PCFORMULA RETURN NUMBER;
78 
79   FUNCTION PERIOD2_PCFORMULA RETURN NUMBER;
80 
81   FUNCTION DO_INSERTFORMULA RETURN NUMBER;
82 
83   FUNCTION OUT_OF_BALANCEFORMULA(BEGIN1 IN NUMBER
84                                 ,ADDITION IN NUMBER
85                                 ,DEPRECIATION IN NUMBER
86                                 ,RECLASS IN NUMBER
87                                 ,RETIREMENT IN NUMBER
88                                 ,ADJUST IN NUMBER
89                                 ,TRANSFER IN NUMBER
90                                 ,END1 IN NUMBER) RETURN VARCHAR2;
91 
92   FUNCTION ACCT_OUT_OF_BALANCEFORMULA(ACCT_BEGIN IN NUMBER
93                                      ,ACCT_ADD IN NUMBER
94                                      ,ACCT_DEPRN IN NUMBER
95                                      ,ACCT_RECLASS IN NUMBER
96                                      ,ACCT_RETIRE IN NUMBER
97                                      ,ACCT_ADJUST IN NUMBER
98                                      ,ACCT_TRANS IN NUMBER
99                                      ,ACCT_END IN NUMBER) RETURN VARCHAR2;
100 
101   FUNCTION BAL_OUT_OF_BALANCEFORMULA(BAL_BEGIN IN NUMBER
102                                     ,BAL_ADD IN NUMBER
103                                     ,BAL_DEPRN IN NUMBER
104                                     ,BAL_RECLASS IN NUMBER
105                                     ,BAL_RETIRE IN NUMBER
106                                     ,BAL_ADJUST IN NUMBER
107                                     ,BAL_TRANS IN NUMBER
108                                     ,BAL_END IN NUMBER) RETURN VARCHAR2;
109 
110   FUNCTION ADJUSTFORMULA(TAX IN NUMBER
111                         ,REVALUATION IN NUMBER) RETURN NUMBER;
112 
113   FUNCTION AFTERREPORT RETURN BOOLEAN;
114 
115   FUNCTION CF_REPORT_DATEFORMULA RETURN CHAR;
116 
117   PROCEDURE GET_ADJUSTMENTS;
118 
119   PROCEDURE GET_DEPRN_EFFECTS;
120 
121   PROCEDURE VERSION;
122 
123   PROCEDURE INSERT_INFO;
124 
125   PROCEDURE GET_BALANCE;
126 
127   FUNCTION ACCT_BAL_APROMPT_P RETURN VARCHAR2;
128 
129   FUNCTION ACCT_CC_APROMPT_P RETURN VARCHAR2;
130 
131   FUNCTION CAT_MAJ_RPROMPT_P RETURN VARCHAR2;
132 
133   FUNCTION PERIOD1_POD_P RETURN DATE;
134 
135   FUNCTION PERIOD1_PCD_P RETURN DATE;
136 
137   FUNCTION PERIOD1_FY_P RETURN NUMBER;
138 
139   FUNCTION PERIOD2_POD_P RETURN DATE;
140 
141   FUNCTION PERIOD2_PCD_P RETURN DATE;
142 
143   FUNCTION PERIOD2_FY_P RETURN NUMBER;
144 
145   FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
146 
147   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
148 
149   FUNCTION RP_BAL_LPROMPT_P RETURN VARCHAR2;
150 
151   FUNCTION RP_CTR_APROMPT_P RETURN VARCHAR2;
152 
153   FUNCTION CP_END_DATE_P RETURN DATE;
154 
155   FUNCTION CP_END_DATE_OPEN_P RETURN VARCHAR2;
156 
157   FUNCTION CP_PERIOD1_PC_P RETURN NUMBER;
158 
159   FUNCTION CP_PERIOD1_POD_P RETURN DATE;
160 
161   FUNCTION CP_PERIOD1_PCD_P RETURN DATE;
162 
163   FUNCTION CP_PERIOD2_PC_P RETURN NUMBER;
164 
165   FUNCTION CP_PERIOD2_PCD_P RETURN DATE;
166 
167   FUNCTION CP_DISTRIBUTION_SOURCE_BOOK_P RETURN VARCHAR2;
168 
169   FUNCTION CP_BALANCE_TYPE_P RETURN VARCHAR2;
170 
171   FUNCTION CP_FDRCSID_P RETURN VARCHAR2;
172 
173   FUNCTION CP_BEGIN_OR_END_P RETURN VARCHAR2;
174 
175   FUNCTION CP_PERIOD_PC_P RETURN NUMBER;
176 
177   FUNCTION CP_PERIOD_POD_P RETURN DATE;
178 
179   FUNCTION CP_PERIOD_PCD_P RETURN DATE;
180 
181 END JE_JEHUFAMD_XMLP_PKG;
182 
183