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_XLA_EVENTS dependencies on DBMS_SQL

Line 19: trx_status DBMS_SQL.VARCHAR2_TABLE ,

15: xla_fetch_size NUMBER --bulk fetch size
16: );
17:
18: TYPE ev_rec_type IS RECORD (
19: trx_status DBMS_SQL.VARCHAR2_TABLE ,
20: trx_number DBMS_SQL.VARCHAR2_TABLE ,
21: trx_id DBMS_SQL.NUMBER_TABLE ,
22: pstid DBMS_SQL.NUMBER_TABLE ,
23: org_id DBMS_SQL.NUMBER_TABLE ,

Line 20: trx_number DBMS_SQL.VARCHAR2_TABLE ,

16: );
17:
18: TYPE ev_rec_type IS RECORD (
19: trx_status DBMS_SQL.VARCHAR2_TABLE ,
20: trx_number DBMS_SQL.VARCHAR2_TABLE ,
21: trx_id DBMS_SQL.NUMBER_TABLE ,
22: pstid DBMS_SQL.NUMBER_TABLE ,
23: org_id DBMS_SQL.NUMBER_TABLE ,
24: dist_id DBMS_SQL.NUMBER_TABLE ,

Line 21: trx_id DBMS_SQL.NUMBER_TABLE ,

17:
18: TYPE ev_rec_type IS RECORD (
19: trx_status DBMS_SQL.VARCHAR2_TABLE ,
20: trx_number DBMS_SQL.VARCHAR2_TABLE ,
21: trx_id DBMS_SQL.NUMBER_TABLE ,
22: pstid DBMS_SQL.NUMBER_TABLE ,
23: org_id DBMS_SQL.NUMBER_TABLE ,
24: dist_id DBMS_SQL.NUMBER_TABLE ,
25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,

Line 22: pstid DBMS_SQL.NUMBER_TABLE ,

18: TYPE ev_rec_type IS RECORD (
19: trx_status DBMS_SQL.VARCHAR2_TABLE ,
20: trx_number DBMS_SQL.VARCHAR2_TABLE ,
21: trx_id DBMS_SQL.NUMBER_TABLE ,
22: pstid DBMS_SQL.NUMBER_TABLE ,
23: org_id DBMS_SQL.NUMBER_TABLE ,
24: dist_id DBMS_SQL.NUMBER_TABLE ,
25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26: dist_event_id DBMS_SQL.NUMBER_TABLE ,

Line 23: org_id DBMS_SQL.NUMBER_TABLE ,

19: trx_status DBMS_SQL.VARCHAR2_TABLE ,
20: trx_number DBMS_SQL.VARCHAR2_TABLE ,
21: trx_id DBMS_SQL.NUMBER_TABLE ,
22: pstid DBMS_SQL.NUMBER_TABLE ,
23: org_id DBMS_SQL.NUMBER_TABLE ,
24: dist_id DBMS_SQL.NUMBER_TABLE ,
25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26: dist_event_id DBMS_SQL.NUMBER_TABLE ,
27: dist_gl_date DBMS_SQL.DATE_TABLE ,

Line 24: dist_id DBMS_SQL.NUMBER_TABLE ,

20: trx_number DBMS_SQL.VARCHAR2_TABLE ,
21: trx_id DBMS_SQL.NUMBER_TABLE ,
22: pstid DBMS_SQL.NUMBER_TABLE ,
23: org_id DBMS_SQL.NUMBER_TABLE ,
24: dist_id DBMS_SQL.NUMBER_TABLE ,
25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26: dist_event_id DBMS_SQL.NUMBER_TABLE ,
27: dist_gl_date DBMS_SQL.DATE_TABLE ,
28: override_event DBMS_SQL.VARCHAR2_TABLE ,

Line 25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,

21: trx_id DBMS_SQL.NUMBER_TABLE ,
22: pstid DBMS_SQL.NUMBER_TABLE ,
23: org_id DBMS_SQL.NUMBER_TABLE ,
24: dist_id DBMS_SQL.NUMBER_TABLE ,
25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26: dist_event_id DBMS_SQL.NUMBER_TABLE ,
27: dist_gl_date DBMS_SQL.DATE_TABLE ,
28: override_event DBMS_SQL.VARCHAR2_TABLE ,
29: trx_type DBMS_SQL.VARCHAR2_TABLE ,

Line 26: dist_event_id DBMS_SQL.NUMBER_TABLE ,

22: pstid DBMS_SQL.NUMBER_TABLE ,
23: org_id DBMS_SQL.NUMBER_TABLE ,
24: dist_id DBMS_SQL.NUMBER_TABLE ,
25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26: dist_event_id DBMS_SQL.NUMBER_TABLE ,
27: dist_gl_date DBMS_SQL.DATE_TABLE ,
28: override_event DBMS_SQL.VARCHAR2_TABLE ,
29: trx_type DBMS_SQL.VARCHAR2_TABLE ,
30: posttogl DBMS_SQL.VARCHAR2_TABLE ,

Line 27: dist_gl_date DBMS_SQL.DATE_TABLE ,

23: org_id DBMS_SQL.NUMBER_TABLE ,
24: dist_id DBMS_SQL.NUMBER_TABLE ,
25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26: dist_event_id DBMS_SQL.NUMBER_TABLE ,
27: dist_gl_date DBMS_SQL.DATE_TABLE ,
28: override_event DBMS_SQL.VARCHAR2_TABLE ,
29: trx_type DBMS_SQL.VARCHAR2_TABLE ,
30: posttogl DBMS_SQL.VARCHAR2_TABLE ,
31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,

Line 28: override_event DBMS_SQL.VARCHAR2_TABLE ,

24: dist_id DBMS_SQL.NUMBER_TABLE ,
25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26: dist_event_id DBMS_SQL.NUMBER_TABLE ,
27: dist_gl_date DBMS_SQL.DATE_TABLE ,
28: override_event DBMS_SQL.VARCHAR2_TABLE ,
29: trx_type DBMS_SQL.VARCHAR2_TABLE ,
30: posttogl DBMS_SQL.VARCHAR2_TABLE ,
31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,

Line 29: trx_type DBMS_SQL.VARCHAR2_TABLE ,

25: dist_row_id DBMS_SQL.VARCHAR2_TABLE ,
26: dist_event_id DBMS_SQL.NUMBER_TABLE ,
27: dist_gl_date DBMS_SQL.DATE_TABLE ,
28: override_event DBMS_SQL.VARCHAR2_TABLE ,
29: trx_type DBMS_SQL.VARCHAR2_TABLE ,
30: posttogl DBMS_SQL.VARCHAR2_TABLE ,
31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,

Line 30: posttogl DBMS_SQL.VARCHAR2_TABLE ,

26: dist_event_id DBMS_SQL.NUMBER_TABLE ,
27: dist_gl_date DBMS_SQL.DATE_TABLE ,
28: override_event DBMS_SQL.VARCHAR2_TABLE ,
29: trx_type DBMS_SQL.VARCHAR2_TABLE ,
30: posttogl DBMS_SQL.VARCHAR2_TABLE ,
31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,

Line 31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,

27: dist_gl_date DBMS_SQL.DATE_TABLE ,
28: override_event DBMS_SQL.VARCHAR2_TABLE ,
29: trx_type DBMS_SQL.VARCHAR2_TABLE ,
30: posttogl DBMS_SQL.VARCHAR2_TABLE ,
31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,

Line 32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,

28: override_event DBMS_SQL.VARCHAR2_TABLE ,
29: trx_type DBMS_SQL.VARCHAR2_TABLE ,
30: posttogl DBMS_SQL.VARCHAR2_TABLE ,
31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,

Line 33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,

29: trx_type DBMS_SQL.VARCHAR2_TABLE ,
30: posttogl DBMS_SQL.VARCHAR2_TABLE ,
31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,

Line 34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,

30: posttogl DBMS_SQL.VARCHAR2_TABLE ,
31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,
38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,

Line 35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,

31: ev_match_event_id DBMS_SQL.NUMBER_TABLE ,
32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,
38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,
39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,

Line 36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,

32: ev_match_temp_event_id DBMS_SQL.NUMBER_TABLE ,
33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,
38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,
39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,
40: dist_dml_flag DBMS_SQL.VARCHAR2_TABLE

Line 37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,

33: ev_match_gl_date DBMS_SQL.DATE_TABLE ,
34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,
38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,
39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,
40: dist_dml_flag DBMS_SQL.VARCHAR2_TABLE
41: --{HYU Add transaction_date and legal_entity_id

Line 38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,

34: ev_match_status DBMS_SQL.VARCHAR2_TABLE ,
35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,
38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,
39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,
40: dist_dml_flag DBMS_SQL.VARCHAR2_TABLE
41: --{HYU Add transaction_date and legal_entity_id
42: ,transaction_date DBMS_SQL.DATE_TABLE

Line 39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,

35: ev_match_type DBMS_SQL.VARCHAR2_TABLE ,
36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,
38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,
39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,
40: dist_dml_flag DBMS_SQL.VARCHAR2_TABLE
41: --{HYU Add transaction_date and legal_entity_id
42: ,transaction_date DBMS_SQL.DATE_TABLE
43: ,legal_entity_id DBMS_SQL.NUMBER_TABLE

Line 40: dist_dml_flag DBMS_SQL.VARCHAR2_TABLE

36: ev_exist_id DBMS_SQL.NUMBER_TABLE ,
37: ev_exist_gl_date DBMS_SQL.DATE_TABLE ,
38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,
39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,
40: dist_dml_flag DBMS_SQL.VARCHAR2_TABLE
41: --{HYU Add transaction_date and legal_entity_id
42: ,transaction_date DBMS_SQL.DATE_TABLE
43: ,legal_entity_id DBMS_SQL.NUMBER_TABLE
44: --}

Line 42: ,transaction_date DBMS_SQL.DATE_TABLE

38: ev_exist_status DBMS_SQL.VARCHAR2_TABLE ,
39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,
40: dist_dml_flag DBMS_SQL.VARCHAR2_TABLE
41: --{HYU Add transaction_date and legal_entity_id
42: ,transaction_date DBMS_SQL.DATE_TABLE
43: ,legal_entity_id DBMS_SQL.NUMBER_TABLE
44: --}
45: );
46:

Line 43: ,legal_entity_id DBMS_SQL.NUMBER_TABLE

39: ev_exist_type DBMS_SQL.VARCHAR2_TABLE ,
40: dist_dml_flag DBMS_SQL.VARCHAR2_TABLE
41: --{HYU Add transaction_date and legal_entity_id
42: ,transaction_date DBMS_SQL.DATE_TABLE
43: ,legal_entity_id DBMS_SQL.NUMBER_TABLE
44: --}
45: );
46:
47: /*========================================================================