APPS.ARP_ADJUSTMENTS_MAIN dependencies on AR_DISTRIBUTIONS

Line 45: p_ard_rec OUT NOCOPY ar_distributions%ROWTYPE );

41: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ,
42: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
43: p_ctlgd_inv_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
44: p_rule_rec OUT NOCOPY ae_rule_rec_type ,
45: p_ard_rec OUT NOCOPY ar_distributions%ROWTYPE );
46:
47: -- Added parameter for Line Level Adjustment
48: PROCEDURE Create_Ae_Lines_Common (
49: p_level IN VARCHAR2,

Line 58: p_ard_rec IN ar_distributions%ROWTYPE ,

54: p_adj_rec IN ar_adjustments%ROWTYPE ,
55: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
56: p_ctlgd_inv_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
57: p_rule_rec IN ae_rule_rec_type ,
58: p_ard_rec IN ar_distributions%ROWTYPE ,
59: p_from_llca_call IN VARCHAR2 DEFAULT 'N' ,
60: p_gt_id IN NUMBER DEFAULT NULL);
61:
62: PROCEDURE Assign_Ael_Elements(

Line 332: | AR_DISTRIBUTIONS table.This routine deletes all records

328: | PROCEDURE Delete_ADJ
329: |
330: | DESCRIPTION
331: | Deletes accounting associated with a Adjustment id from the
332: | AR_DISTRIBUTIONS table.This routine deletes all records
333: | matching the input source_id. Note records from child table
334: | (AR_DISTRIBUTIONS) be deleted first.
335: |
336: | PARAMETERS

Line 334: | (AR_DISTRIBUTIONS) be deleted first.

330: | DESCRIPTION
331: | Deletes accounting associated with a Adjustment id from the
332: | AR_DISTRIBUTIONS table.This routine deletes all records
333: | matching the input source_id. Note records from child table
334: | (AR_DISTRIBUTIONS) be deleted first.
335: |
336: | PARAMETERS
337: | p_ae_deleted indicates whether records were deleted
338: | for source_id

Line 342: l_source_id ar_distributions.source_id%TYPE;

338: | for source_id
339: * ======================================================================*/
340: PROCEDURE Delete_ADJ(p_ae_deleted OUT NOCOPY BOOLEAN) IS
341:
342: l_source_id ar_distributions.source_id%TYPE;
343:
344: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
345:
346: BEGIN

Line 361: FROM ar_distributions ard

357: WHERE adj.adjustment_id = g_ae_doc_rec.source_id
358: AND adj.posting_control_id = -3
359: AND g_ae_doc_rec.source_table = 'ADJ'
360: AND EXISTS (SELECT 'x'
361: FROM ar_distributions ard
362: WHERE ard.source_id = adj.adjustment_id
363: AND ard.source_table = 'ADJ');
364:
365: /*-------------------------------------------------------------------+

Line 371: DELETE FROM AR_DISTRIBUTIONS

367: | if valid candidate for deletion |
368: +-------------------------------------------------------------------*/
369:
370: -- modified for mrc trigger elimination.
371: DELETE FROM AR_DISTRIBUTIONS
372: WHERE source_id = l_source_id
373: AND source_table = 'ADJ'
374: RETURNING line_id
375: BULK COLLECT INTO l_ar_dist_key_value_list;

Line 384: -- p_table_name => 'AR_DISTRIBUTIONS',

380: +---------------------------------*/
381: --{BUG#4301323
382: -- ar_mrc_engine.maintain_mrc_data(
383: -- p_event_mode => 'DELETE',
384: -- p_table_name => 'AR_DISTRIBUTIONS',
385: -- p_mode => 'BATCH',
386: -- p_key_value_list => l_ar_dist_key_value_list);
387: --}
388:

Line 415: | This procedure reverses the records in AR_DISTRIBUTIONS for a

411: |
412: | PROCEDURE Reverse_Adjustment
413: |
414: | DESCRIPTION
415: | This procedure reverses the records in AR_DISTRIBUTIONS for a
416: | Adjustment. It gets the accounting for the old adjustment and
417: | simply swaps the amount columns creating new accounting for the
418: | new adjustment id. Adjustment reversals occur for receivable trx id
419: | -13.

Line 476: from ar_distributions ard,

472: --}
473: ard.ref_account_class,
474: ard.activity_bucket,
475: ard.ref_dist_ccid
476: from ar_distributions ard,
477: ar_adjustments adj
478: where g_ae_sys_rec.sob_type = 'P'
479: and ard.source_id = g_ae_doc_rec.source_id_old
480: and ard.source_table = g_ae_doc_rec.source_table

Line 520: from ar_distributions ard,

516: --}
517: ard.ref_account_class,
518: ard.activity_bucket,
519: ard.ref_dist_ccid
520: from ar_distributions ard,
521: ar_adjustments adj
522: where g_ae_sys_rec.sob_type = 'P'
523: and adj.adjustment_id = g_ae_doc_rec.source_id_old
524: and ard.source_id = adj.link_to_trx_hist_id

Line 897: p_ard_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS

893: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ,
894: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
895: p_ctlgd_inv_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
896: p_rule_rec OUT NOCOPY ae_rule_rec_type ,
897: p_ard_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
898:
899: l_tax_rate_id NUMBER;
900: l_le_id NUMBER;
901: l_msg_count NUMBER;

Line 1243: ar_distributions ard

1239: p_ard_rec.ref_line_id
1240: --}
1241: from ar_transaction_history th,
1242: ar_payment_schedules pay,
1243: ar_distributions ard
1244: where
1245: th.transaction_history_id =
1246: (select max(th1.transaction_history_id)
1247: from ar_transaction_history th1

Line 1379: l_ard_rec ar_distributions%ROWTYPE ;

1375: l_adj_rec ar_adjustments%ROWTYPE ;
1376: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1377: l_ctlgd_inv_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1378: l_rule_rec ae_rule_rec_type ;
1379: l_ard_rec ar_distributions%ROWTYPE ;
1380:
1381: BEGIN
1382:
1383: IF PG_DEBUG in ('Y', 'C') THEN

Line 1452: p_ard_rec IN ar_distributions%ROWTYPE ,

1448: p_adj_rec IN ar_adjustments%ROWTYPE ,
1449: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
1450: p_ctlgd_inv_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
1451: p_rule_rec IN ae_rule_rec_type ,
1452: p_ard_rec IN ar_distributions%ROWTYPE ,
1453: p_from_llca_call IN VARCHAR2 DEFAULT 'N' ,
1454: p_gt_id IN NUMBER DEFAULT NULL) IS
1455:
1456: l_ael_line_rec ae_line_rec_type;

Line 1619: from ar_distributions ard

1615: from ar_transaction_history th
1616: where th.customer_trx_id = p_adj_rec.customer_trx_id
1617: and th.event = 'MATURITY_DATE'
1618: and exists (select 'x'
1619: from ar_distributions ard
1620: where ard.source_id = th.transaction_history_id
1621: and ard.source_table = 'TH'))
1622: where adjustment_id = p_adj_rec.adjustment_id;
1623: