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.

[Home] [Help]

APPS.EDW_GEN_VIEW dependencies on DBMS_SQL

Line 95: cid := DBMS_SQL.open_cursor;

91: writelog('Executing following SQL to get the APPS schema :');
92: writelog(stmt);
93: END IF;
94:
95: cid := DBMS_SQL.open_cursor;
96:
97: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
98: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_schema, 100);
99:

Line 97: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

93: END IF;
94:
95: cid := DBMS_SQL.open_cursor;
96:
97: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
98: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_schema, 100);
99:
100: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
101:

Line 98: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_schema, 100);

94:
95: cid := DBMS_SQL.open_cursor;
96:
97: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
98: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_schema, 100);
99:
100: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
101:
102: DBMS_SQL.COLUMN_VALUE(cid, 1, l_schema);

Line 100: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

96:
97: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
98: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_schema, 100);
99:
100: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
101:
102: DBMS_SQL.COLUMN_VALUE(cid, 1, l_schema);
103: DBMS_SQL.close_cursor(cid);
104:

Line 102: DBMS_SQL.COLUMN_VALUE(cid, 1, l_schema);

98: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_schema, 100);
99:
100: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
101:
102: DBMS_SQL.COLUMN_VALUE(cid, 1, l_schema);
103: DBMS_SQL.close_cursor(cid);
104:
105:
106: IF (g_log) THEN

Line 103: DBMS_SQL.close_cursor(cid);

99:
100: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
101:
102: DBMS_SQL.COLUMN_VALUE(cid, 1, l_schema);
103: DBMS_SQL.close_cursor(cid);
104:
105:
106: IF (g_log) THEN
107: writelog('Completed getAppsSchema, returning:'||l_schema);

Line 191: v_segment_list DBMS_SQL.VARCHAR2_TABLE;

187: l_newstring varchar2(100);
188: l_length number := 0;
189: l_string varchar2(100);
190: l_trunc_segment varchar2(30);
191: v_segment_list DBMS_SQL.VARCHAR2_TABLE;
192:
193: CURSOR C_Key_Segment_List(p_id_flex_code VARCHAR2, p_struct_num NUMBER, p_trunc_segment VARCHAR2) IS
194: select segment_name
195: from fnd_id_flex_segments_vl

Line 509: cid := DBMS_SQL.open_cursor;

505:
506:
507: stmt := ' SELECT count(distinct(column_name)) FROM all_tab_columns@'||g_source_db_link;
508: stmt := stmt||' WHERE table_name = :view_name AND owner = :owner';
509: cid := DBMS_SQL.open_cursor;
510: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
511:
512: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
513: DBMS_SQL.BIND_VARIABLE(cid, ':owner', g_apps_schema, 50);

Line 510: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

506:
507: stmt := ' SELECT count(distinct(column_name)) FROM all_tab_columns@'||g_source_db_link;
508: stmt := stmt||' WHERE table_name = :view_name AND owner = :owner';
509: cid := DBMS_SQL.open_cursor;
510: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
511:
512: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
513: DBMS_SQL.BIND_VARIABLE(cid, ':owner', g_apps_schema, 50);
514:

Line 512: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);

508: stmt := stmt||' WHERE table_name = :view_name AND owner = :owner';
509: cid := DBMS_SQL.open_cursor;
510: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
511:
512: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
513: DBMS_SQL.BIND_VARIABLE(cid, ':owner', g_apps_schema, 50);
514:
515: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_count);
516: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

Line 513: DBMS_SQL.BIND_VARIABLE(cid, ':owner', g_apps_schema, 50);

509: cid := DBMS_SQL.open_cursor;
510: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
511:
512: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
513: DBMS_SQL.BIND_VARIABLE(cid, ':owner', g_apps_schema, 50);
514:
515: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_count);
516: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
517: DBMS_SQL.COLUMN_VALUE(cid, 1, l_count);

Line 515: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_count);

511:
512: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
513: DBMS_SQL.BIND_VARIABLE(cid, ':owner', g_apps_schema, 50);
514:
515: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_count);
516: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
517: DBMS_SQL.COLUMN_VALUE(cid, 1, l_count);
518: DBMS_SQL.close_cursor(cid);
519:

Line 516: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

512: DBMS_SQL.BIND_VARIABLE(cid, ':view_name', upper(view_name), 50);
513: DBMS_SQL.BIND_VARIABLE(cid, ':owner', g_apps_schema, 50);
514:
515: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_count);
516: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
517: DBMS_SQL.COLUMN_VALUE(cid, 1, l_count);
518: DBMS_SQL.close_cursor(cid);
519:
520: IF (g_log) THEN

Line 517: DBMS_SQL.COLUMN_VALUE(cid, 1, l_count);

513: DBMS_SQL.BIND_VARIABLE(cid, ':owner', g_apps_schema, 50);
514:
515: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_count);
516: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
517: DBMS_SQL.COLUMN_VALUE(cid, 1, l_count);
518: DBMS_SQL.close_cursor(cid);
519:
520: IF (g_log) THEN
521: writelog('Completed getColumnCountForView, Column count is : '||l_count);

Line 518: DBMS_SQL.close_cursor(cid);

514:
515: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_count);
516: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
517: DBMS_SQL.COLUMN_VALUE(cid, 1, l_count);
518: DBMS_SQL.close_cursor(cid);
519:
520: IF (g_log) THEN
521: writelog('Completed getColumnCountForView, Column count is : '||l_count);
522: indentEnd;

Line 537: cid := DBMS_SQL.OPEN_CURSOR;

533: l_dummy number;
534: begin
535: apiClause := 'BEGIN
536: IF (FND_INSTALLATION.GET_APP_INFO@'||edw_gen_view.g_source_db_link||'(''FND'', :dummy1, :dummy2, :l_applsys_schema)) THEN NULL; END IF; END;';
537: cid := DBMS_SQL.OPEN_CURSOR;
538: DBMS_SQL.PARSE(cid, apiClause, DBMS_SQL.NATIVE);
539: DBMS_SQL.BIND_VARIABLE(cid, ':dummy1', dummy1, 32);
540: DBMS_SQL.BIND_VARIABLE(cid, ':dummy2', dummy2, 32);
541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);

Line 538: DBMS_SQL.PARSE(cid, apiClause, DBMS_SQL.NATIVE);

534: begin
535: apiClause := 'BEGIN
536: IF (FND_INSTALLATION.GET_APP_INFO@'||edw_gen_view.g_source_db_link||'(''FND'', :dummy1, :dummy2, :l_applsys_schema)) THEN NULL; END IF; END;';
537: cid := DBMS_SQL.OPEN_CURSOR;
538: DBMS_SQL.PARSE(cid, apiClause, DBMS_SQL.NATIVE);
539: DBMS_SQL.BIND_VARIABLE(cid, ':dummy1', dummy1, 32);
540: DBMS_SQL.BIND_VARIABLE(cid, ':dummy2', dummy2, 32);
541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);
542:

Line 539: DBMS_SQL.BIND_VARIABLE(cid, ':dummy1', dummy1, 32);

535: apiClause := 'BEGIN
536: IF (FND_INSTALLATION.GET_APP_INFO@'||edw_gen_view.g_source_db_link||'(''FND'', :dummy1, :dummy2, :l_applsys_schema)) THEN NULL; END IF; END;';
537: cid := DBMS_SQL.OPEN_CURSOR;
538: DBMS_SQL.PARSE(cid, apiClause, DBMS_SQL.NATIVE);
539: DBMS_SQL.BIND_VARIABLE(cid, ':dummy1', dummy1, 32);
540: DBMS_SQL.BIND_VARIABLE(cid, ':dummy2', dummy2, 32);
541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);
542:
543: l_dummy := DBMS_SQL.EXECUTE(cid);

Line 540: DBMS_SQL.BIND_VARIABLE(cid, ':dummy2', dummy2, 32);

536: IF (FND_INSTALLATION.GET_APP_INFO@'||edw_gen_view.g_source_db_link||'(''FND'', :dummy1, :dummy2, :l_applsys_schema)) THEN NULL; END IF; END;';
537: cid := DBMS_SQL.OPEN_CURSOR;
538: DBMS_SQL.PARSE(cid, apiClause, DBMS_SQL.NATIVE);
539: DBMS_SQL.BIND_VARIABLE(cid, ':dummy1', dummy1, 32);
540: DBMS_SQL.BIND_VARIABLE(cid, ':dummy2', dummy2, 32);
541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);
542:
543: l_dummy := DBMS_SQL.EXECUTE(cid);
544: DBMS_SQL.VARIABLE_VALUE(cid, ':l_applsys_schema', l_applsys_schema);

Line 541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);

537: cid := DBMS_SQL.OPEN_CURSOR;
538: DBMS_SQL.PARSE(cid, apiClause, DBMS_SQL.NATIVE);
539: DBMS_SQL.BIND_VARIABLE(cid, ':dummy1', dummy1, 32);
540: DBMS_SQL.BIND_VARIABLE(cid, ':dummy2', dummy2, 32);
541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);
542:
543: l_dummy := DBMS_SQL.EXECUTE(cid);
544: DBMS_SQL.VARIABLE_VALUE(cid, ':l_applsys_schema', l_applsys_schema);
545: DBMS_SQL.CLOSE_CURSOR(cid);

Line 543: l_dummy := DBMS_SQL.EXECUTE(cid);

539: DBMS_SQL.BIND_VARIABLE(cid, ':dummy1', dummy1, 32);
540: DBMS_SQL.BIND_VARIABLE(cid, ':dummy2', dummy2, 32);
541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);
542:
543: l_dummy := DBMS_SQL.EXECUTE(cid);
544: DBMS_SQL.VARIABLE_VALUE(cid, ':l_applsys_schema', l_applsys_schema);
545: DBMS_SQL.CLOSE_CURSOR(cid);
546: return l_applsys_schema;
547: exception

Line 544: DBMS_SQL.VARIABLE_VALUE(cid, ':l_applsys_schema', l_applsys_schema);

540: DBMS_SQL.BIND_VARIABLE(cid, ':dummy2', dummy2, 32);
541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);
542:
543: l_dummy := DBMS_SQL.EXECUTE(cid);
544: DBMS_SQL.VARIABLE_VALUE(cid, ':l_applsys_schema', l_applsys_schema);
545: DBMS_SQL.CLOSE_CURSOR(cid);
546: return l_applsys_schema;
547: exception
548: when others then

Line 545: DBMS_SQL.CLOSE_CURSOR(cid);

541: DBMS_SQL.BIND_VARIABLE(cid, ':l_applsys_schema', l_applsys_schema, 32);
542:
543: l_dummy := DBMS_SQL.EXECUTE(cid);
544: DBMS_SQL.VARIABLE_VALUE(cid, ':l_applsys_schema', l_applsys_schema);
545: DBMS_SQL.CLOSE_CURSOR(cid);
546: return l_applsys_schema;
547: exception
548: when others then
549: if g_log then

Line 642: cid := DBMS_SQL.open_cursor;

638: apiClause := apiClause|| ', APPLICATION_SHORT_NAME => ''FND''';
639: apiClause := apiClause||newline||', STATEMENT_TYPE => 2, STATEMENT => :source_view ';
640: apiClause := apiClause||' , OBJECT_NAME => '''||view_name||'''); END;';
641:
642: cid := DBMS_SQL.open_cursor;
643: dbms_sql.parse(cid, apiClause, dbms_sql.native);
644: DBMS_SQL.BIND_VARIABLE(cid, ':source_view', src_view, 32760);
645: l_dummy := DBMS_SQL.EXECUTE(cid);
646: DBMS_SQL.close_cursor(cid);

Line 643: dbms_sql.parse(cid, apiClause, dbms_sql.native);

639: apiClause := apiClause||newline||', STATEMENT_TYPE => 2, STATEMENT => :source_view ';
640: apiClause := apiClause||' , OBJECT_NAME => '''||view_name||'''); END;';
641:
642: cid := DBMS_SQL.open_cursor;
643: dbms_sql.parse(cid, apiClause, dbms_sql.native);
644: DBMS_SQL.BIND_VARIABLE(cid, ':source_view', src_view, 32760);
645: l_dummy := DBMS_SQL.EXECUTE(cid);
646: DBMS_SQL.close_cursor(cid);
647:

Line 644: DBMS_SQL.BIND_VARIABLE(cid, ':source_view', src_view, 32760);

640: apiClause := apiClause||' , OBJECT_NAME => '''||view_name||'''); END;';
641:
642: cid := DBMS_SQL.open_cursor;
643: dbms_sql.parse(cid, apiClause, dbms_sql.native);
644: DBMS_SQL.BIND_VARIABLE(cid, ':source_view', src_view, 32760);
645: l_dummy := DBMS_SQL.EXECUTE(cid);
646: DBMS_SQL.close_cursor(cid);
647:
648: IF (g_log) THEN

Line 645: l_dummy := DBMS_SQL.EXECUTE(cid);

641:
642: cid := DBMS_SQL.open_cursor;
643: dbms_sql.parse(cid, apiClause, dbms_sql.native);
644: DBMS_SQL.BIND_VARIABLE(cid, ':source_view', src_view, 32760);
645: l_dummy := DBMS_SQL.EXECUTE(cid);
646: DBMS_SQL.close_cursor(cid);
647:
648: IF (g_log) THEN
649: writelog('Going to check view status of deployed view');

Line 646: DBMS_SQL.close_cursor(cid);

642: cid := DBMS_SQL.open_cursor;
643: dbms_sql.parse(cid, apiClause, dbms_sql.native);
644: DBMS_SQL.BIND_VARIABLE(cid, ':source_view', src_view, 32760);
645: l_dummy := DBMS_SQL.EXECUTE(cid);
646: DBMS_SQL.close_cursor(cid);
647:
648: IF (g_log) THEN
649: writelog('Going to check view status of deployed view');
650: END IF;

Line 708: cid := DBMS_SQL.open_cursor;

704: apiClause := apiClause|| ', APPLICATION_SHORT_NAME => ''FND''';
705: apiClause := apiClause||newline||', STATEMENT_TYPE => 2, lb => :first_line , ub=>:last_line';
706: apiClause := apiClause||' , OBJECT_NAME => :object_name); END;';
707:
708: cid := DBMS_SQL.open_cursor;
709: dbms_sql.parse(cid, apiClause, dbms_sql.native);
710: DBMS_SQL.BIND_VARIABLE(cid, ':first_line', p_first_line_num);
711: DBMS_SQL.BIND_VARIABLE(cid, ':last_line', p_last_line_num);
712: DBMS_SQL.BIND_VARIABLE(cid, ':object_name',view_name ,30);

Line 709: dbms_sql.parse(cid, apiClause, dbms_sql.native);

705: apiClause := apiClause||newline||', STATEMENT_TYPE => 2, lb => :first_line , ub=>:last_line';
706: apiClause := apiClause||' , OBJECT_NAME => :object_name); END;';
707:
708: cid := DBMS_SQL.open_cursor;
709: dbms_sql.parse(cid, apiClause, dbms_sql.native);
710: DBMS_SQL.BIND_VARIABLE(cid, ':first_line', p_first_line_num);
711: DBMS_SQL.BIND_VARIABLE(cid, ':last_line', p_last_line_num);
712: DBMS_SQL.BIND_VARIABLE(cid, ':object_name',view_name ,30);
713:

Line 710: DBMS_SQL.BIND_VARIABLE(cid, ':first_line', p_first_line_num);

706: apiClause := apiClause||' , OBJECT_NAME => :object_name); END;';
707:
708: cid := DBMS_SQL.open_cursor;
709: dbms_sql.parse(cid, apiClause, dbms_sql.native);
710: DBMS_SQL.BIND_VARIABLE(cid, ':first_line', p_first_line_num);
711: DBMS_SQL.BIND_VARIABLE(cid, ':last_line', p_last_line_num);
712: DBMS_SQL.BIND_VARIABLE(cid, ':object_name',view_name ,30);
713:
714: l_dummy := DBMS_SQL.EXECUTE(cid);

Line 711: DBMS_SQL.BIND_VARIABLE(cid, ':last_line', p_last_line_num);

707:
708: cid := DBMS_SQL.open_cursor;
709: dbms_sql.parse(cid, apiClause, dbms_sql.native);
710: DBMS_SQL.BIND_VARIABLE(cid, ':first_line', p_first_line_num);
711: DBMS_SQL.BIND_VARIABLE(cid, ':last_line', p_last_line_num);
712: DBMS_SQL.BIND_VARIABLE(cid, ':object_name',view_name ,30);
713:
714: l_dummy := DBMS_SQL.EXECUTE(cid);
715: DBMS_SQL.close_cursor(cid);

Line 712: DBMS_SQL.BIND_VARIABLE(cid, ':object_name',view_name ,30);

708: cid := DBMS_SQL.open_cursor;
709: dbms_sql.parse(cid, apiClause, dbms_sql.native);
710: DBMS_SQL.BIND_VARIABLE(cid, ':first_line', p_first_line_num);
711: DBMS_SQL.BIND_VARIABLE(cid, ':last_line', p_last_line_num);
712: DBMS_SQL.BIND_VARIABLE(cid, ':object_name',view_name ,30);
713:
714: l_dummy := DBMS_SQL.EXECUTE(cid);
715: DBMS_SQL.close_cursor(cid);
716:

Line 714: l_dummy := DBMS_SQL.EXECUTE(cid);

710: DBMS_SQL.BIND_VARIABLE(cid, ':first_line', p_first_line_num);
711: DBMS_SQL.BIND_VARIABLE(cid, ':last_line', p_last_line_num);
712: DBMS_SQL.BIND_VARIABLE(cid, ':object_name',view_name ,30);
713:
714: l_dummy := DBMS_SQL.EXECUTE(cid);
715: DBMS_SQL.close_cursor(cid);
716:
717: status := getViewStatus(view_name);
718: IF (status <> 'VALID') THEN

Line 715: DBMS_SQL.close_cursor(cid);

711: DBMS_SQL.BIND_VARIABLE(cid, ':last_line', p_last_line_num);
712: DBMS_SQL.BIND_VARIABLE(cid, ':object_name',view_name ,30);
713:
714: l_dummy := DBMS_SQL.EXECUTE(cid);
715: DBMS_SQL.close_cursor(cid);
716:
717: status := getViewStatus(view_name);
718: IF (status <> 'VALID') THEN
719:

Line 1032: cid := DBMS_SQL.open_cursor;

1028: indentBegin;
1029: writelog('Inside getAppsVersion');
1030: END IF;
1031:
1032: cid := DBMS_SQL.open_cursor;
1033:
1034: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1035: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1036:

Line 1034: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

1030: END IF;
1031:
1032: cid := DBMS_SQL.open_cursor;
1033:
1034: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1035: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1036:
1037: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1038:

Line 1035: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);

1031:
1032: cid := DBMS_SQL.open_cursor;
1033:
1034: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1035: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1036:
1037: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1038:
1039: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);

Line 1037: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

1033:
1034: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1035: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1036:
1037: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1038:
1039: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);
1040: DBMS_SQL.close_cursor(cid);
1041:

Line 1039: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);

1035: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1036:
1037: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1038:
1039: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);
1040: DBMS_SQL.close_cursor(cid);
1041:
1042: IF (g_version like '10.7%') THEN
1043: g_version := '10.7';

Line 1040: DBMS_SQL.close_cursor(cid);

1036:
1037: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1038:
1039: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);
1040: DBMS_SQL.close_cursor(cid);
1041:
1042: IF (g_version like '10.7%') THEN
1043: g_version := '10.7';
1044: ELSIF (g_version like '11.0%') THEN

Line 1089: cid := DBMS_SQL.open_cursor;

1085: indentBegin;
1086: writelog('Inside getAppsVersion with instance='||p_instance);
1087: END IF;
1088:
1089: cid := DBMS_SQL.open_cursor;
1090:
1091: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1092: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1093:

Line 1091: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

1087: END IF;
1088:
1089: cid := DBMS_SQL.open_cursor;
1090:
1091: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1092: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1093:
1094: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1095:

Line 1092: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);

1088:
1089: cid := DBMS_SQL.open_cursor;
1090:
1091: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1092: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1093:
1094: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1095:
1096: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);

Line 1094: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);

1090:
1091: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1092: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1093:
1094: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1095:
1096: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);
1097: DBMS_SQL.close_cursor(cid);
1098:

Line 1096: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);

1092: DBMS_SQL.DEFINE_COLUMN(cid, 1, g_version, 100);
1093:
1094: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1095:
1096: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);
1097: DBMS_SQL.close_cursor(cid);
1098:
1099: IF (g_version like '10.7%') THEN
1100: g_version := '10.7';

Line 1097: DBMS_SQL.close_cursor(cid);

1093:
1094: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(cid);
1095:
1096: DBMS_SQL.COLUMN_VALUE(cid, 1, g_version);
1097: DBMS_SQL.close_cursor(cid);
1098:
1099: IF (g_version like '10.7%') THEN
1100: g_version := '10.7';
1101: ELSIF (g_version like '11.0%') THEN

Line 1540: cid := DBMS_SQL.open_cursor;

1536:
1537: stmt := 'delete from edw_object_deployments where
1538: object_short_name = :obj and instance_code = :src';
1539:
1540: cid := DBMS_SQL.open_cursor;
1541: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1542: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1543: DBMS_SQL.BIND_VARIABLE(cid, ':src', p_instance, 50);
1544:

Line 1541: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

1537: stmt := 'delete from edw_object_deployments where
1538: object_short_name = :obj and instance_code = :src';
1539:
1540: cid := DBMS_SQL.open_cursor;
1541: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1542: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1543: DBMS_SQL.BIND_VARIABLE(cid, ':src', p_instance, 50);
1544:
1545: l_dummy := DBMS_SQL.EXECUTE(cid);

Line 1542: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);

1538: object_short_name = :obj and instance_code = :src';
1539:
1540: cid := DBMS_SQL.open_cursor;
1541: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1542: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1543: DBMS_SQL.BIND_VARIABLE(cid, ':src', p_instance, 50);
1544:
1545: l_dummy := DBMS_SQL.EXECUTE(cid);
1546: DBMS_SQL.close_cursor(cid);

Line 1543: DBMS_SQL.BIND_VARIABLE(cid, ':src', p_instance, 50);

1539:
1540: cid := DBMS_SQL.open_cursor;
1541: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1542: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1543: DBMS_SQL.BIND_VARIABLE(cid, ':src', p_instance, 50);
1544:
1545: l_dummy := DBMS_SQL.EXECUTE(cid);
1546: DBMS_SQL.close_cursor(cid);
1547:

Line 1545: l_dummy := DBMS_SQL.EXECUTE(cid);

1541: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1542: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1543: DBMS_SQL.BIND_VARIABLE(cid, ':src', p_instance, 50);
1544:
1545: l_dummy := DBMS_SQL.EXECUTE(cid);
1546: DBMS_SQL.close_cursor(cid);
1547:
1548: cid := DBMS_SQL.open_cursor;
1549: stmt := 'INSERT INTO edw_object_deployments(object_short_name ,

Line 1546: DBMS_SQL.close_cursor(cid);

1542: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1543: DBMS_SQL.BIND_VARIABLE(cid, ':src', p_instance, 50);
1544:
1545: l_dummy := DBMS_SQL.EXECUTE(cid);
1546: DBMS_SQL.close_cursor(cid);
1547:
1548: cid := DBMS_SQL.open_cursor;
1549: stmt := 'INSERT INTO edw_object_deployments(object_short_name ,
1550: dim_flag ,

Line 1548: cid := DBMS_SQL.open_cursor;

1544:
1545: l_dummy := DBMS_SQL.EXECUTE(cid);
1546: DBMS_SQL.close_cursor(cid);
1547:
1548: cid := DBMS_SQL.open_cursor;
1549: stmt := 'INSERT INTO edw_object_deployments(object_short_name ,
1550: dim_flag ,
1551: instance_code ,
1552: deployment_date ,

Line 1560: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);

1556: last_update_login ,
1557: created_by ,
1558: creation_date ) VALUES
1559: (:obj, :dim_flag, :source, sysdate, ''N'', sysdate, 1, 1, 1, sysdate)';
1560: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1561: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1562:
1563: IF (p_obj_type = 'DIMENSION') THEN
1564: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'Y', 1);

Line 1561: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);

1557: created_by ,
1558: creation_date ) VALUES
1559: (:obj, :dim_flag, :source, sysdate, ''N'', sysdate, 1, 1, 1, sysdate)';
1560: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1561: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1562:
1563: IF (p_obj_type = 'DIMENSION') THEN
1564: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'Y', 1);
1565: ELSE

Line 1564: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'Y', 1);

1560: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
1561: DBMS_SQL.BIND_VARIABLE(cid, ':obj', p_obj_name, 50);
1562:
1563: IF (p_obj_type = 'DIMENSION') THEN
1564: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'Y', 1);
1565: ELSE
1566: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'N', 1);
1567: END IF;
1568: DBMS_SQL.BIND_VARIABLE(cid, ':source', p_instance, 50);

Line 1566: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'N', 1);

1562:
1563: IF (p_obj_type = 'DIMENSION') THEN
1564: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'Y', 1);
1565: ELSE
1566: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'N', 1);
1567: END IF;
1568: DBMS_SQL.BIND_VARIABLE(cid, ':source', p_instance, 50);
1569: l_dummy := DBMS_SQL.EXECUTE(cid);
1570: DBMS_SQL.close_cursor(cid);

Line 1568: DBMS_SQL.BIND_VARIABLE(cid, ':source', p_instance, 50);

1564: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'Y', 1);
1565: ELSE
1566: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'N', 1);
1567: END IF;
1568: DBMS_SQL.BIND_VARIABLE(cid, ':source', p_instance, 50);
1569: l_dummy := DBMS_SQL.EXECUTE(cid);
1570: DBMS_SQL.close_cursor(cid);
1571: commit;
1572:

Line 1569: l_dummy := DBMS_SQL.EXECUTE(cid);

1565: ELSE
1566: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'N', 1);
1567: END IF;
1568: DBMS_SQL.BIND_VARIABLE(cid, ':source', p_instance, 50);
1569: l_dummy := DBMS_SQL.EXECUTE(cid);
1570: DBMS_SQL.close_cursor(cid);
1571: commit;
1572:
1573:

Line 1570: DBMS_SQL.close_cursor(cid);

1566: DBMS_SQL.BIND_VARIABLE(cid, ':dim_flag', 'N', 1);
1567: END IF;
1568: DBMS_SQL.BIND_VARIABLE(cid, ':source', p_instance, 50);
1569: l_dummy := DBMS_SQL.EXECUTE(cid);
1570: DBMS_SQL.close_cursor(cid);
1571: commit;
1572:
1573:
1574: IF (NOT g_success) THEN

Line 1670: l_cursor:=dbms_sql.open_cursor;

1666: IF (g_log) THEN
1667: edw_gen_view.writelog('Querying where clause : '|| l_stmt);
1668: END IF;
1669:
1670: l_cursor:=dbms_sql.open_cursor;
1671: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
1672: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
1673: dbms_sql.define_column_long(l_cursor,1);
1674:

Line 1671: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);

1667: edw_gen_view.writelog('Querying where clause : '|| l_stmt);
1668: END IF;
1669:
1670: l_cursor:=dbms_sql.open_cursor;
1671: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
1672: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
1673: dbms_sql.define_column_long(l_cursor,1);
1674:
1675: l_dummy:=dbms_sql.execute(l_cursor);

Line 1672: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);

1668: END IF;
1669:
1670: l_cursor:=dbms_sql.open_cursor;
1671: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
1672: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
1673: dbms_sql.define_column_long(l_cursor,1);
1674:
1675: l_dummy:=dbms_sql.execute(l_cursor);
1676:

Line 1673: dbms_sql.define_column_long(l_cursor,1);

1669:
1670: l_cursor:=dbms_sql.open_cursor;
1671: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
1672: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
1673: dbms_sql.define_column_long(l_cursor,1);
1674:
1675: l_dummy:=dbms_sql.execute(l_cursor);
1676:
1677: LOOP

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

1671: dbms_sql.parse(l_cursor, l_stmt, dbms_sql.native);
1672: dbms_sql.bind_variable(l_cursor, ':vsid', p_value_set_id);
1673: dbms_sql.define_column_long(l_cursor,1);
1674:
1675: l_dummy:=dbms_sql.execute(l_cursor);
1676:
1677: LOOP
1678: -- fetch 'chunks' of the long until we have got the lot
1679: edw_gen_view.writelog('Checking for bind variables '||l_count);

Line 1680: IF (dbms_sql.fetch_rows(l_cursor) = 0) THEN

1676:
1677: LOOP
1678: -- fetch 'chunks' of the long until we have got the lot
1679: edw_gen_view.writelog('Checking for bind variables '||l_count);
1680: IF (dbms_sql.fetch_rows(l_cursor) = 0) THEN
1681: EXIT;
1682: END IF;
1683:
1684: dbms_sql.column_value_long(l_cursor,1,l_chunk_size,l_cur_pos,l_data_chunk,l_chunk_size_returned);

Line 1684: dbms_sql.column_value_long(l_cursor,1,l_chunk_size,l_cur_pos,l_data_chunk,l_chunk_size_returned);

1680: IF (dbms_sql.fetch_rows(l_cursor) = 0) THEN
1681: EXIT;
1682: END IF;
1683:
1684: dbms_sql.column_value_long(l_cursor,1,l_chunk_size,l_cur_pos,l_data_chunk,l_chunk_size_returned);
1685:
1686: IF (upper(l_data_chunk) like '%$FLEX$' OR l_data_chunk like '%:%') THEN
1687: return false;
1688: END IF;

Line 1699: dbms_sql.close_cursor(l_cursor);

1695: l_where_exists := true;
1696: l_count:= l_count +1;
1697: END LOOP;
1698:
1699: dbms_sql.close_cursor(l_cursor);
1700:
1701: IF (l_where_exists ) THEN
1702: g_where_clause(0) := ltrim(g_where_clause(0));
1703: IF (lower(substr(g_where_clause(0), 0, 5) ) = 'where') THEN