APPS.CE_COPY_TRX_CODES_XML dependencies on CE_TRANSACTION_CODES

Line 122: FROM ce_transaction_codes tc

118: -- each trx_code cannot be used by more than one trx_type
119: -- check Type, Code
120: CURSOR chk_duplicates is
121: SELECT 'Duplicate'
122: FROM ce_transaction_codes tc
123: WHERE tc.trx_code = X_trx_code
124: AND tc. bank_account_id = X_bank_account_id
125: AND (X_Row_id IS NULL OR tc.ROWID <> CHARTOROWID(X_Row_id))
126: AND EXISTS(

Line 128: FROM ce_transaction_codes tc2

124: AND tc. bank_account_id = X_bank_account_id
125: AND (X_Row_id IS NULL OR tc.ROWID <> CHARTOROWID(X_Row_id))
126: AND EXISTS(
127: SELECT 'x'
128: FROM ce_transaction_codes tc2
129: WHERE tc2.trx_code = tc.trx_code
130: AND tc2.bank_account_id = tc.bank_account_id
131: AND tc2.TRX_TYPE <> X_trx_type);
132:

Line 136: FROM ce_transaction_codes tc

132:
133: -- check Code, Priority combiniation
134: CURSOR chk_duplicates2 IS
135: SELECT 'Duplicate'
136: FROM ce_transaction_codes tc
137: WHERE tc.trx_code = X_trx_code
138: AND tc.bank_account_id = X_bank_account_id
139: AND NVL(tc.RECONCILIATION_SEQUENCE,0) = NVL(X_RECONCILIATION_SEQUENCE,0)
140: AND (X_Row_id IS NULL OR tc.ROWID <> CHARTOROWID(X_Row_id));

Line 146: FROM ce_transaction_codes tc

142:
143: -- check Code, Transaction Source combiniation
144: CURSOR chk_duplicates3 IS
145: SELECT 'Duplicate'
146: FROM ce_transaction_codes tc
147: WHERE tc.trx_code = X_trx_code
148: AND tc. bank_account_id = X_bank_account_id
149: AND NVL(tc.RECONCILE_FLAG, 'X') = NVL(X_RECONCILE_FLAG, 'X')
150: AND (X_Row_id IS NULL OR tc.ROWID <> CHARTOROWID( X_Row_id ) );

Line 219: | CE_TRANSACTION_CODES_PKG.insert_row |

215: | |
216: | ARGUMENTS |
217: | |
218: | CALLS |
219: | CE_TRANSACTION_CODES_PKG.insert_row |
220: | CE_COPY_TRX_CODES_XML.check_unique_trxn_code |
221: +========================================================================*/
222: PROCEDURE copy_trx_codes
223: IS

Line 256: FROM ce_transaction_codes

252: attribute14,
253: attribute15,
254: payroll_payment_format_id,
255: reconciliation_sequence
256: FROM ce_transaction_codes
257: WHERE bank_account_id = p_source_acct_id;
258:
259: --cursor to fetch destination accounts
260: CURSOR get_dest_accounts IS

Line 311: CE_TRANSACTION_CODES_PKG.insert_row(

307: X_reconcile_flag => SRC_TRX_CODE.reconcile_flag,
308: X_reconciliation_sequence => SRC_TRX_CODE.reconciliation_sequence);
309: IF l_validate_uniq = 'SUCCESS' THEN
310: --no exception: transaction code can be inserted
311: CE_TRANSACTION_CODES_PKG.insert_row(
312: X_Rowid => l_row_id,
313: X_Transaction_Code_Id => l_Transaction_Code_Id,
314: X_Bank_Account_Id => DEST_ACCT.Bank_Account_Id,
315: X_Trx_Code => SRC_TRX_CODE.Trx_Code,

Line 407: FROM ce_transaction_codes

403:
404: --store count of copied codes
405: SELECT count(*)
406: INTO G_INSERT_COUNT
407: FROM ce_transaction_codes
408: WHERE request_id = G_CONC_REQUEST_ID;
409: debug_log('g_insert_count::'||g_insert_count);
410:
411: debug_log('<