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

Line 29: l_cursor_id := dbms_sql.open_cursor;

25: end if;
26:
27: l_stmt := 'select ''Y'' from msc_plans'||l_dblink||' msc where :plan_name in msc.compile_designator '||
28: 'and curr_plan_type <> 4';
29: l_cursor_id := dbms_sql.open_cursor;
30: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
31: dbms_sql.bind_variable(l_cursor_id, ':plan_name', p_plan_name);
32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);
33: l_dummy := dbms_sql.execute(l_cursor_id);

Line 30: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);

26:
27: l_stmt := 'select ''Y'' from msc_plans'||l_dblink||' msc where :plan_name in msc.compile_designator '||
28: 'and curr_plan_type <> 4';
29: l_cursor_id := dbms_sql.open_cursor;
30: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
31: dbms_sql.bind_variable(l_cursor_id, ':plan_name', p_plan_name);
32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);
33: l_dummy := dbms_sql.execute(l_cursor_id);
34: l_dummy := dbms_sql.fetch_rows(l_cursor_id);

Line 31: dbms_sql.bind_variable(l_cursor_id, ':plan_name', p_plan_name);

27: l_stmt := 'select ''Y'' from msc_plans'||l_dblink||' msc where :plan_name in msc.compile_designator '||
28: 'and curr_plan_type <> 4';
29: l_cursor_id := dbms_sql.open_cursor;
30: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
31: dbms_sql.bind_variable(l_cursor_id, ':plan_name', p_plan_name);
32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);
33: l_dummy := dbms_sql.execute(l_cursor_id);
34: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
35: dbms_sql.column_value(l_cursor_id, 1, l_result);

Line 32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);

28: 'and curr_plan_type <> 4';
29: l_cursor_id := dbms_sql.open_cursor;
30: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
31: dbms_sql.bind_variable(l_cursor_id, ':plan_name', p_plan_name);
32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);
33: l_dummy := dbms_sql.execute(l_cursor_id);
34: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
35: dbms_sql.column_value(l_cursor_id, 1, l_result);
36: dbms_sql.close_cursor(l_cursor_id);

Line 33: l_dummy := dbms_sql.execute(l_cursor_id);

29: l_cursor_id := dbms_sql.open_cursor;
30: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
31: dbms_sql.bind_variable(l_cursor_id, ':plan_name', p_plan_name);
32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);
33: l_dummy := dbms_sql.execute(l_cursor_id);
34: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
35: dbms_sql.column_value(l_cursor_id, 1, l_result);
36: dbms_sql.close_cursor(l_cursor_id);
37:

Line 34: l_dummy := dbms_sql.fetch_rows(l_cursor_id);

30: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
31: dbms_sql.bind_variable(l_cursor_id, ':plan_name', p_plan_name);
32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);
33: l_dummy := dbms_sql.execute(l_cursor_id);
34: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
35: dbms_sql.column_value(l_cursor_id, 1, l_result);
36: dbms_sql.close_cursor(l_cursor_id);
37:
38: if (l_result = 'Y') then

Line 35: dbms_sql.column_value(l_cursor_id, 1, l_result);

31: dbms_sql.bind_variable(l_cursor_id, ':plan_name', p_plan_name);
32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);
33: l_dummy := dbms_sql.execute(l_cursor_id);
34: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
35: dbms_sql.column_value(l_cursor_id, 1, l_result);
36: dbms_sql.close_cursor(l_cursor_id);
37:
38: if (l_result = 'Y') then
39: return 'Y';

Line 36: dbms_sql.close_cursor(l_cursor_id);

32: dbms_sql.define_column(l_cursor_id, 1, l_result, 1);
33: l_dummy := dbms_sql.execute(l_cursor_id);
34: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
35: dbms_sql.column_value(l_cursor_id, 1, l_result);
36: dbms_sql.close_cursor(l_cursor_id);
37:
38: if (l_result = 'Y') then
39: return 'Y';
40: else

Line 46: dbms_sql.close_cursor(l_cursor_id);

42: end if;
43:
44: exception
45: when others then
46: dbms_sql.close_cursor(l_cursor_id);
47: raise;
48:
49: end;
50:

Line 93: l_cursor_id := dbms_sql.open_cursor;

