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.AR_AGING_BUCKETS_PKG dependencies on DBMS_SQL

Line 1494: l_stmt_cursor := dbms_sql.open_cursor;

1490: l_from_clause ;
1491:
1492: arp_standard.debug( l_final_stmt );
1493:
1494: l_stmt_cursor := dbms_sql.open_cursor;
1495: dbms_sql.parse (l_stmt_cursor,l_final_stmt,dbms_sql.v7);
1496:
1497: dbms_sql.bind_variable (l_stmt_cursor,':as_of_date',pg_in_as_of_date_low);
1498: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_currency',pg_in_currency);

Line 1495: dbms_sql.parse (l_stmt_cursor,l_final_stmt,dbms_sql.v7);

1491:
1492: arp_standard.debug( l_final_stmt );
1493:
1494: l_stmt_cursor := dbms_sql.open_cursor;
1495: dbms_sql.parse (l_stmt_cursor,l_final_stmt,dbms_sql.v7);
1496:
1497: dbms_sql.bind_variable (l_stmt_cursor,':as_of_date',pg_in_as_of_date_low);
1498: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_currency',pg_in_currency);
1499:

Line 1497: dbms_sql.bind_variable (l_stmt_cursor,':as_of_date',pg_in_as_of_date_low);

1493:
1494: l_stmt_cursor := dbms_sql.open_cursor;
1495: dbms_sql.parse (l_stmt_cursor,l_final_stmt,dbms_sql.v7);
1496:
1497: dbms_sql.bind_variable (l_stmt_cursor,':as_of_date',pg_in_as_of_date_low);
1498: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_currency',pg_in_currency);
1499:
1500: IF pg_in_customer_num_low IS NOT NULL THEN
1501: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_low',pg_in_customer_num_low);

Line 1498: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_currency',pg_in_currency);

1494: l_stmt_cursor := dbms_sql.open_cursor;
1495: dbms_sql.parse (l_stmt_cursor,l_final_stmt,dbms_sql.v7);
1496:
1497: dbms_sql.bind_variable (l_stmt_cursor,':as_of_date',pg_in_as_of_date_low);
1498: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_currency',pg_in_currency);
1499:
1500: IF pg_in_customer_num_low IS NOT NULL THEN
1501: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_low',pg_in_customer_num_low);
1502: END IF;

Line 1501: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_low',pg_in_customer_num_low);

1497: dbms_sql.bind_variable (l_stmt_cursor,':as_of_date',pg_in_as_of_date_low);
1498: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_currency',pg_in_currency);
1499:
1500: IF pg_in_customer_num_low IS NOT NULL THEN
1501: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_low',pg_in_customer_num_low);
1502: END IF;
1503: IF pg_in_customer_num_high IS NOT NULL THEN
1504: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_high',pg_in_customer_num_high);
1505: END IF;

Line 1504: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_high',pg_in_customer_num_high);

1500: IF pg_in_customer_num_low IS NOT NULL THEN
1501: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_low',pg_in_customer_num_low);
1502: END IF;
1503: IF pg_in_customer_num_high IS NOT NULL THEN
1504: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_high',pg_in_customer_num_high);
1505: END IF;
1506: IF pg_in_customer_name_low IS NOT NULL THEN
1507: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_name_low',pg_in_customer_name_low);
1508: END IF;

Line 1507: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_name_low',pg_in_customer_name_low);

1503: IF pg_in_customer_num_high IS NOT NULL THEN
1504: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_num_high',pg_in_customer_num_high);
1505: END IF;
1506: IF pg_in_customer_name_low IS NOT NULL THEN
1507: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_name_low',pg_in_customer_name_low);
1508: END IF;
1509: IF pg_in_customer_name_high IS NOT NULL THEN
1510: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_name_high',pg_in_customer_name_high);
1511: END IF;

Line 1510: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_name_high',pg_in_customer_name_high);

1506: IF pg_in_customer_name_low IS NOT NULL THEN
1507: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_name_low',pg_in_customer_name_low);
1508: END IF;
1509: IF pg_in_customer_name_high IS NOT NULL THEN
1510: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_name_high',pg_in_customer_name_high);
1511: END IF;
1512:
1513: IF pg_in_invoice_type_low IS NOT NULL THEN
1514: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_invoice_type_low',pg_in_invoice_type_low );

Line 1514: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_invoice_type_low',pg_in_invoice_type_low );

1510: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_customer_name_high',pg_in_customer_name_high);
1511: END IF;
1512:
1513: IF pg_in_invoice_type_low IS NOT NULL THEN
1514: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_invoice_type_low',pg_in_invoice_type_low );
1515: END IF;
1516: IF pg_in_invoice_type_high IS NOT NULL THEN
1517: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_invoice_type_high',pg_in_invoice_type_high);
1518: END IF;

Line 1517: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_invoice_type_high',pg_in_invoice_type_high);

1513: IF pg_in_invoice_type_low IS NOT NULL THEN
1514: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_invoice_type_low',pg_in_invoice_type_low );
1515: END IF;
1516: IF pg_in_invoice_type_high IS NOT NULL THEN
1517: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_invoice_type_high',pg_in_invoice_type_high);
1518: END IF;
1519:
1520: l_rows_processed := dbms_sql.execute( l_stmt_cursor );
1521:

Line 1520: l_rows_processed := dbms_sql.execute( l_stmt_cursor );

1516: IF pg_in_invoice_type_high IS NOT NULL THEN
1517: dbms_sql.bind_variable (l_stmt_cursor,':pg_in_invoice_type_high',pg_in_invoice_type_high);
1518: END IF;
1519:
1520: l_rows_processed := dbms_sql.execute( l_stmt_cursor );
1521:
1522: IF PG_PARALLEL IN ('Y', 'C') THEN
1523: COMMIT;
1524: END IF;

Line 1860: dbms_sql.bind_variable(p_cursor, ':bucket_days_from_'||buc_rec.sequence_number,

1856: arp_standard.debug( ':bucket_line_type_'||buc_rec.sequence_number||' value '||buc_rec.type);
1857: arp_standard.debug( ':bucket_category_'||buc_rec.sequence_number||' value '||buc_rec.bucket_category);
1858: END IF;
1859:
1860: dbms_sql.bind_variable(p_cursor, ':bucket_days_from_'||buc_rec.sequence_number,
1861: buc_rec.days_start);
1862: dbms_sql.bind_variable(p_cursor, ':bucket_days_to_'||buc_rec.sequence_number,
1863: buc_rec.days_to);
1864: dbms_sql.bind_variable(p_cursor, ':bucket_line_type_'||buc_rec.sequence_number,

Line 1862: dbms_sql.bind_variable(p_cursor, ':bucket_days_to_'||buc_rec.sequence_number,

1858: END IF;
1859:
1860: dbms_sql.bind_variable(p_cursor, ':bucket_days_from_'||buc_rec.sequence_number,
1861: buc_rec.days_start);
1862: dbms_sql.bind_variable(p_cursor, ':bucket_days_to_'||buc_rec.sequence_number,
1863: buc_rec.days_to);
1864: dbms_sql.bind_variable(p_cursor, ':bucket_line_type_'||buc_rec.sequence_number,
1865: buc_rec.type);
1866: dbms_sql.bind_variable(p_cursor, ':bucket_category_'||buc_rec.sequence_number,

Line 1864: dbms_sql.bind_variable(p_cursor, ':bucket_line_type_'||buc_rec.sequence_number,

1860: dbms_sql.bind_variable(p_cursor, ':bucket_days_from_'||buc_rec.sequence_number,
1861: buc_rec.days_start);
1862: dbms_sql.bind_variable(p_cursor, ':bucket_days_to_'||buc_rec.sequence_number,
1863: buc_rec.days_to);
1864: dbms_sql.bind_variable(p_cursor, ':bucket_line_type_'||buc_rec.sequence_number,
1865: buc_rec.type);
1866: dbms_sql.bind_variable(p_cursor, ':bucket_category_'||buc_rec.sequence_number,
1867: buc_rec.bucket_category);
1868: END LOOP;

Line 1866: dbms_sql.bind_variable(p_cursor, ':bucket_category_'||buc_rec.sequence_number,

1862: dbms_sql.bind_variable(p_cursor, ':bucket_days_to_'||buc_rec.sequence_number,
1863: buc_rec.days_to);
1864: dbms_sql.bind_variable(p_cursor, ':bucket_line_type_'||buc_rec.sequence_number,
1865: buc_rec.type);
1866: dbms_sql.bind_variable(p_cursor, ':bucket_category_'||buc_rec.sequence_number,
1867: buc_rec.bucket_category);
1868: END LOOP;
1869:
1870:

Line 1997: l_cursor := dbms_sql.open_cursor;

1993: ,'||pg_parent_request_id||'
1994: ,'||pg_worker_id||'
1995: from (';
1996:
1997: l_cursor := dbms_sql.open_cursor;
1998:
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_standard.debug( 'as_of_date '||pg_in_as_of_date_low);
2001: arp_standard.debug( 'pg_rep_type '||pg_rep_type);

Line 2010: dbms_sql.parse(l_cursor,l_insert_stmt||p_in_report_query||')',DBMS_SQL.NATIVE);

2006: arp_standard.debug( 'pg_parent_request_id '||pg_parent_request_id);
2007: END IF;
2008:
2009:
2010: dbms_sql.parse(l_cursor,l_insert_stmt||p_in_report_query||')',DBMS_SQL.NATIVE);
2011:
2012: bind_bucket_parameters( l_cursor );
2013:
2014: IF p_qry_category = AR_AGING_CTGRY_INVOICE THEN

Line 2015: dbms_sql.bind_variable(l_cursor, ':pg_rep_type', pg_rep_type);

2011:
2012: bind_bucket_parameters( l_cursor );
2013:
2014: IF p_qry_category = AR_AGING_CTGRY_INVOICE THEN
2015: dbms_sql.bind_variable(l_cursor, ':pg_rep_type', pg_rep_type);
2016: END IF;
2017:
2018: dbms_sql.bind_variable(l_cursor, ':as_of_date', pg_in_as_of_date_low);
2019:

Line 2018: dbms_sql.bind_variable(l_cursor, ':as_of_date', pg_in_as_of_date_low);

2014: IF p_qry_category = AR_AGING_CTGRY_INVOICE THEN
2015: dbms_sql.bind_variable(l_cursor, ':pg_rep_type', pg_rep_type);
2016: END IF;
2017:
2018: dbms_sql.bind_variable(l_cursor, ':as_of_date', pg_in_as_of_date_low);
2019:
2020: --temporary,need to set the actual currency code
2021: dbms_sql.bind_variable(l_cursor, ':functional_currency', pg_functional_currency);
2022: dbms_sql.bind_variable(l_cursor, ':format_detailed', pg_in_format_option_low);

Line 2021: dbms_sql.bind_variable(l_cursor, ':functional_currency', pg_functional_currency);

2017:
2018: dbms_sql.bind_variable(l_cursor, ':as_of_date', pg_in_as_of_date_low);
2019:
2020: --temporary,need to set the actual currency code
2021: dbms_sql.bind_variable(l_cursor, ':functional_currency', pg_functional_currency);
2022: dbms_sql.bind_variable(l_cursor, ':format_detailed', pg_in_format_option_low);
2023: dbms_sql.bind_variable(l_cursor, ':c_convert_flag', pg_convert_flag);
2024: dbms_sql.bind_variable(l_cursor, ':worker_id', pg_worker_id);
2025: dbms_sql.bind_variable(l_cursor, ':parent_request_id', pg_parent_request_id);

Line 2022: dbms_sql.bind_variable(l_cursor, ':format_detailed', pg_in_format_option_low);

2018: dbms_sql.bind_variable(l_cursor, ':as_of_date', pg_in_as_of_date_low);
2019:
2020: --temporary,need to set the actual currency code
2021: dbms_sql.bind_variable(l_cursor, ':functional_currency', pg_functional_currency);
2022: dbms_sql.bind_variable(l_cursor, ':format_detailed', pg_in_format_option_low);
2023: dbms_sql.bind_variable(l_cursor, ':c_convert_flag', pg_convert_flag);
2024: dbms_sql.bind_variable(l_cursor, ':worker_id', pg_worker_id);
2025: dbms_sql.bind_variable(l_cursor, ':parent_request_id', pg_parent_request_id);
2026:

Line 2023: dbms_sql.bind_variable(l_cursor, ':c_convert_flag', pg_convert_flag);

2019:
2020: --temporary,need to set the actual currency code
2021: dbms_sql.bind_variable(l_cursor, ':functional_currency', pg_functional_currency);
2022: dbms_sql.bind_variable(l_cursor, ':format_detailed', pg_in_format_option_low);
2023: dbms_sql.bind_variable(l_cursor, ':c_convert_flag', pg_convert_flag);
2024: dbms_sql.bind_variable(l_cursor, ':worker_id', pg_worker_id);
2025: dbms_sql.bind_variable(l_cursor, ':parent_request_id', pg_parent_request_id);
2026:
2027: l_rows_processed := dbms_sql.execute(l_cursor);

Line 2024: dbms_sql.bind_variable(l_cursor, ':worker_id', pg_worker_id);

2020: --temporary,need to set the actual currency code
2021: dbms_sql.bind_variable(l_cursor, ':functional_currency', pg_functional_currency);
2022: dbms_sql.bind_variable(l_cursor, ':format_detailed', pg_in_format_option_low);
2023: dbms_sql.bind_variable(l_cursor, ':c_convert_flag', pg_convert_flag);
2024: dbms_sql.bind_variable(l_cursor, ':worker_id', pg_worker_id);
2025: dbms_sql.bind_variable(l_cursor, ':parent_request_id', pg_parent_request_id);
2026:
2027: l_rows_processed := dbms_sql.execute(l_cursor);
2028:

Line 2025: dbms_sql.bind_variable(l_cursor, ':parent_request_id', pg_parent_request_id);

2021: dbms_sql.bind_variable(l_cursor, ':functional_currency', pg_functional_currency);
2022: dbms_sql.bind_variable(l_cursor, ':format_detailed', pg_in_format_option_low);
2023: dbms_sql.bind_variable(l_cursor, ':c_convert_flag', pg_convert_flag);
2024: dbms_sql.bind_variable(l_cursor, ':worker_id', pg_worker_id);
2025: dbms_sql.bind_variable(l_cursor, ':parent_request_id', pg_parent_request_id);
2026:
2027: l_rows_processed := dbms_sql.execute(l_cursor);
2028:
2029: IF PG_DEBUG in ('Y', 'C') THEN

Line 2027: l_rows_processed := dbms_sql.execute(l_cursor);

2023: dbms_sql.bind_variable(l_cursor, ':c_convert_flag', pg_convert_flag);
2024: dbms_sql.bind_variable(l_cursor, ':worker_id', pg_worker_id);
2025: dbms_sql.bind_variable(l_cursor, ':parent_request_id', pg_parent_request_id);
2026:
2027: l_rows_processed := dbms_sql.execute(l_cursor);
2028:
2029: IF PG_DEBUG in ('Y', 'C') THEN
2030: arp_standard.debug( 'Rows Processed '||l_rows_processed);
2031: END IF;