[Home] [Help]
PACKAGE: APPS.CE_TRANSACTION_CODES_PKG
Source
1 PACKAGE CE_TRANSACTION_CODES_PKG AUTHID CURRENT_USER as
2 /* $Header: cetrxcds.pls 120.4.12010000.2 2009/07/31 09:30:56 vnetan ship $ */
3 G_spec_revision VARCHAR2(1000) := '$Revision: 120.4.12010000.2 $';
4
5 FUNCTION spec_revision RETURN VARCHAR2;
6 FUNCTION body_revision RETURN VARCHAR2;
7
8 --
9 -- Procedure
10 -- Insert_Row
11 -- Purpose
12 -- Inserts a row into ce_transaction_codes
13 -- History
14 -- 00-00-94 Dean McCarthy Created
15 -- 07-20-09 vnetan 8707463: Added REQUEST_ID column
16 -- Arguments
17 -- all the columns of the table ce_transaction_codes
18 -- Example
19 -- ce_transaction_codes.Insert_Row(....;
20 -- Notes
21 --
22 PROCEDURE Insert_Row(
23 X_Rowid IN OUT NOCOPY VARCHAR2,
24 X_Transaction_Code_Id IN OUT NOCOPY NUMBER,
25 X_Bank_Account_Id NUMBER,
26 X_Trx_Code VARCHAR2,
27 X_Trx_Type VARCHAR2,
28 X_Description VARCHAR2,
29 X_Receivables_Trx_Id NUMBER,
30 X_Receipt_Method_Id NUMBER,
31 X_Create_Misc_Trx_Flag VARCHAR2,
32 X_Reconcile_flag VARCHAR2,
33 X_Float_Days NUMBER,
34 X_Matching_Against VARCHAR2,
35 X_Correction_Method VARCHAR2,
36 X_Start_Date DATE,
37 X_End_Date DATE,
38 X_Attribute_Category VARCHAR2,
39 X_Attribute1 VARCHAR2,
40 X_Attribute2 VARCHAR2,
41 X_Attribute3 VARCHAR2,
42 X_Attribute4 VARCHAR2,
43 X_Attribute5 VARCHAR2,
44 X_Attribute6 VARCHAR2,
45 X_Attribute7 VARCHAR2,
46 X_Attribute8 VARCHAR2,
47 X_Attribute9 VARCHAR2,
48 X_Attribute10 VARCHAR2,
49 X_Attribute11 VARCHAR2,
50 X_Attribute12 VARCHAR2,
51 X_Attribute13 VARCHAR2,
52 X_Attribute14 VARCHAR2,
53 X_Attribute15 VARCHAR2,
54 X_Last_Updated_By NUMBER,
55 X_Last_Update_Date DATE,
56 X_Last_Update_Login NUMBER,
57 X_Created_By NUMBER,
58 X_Creation_Date DATE,
59 X_payroll_payment_format_Id NUMBER DEFAULT NULL,
60 X_reconciliation_sequence NUMBER,
61 X_request_id NUMBER DEFAULT NULL -- 8707463: Added
62 );
63 --
64 -- Procedure
65 -- Lock_Row
66 -- Purpose
67 -- Locks a row into ce_transaction_codes
68 -- History
69 -- 00-00-94 Dean McCarthy Created
70 -- Arguments
71 -- all the columns of the table ce_transaction_codes
72 -- Example
73 -- ce_transaction_codes.Lock_Row(....;
74 -- Notes
75 --
76 PROCEDURE Lock_Row(
77 X_Rowid VARCHAR2,
78 X_Transaction_Code_Id NUMBER,
79 X_Bank_Account_Id NUMBER,
80 X_Trx_Code VARCHAR2,
81 X_Trx_Type VARCHAR2,
82 X_Description VARCHAR2,
83 X_Receivables_Trx_Id NUMBER,
84 X_Receipt_Method_Id NUMBER,
85 X_Create_Misc_Trx_Flag VARCHAR2,
86 X_Reconcile_Flag VARCHAR2,
87 X_Float_Days NUMBER,
88 X_Matching_Against VARCHAR2,
89 X_Correction_Method VARCHAR2,
90 X_Start_Date DATE,
91 X_End_Date DATE,
92 X_Attribute_Category VARCHAR2,
93 X_Attribute1 VARCHAR2,
94 X_Attribute2 VARCHAR2,
95 X_Attribute3 VARCHAR2,
96 X_Attribute4 VARCHAR2,
97 X_Attribute5 VARCHAR2,
98 X_Attribute6 VARCHAR2,
99 X_Attribute7 VARCHAR2,
100 X_Attribute8 VARCHAR2,
101 X_Attribute9 VARCHAR2,
102 X_Attribute10 VARCHAR2,
103 X_Attribute11 VARCHAR2,
104 X_Attribute12 VARCHAR2,
105 X_Attribute13 VARCHAR2,
106 X_Attribute14 VARCHAR2,
107 X_Attribute15 VARCHAR2,
108 X_payroll_payment_format_Id NUMBER DEFAULT NULL,
109 X_reconciliation_sequence NUMBER
110 );
111 --
112 -- Procedure
113 -- Update_Row
114 -- Purpose
115 -- Updates a row into cb_transaction_codes
116 -- History
117 -- 00-00-94 Dean McCarthy Created
118 -- 07-20-09 vnetan 8707463: Added REQUEST_ID column
119 -- Arguments
120 -- all the columns of the table ce_transaction_codes
121 -- Example
122 -- ce_transaction_codes.Update_Row(....;
123 -- Notes
124 --
125 PROCEDURE Update_Row(
126 X_Rowid VARCHAR2,
127 X_Transaction_Code_Id NUMBER,
128 X_Bank_Account_Id NUMBER,
129 X_Trx_Code VARCHAR2,
130 X_Trx_Type VARCHAR2,
131 X_Description VARCHAR2,
132 X_Receivables_Trx_Id NUMBER,
133 X_Receipt_Method_Id NUMBER,
134 X_Create_Misc_Trx_Flag VARCHAR2,
135 X_Reconcile_Flag VARCHAR2,
136 X_Float_Days NUMBER,
137 X_Matching_Against VARCHAR2,
138 X_Correction_Method VARCHAR2,
139 X_Start_Date DATE,
140 X_End_Date DATE,
141 X_Attribute_Category VARCHAR2,
142 X_Attribute1 VARCHAR2,
143 X_Attribute2 VARCHAR2,
144 X_Attribute3 VARCHAR2,
145 X_Attribute4 VARCHAR2,
146 X_Attribute5 VARCHAR2,
147 X_Attribute6 VARCHAR2,
148 X_Attribute7 VARCHAR2,
149 X_Attribute8 VARCHAR2,
150 X_Attribute9 VARCHAR2,
151 X_Attribute10 VARCHAR2,
152 X_Attribute11 VARCHAR2,
153 X_Attribute12 VARCHAR2,
154 X_Attribute13 VARCHAR2,
155 X_Attribute14 VARCHAR2,
156 X_Attribute15 VARCHAR2,
157 X_Last_Updated_By NUMBER,
158 X_Last_Update_Date DATE,
159 X_Last_Update_Login NUMBER,
160 X_payroll_payment_format_id NUMBER DEFAULT NULL,
161 X_reconciliation_sequence NUMBER,
162 X_request_id NUMBER DEFAULT NULL -- 8707463: Added
163 );
164 --
165 -- Procedure
166 -- Delete_Row
167 -- Purpose
168 -- Deletes a row from cb_transaction_codes
169 -- History
170 -- 00-00-94 Dean McCarhty Created
171 -- Arguments
172 -- x_rowid Rowid of a row
173 -- Example
174 -- cb_transaction_codes.delete_row('ajfdshj');
175 -- Notes
176 --
177 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
178 --
179 -- Procedure
180 -- check_unique_txn_code
181 -- Purpose
182 -- Checks for uniquness of Transaction codes before
183 -- insertion and updates for a given bank code
184 -- History
185 -- 11-Jun-95 Ganesh Vaidee Created
186 -- 16-Jun-05 lkwan bug 4435028 - new unique validate rules
187 -- Users should be able to enter the following
188 -- Type Code Transaction Source Priority
189 -- Payment 100 AP Payments 1
190 -- Payment 100 Payroll 2
191 -- Payment 100 Cash Management 3
192 -- Arguments
193 -- x_row_id Rowid of a row
194 -- X_trx_code Transaction code of row to be inserted or updated
195 -- X_bank_account_id Bank Account Id
196 -- X_trx_type DEBIT, CREDIT, MISC_DEBIT, MISC_CREDIT, NSF, REJECTED, STOP
197 -- X_RECONCILE_FLAG null, AR, AP, JE, CE, OI
198 -- X_RECONCILIATION_SEQUENCE null, 1,2,3 ...
199 -- Example
200 -- ce_transaction_codes.check_unique_txn_code('ajfdshj', 11, '123.657.99', DEBIT, AP, 1 );
201 -- Notes
202 --
203 PROCEDURE check_unique_txn_code(
204 X_trx_code IN VARCHAR2,
205 X_bank_account_id IN NUMBER,
206 X_row_id IN VARCHAR2,
207 X_trx_type IN VARCHAR2,
208 X_reconcile_flag IN VARCHAR2,
209 X_reconciliation_sequence IN NUMBER );
210
211 --
212 -- Function
213 -- Is In Use
214 -- Purpose
215 -- Checks whether this transaction code is referenced by a statement line or
216 -- archived statement line.
217 -- History
218 -- 11-AUG-97 JaeSon Kim Created
219 -- Arguments
220 -- CE_TRANSACTION_CODE_ID
221 -- Notes
222 --
223 FUNCTION is_in_use( X_ce_transaction_code_id NUMBER) RETURN BOOLEAN;
224
225 END CE_TRANSACTION_CODES_PKG;