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

Line 459: l_cursor := dbms_sql.open_cursor;

455: -- Bug 540962: error count variable needs to be initialized
456:
457: l_error_count := 0;
458:
459: l_cursor := dbms_sql.open_cursor;
460:
461: l_sql_statement :=
462: 'SELECT ct.previous_customer_trx_id previous_customer_trx_id,
463: ct.trx_number trx_number,

Line 478: dbms_sql.parse(l_cursor,

474: arp_util.debug('check_tax_and_accounting: ' || 'sql statement: ');
475: arp_util.debug('check_tax_and_accounting: ' || l_sql_statement );
476: END IF;
477:
478: dbms_sql.parse(l_cursor,
479: l_sql_statement,
480: dbms_sql.v7);
481:
482: dbms_sql.define_column(l_cursor, 1, l_previous_customer_trx_id);

Line 480: dbms_sql.v7);

476: END IF;
477:
478: dbms_sql.parse(l_cursor,
479: l_sql_statement,
480: dbms_sql.v7);
481:
482: dbms_sql.define_column(l_cursor, 1, l_previous_customer_trx_id);
483: dbms_sql.define_column(l_cursor, 2, l_trx_number, 20);
484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);

Line 482: dbms_sql.define_column(l_cursor, 1, l_previous_customer_trx_id);

478: dbms_sql.parse(l_cursor,
479: l_sql_statement,
480: dbms_sql.v7);
481:
482: dbms_sql.define_column(l_cursor, 1, l_previous_customer_trx_id);
483: dbms_sql.define_column(l_cursor, 2, l_trx_number, 20);
484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);
485: dbms_sql.define_column(l_cursor, 4, l_class, 20);
486: dbms_sql.define_column(l_cursor, 5, l_tax_calculation_flag, 1);

Line 483: dbms_sql.define_column(l_cursor, 2, l_trx_number, 20);

479: l_sql_statement,
480: dbms_sql.v7);
481:
482: dbms_sql.define_column(l_cursor, 1, l_previous_customer_trx_id);
483: dbms_sql.define_column(l_cursor, 2, l_trx_number, 20);
484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);
485: dbms_sql.define_column(l_cursor, 4, l_class, 20);
486: dbms_sql.define_column(l_cursor, 5, l_tax_calculation_flag, 1);
487: dbms_sql.define_column(l_cursor, 6, l_customer_trx_id);

Line 484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);

480: dbms_sql.v7);
481:
482: dbms_sql.define_column(l_cursor, 1, l_previous_customer_trx_id);
483: dbms_sql.define_column(l_cursor, 2, l_trx_number, 20);
484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);
485: dbms_sql.define_column(l_cursor, 4, l_class, 20);
486: dbms_sql.define_column(l_cursor, 5, l_tax_calculation_flag, 1);
487: dbms_sql.define_column(l_cursor, 6, l_customer_trx_id);
488: l_dummy := dbms_sql.execute(l_cursor);

Line 485: dbms_sql.define_column(l_cursor, 4, l_class, 20);

481:
482: dbms_sql.define_column(l_cursor, 1, l_previous_customer_trx_id);
483: dbms_sql.define_column(l_cursor, 2, l_trx_number, 20);
484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);
485: dbms_sql.define_column(l_cursor, 4, l_class, 20);
486: dbms_sql.define_column(l_cursor, 5, l_tax_calculation_flag, 1);
487: dbms_sql.define_column(l_cursor, 6, l_customer_trx_id);
488: l_dummy := dbms_sql.execute(l_cursor);
489:

Line 486: dbms_sql.define_column(l_cursor, 5, l_tax_calculation_flag, 1);

482: dbms_sql.define_column(l_cursor, 1, l_previous_customer_trx_id);
483: dbms_sql.define_column(l_cursor, 2, l_trx_number, 20);
484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);
485: dbms_sql.define_column(l_cursor, 4, l_class, 20);
486: dbms_sql.define_column(l_cursor, 5, l_tax_calculation_flag, 1);
487: dbms_sql.define_column(l_cursor, 6, l_customer_trx_id);
488: l_dummy := dbms_sql.execute(l_cursor);
489:
490:

Line 487: dbms_sql.define_column(l_cursor, 6, l_customer_trx_id);

483: dbms_sql.define_column(l_cursor, 2, l_trx_number, 20);
484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);
485: dbms_sql.define_column(l_cursor, 4, l_class, 20);
486: dbms_sql.define_column(l_cursor, 5, l_tax_calculation_flag, 1);
487: dbms_sql.define_column(l_cursor, 6, l_customer_trx_id);
488: l_dummy := dbms_sql.execute(l_cursor);
489:
490:
491: LOOP

Line 488: l_dummy := dbms_sql.execute(l_cursor);

484: dbms_sql.define_column(l_cursor, 3, l_invoicing_rule_id);
485: dbms_sql.define_column(l_cursor, 4, l_class, 20);
486: dbms_sql.define_column(l_cursor, 5, l_tax_calculation_flag, 1);
487: dbms_sql.define_column(l_cursor, 6, l_customer_trx_id);
488: l_dummy := dbms_sql.execute(l_cursor);
489:
490:
491: LOOP
492: IF (dbms_sql.fetch_rows(l_cursor) > 0)

Line 492: IF (dbms_sql.fetch_rows(l_cursor) > 0)

488: l_dummy := dbms_sql.execute(l_cursor);
489:
490:
491: LOOP
492: IF (dbms_sql.fetch_rows(l_cursor) > 0)
493: THEN
494:
495: dbms_sql.column_value(l_cursor, 1, l_previous_customer_trx_id);
496: dbms_sql.column_value(l_cursor, 2, l_trx_number);

