APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_INTERFACE_LINES

Line 26: g_om_context ra_interface_lines.interface_line_context%type;

22: g_currency_code_f fnd_currencies.currency_code%TYPE;
23: g_precision_f fnd_currencies.precision%TYPE;
24: g_minimum_accountable_unit_f fnd_currencies.minimum_accountable_unit%TYPE;
25: g_source VARCHAR2(30);
26: g_om_context ra_interface_lines.interface_line_context%type;
27:
28: pg_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
29:
30:

Line 1468: from RA_INTERFACE_LINES il

1464: SELECT 1
1465: INTO l_exists
1466: FROM dual
1467: WHERE EXISTS (select 'at least one child'
1468: from RA_INTERFACE_LINES il
1469: where il.request_id = p_request_id
1470: and il.parent_line_id is not null);
1471:
1472: IF l_exists <> 0

Line 1513: ra_interface_lines il,

1509: plc.org_id
1510: FROM ra_customer_trx ct,
1511: ra_customer_trx_lines ctl,
1512: ra_cust_trx_types ctt,
1513: ra_interface_lines il,
1514: ar_line_conts plc
1515: WHERE ct.request_id = p_request_id
1516: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1517: AND nvl(ct.invoicing_rule_id, 0) <> -3 /* 11711172 */

Line 2367: ra_interface_lines il

2363: FROM ra_customer_trx ct,
2364: ra_customer_trx_lines ctl,
2365: ar_line_conts lrc,
2366: ar_interface_conts ic,
2367: ra_interface_lines il
2368: WHERE ctl.request_id = p_request_id
2369: AND ctl.customer_trx_id = ct.customer_trx_id
2370: AND ctl.customer_trx_line_id = lrc.customer_trx_line_id
2371: AND ctl.customer_trx_line_id = ic.interface_line_id

Line 2433: ra_interface_lines il

2429: MAX(il.parent_line_id)
2430: FROM ra_customer_trx ct,
2431: ra_customer_trx_lines ctl,
2432: ar_line_conts lrc,
2433: ra_interface_lines il
2434: WHERE ((p_request_id IS NULL AND p_customer_trx_line_id IS NOT NULL AND
2435: ctl.customer_trx_line_id = p_customer_trx_line_id) OR
2436: (p_request_id IS NOT NULL AND ctl.request_id = p_request_id))
2437: AND ctl.customer_trx_id = ct.customer_trx_id

Line 2664: FROM ra_interface_lines l,

2660: c.interface_contingency_id,
2661: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2662: c.contingency_id,
2663: l.org_id
2664: FROM ra_interface_lines l,
2665: ar_interface_conts c
2666: WHERE l.request_id = p_request_id
2667: AND c.interface_line_id = l.interface_line_id
2668: AND NOT EXISTS

Line 2704: FROM ra_interface_lines l,

2700: c.interface_contingency_id,
2701: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2702: c.contingency_id,
2703: l.org_id
2704: FROM ra_interface_lines l,
2705: ar_interface_conts c,
2706: ar_deferral_reasons dr
2707: WHERE l.request_id = p_request_id
2708: AND c.interface_line_id = l.interface_line_id

Line 4934: ra_interface_lines il

4930: WHERE customer_trx_id IN
4931: (
4932: SELECT DISTINCT il.customer_trx_id
4933: FROM ra_interface_errors ie,
4934: ra_interface_lines il
4935: WHERE ie.interface_line_id = il.interface_line_id
4936: AND il.request_id = p_request_id
4937: )
4938: );

Line 4950: ra_interface_lines il

4946: WHERE customer_trx_id IN
4947: (
4948: SELECT DISTINCT il.customer_trx_id
4949: FROM ra_interface_errors ie,
4950: ra_interface_lines il
4951: WHERE ie.interface_line_id = il.interface_line_id
4952: AND il.request_id = p_request_id
4953: );
4954: