[Home] [Help]
PACKAGE: APPS.CE_CEXRECRE_XMLP_PKG
Source
1 PACKAGE CE_CEXRECRE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CEXRECRES.pls 120.0 2007/12/28 07:56:38 abraghun noship $ */
3
4 P_CONC_REQUEST_ID NUMBER := 0;
5
6 P_SQL_TRACE VARCHAR2(32767);
7
8 P_TEST_LAYOUT VARCHAR2(30);
9
10 P_DEBUG_MODE VARCHAR2(32767);
11
12 P_BANK_ACCOUNT_ID NUMBER;
13
14 P_PERIOD_NAME VARCHAR2(15);
15
16 P_CLOSING_STATEMENT_NUMBER VARCHAR2(50);
17
18 P_CLOSING_BALANCE VARCHAR2(100);
19
20 P_SUMM_OR_DETAIL VARCHAR2(32767);
21
22 P_CLEARING_CCID NUMBER;
23
24 P_RECON_ACCOUNTING_FLAG VARCHAR2(32767);
25
26 P_RECON_USED_FLAG VARCHAR2(32767) := 'N';
27
28 C_CASHBOOK_BEGIN_DATE VARCHAR2(40);
29
30 C_BANK_NAME_DSP VARCHAR2(60);
31
32 C_ACCOUNT_NAME_DSP VARCHAR2(80);
33
34 C_BANK_BRANCH_DSP VARCHAR2(60);
35
36 C_ALL_TRANSLATION VARCHAR2(80);
37
38 C_THE_END VARCHAR2(1) := 'N';
39
40 C_GL_CURRENCY_CODE VARCHAR2(15);
41
42 C_NAME VARCHAR2(80);
43
44 C_SET_OF_BOOKS_ID NUMBER;
45
46 C_BANK_CURR_DSP VARCHAR2(15);
47
48 C_ACCOUNT_NUMBER_DSP VARCHAR2(50);
49
50 C_ASSET_CC_ID NUMBER;
51
52 C_AS_OF_DATE DATE;
53
54 C_CHART_OF_ACCOUNTS_ID NUMBER;
55
56 C_FLEXDATA VARCHAR2(1000) := '(segment1||''-''||segment2||''-''||segment3||''-''
57 ||segment4||''-''||segment5||''-''||segment6||''-''||segment7||''-''||segment8
58 ||''-''||segment9||''-''||segment10||''-''||segment11||''-''||segment12||''-''
59 ||segment13||''-''||segment14||''-''||segment15||''-''||segment16||''-''||segment17
60 ||''-''||segment18||''-''||segment19||''-''||segment20||''-''||segment21||''-''
61 ||segment22||''-''||segment23||''-''||segment24||''-''||segment25||''-''||segment26
62 ||''-''||segment27||''-''||segment28||''-''||segment29||''-''||segment30)';
63
64 C_ADJUSTED_BANK_BALANCE NUMBER;
65
66 C_DIFFERENCE NUMBER;
67
68 FUNCTION BEFOREREPORT RETURN BOOLEAN;
69
70 FUNCTION AFTERREPORT RETURN BOOLEAN;
71
72 FUNCTION C_REP_FLEXDATA_DSPFORMULA(C_FLEXDATA_DSP IN VARCHAR2) RETURN VARCHAR2;
73
74 FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN VARCHAR2;
75
76 FUNCTION CF_CLOSING_BALANCEFORMULA RETURN NUMBER;
77
78 FUNCTION C_BANK_NAME_DSP_P RETURN VARCHAR2;
79
80 FUNCTION C_ACCOUNT_NAME_DSP_P RETURN VARCHAR2;
81
82 FUNCTION C_BANK_BRANCH_DSP_P RETURN VARCHAR2;
83
84 FUNCTION C_ALL_TRANSLATION_P RETURN VARCHAR2;
85
86 FUNCTION C_THE_END_P RETURN VARCHAR2;
87
88 FUNCTION C_GL_CURRENCY_CODE_P RETURN VARCHAR2;
89
90 FUNCTION C_NAME_P RETURN VARCHAR2;
91
92 FUNCTION C_SET_OF_BOOKS_ID_P RETURN NUMBER;
93
94 FUNCTION C_BANK_CURR_DSP_P RETURN VARCHAR2;
95
96 FUNCTION C_ACCOUNT_NUMBER_DSP_P RETURN VARCHAR2;
97
98 FUNCTION C_ASSET_CC_ID_P RETURN NUMBER;
99
100 FUNCTION C_AS_OF_DATE_P RETURN DATE;
101
102 FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
103
104 FUNCTION C_FLEXDATA_P RETURN VARCHAR2;
105
106 FUNCTION C_ADJUSTED_BANK_BALANCE_P RETURN NUMBER;
107
108 FUNCTION C_DIFFERENCE_P RETURN NUMBER;
109
110 /* PROCEDURE DEBUG(LINE IN VARCHAR2);
111
112 PROCEDURE ENABLE_DEBUG;
113
114 PROCEDURE DISABLE_DEBUG;*/
115
116 PROCEDURE INIT_SECURITY;
117
118 /*FUNCTION GET_WINDOW_SESSION_TITLE RETURN VARCHAR2;
119
120 FUNCTION GET_EFFECTIVE_DATE(P_BANK_ACCOUNT_ID IN NUMBER
121 ,P_TRX_CODE IN VARCHAR2
122 ,P_RECEIPT_DATE IN DATE) RETURN DATE;*/
123
124 PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
125 ,NAME IN VARCHAR2);
126
127 /* PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
128 ,VALUE IN VARCHAR2
129 ,TRANSLATE IN BOOLEAN);
130
131 PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
132
133 PROCEDURE CLEAR;
134
135 FUNCTION GET_STRING(APPIN IN VARCHAR2
136 ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
137
138 FUNCTION GET_NUMBER(APPIN IN VARCHAR2
139 ,NAMEIN IN VARCHAR2) RETURN NUMBER;*/
140
141 FUNCTION GET RETURN VARCHAR2;
142
143 /*FUNCTION GET_ENCODED RETURN VARCHAR2;
144
145 PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
146 ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
147 ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
148
149 PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
150
151 PROCEDURE RAISE_ERROR;*/
152
153 END CE_CEXRECRE_XMLP_PKG;
154