APPS.ARP_ADJUSTMENTS_MAIN dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 43: p_ctlgd_inv_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,

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 );
46:
47: -- Added parameter for Line Level Adjustment

Line 56: p_ctlgd_inv_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,

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 ,
59: p_from_llca_call IN VARCHAR2 DEFAULT 'N' ,
60: p_gt_id IN NUMBER DEFAULT NULL);

Line 898: p_ctlgd_inv_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,

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
901:
902: l_tax_rate_id NUMBER;

Line 1031: ra_cust_trx_line_gl_dist ctlgdinv

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
1032: where adj.adjustment_id = g_ae_doc_rec.source_id
1033: and adj.status = 'A' --only approved adjustments
1034: and adj.receivables_trx_id = rt.receivables_trx_id
1035: and rtd.receivables_trx_id (+) = rt.receivables_trx_id

Line 1150: ra_cust_trx_line_gl_dist ctlgdinv

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
1152: and adj.status = 'A' --only approved adjustments
1153: and adj.receivables_trx_id = rt.receivables_trx_id
1154: and adj.customer_trx_id = ctinv.customer_trx_id --INV REC exchange rate Information

Line 1387: l_ctlgd_inv_rec ra_cust_trx_line_gl_dist%ROWTYPE ;

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 ;
1390: l_tmp_upg_method ra_customer_trx.upgrade_method%TYPE;
1391:

Line 1473: p_ctlgd_inv_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,

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 ,
1476: p_from_llca_call IN VARCHAR2 DEFAULT 'N' ,
1477: p_gt_id IN NUMBER DEFAULT NULL) IS

Line 1727: from ra_cust_trx_line_gl_dist ctlgd

1723: IF (((p_rule_rec.tax_code_source1 = 'INVOICE') AND (p_rule_rec.tax_recoverable_flag1 = 'Y'))
1724: OR (p_rule_rec.tax_code_source1 = 'NONE') )THEN
1725: select min(code_combination_id)
1726: into l_code_combination_id
1727: from ra_cust_trx_line_gl_dist ctlgd
1728: where ctlgd.account_class = 'TAX'
1729: and ctlgd.account_set_flag = 'N'
1730: and ctlgd.customer_trx_id = p_adj_rec.customer_trx_id;
1731: