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 86: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;

82: FROM ar_line_app_detail_gt b,
83: ar_distributions_all a
84: WHERE b.line_id = a.line_id;
85:
86: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
87: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
88: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
89: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
90: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;

Line 87: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;

83: ar_distributions_all a
84: WHERE b.line_id = a.line_id;
85:
86: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
87: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
88: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
89: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
90: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
91: l_line_id DBMS_SQL.NUMBER_TABLE;

Line 88: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;

84: WHERE b.line_id = a.line_id;
85:
86: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
87: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
88: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
89: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
90: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
91: l_line_id DBMS_SQL.NUMBER_TABLE;
92: l_last_fetch BOOLEAN := FALSE;

Line 89: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;

85:
86: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
87: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
88: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
89: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
90: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
91: l_line_id DBMS_SQL.NUMBER_TABLE;
92: l_last_fetch BOOLEAN := FALSE;
93: l_found VARCHAR2(1);

Line 90: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;

86: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;
87: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
88: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
89: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
90: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
91: l_line_id DBMS_SQL.NUMBER_TABLE;
92: l_last_fetch BOOLEAN := FALSE;
93: l_found VARCHAR2(1);
94:

Line 91: l_line_id DBMS_SQL.NUMBER_TABLE;

87: l_from_amount_cr DBMS_SQL.NUMBER_TABLE;
88: l_from_acctd_amount_dr DBMS_SQL.NUMBER_TABLE;
89: l_from_acctd_amount_cr DBMS_SQL.NUMBER_TABLE;
90: l_activity_bucket DBMS_SQL.VARCHAR2_TABLE;
91: l_line_id DBMS_SQL.NUMBER_TABLE;
92: l_last_fetch BOOLEAN := FALSE;
93: l_found VARCHAR2(1);
94:
95: BEGIN

Line 5879: l_c := DBMS_SQL.OPEN_CURSOR;

5875: FROM gl_code_combinations
5876: WHERE chart_of_accounts_id = :coa_id
5877: AND code_combination_id = :ccid ';
5878: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
5879: l_c := DBMS_SQL.OPEN_CURSOR;
5880: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
5881: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);

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

5876: WHERE chart_of_accounts_id = :coa_id
5877: AND code_combination_id = :ccid ';
5878: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
5879: l_c := DBMS_SQL.OPEN_CURSOR;
5880: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
5881: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
5884: l_exec := DBMS_SQL.EXECUTE(l_c);

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

5877: AND code_combination_id = :ccid ';
5878: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
5879: l_c := DBMS_SQL.OPEN_CURSOR;
5880: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
5881: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
5884: l_exec := DBMS_SQL.EXECUTE(l_c);
5885: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);

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

5878: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
5879: l_c := DBMS_SQL.OPEN_CURSOR;
5880: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
5881: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
5884: l_exec := DBMS_SQL.EXECUTE(l_c);
5885: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
5886: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);

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

5879: l_c := DBMS_SQL.OPEN_CURSOR;
5880: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
5881: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
5884: l_exec := DBMS_SQL.EXECUTE(l_c);
5885: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
5886: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
5887: DBMS_SQL.CLOSE_CURSOR(l_c);

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

5880: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
5881: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
5884: l_exec := DBMS_SQL.EXECUTE(l_c);
5885: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
5886: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
5887: DBMS_SQL.CLOSE_CURSOR(l_c);
5888: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');

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

5881: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
5884: l_exec := DBMS_SQL.EXECUTE(l_c);
5885: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
5886: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
5887: DBMS_SQL.CLOSE_CURSOR(l_c);
5888: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');
5889: END;

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

5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);
5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
5884: l_exec := DBMS_SQL.EXECUTE(l_c);
5885: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
5886: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
5887: DBMS_SQL.CLOSE_CURSOR(l_c);
5888: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');
5889: END;
5890:

Line 5887: DBMS_SQL.CLOSE_CURSOR(l_c);

5883: DBMS_SQL.DEFINE_COLUMN(l_c,1,x_segment_value,30);
5884: l_exec := DBMS_SQL.EXECUTE(l_c);
5885: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
5886: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
5887: DBMS_SQL.CLOSE_CURSOR(l_c);
5888: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');
5889: END;
5890:
5891: