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

Line 499: -- dbms_sql.execute

495: ) is
496:
497: l_dynamic_spec_cursor integer; -- Dynamic sql cursor
498: l_execute_spec integer; -- Value returned by
499: -- dbms_sql.execute
500: l_dynamic_body_cursor integer; -- Dynamic sql cursor
501: l_execute_body integer; -- Value returned by
502: -- dbms_sql.execute
503:

Line 502: -- dbms_sql.execute

498: l_execute_spec integer; -- Value returned by
499: -- dbms_sql.execute
500: l_dynamic_body_cursor integer; -- Dynamic sql cursor
501: l_execute_body integer; -- Value returned by
502: -- dbms_sql.execute
503:
504: l_proc varchar2(72) := g_package||'execute_source';
505: l_progress number;
506: begin

Line 511: l_dynamic_spec_cursor := dbms_sql.open_cursor;

507: --
508: -- The whole of the new package body code has now been built,
509: -- use dynamic SQL to execute the create or replace package statement
510: --
511: l_dynamic_spec_cursor := dbms_sql.open_cursor;
512: if (l_debug = 1) then
513: trace(l_proc ||' Entering:'|| l_proc, 1);
514: trace(l_proc ||' g_string => ' || g_string, 4);
515: trace(l_proc ||' Starting Generation.....'|| l_proc, 4);

Line 527: dbms_sql.parse(l_dynamic_spec_cursor, g_string, dbms_sql.native);

523: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
524: raise_application_error ('-20000', fnd_message.get);
525: end if;
526:
527: dbms_sql.parse(l_dynamic_spec_cursor, g_string, dbms_sql.native);
528:
529: l_progress := 20;
530: l_execute_spec := dbms_sql.execute(l_dynamic_spec_cursor);
531:

Line 530: l_execute_spec := dbms_sql.execute(l_dynamic_spec_cursor);

526:
527: dbms_sql.parse(l_dynamic_spec_cursor, g_string, dbms_sql.native);
528:
529: l_progress := 20;
530: l_execute_spec := dbms_sql.execute(l_dynamic_spec_cursor);
531:
532: if (l_debug = 1) then
533: trace(l_proc ||'l_execute_spec = ' || l_execute_spec, 4);
534: end if;

Line 537: dbms_sql.close_cursor(l_dynamic_spec_cursor);

533: trace(l_proc ||'l_execute_spec = ' || l_execute_spec, 4);
534: end if;
535:
536: l_progress := 30;
537: dbms_sql.close_cursor(l_dynamic_spec_cursor);
538:
539: if (l_debug = 1) then
540: trace(l_proc ||' Finished Generating Spec...:'|| l_proc, 1);
541: end if;

Line 556: if (dbms_sql.is_open(l_dynamic_spec_cursor)) then

552: if (l_debug = 1) then
553: trace(l_proc ||' Error message within "When Others" exception ' || sqlerrm(sqlcode) || ' Progress : ' || l_progress || ' ' || l_proc, 1);
554: end if;
555:
556: if (dbms_sql.is_open(l_dynamic_spec_cursor)) then
557: if (l_debug = 1) then
558: trace(l_proc ||' Closing Cursor ....');
559: end if;
560: dbms_sql.close_cursor(l_dynamic_spec_cursor);

Line 560: dbms_sql.close_cursor(l_dynamic_spec_cursor);

556: if (dbms_sql.is_open(l_dynamic_spec_cursor)) then
557: if (l_debug = 1) then
558: trace(l_proc ||' Closing Cursor ....');
559: end if;
560: dbms_sql.close_cursor(l_dynamic_spec_cursor);
561: end if;
562: end execute_source;
563: --
564: --

Line 811: l_csr_sql := dbms_sql.open_cursor;

807: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
808: raise_application_error ('-20000', fnd_message.get);
809: end if;
810:
811: l_csr_sql := dbms_sql.open_cursor;
812: dbms_sql.parse
813: (l_csr_sql
814: ,'DROP PACKAGE BODY ' || l_package_name_drop
815: ,dbms_sql.native

Line 812: dbms_sql.parse

808: raise_application_error ('-20000', fnd_message.get);
809: end if;
810:
811: l_csr_sql := dbms_sql.open_cursor;
812: dbms_sql.parse
813: (l_csr_sql
814: ,'DROP PACKAGE BODY ' || l_package_name_drop
815: ,dbms_sql.native
816: );

Line 815: ,dbms_sql.native

811: l_csr_sql := dbms_sql.open_cursor;
812: dbms_sql.parse
813: (l_csr_sql
814: ,'DROP PACKAGE BODY ' || l_package_name_drop
815: ,dbms_sql.native
816: );
817: l_rows := dbms_sql.execute( l_csr_sql );
818: dbms_sql.close_cursor( l_csr_sql );
819: exception

Line 817: l_rows := dbms_sql.execute( l_csr_sql );

813: (l_csr_sql
814: ,'DROP PACKAGE BODY ' || l_package_name_drop
815: ,dbms_sql.native
816: );
817: l_rows := dbms_sql.execute( l_csr_sql );
818: dbms_sql.close_cursor( l_csr_sql );
819: exception
820: when others then
821: --

Line 818: dbms_sql.close_cursor( l_csr_sql );

814: ,'DROP PACKAGE BODY ' || l_package_name_drop
815: ,dbms_sql.native
816: );
817: l_rows := dbms_sql.execute( l_csr_sql );
818: dbms_sql.close_cursor( l_csr_sql );
819: exception
820: when others then
821: --
822: -- Drop package failed.

