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_UTIL dependencies on DBMS_SQL

Line 1118: l_cursor := dbms_sql.open_cursor;

1114: END IF;
1115: END LOOP;
1116: l_sql := l_sql || ')';
1117: END IF;
1118: l_cursor := dbms_sql.open_cursor;
1119: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);
1120: IF (l_bind_values.COUNT > 0) THEN
1121: FOR i IN l_bind_values.FIRST..l_bind_values.LAST LOOP
1122: l_bind_col := ':'|| i;

Line 1119: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);

1115: END LOOP;
1116: l_sql := l_sql || ')';
1117: END IF;
1118: l_cursor := dbms_sql.open_cursor;
1119: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);
1120: IF (l_bind_values.COUNT > 0) THEN
1121: FOR i IN l_bind_values.FIRST..l_bind_values.LAST LOOP
1122: l_bind_col := ':'|| i;
1123: dbms_sql.bind_variable(l_cursor, l_bind_col, l_bind_values(i));

Line 1123: dbms_sql.bind_variable(l_cursor, l_bind_col, l_bind_values(i));

1119: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);
1120: IF (l_bind_values.COUNT > 0) THEN
1121: FOR i IN l_bind_values.FIRST..l_bind_values.LAST LOOP
1122: l_bind_col := ':'|| i;
1123: dbms_sql.bind_variable(l_cursor, l_bind_col, l_bind_values(i));
1124: END LOOP;
1125: END IF;
1126: dbms_sql.define_column(l_cursor, 1, l_menu_id);
1127: ignore := DBMS_SQL.EXECUTE(l_cursor);

Line 1126: dbms_sql.define_column(l_cursor, 1, l_menu_id);

1122: l_bind_col := ':'|| i;
1123: dbms_sql.bind_variable(l_cursor, l_bind_col, l_bind_values(i));
1124: END LOOP;
1125: END IF;
1126: dbms_sql.define_column(l_cursor, 1, l_menu_id);
1127: ignore := DBMS_SQL.EXECUTE(l_cursor);
1128: LOOP
1129: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1130: -- get column values of the row

Line 1127: ignore := DBMS_SQL.EXECUTE(l_cursor);

1123: dbms_sql.bind_variable(l_cursor, l_bind_col, l_bind_values(i));
1124: END LOOP;
1125: END IF;
1126: dbms_sql.define_column(l_cursor, 1, l_menu_id);
1127: ignore := DBMS_SQL.EXECUTE(l_cursor);
1128: LOOP
1129: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1130: -- get column values of the row
1131: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_menu_id);

Line 1129: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

1125: END IF;
1126: dbms_sql.define_column(l_cursor, 1, l_menu_id);
1127: ignore := DBMS_SQL.EXECUTE(l_cursor);
1128: LOOP
1129: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1130: -- get column values of the row
1131: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_menu_id);
1132: l_menu_id_tbl(l_count) := l_menu_id;
1133: l_count := l_count + 1;

Line 1131: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_menu_id);

1127: ignore := DBMS_SQL.EXECUTE(l_cursor);
1128: LOOP
1129: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1130: -- get column values of the row
1131: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_menu_id);
1132: l_menu_id_tbl(l_count) := l_menu_id;
1133: l_count := l_count + 1;
1134: ELSE
1135: -- No more rows

Line 1139: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1135: -- No more rows
1136: EXIT;
1137: END IF;
1138: END LOOP;
1139: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1140: RETURN l_menu_id_tbl;
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

Line 1143: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

1139: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1140: RETURN l_menu_id_tbl;
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
1144: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1145: END IF;
1146: END getRoleIds;
1147:

Line 1144: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1140: RETURN l_menu_id_tbl;
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
1144: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1145: END IF;
1146: END getRoleIds;
1147:
1148: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation

Line 1185: l_cursor := dbms_sql.open_cursor;

1181: END IF;
1182: l_employeeId := FND_GLOBAL.EMPLOYEE_ID;
1183: l_index := INSTR(pParamName, '+');
1184: l_delegation_param := substr(pParamName, 1, l_index-1);
1185: l_cursor := dbms_sql.open_cursor;
1186: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);
1187: dbms_sql.bind_variable(l_cursor, ':1', l_employeeId || '');
1188: dbms_sql.bind_variable(l_cursor, ':2', l_delegation_param);
1189: dbms_sql.bind_variable(l_cursor, ':3', pAsOfDate);

Line 1186: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);

1182: l_employeeId := FND_GLOBAL.EMPLOYEE_ID;
1183: l_index := INSTR(pParamName, '+');
1184: l_delegation_param := substr(pParamName, 1, l_index-1);
1185: l_cursor := dbms_sql.open_cursor;
1186: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);
1187: dbms_sql.bind_variable(l_cursor, ':1', l_employeeId || '');
1188: dbms_sql.bind_variable(l_cursor, ':2', l_delegation_param);
1189: dbms_sql.bind_variable(l_cursor, ':3', pAsOfDate);
1190: IF (pRoleIdsTbl.COUNT > 0) THEN

Line 1187: dbms_sql.bind_variable(l_cursor, ':1', l_employeeId || '');

1183: l_index := INSTR(pParamName, '+');
1184: l_delegation_param := substr(pParamName, 1, l_index-1);
1185: l_cursor := dbms_sql.open_cursor;
1186: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);
1187: dbms_sql.bind_variable(l_cursor, ':1', l_employeeId || '');
1188: dbms_sql.bind_variable(l_cursor, ':2', l_delegation_param);
1189: dbms_sql.bind_variable(l_cursor, ':3', pAsOfDate);
1190: IF (pRoleIdsTbl.COUNT > 0) THEN
1191: FOR i IN pRoleIdsTbl.FIRST..pRoleIdsTbl.LAST LOOP

Line 1188: dbms_sql.bind_variable(l_cursor, ':2', l_delegation_param);

1184: l_delegation_param := substr(pParamName, 1, l_index-1);
1185: l_cursor := dbms_sql.open_cursor;
1186: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);
1187: dbms_sql.bind_variable(l_cursor, ':1', l_employeeId || '');
1188: dbms_sql.bind_variable(l_cursor, ':2', l_delegation_param);
1189: dbms_sql.bind_variable(l_cursor, ':3', pAsOfDate);
1190: IF (pRoleIdsTbl.COUNT > 0) THEN
1191: FOR i IN pRoleIdsTbl.FIRST..pRoleIdsTbl.LAST LOOP
1192: l_bind_col := ':'|| (i+3);

Line 1189: dbms_sql.bind_variable(l_cursor, ':3', pAsOfDate);

1185: l_cursor := dbms_sql.open_cursor;
1186: dbms_sql.parse(l_cursor, l_sql, DBMS_SQL.native);
1187: dbms_sql.bind_variable(l_cursor, ':1', l_employeeId || '');
1188: dbms_sql.bind_variable(l_cursor, ':2', l_delegation_param);
1189: dbms_sql.bind_variable(l_cursor, ':3', pAsOfDate);
1190: IF (pRoleIdsTbl.COUNT > 0) THEN
1191: FOR i IN pRoleIdsTbl.FIRST..pRoleIdsTbl.LAST LOOP
1192: l_bind_col := ':'|| (i+3);
1193: dbms_sql.bind_variable(l_cursor, l_bind_col, pRoleIdsTbl(i));

Line 1193: dbms_sql.bind_variable(l_cursor, l_bind_col, pRoleIdsTbl(i));

1189: dbms_sql.bind_variable(l_cursor, ':3', pAsOfDate);
1190: IF (pRoleIdsTbl.COUNT > 0) THEN
1191: FOR i IN pRoleIdsTbl.FIRST..pRoleIdsTbl.LAST LOOP
1192: l_bind_col := ':'|| (i+3);
1193: dbms_sql.bind_variable(l_cursor, l_bind_col, pRoleIdsTbl(i));
1194: END LOOP;
1195: END IF;
1196: dbms_sql.define_column(l_cursor, 1, l_delegation_id, 256);
1197: dbms_sql.define_column(l_cursor, 2, l_delegation_value, 2000);

Line 1196: dbms_sql.define_column(l_cursor, 1, l_delegation_id, 256);

1192: l_bind_col := ':'|| (i+3);
1193: dbms_sql.bind_variable(l_cursor, l_bind_col, pRoleIdsTbl(i));
1194: END LOOP;
1195: END IF;
1196: dbms_sql.define_column(l_cursor, 1, l_delegation_id, 256);
1197: dbms_sql.define_column(l_cursor, 2, l_delegation_value, 2000);
1198: ignore := DBMS_SQL.EXECUTE(l_cursor);
1199: LOOP
1200: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

Line 1197: dbms_sql.define_column(l_cursor, 2, l_delegation_value, 2000);

1193: dbms_sql.bind_variable(l_cursor, l_bind_col, pRoleIdsTbl(i));
1194: END LOOP;
1195: END IF;
1196: dbms_sql.define_column(l_cursor, 1, l_delegation_id, 256);
1197: dbms_sql.define_column(l_cursor, 2, l_delegation_value, 2000);
1198: ignore := DBMS_SQL.EXECUTE(l_cursor);
1199: LOOP
1200: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1201: -- get column values of the row

Line 1198: ignore := DBMS_SQL.EXECUTE(l_cursor);

1194: END LOOP;
1195: END IF;
1196: dbms_sql.define_column(l_cursor, 1, l_delegation_id, 256);
1197: dbms_sql.define_column(l_cursor, 2, l_delegation_value, 2000);
1198: ignore := DBMS_SQL.EXECUTE(l_cursor);
1199: LOOP
1200: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1201: -- get column values of the row
1202: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_delegation_id);

Line 1200: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

1196: dbms_sql.define_column(l_cursor, 1, l_delegation_id, 256);
1197: dbms_sql.define_column(l_cursor, 2, l_delegation_value, 2000);
1198: ignore := DBMS_SQL.EXECUTE(l_cursor);
1199: LOOP
1200: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1201: -- get column values of the row
1202: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_delegation_id);
1203: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_delegation_value);
1204: xDelegatorIdTbl(l_count) := l_delegation_id;

Line 1202: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_delegation_id);

1198: ignore := DBMS_SQL.EXECUTE(l_cursor);
1199: LOOP
1200: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1201: -- get column values of the row
1202: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_delegation_id);
1203: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_delegation_value);
1204: xDelegatorIdTbl(l_count) := l_delegation_id;
1205: xDelegatorValueTbl(l_count) := l_delegation_value;
1206: l_count := l_count + 1;

Line 1203: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_delegation_value);

1199: LOOP
1200: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
1201: -- get column values of the row
1202: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_delegation_id);
1203: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_delegation_value);
1204: xDelegatorIdTbl(l_count) := l_delegation_id;
1205: xDelegatorValueTbl(l_count) := l_delegation_value;
1206: l_count := l_count + 1;
1207: ELSE

Line 1212: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1208: -- No more rows
1209: EXIT;
1210: END IF;
1211: END LOOP;
1212: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1213: EXCEPTION
1214: WHEN OTHERS THEN
1215: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
1216: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 1215: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

1211: END LOOP;
1212: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1213: EXCEPTION
1214: WHEN OTHERS THEN
1215: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
1216: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1217: END IF;
1218: END getDelegations;
1219:

Line 1216: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1212: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1213: EXCEPTION
1214: WHEN OTHERS THEN
1215: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
1216: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1217: END IF;
1218: END getDelegations;
1219:
1220: --=============================================================================