APPS.ARP_ROUNDING dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 13: trx_for_rof ra_cust_trx_line_gl_dist_all.customer_trx_id%type;

9: iTRUE CONSTANT NUMBER := 1;
10: iFALSE CONSTANT NUMBER := 0;
11: cr CONSTANT char(1) := NULL;
12:
13: trx_for_rof ra_cust_trx_line_gl_dist_all.customer_trx_id%type;
14: /*Added for Bugs 2480898, 2493896, 2497841 */
15: rqid_for_rof ra_cust_trx_line_gl_dist_all.request_id%type;
16:
17: /* 7039838 - determines if call is from an autoinvoice inspired

Line 15: rqid_for_rof ra_cust_trx_line_gl_dist_all.request_id%type;

11: cr CONSTANT char(1) := NULL;
12:
13: trx_for_rof ra_cust_trx_line_gl_dist_all.customer_trx_id%type;
14: /*Added for Bugs 2480898, 2493896, 2497841 */
15: rqid_for_rof ra_cust_trx_line_gl_dist_all.request_id%type;
16:
17: /* 7039838 - determines if call is from an autoinvoice inspired
18: session */
19: g_autoinv BOOLEAN;

Line 22: TYPE l_line_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.customer_trx_line_id%type

18: session */
19: g_autoinv BOOLEAN;
20: g_autoinv_request_id NUMBER;
21:
22: TYPE l_line_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.customer_trx_line_id%type
23: INDEX BY BINARY_INTEGER;
24: TYPE l_amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%type
25: INDEX BY BINARY_INTEGER;
26: TYPE l_percent_type IS TABLE OF ra_cust_trx_line_gl_dist_all.percent%type

Line 24: TYPE l_amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%type

20: g_autoinv_request_id NUMBER;
21:
22: TYPE l_line_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.customer_trx_line_id%type
23: INDEX BY BINARY_INTEGER;
24: TYPE l_amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%type
25: INDEX BY BINARY_INTEGER;
26: TYPE l_percent_type IS TABLE OF ra_cust_trx_line_gl_dist_all.percent%type
27: INDEX BY BINARY_INTEGER;
28: TYPE l_acct_class IS TABLE OF ra_cust_trx_line_gl_dist_all.account_class%type

Line 26: TYPE l_percent_type IS TABLE OF ra_cust_trx_line_gl_dist_all.percent%type

22: TYPE l_line_id_type IS TABLE OF ra_cust_trx_line_gl_dist_all.customer_trx_line_id%type
23: INDEX BY BINARY_INTEGER;
24: TYPE l_amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%type
25: INDEX BY BINARY_INTEGER;
26: TYPE l_percent_type IS TABLE OF ra_cust_trx_line_gl_dist_all.percent%type
27: INDEX BY BINARY_INTEGER;
28: TYPE l_acct_class IS TABLE OF ra_cust_trx_line_gl_dist_all.account_class%type
29: INDEX BY BINARY_INTEGER;
30: TYPE l_rec_offset IS TABLE OF ra_cust_trx_line_gl_dist_all.rec_offset_flag%type

Line 28: TYPE l_acct_class IS TABLE OF ra_cust_trx_line_gl_dist_all.account_class%type

24: TYPE l_amount_type IS TABLE OF ra_cust_trx_line_gl_dist_all.amount%type
25: INDEX BY BINARY_INTEGER;
26: TYPE l_percent_type IS TABLE OF ra_cust_trx_line_gl_dist_all.percent%type
27: INDEX BY BINARY_INTEGER;
28: TYPE l_acct_class IS TABLE OF ra_cust_trx_line_gl_dist_all.account_class%type
29: INDEX BY BINARY_INTEGER;
30: TYPE l_rec_offset IS TABLE OF ra_cust_trx_line_gl_dist_all.rec_offset_flag%type
31: INDEX BY BINARY_INTEGER;
32: TYPE l_date_type IS TABLE OF ra_cust_trx_line_gl_dist_all.gl_date%type

Line 30: TYPE l_rec_offset IS TABLE OF ra_cust_trx_line_gl_dist_all.rec_offset_flag%type

26: TYPE l_percent_type IS TABLE OF ra_cust_trx_line_gl_dist_all.percent%type
27: INDEX BY BINARY_INTEGER;
28: TYPE l_acct_class IS TABLE OF ra_cust_trx_line_gl_dist_all.account_class%type
29: INDEX BY BINARY_INTEGER;
30: TYPE l_rec_offset IS TABLE OF ra_cust_trx_line_gl_dist_all.rec_offset_flag%type
31: INDEX BY BINARY_INTEGER;
32: TYPE l_date_type IS TABLE OF ra_cust_trx_line_gl_dist_all.gl_date%type
33: INDEX BY BINARY_INTEGER;
34:

Line 32: TYPE l_date_type IS TABLE OF ra_cust_trx_line_gl_dist_all.gl_date%type

28: TYPE l_acct_class IS TABLE OF ra_cust_trx_line_gl_dist_all.account_class%type
29: INDEX BY BINARY_INTEGER;
30: TYPE l_rec_offset IS TABLE OF ra_cust_trx_line_gl_dist_all.rec_offset_flag%type
31: INDEX BY BINARY_INTEGER;
32: TYPE l_date_type IS TABLE OF ra_cust_trx_line_gl_dist_all.gl_date%type
33: INDEX BY BINARY_INTEGER;
34:
35: -- Private cursor
36:

Line 3731: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

3727: ORG_ID,
3728: REQUEST_ID,
3729: CUST_TRX_LINE_SALESREP_ID,
3730: 'Y'
3731: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
3732: WHERE CUST_TRX_LINE_GL_DIST_ID IN (
3733: /* SELECT GL_DIST_ID FOR EACH LINE THAT
3734: REQUIRES ROUNDING */
3735: select

Line 4295: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

4291: CUST_TRX_LINE_SALESREP_ID,
4292: REVENUE_ADJUSTMENT_ID,
4293: EVENT_ID,
4294: 'Y'
4295: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
4296: WHERE CUST_TRX_LINE_GL_DIST_ID IN (
4297: /* SELECT GL_DIST_ID FOR EACH LINE THAT
4298: REQUIRES ROUNDING */
4299: select