Line 830: if dbms_sql.is_open( l_csr_sql ) then

826: trace(l_proc ||' Drop Package Error Code = ' || sqlcode);
827: trace(l_proc ||' Drop Package Error Message = ' || sqlerrm);
828: end if;
829:
830: if dbms_sql.is_open( l_csr_sql ) then
831: dbms_sql.close_cursor( l_csr_sql );
832: end if;
833: end;
834: end loop;

Line 831: dbms_sql.close_cursor( l_csr_sql );

827: trace(l_proc ||' Drop Package Error Message = ' || sqlerrm);
828: end if;
829:
830: if dbms_sql.is_open( l_csr_sql ) then
831: dbms_sql.close_cursor( l_csr_sql );
832: end if;
833: end;
834: end loop;
835:

Line 1965: l_csr_sql := dbms_sql.open_cursor;

1961:
1962: l_prog := 52;
1963: if compile then
1964: begin
1965: l_csr_sql := dbms_sql.open_cursor;
1966: dbms_sql.parse(
1967: l_csr_sql
1968: , 'ALTER PACKAGE ' || p_call_package || ' COMPILE SPECIFICATION'
1969: , dbms_sql.native

Line 1966: dbms_sql.parse(

1962: l_prog := 52;
1963: if compile then
1964: begin
1965: l_csr_sql := dbms_sql.open_cursor;
1966: dbms_sql.parse(
1967: l_csr_sql
1968: , 'ALTER PACKAGE ' || p_call_package || ' COMPILE SPECIFICATION'
1969: , dbms_sql.native
1970: );

Line 1969: , dbms_sql.native

1965: l_csr_sql := dbms_sql.open_cursor;
1966: dbms_sql.parse(
1967: l_csr_sql
1968: , 'ALTER PACKAGE ' || p_call_package || ' COMPILE SPECIFICATION'
1969: , dbms_sql.native
1970: );
1971: l_rows := dbms_sql.execute( l_csr_sql );
1972: dbms_sql.close_cursor( l_csr_sql );
1973: exception

Line 1971: l_rows := dbms_sql.execute( l_csr_sql );

1967: l_csr_sql
1968: , 'ALTER PACKAGE ' || p_call_package || ' COMPILE SPECIFICATION'
1969: , dbms_sql.native
1970: );
1971: l_rows := dbms_sql.execute( l_csr_sql );
1972: dbms_sql.close_cursor( l_csr_sql );
1973: exception
1974: when others then
1975: if dbms_sql.is_open( l_csr_sql ) then

Line 1972: dbms_sql.close_cursor( l_csr_sql );

1968: , 'ALTER PACKAGE ' || p_call_package || ' COMPILE SPECIFICATION'
1969: , dbms_sql.native
1970: );
1971: l_rows := dbms_sql.execute( l_csr_sql );
1972: dbms_sql.close_cursor( l_csr_sql );
1973: exception
1974: when others then
1975: if dbms_sql.is_open( l_csr_sql ) then
1976: dbms_sql.close_cursor( l_csr_sql );

Line 1975: if dbms_sql.is_open( l_csr_sql ) then

1971: l_rows := dbms_sql.execute( l_csr_sql );
1972: dbms_sql.close_cursor( l_csr_sql );
1973: exception
1974: when others then
1975: if dbms_sql.is_open( l_csr_sql ) then
1976: dbms_sql.close_cursor( l_csr_sql );
1977:
1978: if (l_debug = 1) then
1979: trace(l_proc||' Compilation of package ' || p_call_package || ' Failed.... ', 4);

Line 1976: dbms_sql.close_cursor( l_csr_sql );

1972: dbms_sql.close_cursor( l_csr_sql );
1973: exception
1974: when others then
1975: if dbms_sql.is_open( l_csr_sql ) then
1976: dbms_sql.close_cursor( l_csr_sql );
1977:
1978: if (l_debug = 1) then
1979: trace(l_proc||' Compilation of package ' || p_call_package || ' Failed.... ', 4);
1980: end if;