89: l_table_name||' f where f.'||l_col_name||' >= trunc(:reference_date)+'||abs(l_days_offset);
90: end if;
91:
92:
93: l_cursor_id := dbms_sql.open_cursor;
94: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
95: dbms_sql.bind_variable(l_cursor_id, ':reference_date', p_reference_date);
96: dbms_sql.define_column(l_cursor_id, 1, l_result);
97: l_dummy := dbms_sql.execute(l_cursor_id);

Line 94: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);

90: end if;
91:
92:
93: l_cursor_id := dbms_sql.open_cursor;
94: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
95: dbms_sql.bind_variable(l_cursor_id, ':reference_date', p_reference_date);
96: dbms_sql.define_column(l_cursor_id, 1, l_result);
97: l_dummy := dbms_sql.execute(l_cursor_id);
98: l_dummy := dbms_sql.fetch_rows(l_cursor_id);

Line 95: dbms_sql.bind_variable(l_cursor_id, ':reference_date', p_reference_date);

91:
92:
93: l_cursor_id := dbms_sql.open_cursor;
94: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
95: dbms_sql.bind_variable(l_cursor_id, ':reference_date', p_reference_date);
96: dbms_sql.define_column(l_cursor_id, 1, l_result);
97: l_dummy := dbms_sql.execute(l_cursor_id);
98: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
99: dbms_sql.column_value(l_cursor_id, 1, l_result);

Line 96: dbms_sql.define_column(l_cursor_id, 1, l_result);

92:
93: l_cursor_id := dbms_sql.open_cursor;
94: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
95: dbms_sql.bind_variable(l_cursor_id, ':reference_date', p_reference_date);
96: dbms_sql.define_column(l_cursor_id, 1, l_result);
97: l_dummy := dbms_sql.execute(l_cursor_id);
98: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
99: dbms_sql.column_value(l_cursor_id, 1, l_result);
100: dbms_sql.close_cursor(l_cursor_id);

Line 97: l_dummy := dbms_sql.execute(l_cursor_id);

93: l_cursor_id := dbms_sql.open_cursor;
94: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
95: dbms_sql.bind_variable(l_cursor_id, ':reference_date', p_reference_date);
96: dbms_sql.define_column(l_cursor_id, 1, l_result);
97: l_dummy := dbms_sql.execute(l_cursor_id);
98: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
99: dbms_sql.column_value(l_cursor_id, 1, l_result);
100: dbms_sql.close_cursor(l_cursor_id);
101: return l_result;

Line 98: l_dummy := dbms_sql.fetch_rows(l_cursor_id);

94: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
95: dbms_sql.bind_variable(l_cursor_id, ':reference_date', p_reference_date);
96: dbms_sql.define_column(l_cursor_id, 1, l_result);
97: l_dummy := dbms_sql.execute(l_cursor_id);
98: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
99: dbms_sql.column_value(l_cursor_id, 1, l_result);
100: dbms_sql.close_cursor(l_cursor_id);
101: return l_result;
102:

Line 99: dbms_sql.column_value(l_cursor_id, 1, l_result);

95: dbms_sql.bind_variable(l_cursor_id, ':reference_date', p_reference_date);
96: dbms_sql.define_column(l_cursor_id, 1, l_result);
97: l_dummy := dbms_sql.execute(l_cursor_id);
98: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
99: dbms_sql.column_value(l_cursor_id, 1, l_result);
100: dbms_sql.close_cursor(l_cursor_id);
101: return l_result;
102:
103: exception

Line 100: dbms_sql.close_cursor(l_cursor_id);

96: dbms_sql.define_column(l_cursor_id, 1, l_result);
97: l_dummy := dbms_sql.execute(l_cursor_id);
98: l_dummy := dbms_sql.fetch_rows(l_cursor_id);
99: dbms_sql.column_value(l_cursor_id, 1, l_result);
100: dbms_sql.close_cursor(l_cursor_id);
101: return l_result;
102:
103: exception
104: when others then

Line 105: dbms_sql.close_cursor(l_cursor_id);

101: return l_result;
102:
103: exception
104: when others then
105: dbms_sql.close_cursor(l_cursor_id);
106: raise;
107: end;
108:
109: