PACKAGE: APPS.JE_JEHUFDAN_XMLP_PKG

Source

1 PACKAGE JE_JEHUFDAN_XMLP_PKG AUTHID CURRENT_USER 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