PACKAGE: APPS.CE_CEXSTMSR_XMLP_PKG

Source

1 PACKAGE CE_CEXSTMSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: CEXSTMSRS.pls 120.0 2007/12/28 07:57:45 abraghun noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_SQL_TRACE VARCHAR2(32767);
6 
7   P_TEST_LAYOUT VARCHAR2(30);
8 
9   P_DEBUG_MODE VARCHAR2(32767);
10 
11   P_STAT_DATE_FROM DATE;
12   P_STAT_DATE_FROM_T VARCHAR2(44);
13 
14   P_STAT_DATE_TO DATE;
15   P_STAT_DATE_TO_T VARCHAR2(44);
16 
17   P_BANK_ACCOUNT_ID NUMBER;
18 
19   P_STAT_NUMBER_FROM VARCHAR2(50);
20 
21   P_STAT_NUMBER_TO VARCHAR2(50);
22 
23   P_BALANCES_BY VARCHAR2(30);
24 
25   P_AS_OF_DATE DATE;
26 
27   C_ALL_TRANSLATION VARCHAR2(80);
28 
29   C_BANK_NAME_DSP VARCHAR2(100);
30 
31   C_STAT_DATE_LEX VARCHAR2(200) := '1=1';
32 
33   C_SOB_NAME VARCHAR2(80);
34 
35   C_SET_OF_BOOKS_ID NUMBER;
36 
37   C_THE_END VARCHAR2(1) := 'N';
38 
39   C_FUNC_CURR_CODE VARCHAR2(15) := 'USD';
40 
41   C_BANK_BRANCH_NAME_DSP VARCHAR2(100);
42 
43   C_BANK_ACCOUNT_NUM_DSP VARCHAR2(100);
44 
45   C_BANK_ACCOUNT_NAME_DSP VARCHAR2(100);
46 
47   C_BANK_CURRENCY_CODE_DSP VARCHAR2(100);
48 
49   C_STAT_NUMBER_LEX VARCHAR2(200) := '1=1';
50 
51   C_AS_OF_DATE_DSP VARCHAR2(38);
52 
53   C_BALANCES_BY VARCHAR2(100);
54 
55   FUNCTION BEFOREREPORT RETURN BOOLEAN;
56 
57   FUNCTION AFTERREPORT RETURN BOOLEAN;
58 
59   FUNCTION C_NET_MOVEMENTFORMULA(C_STAT_END_BAL IN NUMBER
60                                 ,C_STAT_BEGIN_BAL IN NUMBER) RETURN NUMBER;
61 
62   FUNCTION C_ITEMSFORMULA(C_STAT_HEADER_ID IN NUMBER) RETURN NUMBER;
63 
64   FUNCTION C_UNREC_ITEMSFORMULA(C_STAT_HEADER_ID IN NUMBER) RETURN NUMBER;
65 
66   FUNCTION C_STAT_UNREC_AMOUNTFORMULA(C_STAT_HEADER_ID IN NUMBER) RETURN NUMBER;
67 
68   FUNCTION G_BANKGROUPFILTER(C_BANK_ID IN NUMBER) RETURN BOOLEAN;
69 
70   FUNCTION C_LINES_UNREC_AMOUNTFORMULA(C_STAT_LINE_STATUS IN VARCHAR2
71                                       ,C_STAT_LINE_TYPE IN VARCHAR2
72                                       ,C_STAT_LINE_AMOUNT IN NUMBER
73                                       ,C_LINES_SUM_CLEARED IN NUMBER) RETURN NUMBER;
74 
75   FUNCTION C_STAT_END_BALFORMULA(C_STAT_BEGIN_BAL IN NUMBER
76                                 ,C_STAT_DEBIT_AMOUNT IN NUMBER
77                                 ,C_STAT_CREDIT_AMOUNT IN NUMBER) RETURN NUMBER;
78 
79   FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN VARCHAR2;
80 
81   FUNCTION C_ALL_TRANSLATION_P RETURN VARCHAR2;
82 
83   FUNCTION C_BANK_NAME_DSP_P RETURN VARCHAR2;
84 
85   FUNCTION C_STAT_DATE_LEX_P RETURN VARCHAR2;
86 
87   FUNCTION C_SOB_NAME_P RETURN VARCHAR2;
88 
89   FUNCTION C_SET_OF_BOOKS_ID_P RETURN NUMBER;
90 
91   FUNCTION C_THE_END_P RETURN VARCHAR2;
92 
93   FUNCTION C_FUNC_CURR_CODE_P RETURN VARCHAR2;
94 
95   FUNCTION C_BANK_BRANCH_NAME_DSP_P RETURN VARCHAR2;
96 
97   FUNCTION C_BANK_ACCOUNT_NUM_DSP_P RETURN VARCHAR2;
98 
99   FUNCTION C_BANK_ACCOUNT_NAME_DSP_P RETURN VARCHAR2;
100 
101   FUNCTION C_BANK_CURRENCY_CODE_DSP_P RETURN VARCHAR2;
102 
103   FUNCTION C_STAT_NUMBER_LEX_P RETURN VARCHAR2;
104 
105   FUNCTION C_AS_OF_DATE_DSP_P RETURN VARCHAR2;
106 
107   FUNCTION C_BALANCES_BY_P RETURN VARCHAR2;
108 
109   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
110                     ,NAME IN VARCHAR2);
111 
112   /*PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
113                      ,VALUE IN VARCHAR2
114                      ,TRANSLATE IN BOOLEAN);
115 
116   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
117 
118   PROCEDURE CLEAR;
119 
120   FUNCTION GET_STRING(APPIN IN VARCHAR2
121                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;*/
122 
123   FUNCTION GET RETURN VARCHAR2;
124 
125   /*FUNCTION GET_ENCODED RETURN VARCHAR2;
126 
127   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
128                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
129                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
130 
131   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
132 
133   PROCEDURE RAISE_ERROR;
134 
135   PROCEDURE DEBUG(LINE IN VARCHAR2);
136 
137   PROCEDURE ENABLE_DEBUG;
138 
139   PROCEDURE DISABLE_DEBUG;*/
140 
141   PROCEDURE INIT_SECURITY;
142 
143   /*FUNCTION GET_WINDOW_SESSION_TITLE RETURN VARCHAR2;
144 
145   FUNCTION GET_EFFECTIVE_DATE(P_BANK_ACCOUNT_ID IN NUMBER
146                              ,P_TRX_CODE IN VARCHAR2
147                              ,P_RECEIPT_DATE IN DATE) RETURN DATE;*/
148 
149 END CE_CEXSTMSR_XMLP_PKG;
150