Line 495: dbms_sql.column_value(l_cursor, 1, l_previous_customer_trx_id);

491: LOOP
492: IF (dbms_sql.fetch_rows(l_cursor) > 0)
493: THEN
494:
495: dbms_sql.column_value(l_cursor, 1, l_previous_customer_trx_id);
496: dbms_sql.column_value(l_cursor, 2, l_trx_number);
497: dbms_sql.column_value(l_cursor, 3, l_invoicing_rule_id);
498: dbms_sql.column_value(l_cursor, 4, l_class);
499: dbms_sql.column_value(l_cursor, 5, l_tax_calculation_flag);

Line 496: dbms_sql.column_value(l_cursor, 2, l_trx_number);

492: IF (dbms_sql.fetch_rows(l_cursor) > 0)
493: THEN
494:
495: dbms_sql.column_value(l_cursor, 1, l_previous_customer_trx_id);
496: dbms_sql.column_value(l_cursor, 2, l_trx_number);
497: dbms_sql.column_value(l_cursor, 3, l_invoicing_rule_id);
498: dbms_sql.column_value(l_cursor, 4, l_class);
499: dbms_sql.column_value(l_cursor, 5, l_tax_calculation_flag);
500: dbms_sql.column_value(l_cursor, 6, l_customer_trx_id);

Line 497: dbms_sql.column_value(l_cursor, 3, l_invoicing_rule_id);

493: THEN
494:
495: dbms_sql.column_value(l_cursor, 1, l_previous_customer_trx_id);
496: dbms_sql.column_value(l_cursor, 2, l_trx_number);
497: dbms_sql.column_value(l_cursor, 3, l_invoicing_rule_id);
498: dbms_sql.column_value(l_cursor, 4, l_class);
499: dbms_sql.column_value(l_cursor, 5, l_tax_calculation_flag);
500: dbms_sql.column_value(l_cursor, 6, l_customer_trx_id);
501:

Line 498: dbms_sql.column_value(l_cursor, 4, l_class);

494:
495: dbms_sql.column_value(l_cursor, 1, l_previous_customer_trx_id);
496: dbms_sql.column_value(l_cursor, 2, l_trx_number);
497: dbms_sql.column_value(l_cursor, 3, l_invoicing_rule_id);
498: dbms_sql.column_value(l_cursor, 4, l_class);
499: dbms_sql.column_value(l_cursor, 5, l_tax_calculation_flag);
500: dbms_sql.column_value(l_cursor, 6, l_customer_trx_id);
501:
502: IF PG_DEBUG in ('Y', 'C') THEN

Line 499: dbms_sql.column_value(l_cursor, 5, l_tax_calculation_flag);

495: dbms_sql.column_value(l_cursor, 1, l_previous_customer_trx_id);
496: dbms_sql.column_value(l_cursor, 2, l_trx_number);
497: dbms_sql.column_value(l_cursor, 3, l_invoicing_rule_id);
498: dbms_sql.column_value(l_cursor, 4, l_class);
499: dbms_sql.column_value(l_cursor, 5, l_tax_calculation_flag);
500: dbms_sql.column_value(l_cursor, 6, l_customer_trx_id);
501:
502: IF PG_DEBUG in ('Y', 'C') THEN
503: arp_util.debug('check_tax_and_accounting: ' || '');

Line 500: dbms_sql.column_value(l_cursor, 6, l_customer_trx_id);

496: dbms_sql.column_value(l_cursor, 2, l_trx_number);
497: dbms_sql.column_value(l_cursor, 3, l_invoicing_rule_id);
498: dbms_sql.column_value(l_cursor, 4, l_class);
499: dbms_sql.column_value(l_cursor, 5, l_tax_calculation_flag);
500: dbms_sql.column_value(l_cursor, 6, l_customer_trx_id);
501:
502: IF PG_DEBUG in ('Y', 'C') THEN
503: arp_util.debug('check_tax_and_accounting: ' || '');
504: arp_util.debug('check_tax_and_accounting: ' || 'Checking: ');

Line 546: dbms_sql.close_cursor(l_cursor);

542: arp_util.debug('check_tax_and_accounting: ' || 'p_error_other_line_number = ' ||
543: l_error_other_line_number);
544: END IF;
545:
546: dbms_sql.close_cursor(l_cursor);
547:
548: IF PG_DEBUG in ('Y', 'C') THEN
549: arp_util.debug('check_tax_and_accounting: ' || 'returning FALSE');
550: arp_util.debug('check_tax_and_accounting: ' ||

Line 562: dbms_sql.close_cursor(l_cursor);

558: EXIT;
559: END IF;
560: END LOOP;
561:
562: dbms_sql.close_cursor(l_cursor);
563:
564: IF PG_DEBUG in ('Y', 'C') THEN
565: arp_util.debug('check_tax_and_accounting: ' || 'returning TRUE');
566: arp_util.debug('arp_trx_validate.check_tax_and_accounting()-');

Line 580: IF (dbms_sql.is_open(l_cursor))

576: arp_util.debug('======= parameters for check_tax_and_accounting: ' ||
577: '=======');
578: arp_util.debug('check_tax_and_accounting: ' || 'p_query_string = ' || p_query_string );
579: END IF;
580: IF (dbms_sql.is_open(l_cursor))
581: THEN dbms_sql.close_cursor(l_cursor);
582: END IF;
583:
584: RAISE;

Line 581: THEN dbms_sql.close_cursor(l_cursor);

577: '=======');
578: arp_util.debug('check_tax_and_accounting: ' || 'p_query_string = ' || p_query_string );
579: END IF;
580: IF (dbms_sql.is_open(l_cursor))
581: THEN dbms_sql.close_cursor(l_cursor);
582: END IF;
583:
584: RAISE;
585: