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

Line 580: c := dbms_sql.open_cursor;

576: arp_message.set_line( 'ARP_CMERGE_MASTER.merge_product(' ||
577: package_name || ')+' );
578:
579: BEGIN
580: c := dbms_sql.open_cursor;
581: l_sql := 'BEGIN ' ||
582: package_name || '.' || api_name ||
583: '(:req_id, :set_num, :process_mode ); END; ';
584:

Line 585: dbms_sql.parse(c,l_sql,2);

581: l_sql := 'BEGIN ' ||
582: package_name || '.' || api_name ||
583: '(:req_id, :set_num, :process_mode ); END; ';
584:
585: dbms_sql.parse(c,l_sql,2);
586: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
587: dbms_sql.bind_variable(c, 'set_num',to_char(set_num));
588: dbms_sql.bind_variable(c, 'process_mode',process_mode);
589: n := dbms_sql.execute(c);

Line 586: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));

582: package_name || '.' || api_name ||
583: '(:req_id, :set_num, :process_mode ); END; ';
584:
585: dbms_sql.parse(c,l_sql,2);
586: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
587: dbms_sql.bind_variable(c, 'set_num',to_char(set_num));
588: dbms_sql.bind_variable(c, 'process_mode',process_mode);
589: n := dbms_sql.execute(c);
590: dbms_sql.close_cursor(c);

Line 587: dbms_sql.bind_variable(c, 'set_num',to_char(set_num));

583: '(:req_id, :set_num, :process_mode ); END; ';
584:
585: dbms_sql.parse(c,l_sql,2);
586: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
587: dbms_sql.bind_variable(c, 'set_num',to_char(set_num));
588: dbms_sql.bind_variable(c, 'process_mode',process_mode);
589: n := dbms_sql.execute(c);
590: dbms_sql.close_cursor(c);
591: -- EXECUTE IMMEDIATE l_sql;

Line 588: dbms_sql.bind_variable(c, 'process_mode',process_mode);

584:
585: dbms_sql.parse(c,l_sql,2);
586: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
587: dbms_sql.bind_variable(c, 'set_num',to_char(set_num));
588: dbms_sql.bind_variable(c, 'process_mode',process_mode);
589: n := dbms_sql.execute(c);
590: dbms_sql.close_cursor(c);
591: -- EXECUTE IMMEDIATE l_sql;
592: --raji

Line 589: n := dbms_sql.execute(c);

585: dbms_sql.parse(c,l_sql,2);
586: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
587: dbms_sql.bind_variable(c, 'set_num',to_char(set_num));
588: dbms_sql.bind_variable(c, 'process_mode',process_mode);
589: n := dbms_sql.execute(c);
590: dbms_sql.close_cursor(c);
591: -- EXECUTE IMMEDIATE l_sql;
592: --raji
593: success := 'Y' ;

Line 590: dbms_sql.close_cursor(c);

586: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
587: dbms_sql.bind_variable(c, 'set_num',to_char(set_num));
588: dbms_sql.bind_variable(c, 'process_mode',process_mode);
589: n := dbms_sql.execute(c);
590: dbms_sql.close_cursor(c);
591: -- EXECUTE IMMEDIATE l_sql;
592: --raji
593: success := 'Y' ;
594:

Line 604: dbms_sql.close_cursor(c);

600: WHEN OTHERS THEN
601:
602: IF SQLCODE = -6550 THEN
603: success := 'Y' ;
604: dbms_sql.close_cursor(c);
605: ELSIF SQLCODE <> -6550 THEN
606: --Bug fix 2669389,rollback to run the records individually to identify the bad record.
607:
608: ROLLBACK to "start_merge_product";

Line 624: c := dbms_sql.open_cursor;

620:
621: FOR v_current_set in 1001..v_last_set LOOP
622: BEGIN
623:
624: c := dbms_sql.open_cursor;
625:
626: l_sql := 'BEGIN ' ||
627: package_name || '.' || api_name ||
628: '(:req_id, :v_current_set, :process_mode ); END; ';

Line 630: dbms_sql.parse(c,l_sql,2);

626: l_sql := 'BEGIN ' ||
627: package_name || '.' || api_name ||
628: '(:req_id, :v_current_set, :process_mode ); END; ';
629:
630: dbms_sql.parse(c,l_sql,2);
631: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
632: dbms_sql.bind_variable(c, 'v_current_set',to_char(v_current_set));
633: dbms_sql.bind_variable(c, 'process_mode',process_mode);
634: n := dbms_sql.execute(c);

Line 631: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));

627: package_name || '.' || api_name ||
628: '(:req_id, :v_current_set, :process_mode ); END; ';
629:
630: dbms_sql.parse(c,l_sql,2);
631: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
632: dbms_sql.bind_variable(c, 'v_current_set',to_char(v_current_set));
633: dbms_sql.bind_variable(c, 'process_mode',process_mode);
634: n := dbms_sql.execute(c);
635: dbms_sql.close_cursor(c);

Line 632: dbms_sql.bind_variable(c, 'v_current_set',to_char(v_current_set));

628: '(:req_id, :v_current_set, :process_mode ); END; ';
629:
630: dbms_sql.parse(c,l_sql,2);
631: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
632: dbms_sql.bind_variable(c, 'v_current_set',to_char(v_current_set));
633: dbms_sql.bind_variable(c, 'process_mode',process_mode);
634: n := dbms_sql.execute(c);
635: dbms_sql.close_cursor(c);
636: -- EXECUTE IMMEDIATE l_sql;

Line 633: dbms_sql.bind_variable(c, 'process_mode',process_mode);

629:
630: dbms_sql.parse(c,l_sql,2);
631: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
632: dbms_sql.bind_variable(c, 'v_current_set',to_char(v_current_set));
633: dbms_sql.bind_variable(c, 'process_mode',process_mode);
634: n := dbms_sql.execute(c);
635: dbms_sql.close_cursor(c);
636: -- EXECUTE IMMEDIATE l_sql;
637:

Line 634: n := dbms_sql.execute(c);

630: dbms_sql.parse(c,l_sql,2);
631: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
632: dbms_sql.bind_variable(c, 'v_current_set',to_char(v_current_set));
633: dbms_sql.bind_variable(c, 'process_mode',process_mode);
634: n := dbms_sql.execute(c);
635: dbms_sql.close_cursor(c);
636: -- EXECUTE IMMEDIATE l_sql;
637:
638: EXCEPTION

Line 635: dbms_sql.close_cursor(c);

631: dbms_sql.bind_variable(c, 'req_id',to_char(req_id));
632: dbms_sql.bind_variable(c, 'v_current_set',to_char(v_current_set));
633: dbms_sql.bind_variable(c, 'process_mode',process_mode);
634: n := dbms_sql.execute(c);
635: dbms_sql.close_cursor(c);
636: -- EXECUTE IMMEDIATE l_sql;
637:
638: EXCEPTION
639: WHEN OTHERS THEN

Line 641: dbms_sql.close_cursor(c);

637:
638: EXCEPTION
639: WHEN OTHERS THEN
640: IF SQLCODE = -6550 THEN
641: dbms_sql.close_cursor(c);
642: ELSIF SQLCODE <> -6550 THEN
643: G_PRODUCT_RAISING_EXCEPTION := product_code||'.'|| package_name || '.' || api_name ;
644: error_text := G_PRODUCT_RAISING_EXCEPTION || ' ' || arp_message.get_last_few_messages(2);
645: