DBA Data[Home] [Help]

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 895: p_ctlgd_inv_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,

891: PROCEDURE Get_Doc_Entitity_Data (
892: p_level IN VARCHAR2 ,
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;

Line 1026: ra_cust_trx_line_gl_dist ctlgdinv

1022: from ar_adjustments adj ,
1023: ar_receivables_trx rt ,
1024: ar_rec_trx_le_details rtd ,
1025: ra_customer_trx ctinv ,
1026: ra_cust_trx_line_gl_dist ctlgdinv
1027: where adj.adjustment_id = g_ae_doc_rec.source_id
1028: and adj.status = 'A' --only approved adjustments
1029: and adj.receivables_trx_id = rt.receivables_trx_id
1030: and rtd.receivables_trx_id (+) = rt.receivables_trx_id

Line 1143: ra_cust_trx_line_gl_dist ctlgdinv

1139: p_rule_rec.act_vat_tax_id2
1140: from ar_adjustments adj ,
1141: ar_receivables_trx rt ,
1142: ra_customer_trx ctinv ,
1143: ra_cust_trx_line_gl_dist ctlgdinv
1144: where adj.adjustment_id = g_ae_doc_rec.source_id
1145: and adj.status = 'A' --only approved adjustments
1146: and adj.receivables_trx_id = rt.receivables_trx_id
1147: and adj.customer_trx_id = ctinv.customer_trx_id --INV REC exchange rate Information

Line 1377: l_ctlgd_inv_rec ra_cust_trx_line_gl_dist%ROWTYPE ;

1373: p_gt_id IN NUMBER DEFAULT NULL) IS
1374:
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

Line 1450: p_ctlgd_inv_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,

1446: * ======================================================================*/
1447: PROCEDURE Create_Ae_Lines_ADJ(
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