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

Line 425: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;

421: FROM ar_line_app_detail_gt b,
422: ar_distributions_all a
423: WHERE b.line_id = a.line_id;
424:
425: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
426: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
427: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
428: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
429: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;

Line 426: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;

422: ar_distributions_all a
423: WHERE b.line_id = a.line_id;
424:
425: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
426: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
427: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
428: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
429: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
430: l_line_id DBMS_SQL.NUMBER_TABLE;

Line 427: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;

423: WHERE b.line_id = a.line_id;
424:
425: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
426: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
427: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
428: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
429: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
430: l_line_id DBMS_SQL.NUMBER_TABLE;
431: l_last_fetch BOOLEAN := FALSE;

Line 428: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;

424:
425: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
426: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
427: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
428: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
429: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
430: l_line_id DBMS_SQL.NUMBER_TABLE;
431: l_last_fetch BOOLEAN := FALSE;
432: l_found VARCHAR2(1);

Line 429: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;

425: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
426: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
427: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
428: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
429: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
430: l_line_id DBMS_SQL.NUMBER_TABLE;
431: l_last_fetch BOOLEAN := FALSE;
432: l_found VARCHAR2(1);
433:

Line 430: l_line_id DBMS_SQL.NUMBER_TABLE;

426: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
427: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
428: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
429: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
430: l_line_id DBMS_SQL.NUMBER_TABLE;
431: l_last_fetch BOOLEAN := FALSE;
432: l_found VARCHAR2(1);
433:
434: BEGIN

Line 8555: l_c := DBMS_SQL.OPEN_CURSOR;

8551: FROM gl_code_combinations
8552: WHERE chart_of_accounts_id = :coa_id
8553: AND code_combination_id = :ccid ';
8554: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
8555: l_c := DBMS_SQL.OPEN_CURSOR;
8556: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);

Line 8556: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);

8552: WHERE chart_of_accounts_id = :coa_id
8553: AND code_combination_id = :ccid ';
8554: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
8555: l_c := DBMS_SQL.OPEN_CURSOR;
8556: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
8560: l_exec := DBMS_SQL.EXECUTE(l_c);

Line 8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);

8553: AND code_combination_id = :ccid ';
8554: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
8555: l_c := DBMS_SQL.OPEN_CURSOR;
8556: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
8560: l_exec := DBMS_SQL.EXECUTE(l_c);
8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);

Line 8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);

8554: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
8555: l_c := DBMS_SQL.OPEN_CURSOR;
8556: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
8560: l_exec := DBMS_SQL.EXECUTE(l_c);
8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
8562: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);

Line 8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);

8555: l_c := DBMS_SQL.OPEN_CURSOR;
8556: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
8560: l_exec := DBMS_SQL.EXECUTE(l_c);
8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
8562: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
8563: DBMS_SQL.CLOSE_CURSOR(l_c);

Line 8560: l_exec := DBMS_SQL.EXECUTE(l_c);

8556: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
8560: l_exec := DBMS_SQL.EXECUTE(l_c);
8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
8562: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
8563: DBMS_SQL.CLOSE_CURSOR(l_c);
8564: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');

Line 8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);

8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
8560: l_exec := DBMS_SQL.EXECUTE(l_c);
8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
8562: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
8563: DBMS_SQL.CLOSE_CURSOR(l_c);
8564: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');
8565: END;

Line 8562: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);

8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
8560: l_exec := DBMS_SQL.EXECUTE(l_c);
8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
8562: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
8563: DBMS_SQL.CLOSE_CURSOR(l_c);
8564: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');
8565: END;
8566:

Line 8563: DBMS_SQL.CLOSE_CURSOR(l_c);

8559: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
8560: l_exec := DBMS_SQL.EXECUTE(l_c);
8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
8562: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
8563: DBMS_SQL.CLOSE_CURSOR(l_c);
8564: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');
8565: END;
8566:
8567: /*-------------------------------------------------------------------------------+