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

Line 439: p_select_c := dbms_sql.open_cursor;

435: ------------------------------------------------
436: BEGIN
437: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
438:
439: p_select_c := dbms_sql.open_cursor;
440: dbms_sql.parse( p_select_c, l_select_sql,
441: dbms_sql.v7 );
442:
443: EXCEPTION

Line 440: dbms_sql.parse( p_select_c, l_select_sql,

436: BEGIN
437: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
438:
439: p_select_c := dbms_sql.open_cursor;
440: dbms_sql.parse( p_select_c, l_select_sql,
441: dbms_sql.v7 );
442:
443: EXCEPTION
444: WHEN OTHERS THEN

Line 441: dbms_sql.v7 );

437: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
438:
439: p_select_c := dbms_sql.open_cursor;
440: dbms_sql.parse( p_select_c, l_select_sql,
441: dbms_sql.v7 );
442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: debug( 'EXCEPTION: Error parsing stmts', MSG_LEVEL_BASIC );

Line 502: p_insert_audit_c := dbms_sql.open_cursor;

498: ------------------------------------------------
499: BEGIN
500: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
501:
502: p_insert_audit_c := dbms_sql.open_cursor;
503: dbms_sql.parse( p_insert_audit_c, l_insert_audit_sql,
504: dbms_sql.v7 );
505:
506: EXCEPTION

Line 503: dbms_sql.parse( p_insert_audit_c, l_insert_audit_sql,

499: BEGIN
500: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
501:
502: p_insert_audit_c := dbms_sql.open_cursor;
503: dbms_sql.parse( p_insert_audit_c, l_insert_audit_sql,
504: dbms_sql.v7 );
505:
506: EXCEPTION
507: WHEN OTHERS THEN

Line 504: dbms_sql.v7 );

500: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
501:
502: p_insert_audit_c := dbms_sql.open_cursor;
503: dbms_sql.parse( p_insert_audit_c, l_insert_audit_sql,
504: dbms_sql.v7 );
505:
506: EXCEPTION
507: WHEN OTHERS THEN
508: debug( 'EXCEPTION: Error parsing stmts', MSG_LEVEL_BASIC );

Line 562: p_update_adj_c := dbms_sql.open_cursor;

558: ------------------------------------------------
559: BEGIN
560: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
561:
562: p_update_adj_c := dbms_sql.open_cursor;
563: dbms_sql.parse( p_update_adj_c, l_update_adj_sql,
564: dbms_sql.v7 );
565:
566:

Line 563: dbms_sql.parse( p_update_adj_c, l_update_adj_sql,

559: BEGIN
560: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
561:
562: p_update_adj_c := dbms_sql.open_cursor;
563: dbms_sql.parse( p_update_adj_c, l_update_adj_sql,
564: dbms_sql.v7 );
565:
566:
567: EXCEPTION

Line 564: dbms_sql.v7 );

560: debug( ' Parsing stmts', MSG_LEVEL_DEBUG );
561:
562: p_update_adj_c := dbms_sql.open_cursor;
563: dbms_sql.parse( p_update_adj_c, l_update_adj_sql,
564: dbms_sql.v7 );
565:
566:
567: EXCEPTION
568: WHEN OTHERS THEN

Line 628: IF( NOT( dbms_sql.is_open( doc_combo_select_c ) ) ) THEN

624:
625: ---------------------------------------------------------------
626: -- Build dynamic sql
627: ---------------------------------------------------------------
628: IF( NOT( dbms_sql.is_open( doc_combo_select_c ) ) ) THEN
629:
630: build_doc_combo_sql(
631: system_info,
632: profile_info,

Line 646: dbms_sql.bind_variable( doc_combo_select_c,

642:
643: ---------------------------------------------------------------
644: -- Bind variables
645: ---------------------------------------------------------------
646: dbms_sql.bind_variable( doc_combo_select_c,
647: 'customer_trx_id',
648: p_customer_trx_id );
649:
650: if (p_bind1 is not null) then

Line 651: dbms_sql.bind_variable( doc_insert_audit_c,':bind1',p_bind1);

647: 'customer_trx_id',
648: p_customer_trx_id );
649:
650: if (p_bind1 is not null) then
651: dbms_sql.bind_variable( doc_insert_audit_c,':bind1',p_bind1);
652: end if;
653:
654: if (p_bind2 is not null) then
655: dbms_sql.bind_variable( doc_insert_audit_c,':bind2',p_bind2);

Line 655: dbms_sql.bind_variable( doc_insert_audit_c,':bind2',p_bind2);

651: dbms_sql.bind_variable( doc_insert_audit_c,':bind1',p_bind1);
652: end if;
653:
654: if (p_bind2 is not null) then
655: dbms_sql.bind_variable( doc_insert_audit_c,':bind2',p_bind2);
656: end if;
657:
658: if (p_bind3 is not null) then
659: dbms_sql.bind_variable( doc_insert_audit_c,':bind3',p_bind3);

Line 659: dbms_sql.bind_variable( doc_insert_audit_c,':bind3',p_bind3);

655: dbms_sql.bind_variable( doc_insert_audit_c,':bind2',p_bind2);
656: end if;
657:
658: if (p_bind3 is not null) then
659: dbms_sql.bind_variable( doc_insert_audit_c,':bind3',p_bind3);
660: end if;
661:
662: ---------------------------------------------------------------
663: -- Define columns

Line 665: dbms_sql.define_column( doc_combo_select_c, 1, l_set_of_books_id );

661:
662: ---------------------------------------------------------------
663: -- Define columns
664: ---------------------------------------------------------------
665: dbms_sql.define_column( doc_combo_select_c, 1, l_set_of_books_id );
666: dbms_sql.define_column( doc_combo_select_c, 2, l_trx_date );
667: dbms_sql.define_column( doc_combo_select_c, 3, l_type, 30 );
668:
669: ---------------------------------------------------------------

Line 666: dbms_sql.define_column( doc_combo_select_c, 2, l_trx_date );

662: ---------------------------------------------------------------
663: -- Define columns
664: ---------------------------------------------------------------
665: dbms_sql.define_column( doc_combo_select_c, 1, l_set_of_books_id );
666: dbms_sql.define_column( doc_combo_select_c, 2, l_trx_date );
667: dbms_sql.define_column( doc_combo_select_c, 3, l_type, 30 );
668:
669: ---------------------------------------------------------------
670: -- Execute sql

Line 667: dbms_sql.define_column( doc_combo_select_c, 3, l_type, 30 );

663: -- Define columns
664: ---------------------------------------------------------------
665: dbms_sql.define_column( doc_combo_select_c, 1, l_set_of_books_id );
666: dbms_sql.define_column( doc_combo_select_c, 2, l_trx_date );
667: dbms_sql.define_column( doc_combo_select_c, 3, l_type, 30 );
668:
669: ---------------------------------------------------------------
670: -- Execute sql
671: ---------------------------------------------------------------

Line 675: l_ignore := dbms_sql.execute( doc_combo_select_c );

671: ---------------------------------------------------------------
672: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
673:
674: BEGIN
675: l_ignore := dbms_sql.execute( doc_combo_select_c );
676:
677: EXCEPTION
678: WHEN OTHERS THEN
679: debug( 'EXCEPTION: Error executing select sql',

Line 691: IF dbms_sql.fetch_rows( doc_combo_select_c ) > 0 THEN

687: ---------------------------------------------------------------
688: BEGIN
689: LOOP
690:
691: IF dbms_sql.fetch_rows( doc_combo_select_c ) > 0 THEN
692:
693: debug(' Fetched a row', MSG_LEVEL_DEBUG );
694:
695: -----------------------------------------------------------

Line 698: dbms_sql.column_value( doc_combo_select_c,

694:
695: -----------------------------------------------------------
696: -- Get variables:
697: -----------------------------------------------------------
698: dbms_sql.column_value( doc_combo_select_c,
699: 1, l_set_of_books_id );
700: dbms_sql.column_value( doc_combo_select_c, 2, l_trx_date );
701: dbms_sql.column_value( doc_combo_select_c, 3, l_type );
702:

Line 700: dbms_sql.column_value( doc_combo_select_c, 2, l_trx_date );

696: -- Get variables:
697: -----------------------------------------------------------
698: dbms_sql.column_value( doc_combo_select_c,
699: 1, l_set_of_books_id );
700: dbms_sql.column_value( doc_combo_select_c, 2, l_trx_date );
701: dbms_sql.column_value( doc_combo_select_c, 3, l_type );
702:
703: debug(' set_of_books_id='||l_set_of_books_id,
704: MSG_LEVEL_DEVELOP );

Line 701: dbms_sql.column_value( doc_combo_select_c, 3, l_type );

697: -----------------------------------------------------------
698: dbms_sql.column_value( doc_combo_select_c,
699: 1, l_set_of_books_id );
700: dbms_sql.column_value( doc_combo_select_c, 2, l_trx_date );
701: dbms_sql.column_value( doc_combo_select_c, 3, l_type );
702:
703: debug(' set_of_books_id='||l_set_of_books_id,
704: MSG_LEVEL_DEVELOP );
705: debug(' trx_date='||l_trx_date, MSG_LEVEL_DEVELOP );

Line 839: dbms_sql.bind_variable( doc_update_adj_c ,':bind1',p_bind1);

835: doc_update_adj_c );
836:
837: -- Bind Variables
838: if (p_bind1 is not null) then
839: dbms_sql.bind_variable( doc_update_adj_c ,':bind1',p_bind1);
840: end if;
841:
842: if (p_bind2 is not null) then
843: dbms_sql.bind_variable( doc_update_adj_c ,':bind2',p_bind2);

Line 843: dbms_sql.bind_variable( doc_update_adj_c ,':bind2',p_bind2);

839: dbms_sql.bind_variable( doc_update_adj_c ,':bind1',p_bind1);
840: end if;
841:
842: if (p_bind2 is not null) then
843: dbms_sql.bind_variable( doc_update_adj_c ,':bind2',p_bind2);
844: end if;
845:
846: if (p_bind3 is not null) then
847: dbms_sql.bind_variable( doc_update_adj_c ,':bind3',p_bind3);

Line 847: dbms_sql.bind_variable( doc_update_adj_c ,':bind3',p_bind3);

843: dbms_sql.bind_variable( doc_update_adj_c ,':bind2',p_bind2);
844: end if;
845:
846: if (p_bind3 is not null) then
847: dbms_sql.bind_variable( doc_update_adj_c ,':bind3',p_bind3);
848: end if;
849: dbms_sql.bind_variable( doc_update_adj_c ,':adjustment_id',adj_rec.adjustment_id);
850:
851:

Line 849: dbms_sql.bind_variable( doc_update_adj_c ,':adjustment_id',adj_rec.adjustment_id);

845:
846: if (p_bind3 is not null) then
847: dbms_sql.bind_variable( doc_update_adj_c ,':bind3',p_bind3);
848: end if;
849: dbms_sql.bind_variable( doc_update_adj_c ,':adjustment_id',adj_rec.adjustment_id);
850:
851:
852:
853: l_ignore := dbms_sql.execute( doc_update_adj_c );

Line 853: l_ignore := dbms_sql.execute( doc_update_adj_c );

849: dbms_sql.bind_variable( doc_update_adj_c ,':adjustment_id',adj_rec.adjustment_id);
850:
851:
852:
853: l_ignore := dbms_sql.execute( doc_update_adj_c );
854:
855: /* MRC call not required because update only affects
856: doc_sequence_value and doc_sequence_id - Ie. no
857: accounting columns */

Line 880: dbms_sql.bind_variable(

876: BEGIN
877: -------------------------------------------------------
878: -- Bind variables
879: -------------------------------------------------------
880: dbms_sql.bind_variable(
881: doc_insert_audit_c,
882: 'sequence_assignment_id',
883: l_sequence_assignment_id );
884:

Line 885: l_ignore := dbms_sql.execute( doc_insert_audit_c );

881: doc_insert_audit_c,
882: 'sequence_assignment_id',
883: l_sequence_assignment_id );
884:
885: l_ignore := dbms_sql.execute( doc_insert_audit_c );
886:
887: debug( to_char(l_ignore) || ' row(s) inserted',
888: MSG_LEVEL_DEBUG );
889: