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_PROCESS_LINE dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 448: ra_cust_trx_line_gl_dist.gl_date%type

444: p_trx_amount IN number,
445: p_exchange_rate IN
446: ra_customer_trx.exchange_rate%type,
447: p_gl_date IN
448: ra_cust_trx_line_gl_dist.gl_date%type
449: )
450: IS
451:
452: l_trx_rec ra_customer_trx%rowtype;

Line 453: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

449: )
450: IS
451:
452: l_trx_rec ra_customer_trx%rowtype;
453: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
454:
455: BEGIN
456:
457: arp_util.debug('arp_process_line.header_freight_only_rules_case()+');

Line 848: p_amount1 IN ra_cust_trx_line_gl_dist.amount%type

844: DEFAULT NULL,
845: p_ccid2 IN
846: gl_code_combinations.code_combination_id%type
847: DEFAULT NULL,
848: p_amount1 IN ra_cust_trx_line_gl_dist.amount%type
849: DEFAULT NULL,
850: p_amount2 IN ra_cust_trx_line_gl_dist.amount%type
851: DEFAULT NULL,
852: p_rule_start_date OUT NOCOPY

Line 850: p_amount2 IN ra_cust_trx_line_gl_dist.amount%type

846: gl_code_combinations.code_combination_id%type
847: DEFAULT NULL,
848: p_amount1 IN ra_cust_trx_line_gl_dist.amount%type
849: DEFAULT NULL,
850: p_amount2 IN ra_cust_trx_line_gl_dist.amount%type
851: DEFAULT NULL,
852: p_rule_start_date OUT NOCOPY
853: ra_customer_trx_lines.rule_start_date%type,
854: p_accounting_rule_duration OUT NOCOPY

Line 857: ra_cust_trx_line_gl_dist.gl_date%type,

853: ra_customer_trx_lines.rule_start_date%type,
854: p_accounting_rule_duration OUT NOCOPY
855: ra_customer_trx_lines.accounting_rule_duration%type,
856: p_gl_date IN OUT NOCOPY
857: ra_cust_trx_line_gl_dist.gl_date%type,
858: p_trx_date IN OUT NOCOPY
859: ra_customer_trx.trx_date%type,
860: p_header_currency_code IN
861: ra_customer_trx.invoice_currency_code%type

Line 903: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

899:
900: --Bug#2750340
901: l_ev_rec arp_xla_events.xla_events_type;
902: /*Bug 3130851 and bug 3407389*/
903: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
904: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;
905: l_tax_computed BOOLEAN;
906: l_action VARCHAR2(12);
907: l_count NUMBER;

Line 904: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;

900: --Bug#2750340
901: l_ev_rec arp_xla_events.xla_events_type;
902: /*Bug 3130851 and bug 3407389*/
903: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
904: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;
905: l_tax_computed BOOLEAN;
906: l_action VARCHAR2(12);
907: l_count NUMBER;
908:

Line 1207: FROM ra_cust_trx_line_gl_dist

1203:
1204: BEGIN
1205: SELECT customer_trx_line_id
1206: INTO l_dist_line
1207: FROM ra_cust_trx_line_gl_dist
1208: WHERE customer_trx_line_id = p_customer_trx_line_id
1209: AND account_set_flag = 'N'
1210: AND ROWNUM < 2;
1211: EXCEPTION

Line 1359: ra_cust_trx_line_gl_dist.gl_date%type,

1355: ra_customer_trx_lines.rule_start_date%type,
1356: p_accounting_rule_duration OUT NOCOPY
1357: ra_customer_trx_lines.accounting_rule_duration%type,
1358: p_gl_date IN OUT NOCOPY
1359: ra_cust_trx_line_gl_dist.gl_date%type,
1360: p_trx_date IN OUT NOCOPY
1361: ra_customer_trx.trx_date%type,
1362: p_status OUT NOCOPY varchar2 )
1363: IS

Line 1399: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

1395: l_ev_rec arp_xla_events.xla_events_type;
1396:
1397: /*Bug 3130851 and bug 3407389*/
1398:
1399: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1400: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;
1401: l_tax_computed BOOLEAN;
1402:
1403:

Line 1400: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;

1396:
1397: /*Bug 3130851 and bug 3407389*/
1398:
1399: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1400: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;
1401: l_tax_computed BOOLEAN;
1402:
1403:
1404: --{BUG#5192414

Line 1408: ra_cust_trx_line_gl_dist d

1404: --{BUG#5192414
1405: CURSOR cpost IS
1406: SELECT 'Y'
1407: FROM ra_customer_trx_lines l,
1408: ra_cust_trx_line_gl_dist d
1409: WHERE l.customer_trx_line_id = p_customer_trx_line_id
1410: AND l.customer_trx_id = d.customer_trx_id
1411: AND d.account_set_flag = 'N'
1412: AND d.posting_Control_id <> -3;

Line 1715: FROM ra_cust_trx_line_gl_dist

1711:
1712: BEGIN
1713: SELECT customer_trx_line_id
1714: INTO l_dist_line
1715: FROM ra_cust_trx_line_gl_dist
1716: WHERE customer_trx_line_id = p_customer_trx_line_id
1717: AND account_set_flag = 'N'
1718: AND ROWNUM < 2;
1719: EXCEPTION

Line 1735: /* The logic below is mainly to hit the other rows in RA_CUST_TRX_LINE_GL_DIST which are

1731: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1732: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1733: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1734:
1735: /* The logic below is mainly to hit the other rows in RA_CUST_TRX_LINE_GL_DIST which are
1736: linked to the line updated above apart from the REC row*/
1737: DECLARE
1738: cursor c1 is select customer_trx_line_id
1739: from ra_customer_trx_lines

Line 1863: p_gl_date IN OUT NOCOPY ra_cust_trx_line_gl_dist.gl_date%type,

1859: p_recalculate_tax_flag IN boolean,
1860: p_trx_amount IN number,
1861: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1862: p_header_currency_code IN fnd_currencies.currency_code%type,
1863: p_gl_date IN OUT NOCOPY ra_cust_trx_line_gl_dist.gl_date%type,
1864: p_trx_date IN OUT NOCOPY ra_customer_trx.trx_date%type,
1865: p_line_rec IN ra_customer_trx_lines%rowtype,
1866: p_status OUT NOCOPY varchar2 ) IS
1867: