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 1396: from RA_INTERFACE_LINES il

1392: SELECT 1
1393: INTO l_exists
1394: FROM dual
1395: WHERE EXISTS (select 'at least one child'
1396: from RA_INTERFACE_LINES il
1397: where il.request_id = p_request_id
1398: and il.parent_line_id is not null);
1399:
1400: IF l_exists <> 0

Line 1441: ra_interface_lines il,

1437: plc.org_id
1438: FROM ra_customer_trx ct,
1439: ra_customer_trx_lines ctl,
1440: ra_cust_trx_types ctt,
1441: ra_interface_lines il,
1442: ar_line_conts plc
1443: WHERE ct.request_id = p_request_id
1444: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1445: AND ctt.type = 'INV'

Line 2253: ra_interface_lines il

2249: FROM ra_customer_trx ct,
2250: ra_customer_trx_lines ctl,
2251: ar_line_conts lrc,
2252: ar_interface_conts ic,
2253: ra_interface_lines il
2254: WHERE ctl.request_id = p_request_id
2255: AND ctl.customer_trx_id = ct.customer_trx_id
2256: AND ctl.customer_trx_line_id = lrc.customer_trx_line_id
2257: AND ctl.customer_trx_line_id = ic.interface_line_id

Line 2319: ra_interface_lines il

2315: MAX(il.parent_line_id)
2316: FROM ra_customer_trx ct,
2317: ra_customer_trx_lines ctl,
2318: ar_line_conts lrc,
2319: ra_interface_lines il
2320: WHERE ((p_request_id IS NULL AND p_customer_trx_line_id IS NOT NULL AND
2321: ctl.customer_trx_line_id = p_customer_trx_line_id) OR
2322: (p_request_id IS NOT NULL AND ctl.request_id = p_request_id))
2323: AND ctl.customer_trx_id = ct.customer_trx_id

Line 2517: FROM ra_interface_lines l,

2513: c.interface_contingency_id,
2514: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2515: c.contingency_id,
2516: l.org_id
2517: FROM ra_interface_lines l,
2518: ar_interface_conts c
2519: WHERE l.request_id = p_request_id
2520: AND c.interface_line_id = l.interface_line_id
2521: AND NOT EXISTS

Line 2557: FROM ra_interface_lines l,

2553: c.interface_contingency_id,
2554: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2555: c.contingency_id,
2556: l.org_id
2557: FROM ra_interface_lines l,
2558: ar_interface_conts c,
2559: ar_deferral_reasons dr
2560: WHERE l.request_id = p_request_id
2561: AND c.interface_line_id = l.interface_line_id

Line 4767: ra_interface_lines il

4763: WHERE customer_trx_id IN
4764: (
4765: SELECT DISTINCT il.customer_trx_id
4766: FROM ra_interface_errors ie,
4767: ra_interface_lines il
4768: WHERE ie.interface_line_id = il.interface_line_id
4769: AND il.request_id = p_request_id
4770: )
4771: );

Line 4783: ra_interface_lines il

4779: WHERE customer_trx_id IN
4780: (
4781: SELECT DISTINCT il.customer_trx_id
4782: FROM ra_interface_errors ie,
4783: ra_interface_lines il
4784: WHERE ie.interface_line_id = il.interface_line_id
4785: AND il.request_id = p_request_id
4786: );
4787: