APPS.ARP_CORRECT_CCID dependencies on AR_CCID_CORRECTIONS

Line 144: DELETE FROM AR_CCID_CORRECTIONS

140: END IF;
141: END IF;
142:
143: /* delete from the interim table */
144: DELETE FROM AR_CCID_CORRECTIONS
145: WHERE code_combination_id = p_old_ccid
146: AND distribution_type = p_dist_type
147: AND category_type = p_category_type
148: AND distribution_id = p_distribution_id

Line 171: | rows in the ar_ccid_corrections table.

167: | PUBLIC PROCEDURE lock_and_update
168: |
169: | DESCRIPTION
170: | This procedure will take an invalid CCID and lock and update all
171: | rows in the ar_ccid_corrections table.
172: |
173: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
174: | This is called from the form ARXGLCOR.fmb
175: |

Line 213: Update AR_CCID_CORRECTIONS

209: | Undate rows with the new CCID based on the old ccid, trx code and |
210: | distribution code. |
211: +---------------------------------------------------------------------*/
212:
213: Update AR_CCID_CORRECTIONS
214: set NEW_CODE_COMBINATION_ID = p_new_ccid,
215: submission_id = p_seq_id
216: WHERE
217: code_combination_id = p_old_ccid and

Line 284: FROM ar_ccid_corrections acc

280: last_updated_by = arp_global.last_updated_by,
281: last_update_login = arp_global.last_update_login,
282: code_combination_id = (
283: SELECT nvl(new_code_combination_id, code_combination_id)
284: FROM ar_ccid_corrections acc
285: WHERE acc.submission_id = p_submission_id
286: AND acc.source_table = 'GLD'
287: AND acc.distribution_type = gld.account_class
288: AND acc.distribution_id = gld.cust_trx_line_gl_dist_id)

Line 291: FROM ar_ccid_corrections

287: AND acc.distribution_type = gld.account_class
288: AND acc.distribution_id = gld.cust_trx_line_gl_dist_id)
289: WHERE gld.cust_trx_line_gl_dist_id in (
290: SELECT distribution_id
291: FROM ar_ccid_corrections
292: WHERE submission_id = p_submission_id
293: AND source_table = 'GLD');
294:
295: IF PG_DEBUG in ('Y', 'C') THEN

Line 307: FROM ar_ccid_corrections acc

303: last_updated_by = arp_global.last_updated_by,
304: last_update_login = arp_global.last_update_login,
305: code_combination_id = (
306: SELECT nvl(new_code_combination_id, code_combination_id)
307: FROM ar_ccid_corrections acc
308: WHERE acc.submission_id = p_submission_id
309: AND acc.distribution_id = ard.line_id
310: AND acc.source_table = ard.source_table
311: AND acc.distribution_type = ard.source_type)

Line 314: FROM ar_ccid_corrections

310: AND acc.source_table = ard.source_table
311: AND acc.distribution_type = ard.source_type)
312: WHERE ard.line_id in (
313: SELECT distribution_id
314: FROM ar_ccid_corrections
315: WHERE submission_id = p_submission_id
316: AND source_table IN ('ADJ','CRH','RA','MCD','TH'));
317:
318: IF PG_DEBUG in ('Y', 'C') THEN

Line 330: FROM ar_ccid_corrections acc

326: last_updated_by = arp_global.last_updated_by,
327: last_update_login = arp_global.last_update_login,
328: code_combination_id = (
329: SELECT nvl(new_code_combination_id, code_combination_id)
330: FROM ar_ccid_corrections acc
331: WHERE acc.submission_id = p_submission_id
332: AND acc.source_table = 'ADJ'
333: AND acc.distribution_type = 'ADJ'
334: AND acc.parent_id = adj.adjustment_id)

Line 337: FROM ar_ccid_corrections

333: AND acc.distribution_type = 'ADJ'
334: AND acc.parent_id = adj.adjustment_id)
335: WHERE adj.adjustment_id in (
336: SELECT parent_id
337: FROM ar_ccid_corrections
338: WHERE submission_id = p_submission_id
339: AND source_table = 'ADJ'
340: AND distribution_type = 'ADJ');
341:

Line 354: FROM ar_ccid_corrections acc

350: last_updated_by = arp_global.last_updated_by,
351: last_update_login = arp_global.last_update_login,
352: account_code_combination_id = (
353: SELECT nvl(new_code_combination_id, account_code_combination_id)
354: FROM ar_ccid_corrections acc
355: WHERE acc.submission_id = p_submission_id
356: AND acc.source_table = 'CRH'
357: AND acc.distribution_type = 'CASH'
358: AND acc.parent_id = crh.cash_receipt_history_id)

Line 361: FROM ar_ccid_corrections

357: AND acc.distribution_type = 'CASH'
358: AND acc.parent_id = crh.cash_receipt_history_id)
359: WHERE crh.cash_receipt_history_id in (
360: SELECT parent_id
361: FROM ar_ccid_corrections
362: WHERE submission_id = p_submission_id
363: AND source_table = 'CRH'
364: AND distribution_type = 'CASH');
365:

Line 378: FROM ar_ccid_corrections acc

374: last_updated_by = arp_global.last_updated_by,
375: last_update_login = arp_global.last_update_login,
376: code_combination_id = (
377: SELECT nvl(new_code_combination_id, code_combination_id)
378: FROM ar_ccid_corrections acc
379: WHERE acc.submission_id = p_submission_id
380: AND acc.source_table = 'MCD'
381: AND acc.distribution_type = 'MISCCASH'
382: AND acc.parent_id = mcd.misc_cash_distribution_id)

Line 385: FROM ar_ccid_corrections

381: AND acc.distribution_type = 'MISCCASH'
382: AND acc.parent_id = mcd.misc_cash_distribution_id)
383: WHERE misc_cash_distribution_id in (
384: SELECT parent_id
385: FROM ar_ccid_corrections
386: WHERE submission_id = p_submission_id
387: AND source_table = 'MCD'
388: AND distribution_type = 'MISCCASH');
389: