eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_ADJUSTMENTS_MAIN dependencies on AR_ADJUSTMENTS

Line 41: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ,

37: PROCEDURE Reverse_Adjustment;
38:
39: PROCEDURE Get_Doc_Entitity_Data (
40: p_level IN VARCHAR2 ,
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 );

Line 54: p_adj_rec IN ar_adjustments%ROWTYPE ,

50: p_from_llca_call IN VARCHAR2 DEFAULT 'N',
51: p_gt_id IN NUMBER DEFAULT NULL);
52: -- Added parameter for Line Level Adjustment
53: PROCEDURE Create_Ae_Lines_ADJ(
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 ,

Line 356: FROM ar_adjustments adj

352: | Verify that the source id is a valid candidate for deletion |
353: +-------------------------------------------------------------------*/
354: SELECT adj.adjustment_id
355: INTO l_source_id
356: FROM ar_adjustments adj
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'

Line 477: ar_adjustments adj

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
481: and nvl(ard.source_type_secondary,'X') NOT IN

Line 521: ar_adjustments adj

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
525: and ard.source_table = 'TH' --for Bills Receivable Standard/Factored

Line 566: ar_adjustments adj

562: DECODE( ard.ref_customer_trx_line_id, NULL,'N',
563: DECODE(adj.type,'CHARGES','ADDCHRG','ADDCTL')) WHICH_BUCKET
564: --}
565: from ar_mc_distributions_all ard,
566: ar_adjustments adj
567: where g_ae_sys_rec.sob_type = 'R'
568: and ard.set_of_books_id = g_ae_sys_rec.set_of_books_id
569: and ard.source_id = g_ae_doc_rec.source_id_old
570: and ard.source_table = g_ae_doc_rec.source_table

Line 608: ar_adjustments adj

604: DECODE( ard.ref_customer_trx_line_id, NULL,'N',
605: DECODE(adj.type,'CHARGES','ADDCHRG','ADDCTL')) WHICH_BUCKET
606: --}
607: from ar_mc_distributions_all ard,
608: ar_adjustments adj
609: where g_ae_sys_rec.sob_type = 'R'
610: and g_ae_sys_rec.set_of_books_id = ard.set_of_books_id
611: and adj.adjustment_id = g_ae_doc_rec.source_id_old
612: and ard.source_id = adj.link_to_trx_hist_id

Line 662: from ar_adjustments adj,

658: ctinv.bill_to_customer_id bill_to_customer_id,
659: ctinv.bill_to_site_use_id bill_to_site_use_id,
660: ctinv.drawee_id drawee_id,
661: ctinv.drawee_site_use_id drawee_site_use_id
662: from ar_adjustments adj,
663: ra_customer_trx ctinv
664: where adj.adjustment_id = g_ae_doc_rec.source_id_old
665: and adj.status = 'A'
666: and g_ae_doc_rec.source_table = 'ADJ'

Line 896: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ,

892: | p_ard_rec Distributions record used by Bills Receivable
893: * ======================================================================*/
894: PROCEDURE Get_Doc_Entitity_Data (
895: p_level IN VARCHAR2 ,
896: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ,
897: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
898: p_ctlgd_inv_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
899: p_rule_rec OUT NOCOPY ae_rule_rec_type ,
900: p_ard_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS

Line 1027: from ar_adjustments adj ,

1023: p_rule_rec.asset_tax_code2 ,
1024: p_rule_rec.liability_tax_code2 ,
1025: p_rule_rec.act_tax_non_rec_ccid2 ,
1026: p_rule_rec.act_vat_tax_id2
1027: from ar_adjustments adj ,
1028: ar_receivables_trx rt ,
1029: ar_rec_trx_le_details rtd ,
1030: ra_customer_trx ctinv ,
1031: ra_cust_trx_line_gl_dist ctlgdinv

Line 1147: from ar_adjustments adj ,

1143: p_rule_rec.asset_tax_code2 ,
1144: p_rule_rec.liability_tax_code2 ,
1145: p_rule_rec.act_tax_non_rec_ccid2 ,
1146: p_rule_rec.act_vat_tax_id2
1147: from ar_adjustments adj ,
1148: ar_receivables_trx rt ,
1149: ra_customer_trx ctinv ,
1150: ra_cust_trx_line_gl_dist ctlgdinv
1151: where adj.adjustment_id = g_ae_doc_rec.source_id

Line 1385: l_adj_rec ar_adjustments%ROWTYPE ;

1381: p_level IN VARCHAR2,
1382: p_from_llca_call IN VARCHAR2 DEFAULT 'N',
1383: p_gt_id IN NUMBER DEFAULT NULL) IS
1384:
1385: l_adj_rec ar_adjustments%ROWTYPE ;
1386: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1387: l_ctlgd_inv_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1388: l_rule_rec ae_rule_rec_type ;
1389: l_ard_rec ar_distributions%ROWTYPE ;

Line 1424: IF p_level = 'ADJ' THEN -- Entity level = ar_adjustments

1420:
1421: /*------------------------------------------------------+
1422: | Create AE Lines for Adjustment |
1423: +------------------------------------------------------*/
1424: IF p_level = 'ADJ' THEN -- Entity level = ar_adjustments
1425:
1426: /*------------------------------------------------------+
1427: | Create AE Lines for Receivables |
1428: +------------------------------------------------------*/

Line 1471: p_adj_rec IN ar_adjustments%ROWTYPE ,

1467: | p_rule_rec Rule record
1468: | p_ard_rec Distributions record used by Bills Receivable
1469: * ======================================================================*/
1470: PROCEDURE Create_Ae_Lines_ADJ(
1471: p_adj_rec IN ar_adjustments%ROWTYPE ,
1472: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
1473: p_ctlgd_inv_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
1474: p_rule_rec IN ae_rule_rec_type ,
1475: p_ard_rec IN ar_distributions%ROWTYPE ,

Line 1479: l_code_combination_id ar_adjustments.code_combination_id%TYPE; /7125756/

1475: p_ard_rec IN ar_distributions%ROWTYPE ,
1476: p_from_llca_call IN VARCHAR2 DEFAULT 'N' ,
1477: p_gt_id IN NUMBER DEFAULT NULL) IS
1478: l_subs_bal_seg VARCHAR2(1); /*7125756*/
1479: l_code_combination_id ar_adjustments.code_combination_id%TYPE; /*7125756*/
1480: l_ael_line_rec ae_line_rec_type;
1481: l_empty_ael_line_rec ae_line_rec_type;
1482: l_app_rec ar_receivable_applications%ROWTYPE;
1483: l_ae_line_tbl ae_line_tbl_type;

Line 1486: l_actual_ccid ar_adjustments.code_combination_id%TYPE := null;

1482: l_app_rec ar_receivable_applications%ROWTYPE;
1483: l_ae_line_tbl ae_line_tbl_type;
1484: l_ae_ctr BINARY_INTEGER := 0;
1485: l_ctr BINARY_INTEGER;
1486: l_actual_ccid ar_adjustments.code_combination_id%TYPE := null;
1487:
1488: BEGIN
1489: IF PG_DEBUG in ('Y', 'C') THEN
1490: arp_standard.debug( 'Create_Ae_Lines_ADJ.Create_Ae_Lines_ADJ()+');

Line 1637: update ar_adjustments

1633: | event is seperate from the creation of the adjustment, for approved |
1634: | Endorsments, we need to update the link id so the last Transaction |
1635: | History Record must be for Matured Pending Risk elimination Endorsment|
1636: +-----------------------------------------------------------------------*/
1637: update ar_adjustments
1638: set link_to_trx_hist_id = (select max(th.transaction_history_id)
1639: from ar_transaction_history th
1640: where th.customer_trx_id = p_adj_rec.customer_trx_id
1641: and th.event = 'MATURITY_DATE'