[Home] [Help]
PACKAGE: APPS.JE_JEDEAPVR_XMLP_PKG
Source
1 PACKAGE JE_JEDEAPVR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JEDEAPVRS.pls 120.1 2007/12/25 16:51:59 dwkrishn noship $ */
3 P_VAT_FROM VARCHAR2(15);
4
5 P_VAT_TO VARCHAR2(15);
6
7 P_LOW_RANGE VARCHAR2(200);
8
9 P_HIGH_RANGE VARCHAR2(200);
10
11 P_PERIOD_FROM VARCHAR2(15);
12
13 P_PERIOD_TO VARCHAR2(15);
14
15 P_SET_OF_BOOKS_ID VARCHAR2(32767);
16
17 P_CONC_REQUEST_ID NUMBER := 0;
18
19 P_APP_ID VARCHAR2(25);
20
21 P_PERIOD_NUM_FROM NUMBER;
22
23 P_PERIOD_NUM_TO NUMBER;
24
25 P_LEGAL_ENTITY_ID NUMBER;
26
27 P_CHART_OF_ACCT NUMBER;
28
29 P_BALANCING_SEGMENT NUMBER;
30
31 P_BAL_SEG_NAME VARCHAR2(200) := '1=1';
32
33 FLEX_DATA VARCHAR2(2100) := '(CC.SEGMENT1||''\n''||CC.SEGMENT2||''\n''||CC.SEGMENT3||''\n''||
34 CC.SEGMENT4||''\n''||CC.SEGMENT5||''\n''||CC.SEGMENT6||''\n''||CC.SEGMENT7||''\n''||CC.SEGMENT8||''\n''||
35 CC.SEGMENT9||''\n''||CC.SEGMENT10||''\n''||CC.SEGMENT11||''\n''||CC.SEGMENT12||''\n''||CC.SEGMENT13||''\n''||
36 CC.SEGMENT14||''\n''||CC.SEGMENT15||''\n''||CC.SEGMENT16||''\n''||CC.SEGMENT17||''\n''||CC.SEGMENT18||''\n''||
37 CC.SEGMENT19||''\n''||CC.SEGMENT20||''\n''||CC.SEGMENT21||''\n''||CC.SEGMENT22||''\n''||CC.SEGMENT23||''\n''||
38 CC.SEGMENT24||''\n''||CC.SEGMENT25||''\n''||CC.SEGMENT26||''\n''||CC.SEGMENT27||''\n''||CC.SEGMENT28||''\n''||
39 CC.SEGMENT28||''\n''||CC.SEGMENT29||''\n''||CC.SEGMENT30)';
40
41 FLEX_PARM VARCHAR2(2100) := '1=1';
42
43 STRUCT_NUM VARCHAR2(15);
44
45 SET_OF_BOOKS_NAME VARCHAR2(30);
46
47 FUNC_CURR VARCHAR2(15);
48
49 FROM_DATE DATE;
50
51 THRU_DATE DATE;
52
53 DIST_OPT VARCHAR2(32767);
54
55 CURR_PERC NUMBER;
56
57 P_SCALING_FACTOR NUMBER;
58
59 FUNCTION BEFOREREPORT RETURN BOOLEAN;
60
61 FUNCTION AFTERREPORT RETURN BOOLEAN;
62
63 FUNCTION COMP_DIFFFORMULA(COMP_GL_BALANCE IN NUMBER
64 ,COMP_DV IN NUMBER) RETURN NUMBER;
65
66 FUNCTION W_CALC_VATFORMULA(TAX_TYPE IN VARCHAR2
67 ,W_ORIG_COSTS IN NUMBER
68 ,TAX_RATE IN NUMBER) RETURN NUMBER;
69
70 FUNCTION ROUND_ORIG_COSTSFORMULA(INV_ORIG_COST IN NUMBER) RETURN NUMBER;
71
72 FUNCTION ROUND_ORIG_VATFORMULA(INV_VAT_COST IN NUMBER) RETURN NUMBER;
73
74 FUNCTION ROUND_DISC_COSTSFORMULA(INV_DISC_COST IN NUMBER) RETURN NUMBER;
75
76 FUNCTION ROUND_DISC_VATFORMULA(INV_VAT_DISC IN NUMBER) RETURN NUMBER;
77
78 FUNCTION VAT_CALC_DIFFFORMULA(W_CALC_VAT IN NUMBER
79 ,W_ORIG_VAT IN NUMBER) RETURN NUMBER;
80
81 FUNCTION COMP_OTHER_DIFFFORMULA(COMP_GL_BALANCE IN NUMBER
82 ,COMP_OV IN NUMBER
83 ,COMP_DV IN NUMBER) RETURN NUMBER;
84
85 PROCEDURE JG_GET_PERIOD_DATES(APP_ID IN NUMBER
86 ,TSET_OF_BOOKS_ID IN NUMBER
87 ,TPERIOD_NAME IN VARCHAR2
88 ,TSTART_DATE OUT NOCOPY DATE
89 ,TEND_DATE OUT NOCOPY DATE
90 ,ERRBUF OUT NOCOPY VARCHAR);
91
92 FUNCTION CF_REPORT_DATEFORMULA RETURN CHAR;
93
94 FUNCTION CF_INVOICE_DATEFORMULA(INVOICE_DATE IN DATE) RETURN CHAR;
95
96 FUNCTION CF_INVOICE_DATE1FORMULA(INVOICE_DATE1 IN DATE) RETURN CHAR;
97
98 FUNCTION GET_DISCOUNT_VATFORMULA(TAX_DISCOUNT IN NUMBER
99 ,INVOICE_ID_V IN NUMBER) RETURN NUMBER;
100
101 FUNCTION FLEX_DATA_P RETURN VARCHAR2;
102
103 FUNCTION FLEX_PARM_P RETURN VARCHAR2;
104
105 FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
106
107 FUNCTION SET_OF_BOOKS_NAME_P RETURN VARCHAR2;
108
109 FUNCTION FUNC_CURR_P RETURN VARCHAR2;
110
111 FUNCTION FROM_DATE_P RETURN DATE;
112
113 FUNCTION THRU_DATE_P RETURN DATE;
114
115 FUNCTION DIST_OPT_P RETURN VARCHAR2;
116
117 FUNCTION CURR_PERC_P RETURN NUMBER;
118
119 FUNCTION P_SCALING_FACTOR_P RETURN NUMBER;
120
121 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
122 ,NAME IN VARCHAR2);
123
124 PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
125 ,VALUE IN VARCHAR2
126 ,TRANSLATE IN BOOLEAN);
127
128 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
129
130 PROCEDURE CLEAR;
131
132 FUNCTION GET_STRING(APPIN IN VARCHAR2
133 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
134
135 FUNCTION GET RETURN VARCHAR2;
136
137 FUNCTION GET_ENCODED RETURN VARCHAR2;
138
139 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
140 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
141 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
142
143 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
144
145 PROCEDURE RAISE_ERROR;
146
147 PROCEDURE JG_GET_SET_OF_BOOKS_INFO(SOBID IN NUMBER
148 ,COAID OUT NOCOPY NUMBER
149 ,SOBNAME OUT NOCOPY VARCHAR2
150 ,FUNC_CURR OUT NOCOPY VARCHAR2
151 ,ERRBUF OUT NOCOPY VARCHAR2);
152
153 PROCEDURE JG_GET_BUD_OR_ENC_NAME(ACTUAL_TYPE IN VARCHAR2
154 ,TYPE_ID IN NUMBER
155 ,NAME OUT NOCOPY VARCHAR2
156 ,ERRBUF OUT NOCOPY VARCHAR2);
157
158 PROCEDURE JG_GET_LOOKUP_VALUE(LMODE IN VARCHAR2
159 ,CODE IN VARCHAR2
160 ,TYPE IN VARCHAR2
161 ,VALUE OUT NOCOPY VARCHAR2
162 ,ERRBUF OUT NOCOPY VARCHAR2);
163
164 PROCEDURE JG_GET_FIRST_PERIOD(APP_ID IN NUMBER
165 ,TSET_OF_BOOKS_ID IN NUMBER
166 ,TPERIOD_NAME IN VARCHAR2
167 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
168 ,ERRBUF OUT NOCOPY VARCHAR2);
169
170 PROCEDURE JG_GET_FIRST_PERIOD_OF_QUARTER(APP_ID IN NUMBER
171 ,TSET_OF_BOOKS_ID IN NUMBER
172 ,TPERIOD_NAME IN VARCHAR2
173 ,TFIRST_PERIOD OUT NOCOPY VARCHAR2
174 ,ERRBUF OUT NOCOPY VARCHAR2);
175
176 FUNCTION JG_FORMAT_CURR_AMT(IN_PRECISION IN NUMBER
177 ,IN_AMOUNT_DISP IN VARCHAR2) RETURN VARCHAR2;
178
179 END JE_JEDEAPVR_XMLP_PKG;
180
181