[Home] [Help]
PACKAGE: APPS.JE_JEHUFDAN_XMLP_PKG
Source
1 PACKAGE JE_JEHUFDAN_XMLP_PKG AS
2 /* $Header: JEHUFDANS.pls 120.1 2007/12/25 16:54:31 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_DISTRIBUTION_SOURCE_BOOK VARCHAR2(15);
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(2);
58
59 CP_PERIOD_FROM VARCHAR2(20);
60
61 CP_PERIOD_TO VARCHAR2(20);
62
63 CP_OPEN_CLOSED VARCHAR2(20);
64
65 FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
66
67 FUNCTION B_PERIOD_OPENFORMATTRIGGER RETURN VARCHAR2;
68
69 FUNCTION BEFOREREPORT RETURN BOOLEAN;
70
71 FUNCTION AFTERREPORT RETURN BOOLEAN;
72
73 FUNCTION PERIOD1_PCFORMULA RETURN NUMBER;
74
75 FUNCTION PERIOD2_PCFORMULA RETURN NUMBER;
76
77 FUNCTION DO_INSERTFORMULA RETURN NUMBER;
78
79 FUNCTION ADJUSTFORMULA(TAX IN NUMBER
80 ,FLAT IN NUMBER
81 ,NON_STR_UNPLANNED IN NUMBER) RETURN NUMBER;
82
83 FUNCTION ENDFORMULA(LIFE IN NUMBER
84 ,EXPENSE IN NUMBER
85 ,ADJUST IN NUMBER
86 ,PRODUCTION IN NUMBER) RETURN NUMBER;
87
88 FUNCTION LIFEFORMULA(STRAIGHT IN NUMBER
89 ,STR_UNPLANNED IN NUMBER
90 ,EXPENSE IN NUMBER) RETURN NUMBER;
91
92 PROCEDURE INSERT_INFO;
93
94 PROCEDURE GET_ADJUSTMENTS;
95
96 PROCEDURE GET_ADJUSTMENTS_METHOD;
97
98 PROCEDURE GET_ADJ_STR_UNPLANNED;
99
100 PROCEDURE GET_DEPRN_EFFECTS;
101
102 PROCEDURE GET_DEPRN_EFFECTS_FIRST;
103
104 PROCEDURE GET_DEPRN_EFFECTS_METHOD;
105
106 FUNCTION CF_CURRENT_DATEFORMULA RETURN CHAR;
107
108 PROCEDURE GET_ADJ_NON_STR_UNPLANNED;
109
110 FUNCTION CF_UNPLANNEDFORMULA(FIRST_STR IN NUMBER
111 ,STR_UNPLANNED IN NUMBER
112 ,NON_STR_UNPLANNED IN NUMBER
113 ,FIRST_NON_STR IN NUMBER) RETURN NUMBER;
114
115 PROCEDURE GET_FIRST_MON_STR_UNPL;
116
117 PROCEDURE GET_FIRST_MON_NON_STR_UNPL;
118
119 FUNCTION CF_TOTAL_DEPRECIATIONFORMULA(CF_UNPLANNED IN NUMBER
120 ,END1 IN NUMBER) RETURN NUMBER;
121
122 FUNCTION ACCT_BAL_APROMPT_P RETURN VARCHAR2;
123
124 FUNCTION ACCT_CC_APROMPT_P RETURN VARCHAR2;
125
126 FUNCTION CAT_MAJ_RPROMPT_P RETURN VARCHAR2;
127
128 FUNCTION PERIOD1_POD_P RETURN DATE;
129
130 FUNCTION PERIOD1_PCD_P RETURN DATE;
131
132 FUNCTION PERIOD1_FY_P RETURN NUMBER;
133
134 FUNCTION PERIOD2_POD_P RETURN DATE;
135
136 FUNCTION PERIOD2_PCD_P RETURN DATE;
137
138 FUNCTION PERIOD2_FY_P RETURN NUMBER;
139
140 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
141
142 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
143
144 FUNCTION RP_BAL_LPROMPT_P RETURN VARCHAR2;
145
146 FUNCTION RP_CTR_APROMPT_P RETURN VARCHAR2;
147
148 FUNCTION CP_DISTRIBUTION_SOURCE_BOOK_P RETURN VARCHAR2;
149
150 FUNCTION CP_PERIOD1_PC_P RETURN NUMBER;
151
152 FUNCTION CP_PERIOD1_POD_P RETURN DATE;
153
154 FUNCTION CP_PERIOD1_PCD_P RETURN DATE;
155
156 FUNCTION CP_PERIOD2_PC_P RETURN NUMBER;
157
158 FUNCTION CP_PERIOD2_PCD_P RETURN DATE;
159
160 FUNCTION CP_BALANCE_TYPE_P RETURN VARCHAR2;
161
162 FUNCTION CP_PERIOD_FROM_P RETURN VARCHAR2;
163
164 FUNCTION CP_PERIOD_TO_P RETURN VARCHAR2;
165
166 FUNCTION CP_OPEN_CLOSED_P RETURN VARCHAR2;
167
168 END JE_JEHUFDAN_XMLP_PKG;
169
170