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 1193: FROM ra_cust_trx_line_gl_dist

1189:
1190: BEGIN
1191: SELECT customer_trx_line_id
1192: INTO l_dist_line
1193: FROM ra_cust_trx_line_gl_dist
1194: WHERE customer_trx_line_id = p_customer_trx_line_id
1195: AND account_set_flag = 'N'
1196: AND ROWNUM < 2;
1197: EXCEPTION

Line 1345: ra_cust_trx_line_gl_dist.gl_date%type,

1341: ra_customer_trx_lines.rule_start_date%type,
1342: p_accounting_rule_duration OUT NOCOPY
1343: ra_customer_trx_lines.accounting_rule_duration%type,
1344: p_gl_date IN OUT NOCOPY
1345: ra_cust_trx_line_gl_dist.gl_date%type,
1346: p_trx_date IN OUT NOCOPY
1347: ra_customer_trx.trx_date%type,
1348: p_status OUT NOCOPY varchar2 )
1349: IS

Line 1385: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

1381: l_ev_rec arp_xla_events.xla_events_type;
1382:
1383: /*Bug 3130851 and bug 3407389*/
1384:
1385: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1386: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;
1387: l_tax_computed BOOLEAN;
1388:
1389:

Line 1386: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;

1382:
1383: /*Bug 3130851 and bug 3407389*/
1384:
1385: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1386: l_dist_line ra_cust_trx_line_gl_dist.customer_trx_line_id%type;
1387: l_tax_computed BOOLEAN;
1388:
1389:
1390: --{BUG#5192414

Line 1394: ra_cust_trx_line_gl_dist d

1390: --{BUG#5192414
1391: CURSOR cpost IS
1392: SELECT 'Y'
1393: FROM ra_customer_trx_lines l,
1394: ra_cust_trx_line_gl_dist d
1395: WHERE l.customer_trx_line_id = p_customer_trx_line_id
1396: AND l.customer_trx_id = d.customer_trx_id
1397: AND d.account_set_flag = 'N'
1398: AND d.posting_Control_id <> -3;

Line 1701: FROM ra_cust_trx_line_gl_dist

1697:
1698: BEGIN
1699: SELECT customer_trx_line_id
1700: INTO l_dist_line
1701: FROM ra_cust_trx_line_gl_dist
1702: WHERE customer_trx_line_id = p_customer_trx_line_id
1703: AND account_set_flag = 'N'
1704: AND ROWNUM < 2;
1705: EXCEPTION

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

1717: ARP_CTLGD_PKG.set_to_dummy(l_dist_rec);
1718: l_dist_rec.ussgl_transaction_code := p_line_rec.DEFAULT_USSGL_TRANSACTION_CODE;
1719: ARP_CTLGD_PKG.update_f_ctl_id(l_dist_rec,p_customer_trx_line_id,'N','');
1720:
1721: /* The logic below is mainly to hit the other rows in RA_CUST_TRX_LINE_GL_DIST which are
1722: linked to the line updated above apart from the REC row*/
1723: DECLARE
1724: cursor c1 is select customer_trx_line_id
1725: from ra_customer_trx_lines

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

1845: p_recalculate_tax_flag IN boolean,
1846: p_trx_amount IN number,
1847: p_exchange_rate IN ra_customer_trx.exchange_rate%type,
1848: p_header_currency_code IN fnd_currencies.currency_code%type,
1849: p_gl_date IN OUT NOCOPY ra_cust_trx_line_gl_dist.gl_date%type,
1850: p_trx_date IN OUT NOCOPY ra_customer_trx.trx_date%type,
1851: p_line_rec IN ra_customer_trx_lines%rowtype,
1852: p_status OUT NOCOPY varchar2 ) IS
1853: