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

Line 6501: l_cursor := dbms_sql.open_cursor;

6497: begin
6498:
6499: l_bind_sql := replace(p_bind_sql, ':', ':x');
6500:
6501: l_cursor := dbms_sql.open_cursor;
6502: dbms_sql.parse(l_cursor, l_bind_sql, DBMS_SQL.native);
6503:
6504: if (p_bind_values.COUNT > 0) then
6505: for i in p_bind_values.FIRST..p_bind_values.LAST loop

Line 6502: dbms_sql.parse(l_cursor, l_bind_sql, DBMS_SQL.native);

6498:
6499: l_bind_sql := replace(p_bind_sql, ':', ':x');
6500:
6501: l_cursor := dbms_sql.open_cursor;
6502: dbms_sql.parse(l_cursor, l_bind_sql, DBMS_SQL.native);
6503:
6504: if (p_bind_values.COUNT > 0) then
6505: for i in p_bind_values.FIRST..p_bind_values.LAST loop
6506: l_bind_col := ':x'|| i;

Line 6507: dbms_sql.bind_variable(l_cursor, l_bind_col, p_bind_values(i));

6503:
6504: if (p_bind_values.COUNT > 0) then
6505: for i in p_bind_values.FIRST..p_bind_values.LAST loop
6506: l_bind_col := ':x'|| i;
6507: dbms_sql.bind_variable(l_cursor, l_bind_col, p_bind_values(i));
6508: end loop;
6509: end if;
6510:
6511: dbms_sql.define_column(l_cursor, 1, x_parameter_id, 2000);

Line 6511: dbms_sql.define_column(l_cursor, 1, x_parameter_id, 2000);

6507: dbms_sql.bind_variable(l_cursor, l_bind_col, p_bind_values(i));
6508: end loop;
6509: end if;
6510:
6511: dbms_sql.define_column(l_cursor, 1, x_parameter_id, 2000);
6512: dbms_sql.define_column(l_cursor, 2, x_parameter_value, 2000);
6513:
6514: if p_time_flag = 'Y' then
6515: dbms_sql.define_column(l_cursor, 3, x_start_date);

Line 6512: dbms_sql.define_column(l_cursor, 2, x_parameter_value, 2000);

6508: end loop;
6509: end if;
6510:
6511: dbms_sql.define_column(l_cursor, 1, x_parameter_id, 2000);
6512: dbms_sql.define_column(l_cursor, 2, x_parameter_value, 2000);
6513:
6514: if p_time_flag = 'Y' then
6515: dbms_sql.define_column(l_cursor, 3, x_start_date);
6516: dbms_sql.define_column(l_cursor, 4, x_end_date);

Line 6515: dbms_sql.define_column(l_cursor, 3, x_start_date);

6511: dbms_sql.define_column(l_cursor, 1, x_parameter_id, 2000);
6512: dbms_sql.define_column(l_cursor, 2, x_parameter_value, 2000);
6513:
6514: if p_time_flag = 'Y' then
6515: dbms_sql.define_column(l_cursor, 3, x_start_date);
6516: dbms_sql.define_column(l_cursor, 4, x_end_date);
6517: end if;
6518:
6519: ignore := dbms_sql.execute_and_fetch(l_cursor);

Line 6516: dbms_sql.define_column(l_cursor, 4, x_end_date);

6512: dbms_sql.define_column(l_cursor, 2, x_parameter_value, 2000);
6513:
6514: if p_time_flag = 'Y' then
6515: dbms_sql.define_column(l_cursor, 3, x_start_date);
6516: dbms_sql.define_column(l_cursor, 4, x_end_date);
6517: end if;
6518:
6519: ignore := dbms_sql.execute_and_fetch(l_cursor);
6520:

Line 6519: ignore := dbms_sql.execute_and_fetch(l_cursor);

6515: dbms_sql.define_column(l_cursor, 3, x_start_date);
6516: dbms_sql.define_column(l_cursor, 4, x_end_date);
6517: end if;
6518:
6519: ignore := dbms_sql.execute_and_fetch(l_cursor);
6520:
6521: dbms_sql.column_value (l_cursor, 1, x_parameter_id);
6522: dbms_sql.column_value (l_cursor, 2, x_parameter_value);
6523:

Line 6521: dbms_sql.column_value (l_cursor, 1, x_parameter_id);

6517: end if;
6518:
6519: ignore := dbms_sql.execute_and_fetch(l_cursor);
6520:
6521: dbms_sql.column_value (l_cursor, 1, x_parameter_id);
6522: dbms_sql.column_value (l_cursor, 2, x_parameter_value);
6523:
6524: if p_time_flag = 'Y' then
6525: dbms_sql.column_value (l_cursor, 3, x_start_date);

Line 6522: dbms_sql.column_value (l_cursor, 2, x_parameter_value);

6518:
6519: ignore := dbms_sql.execute_and_fetch(l_cursor);
6520:
6521: dbms_sql.column_value (l_cursor, 1, x_parameter_id);
6522: dbms_sql.column_value (l_cursor, 2, x_parameter_value);
6523:
6524: if p_time_flag = 'Y' then
6525: dbms_sql.column_value (l_cursor, 3, x_start_date);
6526: dbms_sql.column_value (l_cursor, 4, x_end_date);

Line 6525: dbms_sql.column_value (l_cursor, 3, x_start_date);

6521: dbms_sql.column_value (l_cursor, 1, x_parameter_id);
6522: dbms_sql.column_value (l_cursor, 2, x_parameter_value);
6523:
6524: if p_time_flag = 'Y' then
6525: dbms_sql.column_value (l_cursor, 3, x_start_date);
6526: dbms_sql.column_value (l_cursor, 4, x_end_date);
6527: end if;
6528:
6529: dbms_sql.close_cursor(l_cursor);

Line 6526: dbms_sql.column_value (l_cursor, 4, x_end_date);

6522: dbms_sql.column_value (l_cursor, 2, x_parameter_value);
6523:
6524: if p_time_flag = 'Y' then
6525: dbms_sql.column_value (l_cursor, 3, x_start_date);
6526: dbms_sql.column_value (l_cursor, 4, x_end_date);
6527: end if;
6528:
6529: dbms_sql.close_cursor(l_cursor);
6530:

Line 6529: dbms_sql.close_cursor(l_cursor);

6525: dbms_sql.column_value (l_cursor, 3, x_start_date);
6526: dbms_sql.column_value (l_cursor, 4, x_end_date);
6527: end if;
6528:
6529: dbms_sql.close_cursor(l_cursor);
6530:
6531: EXCEPTION
6532: WHEN FND_API.G_EXC_ERROR THEN
6533: x_return_status := FND_API.G_RET_STS_ERROR;