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.

SYSTEM.AD_APPS_PRIVATE dependencies on DBMS_SQL

Line 506: c := dbms_sql.open_cursor;

502: IF ( g_Un_Cache_Tbl.COUNT <> 0 AND g_Un_Cache_Tbl.EXISTS(ign||'_aol') ) THEN
503: l_apps_schema := g_Un_Cache_Tbl(ign||'_aol') ;
504: ELSE -- if cache check
505: BEGIN --Block 1
506: c := dbms_sql.open_cursor;
507: -- select APPS account for given IGN, or if IGN is 0 then the min
508: c_statement:= 'select oracle_username from '||
509: aol_or_apps_schema||'.fnd_oracle_userid '||
510: 'where (install_group_num = :install_group_num '||

Line 517: dbms_sql.parse(c, c_statement, dbms_sql.native);

513: aol_or_apps_schema||'.fnd_oracle_userid '||
514: ' where 1 = decode (:install_group_num,0,1,2) '||
515: ' and read_only_flag = ''U'')) '||
516: 'and read_only_flag = ''U'' ';
517: dbms_sql.parse(c, c_statement, dbms_sql.native);
518: dbms_sql.bind_variable(c,'install_group_num',ign);
519: dbms_sql.define_column(c,1,l_apps_schema,30);
520: rows_processed := dbms_sql.execute(c);
521: if dbms_sql.fetch_rows(c) > 0 then

Line 518: dbms_sql.bind_variable(c,'install_group_num',ign);

514: ' where 1 = decode (:install_group_num,0,1,2) '||
515: ' and read_only_flag = ''U'')) '||
516: 'and read_only_flag = ''U'' ';
517: dbms_sql.parse(c, c_statement, dbms_sql.native);
518: dbms_sql.bind_variable(c,'install_group_num',ign);
519: dbms_sql.define_column(c,1,l_apps_schema,30);
520: rows_processed := dbms_sql.execute(c);
521: if dbms_sql.fetch_rows(c) > 0 then
522: dbms_sql.column_value(c,1,l_apps_schema);

Line 519: dbms_sql.define_column(c,1,l_apps_schema,30);

515: ' and read_only_flag = ''U'')) '||
516: 'and read_only_flag = ''U'' ';
517: dbms_sql.parse(c, c_statement, dbms_sql.native);
518: dbms_sql.bind_variable(c,'install_group_num',ign);
519: dbms_sql.define_column(c,1,l_apps_schema,30);
520: rows_processed := dbms_sql.execute(c);
521: if dbms_sql.fetch_rows(c) > 0 then
522: dbms_sql.column_value(c,1,l_apps_schema);
523: else

Line 520: rows_processed := dbms_sql.execute(c);

516: 'and read_only_flag = ''U'' ';
517: dbms_sql.parse(c, c_statement, dbms_sql.native);
518: dbms_sql.bind_variable(c,'install_group_num',ign);
519: dbms_sql.define_column(c,1,l_apps_schema,30);
520: rows_processed := dbms_sql.execute(c);
521: if dbms_sql.fetch_rows(c) > 0 then
522: dbms_sql.column_value(c,1,l_apps_schema);
523: else
524: raise no_data_found;

Line 521: if dbms_sql.fetch_rows(c) > 0 then

517: dbms_sql.parse(c, c_statement, dbms_sql.native);
518: dbms_sql.bind_variable(c,'install_group_num',ign);
519: dbms_sql.define_column(c,1,l_apps_schema,30);
520: rows_processed := dbms_sql.execute(c);
521: if dbms_sql.fetch_rows(c) > 0 then
522: dbms_sql.column_value(c,1,l_apps_schema);
523: else
524: raise no_data_found;
525: end if;

Line 522: dbms_sql.column_value(c,1,l_apps_schema);

518: dbms_sql.bind_variable(c,'install_group_num',ign);
519: dbms_sql.define_column(c,1,l_apps_schema,30);
520: rows_processed := dbms_sql.execute(c);
521: if dbms_sql.fetch_rows(c) > 0 then
522: dbms_sql.column_value(c,1,l_apps_schema);
523: else
524: raise no_data_found;
525: end if;
526: dbms_sql.close_cursor(c);

Line 526: dbms_sql.close_cursor(c);

522: dbms_sql.column_value(c,1,l_apps_schema);
523: else
524: raise no_data_found;
525: end if;
526: dbms_sql.close_cursor(c);
527: --
528: -- Cache the result to the global collection
529: g_Un_Cache_Tbl(ign||'_aol') := l_apps_schema;
530: EXCEPTION

Line 532: dbms_sql.close_cursor(c);

528: -- Cache the result to the global collection
529: g_Un_Cache_Tbl(ign||'_aol') := l_apps_schema;
530: EXCEPTION
531: when others then
532: dbms_sql.close_cursor(c);
533: ad_apps_private.error_buf := 'c_statement='||c_statement||': '||
534: ad_apps_private.error_buf;
535: raise;
536: END ; -- Block 1

Line 551: c := dbms_sql.open_cursor;

547: IF ( g_Un_Cache_Tbl.COUNT <> 0 AND g_Un_Cache_Tbl.EXISTS (ign||'_mls') ) THEN
548: l_mls_apps_schema := g_Un_Cache_Tbl(ign||'_mls') ;
549: ELSE -- if cache check 2
550: BEGIN --BLock 2
551: c := dbms_sql.open_cursor;
552: c_statement:= 'select oracle_username from '||
553: aol_or_apps_schema||'.fnd_oracle_userid '||
554: 'where (install_group_num = :install_group_num '||
555: ' or install_group_num = '||

Line 561: dbms_sql.parse(c, c_statement, dbms_sql.native);

557: aol_or_apps_schema||'.fnd_oracle_userid '||
558: ' where 1 = decode (:install_group_num,0,1,2) '||
559: ' and read_only_flag = ''M'')) '||
560: 'and read_only_flag = ''M'' ';
561: dbms_sql.parse(c, c_statement, dbms_sql.native);
562: dbms_sql.bind_variable(c,'install_group_num',ign);
563: dbms_sql.define_column(c,1,l_mls_apps_schema,30);
564: rows_processed := dbms_sql.execute(c);
565: if dbms_sql.fetch_rows(c) > 0 then

Line 562: dbms_sql.bind_variable(c,'install_group_num',ign);

558: ' where 1 = decode (:install_group_num,0,1,2) '||
559: ' and read_only_flag = ''M'')) '||
560: 'and read_only_flag = ''M'' ';
561: dbms_sql.parse(c, c_statement, dbms_sql.native);
562: dbms_sql.bind_variable(c,'install_group_num',ign);
563: dbms_sql.define_column(c,1,l_mls_apps_schema,30);
564: rows_processed := dbms_sql.execute(c);
565: if dbms_sql.fetch_rows(c) > 0 then
566: dbms_sql.column_value(c,1,l_mls_apps_schema);

Line 563: dbms_sql.define_column(c,1,l_mls_apps_schema,30);

559: ' and read_only_flag = ''M'')) '||
560: 'and read_only_flag = ''M'' ';
561: dbms_sql.parse(c, c_statement, dbms_sql.native);
562: dbms_sql.bind_variable(c,'install_group_num',ign);
563: dbms_sql.define_column(c,1,l_mls_apps_schema,30);
564: rows_processed := dbms_sql.execute(c);
565: if dbms_sql.fetch_rows(c) > 0 then
566: dbms_sql.column_value(c,1,l_mls_apps_schema);
567: else

Line 564: rows_processed := dbms_sql.execute(c);

560: 'and read_only_flag = ''M'' ';
561: dbms_sql.parse(c, c_statement, dbms_sql.native);
562: dbms_sql.bind_variable(c,'install_group_num',ign);
563: dbms_sql.define_column(c,1,l_mls_apps_schema,30);
564: rows_processed := dbms_sql.execute(c);
565: if dbms_sql.fetch_rows(c) > 0 then
566: dbms_sql.column_value(c,1,l_mls_apps_schema);
567: else
568: raise no_data_found;

Line 565: if dbms_sql.fetch_rows(c) > 0 then

561: dbms_sql.parse(c, c_statement, dbms_sql.native);
562: dbms_sql.bind_variable(c,'install_group_num',ign);
563: dbms_sql.define_column(c,1,l_mls_apps_schema,30);
564: rows_processed := dbms_sql.execute(c);
565: if dbms_sql.fetch_rows(c) > 0 then
566: dbms_sql.column_value(c,1,l_mls_apps_schema);
567: else
568: raise no_data_found;
569: end if;

Line 566: dbms_sql.column_value(c,1,l_mls_apps_schema);

562: dbms_sql.bind_variable(c,'install_group_num',ign);
563: dbms_sql.define_column(c,1,l_mls_apps_schema,30);
564: rows_processed := dbms_sql.execute(c);
565: if dbms_sql.fetch_rows(c) > 0 then
566: dbms_sql.column_value(c,1,l_mls_apps_schema);
567: else
568: raise no_data_found;
569: end if;
570: dbms_sql.close_cursor(c);

Line 570: dbms_sql.close_cursor(c);

566: dbms_sql.column_value(c,1,l_mls_apps_schema);
567: else
568: raise no_data_found;
569: end if;
570: dbms_sql.close_cursor(c);
571: g_Un_Cache_Tbl(ign||'_mls') := l_mls_apps_schema ;
572: EXCEPTION
573: when others then
574: dbms_sql.close_cursor(c);

Line 574: dbms_sql.close_cursor(c);

570: dbms_sql.close_cursor(c);
571: g_Un_Cache_Tbl(ign||'_mls') := l_mls_apps_schema ;
572: EXCEPTION
573: when others then
574: dbms_sql.close_cursor(c);
575: ad_apps_private.error_buf := 'c_statement='||c_statement||': '||
576: ad_apps_private.error_buf;
577: raise;
578: END ; -- Block 2

Line 614: c := dbms_sql.open_cursor;

610: begin
611: -- don't use apps_ddl here because this is called in the
612: -- procedure that creates the apps_ddl code, so apps_ddl cannot be
613: -- called before it is created
614: c := dbms_sql.open_cursor;
615: statement :='drop '||object_type||' '||target_schema||'."'||object_name||'"';
616: dbms_sql.parse(c, statement, dbms_sql.native);
617: rows_processed := dbms_sql.execute(c);
618: dbms_sql.close_cursor(c);

Line 616: dbms_sql.parse(c, statement, dbms_sql.native);

612: -- procedure that creates the apps_ddl code, so apps_ddl cannot be
613: -- called before it is created
614: c := dbms_sql.open_cursor;
615: statement :='drop '||object_type||' '||target_schema||'."'||object_name||'"';
616: dbms_sql.parse(c, statement, dbms_sql.native);
617: rows_processed := dbms_sql.execute(c);
618: dbms_sql.close_cursor(c);
619: exception
620: -- trap ora -4043 (Object xxx does not exist)

Line 617: rows_processed := dbms_sql.execute(c);

613: -- called before it is created
614: c := dbms_sql.open_cursor;
615: statement :='drop '||object_type||' '||target_schema||'."'||object_name||'"';
616: dbms_sql.parse(c, statement, dbms_sql.native);
617: rows_processed := dbms_sql.execute(c);
618: dbms_sql.close_cursor(c);
619: exception
620: -- trap ora -4043 (Object xxx does not exist)
621: when object_not_exist then

Line 618: dbms_sql.close_cursor(c);

614: c := dbms_sql.open_cursor;
615: statement :='drop '||object_type||' '||target_schema||'."'||object_name||'"';
616: dbms_sql.parse(c, statement, dbms_sql.native);
617: rows_processed := dbms_sql.execute(c);
618: dbms_sql.close_cursor(c);
619: exception
620: -- trap ora -4043 (Object xxx does not exist)
621: when object_not_exist then
622: dbms_sql.close_cursor(c);

Line 622: dbms_sql.close_cursor(c);

618: dbms_sql.close_cursor(c);
619: exception
620: -- trap ora -4043 (Object xxx does not exist)
621: when object_not_exist then
622: dbms_sql.close_cursor(c);
623: if upper(object_type) = 'PROCEDURE' or
624: upper(object_type) = 'PACKAGE' or
625: upper(object_type) = 'PACKAGE BODY' then
626: null;

Line 635: dbms_sql.close_cursor(c);

631: raise;
632: end if;
633: -- trap ora -942 (Table or view xxx does not exist)
634: when table_view_not_exist then
635: dbms_sql.close_cursor(c);
636: if upper(object_type) = 'VIEW' then
637: null;
638: else
639: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

Line 646: dbms_sql.close_cursor(c);

642: raise;
643: end if;
644: -- trap ora -4080 (Trigger does not exist)
645: when trigger_not_exist then
646: dbms_sql.close_cursor(c);
647: if upper(object_type) = 'TRIGGER' then
648: null;
649: else
650: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

Line 657: dbms_sql.close_cursor(c);

653: raise;
654: end if;
655: -- trap ora -1434 (Synonym does not exist)
656: when synonym_not_exist then
657: dbms_sql.close_cursor(c);
658: if upper(object_type) = 'SYNONYM' then
659: null;
660: else
661: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

Line 668: dbms_sql.close_cursor(c);

664: raise;
665: end if;
666: -- trap ora -2289 (Sequence does not exist)
667: when sequence_not_exist then
668: dbms_sql.close_cursor(c);
669: if upper(object_type) = 'SEQUENCE' then
670: null;
671: else
672: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

Line 678: dbms_sql.close_cursor(c);

674: ad_apps_private.error_buf;
675: raise;
676: end if;
677: when others then
678: dbms_sql.close_cursor(c);
679: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
680: object_name||
681: ','||object_type||'): '||ad_apps_private.error_buf;
682: raise;

Line 995: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);

991: statement := 'select text into :view_text from dba_views '||
992: 'where owner='''||copy_huge_view.fromschema||''' '||
993: 'and view_name='''||copy_huge_view.view_name||'''';
994:
995: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);
996: sys.dbms_sys_sql.define_column_long(c,1);
997: rows_processed := sys.dbms_sys_sql.execute(c);
998:
999: if sys.dbms_sys_sql.fetch_rows(c) > 0 then

Line 1129: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);

1125: 'where owner=upper('''||fromschema||''') '||
1126: 'and view_name=upper('''||view_name||''') '||
1127: 'and text_length='||from_len;
1128:
1129: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1130: sys.dbms_sys_sql.define_column_long(c1,1);
1131: rows_processed := sys.dbms_sys_sql.execute(c1);
1132:
1133: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then

Line 1152: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);

1148: 'where owner=upper('''||toschema||''') '||
1149: 'and view_name=upper('''||view_name||''') '||
1150: 'and text_length='||to_len;
1151:
1152: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1153: sys.dbms_sys_sql.define_column_long(c2,1);
1154: rows_processed := sys.dbms_sys_sql.execute(c2);
1155:
1156: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then

Line 2059: oracle_id_cursor := dbms_sql.open_cursor;

2055: aol_schema||ign_schema_select_part2||aol_schema||
2056: ign_schema_select_part3||' in (to_char(:install_g_num), 0 )';
2057: begin
2058:
2059: oracle_id_cursor := dbms_sql.open_cursor;
2060: dbms_sql.parse(oracle_id_cursor, oracle_id_sql, dbms_sql.native);
2061: dbms_sql.bind_variable(oracle_id_cursor,'install_g_num',
2062: create_special_views.install_group_num);
2063: dbms_sql.define_column(oracle_id_cursor,1,table_schema,30);

Line 2060: dbms_sql.parse(oracle_id_cursor, oracle_id_sql, dbms_sql.native);

2056: ign_schema_select_part3||' in (to_char(:install_g_num), 0 )';
2057: begin
2058:
2059: oracle_id_cursor := dbms_sql.open_cursor;
2060: dbms_sql.parse(oracle_id_cursor, oracle_id_sql, dbms_sql.native);
2061: dbms_sql.bind_variable(oracle_id_cursor,'install_g_num',
2062: create_special_views.install_group_num);
2063: dbms_sql.define_column(oracle_id_cursor,1,table_schema,30);
2064: rows_processed := dbms_sql.execute(oracle_id_cursor);

Line 2061: dbms_sql.bind_variable(oracle_id_cursor,'install_g_num',

2057: begin
2058:
2059: oracle_id_cursor := dbms_sql.open_cursor;
2060: dbms_sql.parse(oracle_id_cursor, oracle_id_sql, dbms_sql.native);
2061: dbms_sql.bind_variable(oracle_id_cursor,'install_g_num',
2062: create_special_views.install_group_num);
2063: dbms_sql.define_column(oracle_id_cursor,1,table_schema,30);
2064: rows_processed := dbms_sql.execute(oracle_id_cursor);
2065: loop

Line 2063: dbms_sql.define_column(oracle_id_cursor,1,table_schema,30);

2059: oracle_id_cursor := dbms_sql.open_cursor;
2060: dbms_sql.parse(oracle_id_cursor, oracle_id_sql, dbms_sql.native);
2061: dbms_sql.bind_variable(oracle_id_cursor,'install_g_num',
2062: create_special_views.install_group_num);
2063: dbms_sql.define_column(oracle_id_cursor,1,table_schema,30);
2064: rows_processed := dbms_sql.execute(oracle_id_cursor);
2065: loop
2066: if dbms_sql.fetch_rows(oracle_id_cursor) > 0 then
2067: dbms_sql.column_value(oracle_id_cursor,1,table_schema);

Line 2064: rows_processed := dbms_sql.execute(oracle_id_cursor);

2060: dbms_sql.parse(oracle_id_cursor, oracle_id_sql, dbms_sql.native);
2061: dbms_sql.bind_variable(oracle_id_cursor,'install_g_num',
2062: create_special_views.install_group_num);
2063: dbms_sql.define_column(oracle_id_cursor,1,table_schema,30);
2064: rows_processed := dbms_sql.execute(oracle_id_cursor);
2065: loop
2066: if dbms_sql.fetch_rows(oracle_id_cursor) > 0 then
2067: dbms_sql.column_value(oracle_id_cursor,1,table_schema);
2068: -- for each schema see if any of the listed tables exist in

Line 2066: if dbms_sql.fetch_rows(oracle_id_cursor) > 0 then

2062: create_special_views.install_group_num);
2063: dbms_sql.define_column(oracle_id_cursor,1,table_schema,30);
2064: rows_processed := dbms_sql.execute(oracle_id_cursor);
2065: loop
2066: if dbms_sql.fetch_rows(oracle_id_cursor) > 0 then
2067: dbms_sql.column_value(oracle_id_cursor,1,table_schema);
2068: -- for each schema see if any of the listed tables exist in
2069: -- that schema and create the view in the apps schema
2070: declare

Line 2067: dbms_sql.column_value(oracle_id_cursor,1,table_schema);

2063: dbms_sql.define_column(oracle_id_cursor,1,table_schema,30);
2064: rows_processed := dbms_sql.execute(oracle_id_cursor);
2065: loop
2066: if dbms_sql.fetch_rows(oracle_id_cursor) > 0 then
2067: dbms_sql.column_value(oracle_id_cursor,1,table_schema);
2068: -- for each schema see if any of the listed tables exist in
2069: -- that schema and create the view in the apps schema
2070: declare
2071: c integer;

Line 2092: c := dbms_sql.open_cursor;

2088: c integer;
2089: rows_processed integer;
2090: statement varchar2(500);
2091: begin
2092: c := dbms_sql.open_cursor;
2093: statement :=
2094: 'select nvl(max(last_update_date), '||
2095: ' to_date(''01/01/1970'',''DD/MM/YYYY'')) '||
2096: ' from '||aol_schema||'.ak_translated_columns';

Line 2097: dbms_sql.parse(c, statement, dbms_sql.native);

2093: statement :=
2094: 'select nvl(max(last_update_date), '||
2095: ' to_date(''01/01/1970'',''DD/MM/YYYY'')) '||
2096: ' from '||aol_schema||'.ak_translated_columns';
2097: dbms_sql.parse(c, statement, dbms_sql.native);
2098: dbms_sql.define_column(c,1,max_trans_date);
2099: rows_processed := dbms_sql.execute(c);
2100: loop
2101: if dbms_sql.fetch_rows(c) > 0 then

Line 2098: dbms_sql.define_column(c,1,max_trans_date);

2094: 'select nvl(max(last_update_date), '||
2095: ' to_date(''01/01/1970'',''DD/MM/YYYY'')) '||
2096: ' from '||aol_schema||'.ak_translated_columns';
2097: dbms_sql.parse(c, statement, dbms_sql.native);
2098: dbms_sql.define_column(c,1,max_trans_date);
2099: rows_processed := dbms_sql.execute(c);
2100: loop
2101: if dbms_sql.fetch_rows(c) > 0 then
2102: dbms_sql.column_value(c,1,max_trans_date);

Line 2099: rows_processed := dbms_sql.execute(c);

2095: ' to_date(''01/01/1970'',''DD/MM/YYYY'')) '||
2096: ' from '||aol_schema||'.ak_translated_columns';
2097: dbms_sql.parse(c, statement, dbms_sql.native);
2098: dbms_sql.define_column(c,1,max_trans_date);
2099: rows_processed := dbms_sql.execute(c);
2100: loop
2101: if dbms_sql.fetch_rows(c) > 0 then
2102: dbms_sql.column_value(c,1,max_trans_date);
2103: end if;

Line 2101: if dbms_sql.fetch_rows(c) > 0 then

2097: dbms_sql.parse(c, statement, dbms_sql.native);
2098: dbms_sql.define_column(c,1,max_trans_date);
2099: rows_processed := dbms_sql.execute(c);
2100: loop
2101: if dbms_sql.fetch_rows(c) > 0 then
2102: dbms_sql.column_value(c,1,max_trans_date);
2103: end if;
2104: dbms_sql.close_cursor(c);
2105: exit;

Line 2102: dbms_sql.column_value(c,1,max_trans_date);

2098: dbms_sql.define_column(c,1,max_trans_date);
2099: rows_processed := dbms_sql.execute(c);
2100: loop
2101: if dbms_sql.fetch_rows(c) > 0 then
2102: dbms_sql.column_value(c,1,max_trans_date);
2103: end if;
2104: dbms_sql.close_cursor(c);
2105: exit;
2106: end loop;

Line 2104: dbms_sql.close_cursor(c);

2100: loop
2101: if dbms_sql.fetch_rows(c) > 0 then
2102: dbms_sql.column_value(c,1,max_trans_date);
2103: end if;
2104: dbms_sql.close_cursor(c);
2105: exit;
2106: end loop;
2107: exception
2108: when others then

Line 2109: dbms_sql.close_cursor(c);

2105: exit;
2106: end loop;
2107: exception
2108: when others then
2109: dbms_sql.close_cursor(c);
2110: ad_apps_private.error_buf := 'statement='||
2111: statement||':'||
2112: ad_apps_private.error_buf;
2113: raise;

Line 2123: c := dbms_sql.open_cursor;

2119: c integer;
2120: rows_processed integer;
2121: statement varchar2(500);
2122: begin
2123: c := dbms_sql.open_cursor;
2124: statement :=
2125: 'select nvl(max(last_update_date), '||
2126: ' to_date(''01/01/1970'',''DD/MM/YYYY'')) '||
2127: ' from '||aol_schema||'.ak_language_attribute_xrefs';

Line 2128: dbms_sql.parse(c, statement, dbms_sql.native);

2124: statement :=
2125: 'select nvl(max(last_update_date), '||
2126: ' to_date(''01/01/1970'',''DD/MM/YYYY'')) '||
2127: ' from '||aol_schema||'.ak_language_attribute_xrefs';
2128: dbms_sql.parse(c, statement, dbms_sql.native);
2129: dbms_sql.define_column(c,1,max_xref_date);
2130: rows_processed := dbms_sql.execute(c);
2131: loop
2132: if dbms_sql.fetch_rows(c) > 0 then

Line 2129: dbms_sql.define_column(c,1,max_xref_date);

2125: 'select nvl(max(last_update_date), '||
2126: ' to_date(''01/01/1970'',''DD/MM/YYYY'')) '||
2127: ' from '||aol_schema||'.ak_language_attribute_xrefs';
2128: dbms_sql.parse(c, statement, dbms_sql.native);
2129: dbms_sql.define_column(c,1,max_xref_date);
2130: rows_processed := dbms_sql.execute(c);
2131: loop
2132: if dbms_sql.fetch_rows(c) > 0 then
2133: dbms_sql.column_value(c,1,max_xref_date);

Line 2130: rows_processed := dbms_sql.execute(c);

2126: ' to_date(''01/01/1970'',''DD/MM/YYYY'')) '||
2127: ' from '||aol_schema||'.ak_language_attribute_xrefs';
2128: dbms_sql.parse(c, statement, dbms_sql.native);
2129: dbms_sql.define_column(c,1,max_xref_date);
2130: rows_processed := dbms_sql.execute(c);
2131: loop
2132: if dbms_sql.fetch_rows(c) > 0 then
2133: dbms_sql.column_value(c,1,max_xref_date);
2134: end if;

Line 2132: if dbms_sql.fetch_rows(c) > 0 then

2128: dbms_sql.parse(c, statement, dbms_sql.native);
2129: dbms_sql.define_column(c,1,max_xref_date);
2130: rows_processed := dbms_sql.execute(c);
2131: loop
2132: if dbms_sql.fetch_rows(c) > 0 then
2133: dbms_sql.column_value(c,1,max_xref_date);
2134: end if;
2135: dbms_sql.close_cursor(c);
2136: exit;

Line 2133: dbms_sql.column_value(c,1,max_xref_date);

2129: dbms_sql.define_column(c,1,max_xref_date);
2130: rows_processed := dbms_sql.execute(c);
2131: loop
2132: if dbms_sql.fetch_rows(c) > 0 then
2133: dbms_sql.column_value(c,1,max_xref_date);
2134: end if;
2135: dbms_sql.close_cursor(c);
2136: exit;
2137: end loop;

Line 2135: dbms_sql.close_cursor(c);

2131: loop
2132: if dbms_sql.fetch_rows(c) > 0 then
2133: dbms_sql.column_value(c,1,max_xref_date);
2134: end if;
2135: dbms_sql.close_cursor(c);
2136: exit;
2137: end loop;
2138: exception
2139: when others then

Line 2140: dbms_sql.close_cursor(c);

2136: exit;
2137: end loop;
2138: exception
2139: when others then
2140: dbms_sql.close_cursor(c);
2141: ad_apps_private.error_buf := 'statement='||
2142: statement||':'||
2143: ad_apps_private.error_buf;
2144: raise;

Line 2148: c := dbms_sql.open_cursor;

2144: raise;
2145: end;
2146:
2147:
2148: c := dbms_sql.open_cursor;
2149:
2150: if create_mls_views then
2151: -- work on tables that are multilingual
2152: statement := 'select distinct upper(atc.table_name) '||

Line 2165: dbms_sql.parse(c, statement, dbms_sql.native);

2161: 'and :table_schema = ''X'' ';
2162: end if;
2163:
2164:
2165: dbms_sql.parse(c, statement, dbms_sql.native);
2166: dbms_sql.bind_variable(c,'table_schema',table_schema);
2167: dbms_sql.define_column(c,1,l_table_name,30);
2168: rows_processed := dbms_sql.execute(c);
2169: loop

Line 2166: dbms_sql.bind_variable(c,'table_schema',table_schema);

2162: end if;
2163:
2164:
2165: dbms_sql.parse(c, statement, dbms_sql.native);
2166: dbms_sql.bind_variable(c,'table_schema',table_schema);
2167: dbms_sql.define_column(c,1,l_table_name,30);
2168: rows_processed := dbms_sql.execute(c);
2169: loop
2170: if dbms_sql.fetch_rows(c) > 0 then

Line 2167: dbms_sql.define_column(c,1,l_table_name,30);

2163:
2164:
2165: dbms_sql.parse(c, statement, dbms_sql.native);
2166: dbms_sql.bind_variable(c,'table_schema',table_schema);
2167: dbms_sql.define_column(c,1,l_table_name,30);
2168: rows_processed := dbms_sql.execute(c);
2169: loop
2170: if dbms_sql.fetch_rows(c) > 0 then
2171: dbms_sql.column_value(c,1,l_table_name);

Line 2168: rows_processed := dbms_sql.execute(c);

2164:
2165: dbms_sql.parse(c, statement, dbms_sql.native);
2166: dbms_sql.bind_variable(c,'table_schema',table_schema);
2167: dbms_sql.define_column(c,1,l_table_name,30);
2168: rows_processed := dbms_sql.execute(c);
2169: loop
2170: if dbms_sql.fetch_rows(c) > 0 then
2171: dbms_sql.column_value(c,1,l_table_name);
2172:

Line 2170: if dbms_sql.fetch_rows(c) > 0 then

2166: dbms_sql.bind_variable(c,'table_schema',table_schema);
2167: dbms_sql.define_column(c,1,l_table_name,30);
2168: rows_processed := dbms_sql.execute(c);
2169: loop
2170: if dbms_sql.fetch_rows(c) > 0 then
2171: dbms_sql.column_value(c,1,l_table_name);
2172:
2173: -- initialize all comparison variables
2174: view_is_old := FALSE;

Line 2171: dbms_sql.column_value(c,1,l_table_name);

2167: dbms_sql.define_column(c,1,l_table_name,30);
2168: rows_processed := dbms_sql.execute(c);
2169: loop
2170: if dbms_sql.fetch_rows(c) > 0 then
2171: dbms_sql.column_value(c,1,l_table_name);
2172:
2173: -- initialize all comparison variables
2174: view_is_old := FALSE;
2175: view_date := to_date('01/01/1970','DD/MM/YYYY');

Line 2204: c := dbms_sql.open_cursor;

2200: c integer;
2201: rows_processed integer;
2202: statement varchar2(500);
2203: begin
2204: c := dbms_sql.open_cursor;
2205: statement :=
2206: 'select last_update_date '||
2207: ' from '||aol_schema||'.ak_translated_columns '||
2208: ' where upper(table_name) = upper(:table_name) ';

Line 2209: dbms_sql.parse(c, statement, dbms_sql.native);

2205: statement :=
2206: 'select last_update_date '||
2207: ' from '||aol_schema||'.ak_translated_columns '||
2208: ' where upper(table_name) = upper(:table_name) ';
2209: dbms_sql.parse(c, statement, dbms_sql.native);
2210: dbms_sql.bind_variable(c,'table_name',l_table_name);
2211: dbms_sql.define_column(c,1,trans_record_date);
2212: rows_processed := dbms_sql.execute(c);
2213: loop

Line 2210: dbms_sql.bind_variable(c,'table_name',l_table_name);

2206: 'select last_update_date '||
2207: ' from '||aol_schema||'.ak_translated_columns '||
2208: ' where upper(table_name) = upper(:table_name) ';
2209: dbms_sql.parse(c, statement, dbms_sql.native);
2210: dbms_sql.bind_variable(c,'table_name',l_table_name);
2211: dbms_sql.define_column(c,1,trans_record_date);
2212: rows_processed := dbms_sql.execute(c);
2213: loop
2214: if dbms_sql.fetch_rows(c) > 0 then

Line 2211: dbms_sql.define_column(c,1,trans_record_date);

2207: ' from '||aol_schema||'.ak_translated_columns '||
2208: ' where upper(table_name) = upper(:table_name) ';
2209: dbms_sql.parse(c, statement, dbms_sql.native);
2210: dbms_sql.bind_variable(c,'table_name',l_table_name);
2211: dbms_sql.define_column(c,1,trans_record_date);
2212: rows_processed := dbms_sql.execute(c);
2213: loop
2214: if dbms_sql.fetch_rows(c) > 0 then
2215: dbms_sql.column_value(c,1,trans_record_date);

Line 2212: rows_processed := dbms_sql.execute(c);

2208: ' where upper(table_name) = upper(:table_name) ';
2209: dbms_sql.parse(c, statement, dbms_sql.native);
2210: dbms_sql.bind_variable(c,'table_name',l_table_name);
2211: dbms_sql.define_column(c,1,trans_record_date);
2212: rows_processed := dbms_sql.execute(c);
2213: loop
2214: if dbms_sql.fetch_rows(c) > 0 then
2215: dbms_sql.column_value(c,1,trans_record_date);
2216: end if;

Line 2214: if dbms_sql.fetch_rows(c) > 0 then

2210: dbms_sql.bind_variable(c,'table_name',l_table_name);
2211: dbms_sql.define_column(c,1,trans_record_date);
2212: rows_processed := dbms_sql.execute(c);
2213: loop
2214: if dbms_sql.fetch_rows(c) > 0 then
2215: dbms_sql.column_value(c,1,trans_record_date);
2216: end if;
2217: dbms_sql.close_cursor(c);
2218: exit;

Line 2215: dbms_sql.column_value(c,1,trans_record_date);

2211: dbms_sql.define_column(c,1,trans_record_date);
2212: rows_processed := dbms_sql.execute(c);
2213: loop
2214: if dbms_sql.fetch_rows(c) > 0 then
2215: dbms_sql.column_value(c,1,trans_record_date);
2216: end if;
2217: dbms_sql.close_cursor(c);
2218: exit;
2219: end loop;

Line 2217: dbms_sql.close_cursor(c);

2213: loop
2214: if dbms_sql.fetch_rows(c) > 0 then
2215: dbms_sql.column_value(c,1,trans_record_date);
2216: end if;
2217: dbms_sql.close_cursor(c);
2218: exit;
2219: end loop;
2220: exception
2221: when others then

Line 2222: dbms_sql.close_cursor(c);

2218: exit;
2219: end loop;
2220: exception
2221: when others then
2222: dbms_sql.close_cursor(c);
2223: ad_apps_private.error_buf := 'statement='||
2224: statement||':'||
2225: ad_apps_private.error_buf;
2226: raise;

Line 2308: dbms_sql.close_cursor(c);

2304: end;
2305: end if; -- view_is_old
2306: else
2307: -- no more oracle views to process for this schema
2308: dbms_sql.close_cursor(c);
2309: exit;
2310: end if;
2311: end loop; -- loop over all views
2312:

Line 2315: dbms_sql.close_cursor(c);

2311: end loop; -- loop over all views
2312:
2313: exception
2314: when others then
2315: dbms_sql.close_cursor(c);
2316: ad_apps_private.error_buf := 'statement='||statement||': '||
2317: ad_apps_private.error_buf;
2318: raise;
2319: end;

Line 2323: dbms_sql.close_cursor(oracle_id_cursor);

2319: end;
2320:
2321: else
2322: -- no more rows to process
2323: dbms_sql.close_cursor(oracle_id_cursor);
2324: exit;
2325: end if;
2326: end loop;
2327: exception

Line 2329: dbms_sql.close_cursor(oracle_id_cursor);

2325: end if;
2326: end loop;
2327: exception
2328: when others then
2329: dbms_sql.close_cursor(oracle_id_cursor);
2330: ad_apps_private.error_buf := 'create_special_views('||install_group_num||
2331: ','||aol_schema||
2332: ','||apps_schema||',create_mls_views): '||
2333: ad_apps_private.error_buf;

Line 3739: c := dbms_sql.open_cursor;

3735: c integer;
3736: rows_processed integer;
3737: statement varchar2(500);
3738: begin
3739: c := dbms_sql.open_cursor;
3740: statement := 'select nvl(min(multi_currency_flag),''N''), '||
3741: 'nvl(min(multi_lingual_flag),''N'') '||
3742: 'from '||aol_schema||'.fnd_product_groups';
3743: dbms_sql.parse(c, statement, dbms_sql.native);

Line 3743: dbms_sql.parse(c, statement, dbms_sql.native);

3739: c := dbms_sql.open_cursor;
3740: statement := 'select nvl(min(multi_currency_flag),''N''), '||
3741: 'nvl(min(multi_lingual_flag),''N'') '||
3742: 'from '||aol_schema||'.fnd_product_groups';
3743: dbms_sql.parse(c, statement, dbms_sql.native);
3744: dbms_sql.define_column(c,1,x,30);
3745: dbms_sql.define_column(c,2,y,30);
3746: rows_processed := dbms_sql.execute(c);
3747: if dbms_sql.fetch_rows(c) > 0 then

Line 3744: dbms_sql.define_column(c,1,x,30);

3740: statement := 'select nvl(min(multi_currency_flag),''N''), '||
3741: 'nvl(min(multi_lingual_flag),''N'') '||
3742: 'from '||aol_schema||'.fnd_product_groups';
3743: dbms_sql.parse(c, statement, dbms_sql.native);
3744: dbms_sql.define_column(c,1,x,30);
3745: dbms_sql.define_column(c,2,y,30);
3746: rows_processed := dbms_sql.execute(c);
3747: if dbms_sql.fetch_rows(c) > 0 then
3748: dbms_sql.column_value(c,1,x);

Line 3745: dbms_sql.define_column(c,2,y,30);

3741: 'nvl(min(multi_lingual_flag),''N'') '||
3742: 'from '||aol_schema||'.fnd_product_groups';
3743: dbms_sql.parse(c, statement, dbms_sql.native);
3744: dbms_sql.define_column(c,1,x,30);
3745: dbms_sql.define_column(c,2,y,30);
3746: rows_processed := dbms_sql.execute(c);
3747: if dbms_sql.fetch_rows(c) > 0 then
3748: dbms_sql.column_value(c,1,x);
3749: dbms_sql.column_value(c,2,y);

Line 3746: rows_processed := dbms_sql.execute(c);

3742: 'from '||aol_schema||'.fnd_product_groups';
3743: dbms_sql.parse(c, statement, dbms_sql.native);
3744: dbms_sql.define_column(c,1,x,30);
3745: dbms_sql.define_column(c,2,y,30);
3746: rows_processed := dbms_sql.execute(c);
3747: if dbms_sql.fetch_rows(c) > 0 then
3748: dbms_sql.column_value(c,1,x);
3749: dbms_sql.column_value(c,2,y);
3750:

Line 3747: if dbms_sql.fetch_rows(c) > 0 then

3743: dbms_sql.parse(c, statement, dbms_sql.native);
3744: dbms_sql.define_column(c,1,x,30);
3745: dbms_sql.define_column(c,2,y,30);
3746: rows_processed := dbms_sql.execute(c);
3747: if dbms_sql.fetch_rows(c) > 0 then
3748: dbms_sql.column_value(c,1,x);
3749: dbms_sql.column_value(c,2,y);
3750:
3751: if x = 'Y' then

Line 3748: dbms_sql.column_value(c,1,x);

3744: dbms_sql.define_column(c,1,x,30);
3745: dbms_sql.define_column(c,2,y,30);
3746: rows_processed := dbms_sql.execute(c);
3747: if dbms_sql.fetch_rows(c) > 0 then
3748: dbms_sql.column_value(c,1,x);
3749: dbms_sql.column_value(c,2,y);
3750:
3751: if x = 'Y' then
3752: -- Fixed bug 3258312 : Although MRC flag is at 'Y', someone

Line 3749: dbms_sql.column_value(c,2,y);

3745: dbms_sql.define_column(c,2,y,30);
3746: rows_processed := dbms_sql.execute(c);
3747: if dbms_sql.fetch_rows(c) > 0 then
3748: dbms_sql.column_value(c,1,x);
3749: dbms_sql.column_value(c,2,y);
3750:
3751: if x = 'Y' then
3752: -- Fixed bug 3258312 : Although MRC flag is at 'Y', someone
3753: -- may have dropped it or the release might be 11.5.10 or more.

Line 3839: dbms_sql.close_cursor(c);

3835: ad_apps_private.is_mls := TRUE;
3836: else
3837: ad_apps_private.is_mls := FALSE;
3838: end if;
3839: dbms_sql.close_cursor(c);
3840: else
3841: raise no_data_found;
3842: end if;
3843: exception

Line 3845: dbms_sql.close_cursor(c);

3841: raise no_data_found;
3842: end if;
3843: exception
3844: when others then
3845: dbms_sql.close_cursor(c);
3846: ad_apps_private.error_buf := 'statement='||
3847: statement||':'||
3848: ad_apps_private.error_buf;
3849: raise;