APPS.ARP_EBS_AUTOINV_PREPROC dependencies on RA_INTERFACE_LINES

Line 10: FROM RA_INTERFACE_LINES_GT l,

6: p_error_code IN OUT NOCOPY NUMBER ) IS
7:
8: CURSOR curr_code IS
9: SELECT distinct l.currency_code, curr.end_date_active
10: FROM RA_INTERFACE_LINES_GT l,
11: FND_CURRENCIES curr
12: WHERE l.request_id = p_request_id
13: AND l.currency_code = curr.currency_code
14: AND curr.derive_type = 'EMU' ;

Line 33: FROM RA_INTERFACE_LINES

29: SELECT interface_line_id,
30: err_msg,
31: NULL,
32: org_id
33: FROM RA_INTERFACE_LINES
34: WHERE request_id = p_request_id
35: AND trx_date > NVL(rec.end_date_active,
36: to_date('31-12-2001','DD-MM-YYYY'))
37: AND currency_code = rec.currency_code

Line 53: from ra_interface_lines_gt

49: dist.amount ),
50: acctd_amount = null
51: WHERE interface_line_id in (
52: select interface_line_id
53: from ra_interface_lines_gt
54: where request_id = p_request_id
55: and trx_date > NVL(rec.end_date_active,
56: to_date('31-12-2001','DD-MM-YYYY'))
57: and currency_code = rec.currency_code)

Line 69: from ra_interface_lines_gt

65: 'EMU FIXED',
66: salescred.sales_credit_amount_split )
67: WHERE interface_line_id in (
68: select interface_line_id
69: from ra_interface_lines_gt
70: where request_id = p_request_id
71: and trx_date > NVL(rec.end_date_active,
72: to_date('31-12-2001','DD-MM-YYYY'))
73: and currency_code = rec.currency_code)

Line 78: UPDATE ra_interface_lines_gt l

74: AND sales_credit_amount_split is not null;
75:
76:
77: -- Update credit memo headers
78: UPDATE ra_interface_lines_gt l
79: SET
80: reference_line_id = NULL,
81: reference_line_context = NULL,
82: reference_line_attribute1 = NULL,

Line 109: UPDATE ra_interface_lines_gt l

105:
106: -- Update invoice and CM headers
107:
108: /* 4448712 - Need to update tax lines with null trx_dates too */
109: UPDATE ra_interface_lines_gt l
110: SET currency_code = p_func_curr_code,
111: conversion_rate = 1,
112: conversion_type = 'User',
113: amount = GL_CURRENCY_API.convert_amount( l.currency_code,

Line 134: FROM ra_interface_lines PARENT

130: AND (trx_date > NVL(rec.end_date_active,
131: to_date('31-12-2001','DD-MM-YYYY'))
132: OR EXISTS (
133: SELECT 'child needs processing'
134: FROM ra_interface_lines PARENT
135: WHERE l.link_to_line_id = PARENT.interface_line_id
136: AND PARENT.trx_date > NVL(rec.end_date_active,
137: to_date('31-12-2001', 'DD-MM-YYYY'))
138: AND PARENT.request_id = p_request_id