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