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

Line 108: l_sql_cursor := dbms_sql.open_cursor;

104: ||' FROM per_competence_levels_v'
105: ||' WHERE competence_id IN ('||l_ids||')'
106: ||' GROUP BY competence_id';
107:
108: l_sql_cursor := dbms_sql.open_cursor;
109: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
110: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
111: l_rows := dbms_sql.execute(l_sql_cursor);
112:

Line 109: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);

105: ||' WHERE competence_id IN ('||l_ids||')'
106: ||' GROUP BY competence_id';
107:
108: l_sql_cursor := dbms_sql.open_cursor;
109: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
110: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
111: l_rows := dbms_sql.execute(l_sql_cursor);
112:
113: IF dbms_sql.fetch_rows(l_sql_cursor) > 0 THEN

Line 110: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);

106: ||' GROUP BY competence_id';
107:
108: l_sql_cursor := dbms_sql.open_cursor;
109: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
110: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
111: l_rows := dbms_sql.execute(l_sql_cursor);
112:
113: IF dbms_sql.fetch_rows(l_sql_cursor) > 0 THEN
114: dbms_sql.column_value(l_sql_cursor, 1, c_name);

Line 111: l_rows := dbms_sql.execute(l_sql_cursor);

107:
108: l_sql_cursor := dbms_sql.open_cursor;
109: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
110: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
111: l_rows := dbms_sql.execute(l_sql_cursor);
112:
113: IF dbms_sql.fetch_rows(l_sql_cursor) > 0 THEN
114: dbms_sql.column_value(l_sql_cursor, 1, c_name);
115: l_max_step_value := to_number(c_name);

Line 113: IF dbms_sql.fetch_rows(l_sql_cursor) > 0 THEN

109: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
110: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
111: l_rows := dbms_sql.execute(l_sql_cursor);
112:
113: IF dbms_sql.fetch_rows(l_sql_cursor) > 0 THEN
114: dbms_sql.column_value(l_sql_cursor, 1, c_name);
115: l_max_step_value := to_number(c_name);
116: END IF;
117:

Line 114: dbms_sql.column_value(l_sql_cursor, 1, c_name);

110: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
111: l_rows := dbms_sql.execute(l_sql_cursor);
112:
113: IF dbms_sql.fetch_rows(l_sql_cursor) > 0 THEN
114: dbms_sql.column_value(l_sql_cursor, 1, c_name);
115: l_max_step_value := to_number(c_name);
116: END IF;
117:
118: dbms_sql.close_cursor(l_sql_cursor);

Line 118: dbms_sql.close_cursor(l_sql_cursor);

114: dbms_sql.column_value(l_sql_cursor, 1, c_name);
115: l_max_step_value := to_number(c_name);
116: END IF;
117:
118: dbms_sql.close_cursor(l_sql_cursor);
119:
120: RETURN l_max_step_value;
121:
122: EXCEPTION

Line 124: IF dbms_sql.is_open(l_sql_cursor) THEN

120: RETURN l_max_step_value;
121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: IF dbms_sql.is_open(l_sql_cursor) THEN
125: dbms_sql.close_cursor(l_sql_cursor);
126: END IF;
127: RETURN 0;
128: END get_max_step_value;

Line 125: dbms_sql.close_cursor(l_sql_cursor);

121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: IF dbms_sql.is_open(l_sql_cursor) THEN
125: dbms_sql.close_cursor(l_sql_cursor);
126: END IF;
127: RETURN 0;
128: END get_max_step_value;
129: -- ---------------------------------------------------------------------------

Line 317: l_sql_cursor := dbms_sql.open_cursor;

313: l_dynamic_sql := l_dynamic_sql
314: ||' ORDER BY NVL(ppf.order_name, ppf.full_name)';
315: END IF;
316:
317: l_sql_cursor := dbms_sql.open_cursor;
318: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
319: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);

Line 318: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);

314: ||' ORDER BY NVL(ppf.order_name, ppf.full_name)';
315: END IF;
316:
317: l_sql_cursor := dbms_sql.open_cursor;
318: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
319: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);
322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);

Line 319: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);

315: END IF;
316:
317: l_sql_cursor := dbms_sql.open_cursor;
318: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
319: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);
322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);
323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);

Line 320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);

316:
317: l_sql_cursor := dbms_sql.open_cursor;
318: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
319: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);
322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);
323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);
324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);

Line 321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);

317: l_sql_cursor := dbms_sql.open_cursor;
318: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
319: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);
322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);
323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);
324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);
325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);

Line 322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);

318: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
319: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);
322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);
323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);
324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);
325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);
326: dbms_sql.define_column(l_sql_cursor, 8, c_hire_date, 30);

Line 323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);

319: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);
322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);
323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);
324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);
325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);
326: dbms_sql.define_column(l_sql_cursor, 8, c_hire_date, 30);
327: l_rows := dbms_sql.execute(l_sql_cursor);

Line 324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);

320: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);
322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);
323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);
324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);
325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);
326: dbms_sql.define_column(l_sql_cursor, 8, c_hire_date, 30);
327: l_rows := dbms_sql.execute(l_sql_cursor);
328: l_index := 0;

Line 325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);

321: dbms_sql.define_column(l_sql_cursor, 3, c_type, 2000);
322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);
323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);
324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);
325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);
326: dbms_sql.define_column(l_sql_cursor, 8, c_hire_date, 30);
327: l_rows := dbms_sql.execute(l_sql_cursor);
328: l_index := 0;
329: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP

Line 326: dbms_sql.define_column(l_sql_cursor, 8, c_hire_date, 30);

322: dbms_sql.define_column(l_sql_cursor, 4, c_phone, 240);
323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);
324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);
325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);
326: dbms_sql.define_column(l_sql_cursor, 8, c_hire_date, 30);
327: l_rows := dbms_sql.execute(l_sql_cursor);
328: l_index := 0;
329: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
330: l_index := l_index + 1;

Line 327: l_rows := dbms_sql.execute(l_sql_cursor);

323: dbms_sql.define_column(l_sql_cursor, 5, c_location, 240);
324: dbms_sql.define_column(l_sql_cursor, 6, c_employee_number, 30);
325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);
326: dbms_sql.define_column(l_sql_cursor, 8, c_hire_date, 30);
327: l_rows := dbms_sql.execute(l_sql_cursor);
328: l_index := 0;
329: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
330: l_index := l_index + 1;
331: dbms_sql.column_value(l_sql_cursor, 1, c_id);

Line 329: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP

325: dbms_sql.define_column(l_sql_cursor, 7, c_applicant_number, 30);
326: dbms_sql.define_column(l_sql_cursor, 8, c_hire_date, 30);
327: l_rows := dbms_sql.execute(l_sql_cursor);
328: l_index := 0;
329: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
330: l_index := l_index + 1;
331: dbms_sql.column_value(l_sql_cursor, 1, c_id);
332: dbms_sql.column_value(l_sql_cursor, 2, p_person_table(l_index).name);
333: dbms_sql.column_value(l_sql_cursor, 3, p_person_table(l_index).person_type);

Line 331: dbms_sql.column_value(l_sql_cursor, 1, c_id);

327: l_rows := dbms_sql.execute(l_sql_cursor);
328: l_index := 0;
329: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
330: l_index := l_index + 1;
331: dbms_sql.column_value(l_sql_cursor, 1, c_id);
332: dbms_sql.column_value(l_sql_cursor, 2, p_person_table(l_index).name);
333: dbms_sql.column_value(l_sql_cursor, 3, p_person_table(l_index).person_type);
334: dbms_sql.column_value(l_sql_cursor, 4, p_person_table(l_index).work_phone);
335: dbms_sql.column_value

Line 332: dbms_sql.column_value(l_sql_cursor, 2, p_person_table(l_index).name);

328: l_index := 0;
329: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
330: l_index := l_index + 1;
331: dbms_sql.column_value(l_sql_cursor, 1, c_id);
332: dbms_sql.column_value(l_sql_cursor, 2, p_person_table(l_index).name);
333: dbms_sql.column_value(l_sql_cursor, 3, p_person_table(l_index).person_type);
334: dbms_sql.column_value(l_sql_cursor, 4, p_person_table(l_index).work_phone);
335: dbms_sql.column_value
336: (l_sql_cursor, 5, p_person_table(l_index).location_code);

Line 333: dbms_sql.column_value(l_sql_cursor, 3, p_person_table(l_index).person_type);

329: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
330: l_index := l_index + 1;
331: dbms_sql.column_value(l_sql_cursor, 1, c_id);
332: dbms_sql.column_value(l_sql_cursor, 2, p_person_table(l_index).name);
333: dbms_sql.column_value(l_sql_cursor, 3, p_person_table(l_index).person_type);
334: dbms_sql.column_value(l_sql_cursor, 4, p_person_table(l_index).work_phone);
335: dbms_sql.column_value
336: (l_sql_cursor, 5, p_person_table(l_index).location_code);
337: dbms_sql.column_value

Line 334: dbms_sql.column_value(l_sql_cursor, 4, p_person_table(l_index).work_phone);

330: l_index := l_index + 1;
331: dbms_sql.column_value(l_sql_cursor, 1, c_id);
332: dbms_sql.column_value(l_sql_cursor, 2, p_person_table(l_index).name);
333: dbms_sql.column_value(l_sql_cursor, 3, p_person_table(l_index).person_type);
334: dbms_sql.column_value(l_sql_cursor, 4, p_person_table(l_index).work_phone);
335: dbms_sql.column_value
336: (l_sql_cursor, 5, p_person_table(l_index).location_code);
337: dbms_sql.column_value
338: (l_sql_cursor, 6, p_person_table(l_index).employee_number);

Line 335: dbms_sql.column_value

331: dbms_sql.column_value(l_sql_cursor, 1, c_id);
332: dbms_sql.column_value(l_sql_cursor, 2, p_person_table(l_index).name);
333: dbms_sql.column_value(l_sql_cursor, 3, p_person_table(l_index).person_type);
334: dbms_sql.column_value(l_sql_cursor, 4, p_person_table(l_index).work_phone);
335: dbms_sql.column_value
336: (l_sql_cursor, 5, p_person_table(l_index).location_code);
337: dbms_sql.column_value
338: (l_sql_cursor, 6, p_person_table(l_index).employee_number);
339: dbms_sql.column_value

Line 337: dbms_sql.column_value

333: dbms_sql.column_value(l_sql_cursor, 3, p_person_table(l_index).person_type);
334: dbms_sql.column_value(l_sql_cursor, 4, p_person_table(l_index).work_phone);
335: dbms_sql.column_value
336: (l_sql_cursor, 5, p_person_table(l_index).location_code);
337: dbms_sql.column_value
338: (l_sql_cursor, 6, p_person_table(l_index).employee_number);
339: dbms_sql.column_value
340: (l_sql_cursor, 7, p_person_table(l_index).applicant_number);
341: dbms_sql.column_value

Line 339: dbms_sql.column_value

335: dbms_sql.column_value
336: (l_sql_cursor, 5, p_person_table(l_index).location_code);
337: dbms_sql.column_value
338: (l_sql_cursor, 6, p_person_table(l_index).employee_number);
339: dbms_sql.column_value
340: (l_sql_cursor, 7, p_person_table(l_index).applicant_number);
341: dbms_sql.column_value
342: (l_sql_cursor, 8, c_hire_date);
343: p_person_table(l_index).person_id := c_id;

Line 341: dbms_sql.column_value

337: dbms_sql.column_value
338: (l_sql_cursor, 6, p_person_table(l_index).employee_number);
339: dbms_sql.column_value
340: (l_sql_cursor, 7, p_person_table(l_index).applicant_number);
341: dbms_sql.column_value
342: (l_sql_cursor, 8, c_hire_date);
343: p_person_table(l_index).person_id := c_id;
344: p_person_table(l_index).hire_date := c_hire_date;
345: END LOOP;

Line 347: dbms_sql.close_cursor(l_sql_cursor);

343: p_person_table(l_index).person_id := c_id;
344: p_person_table(l_index).hire_date := c_hire_date;
345: END LOOP;
346:
347: dbms_sql.close_cursor(l_sql_cursor);
348:
349: p_count := l_index;
350:
351: EXCEPTION

Line 353: IF dbms_sql.is_open(l_sql_cursor) THEN

349: p_count := l_index;
350:
351: EXCEPTION
352: WHEN others THEN
353: IF dbms_sql.is_open(l_sql_cursor) THEN
354: dbms_sql.close_cursor(l_sql_cursor);
355: END IF;
356: END get_people_info;
357:

Line 354: dbms_sql.close_cursor(l_sql_cursor);

350:
351: EXCEPTION
352: WHEN others THEN
353: IF dbms_sql.is_open(l_sql_cursor) THEN
354: dbms_sql.close_cursor(l_sql_cursor);
355: END IF;
356: END get_people_info;
357:
358: -- ---------------------------------------------------------------------------

Line 1321: l_sql_cursor := dbms_sql.open_cursor;

1317: c_id number;
1318: c_name varchar2(240);
1319:
1320: BEGIN
1321: l_sql_cursor := dbms_sql.open_cursor;
1322: dbms_sql.parse(l_sql_cursor, p_dynamic_sql, dbms_sql.v7);
1323: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
1324: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
1325: l_rows := dbms_sql.execute(l_sql_cursor);

Line 1322: dbms_sql.parse(l_sql_cursor, p_dynamic_sql, dbms_sql.v7);

1318: c_name varchar2(240);
1319:
1320: BEGIN
1321: l_sql_cursor := dbms_sql.open_cursor;
1322: dbms_sql.parse(l_sql_cursor, p_dynamic_sql, dbms_sql.v7);
1323: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
1324: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
1325: l_rows := dbms_sql.execute(l_sql_cursor);
1326: l_index := 0;

Line 1323: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);

1319:
1320: BEGIN
1321: l_sql_cursor := dbms_sql.open_cursor;
1322: dbms_sql.parse(l_sql_cursor, p_dynamic_sql, dbms_sql.v7);
1323: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
1324: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
1325: l_rows := dbms_sql.execute(l_sql_cursor);
1326: l_index := 0;
1327: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP

Line 1324: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);

1320: BEGIN
1321: l_sql_cursor := dbms_sql.open_cursor;
1322: dbms_sql.parse(l_sql_cursor, p_dynamic_sql, dbms_sql.v7);
1323: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
1324: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
1325: l_rows := dbms_sql.execute(l_sql_cursor);
1326: l_index := 0;
1327: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
1328: l_index := l_index + 1;

Line 1325: l_rows := dbms_sql.execute(l_sql_cursor);

1321: l_sql_cursor := dbms_sql.open_cursor;
1322: dbms_sql.parse(l_sql_cursor, p_dynamic_sql, dbms_sql.v7);
1323: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
1324: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
1325: l_rows := dbms_sql.execute(l_sql_cursor);
1326: l_index := 0;
1327: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
1328: l_index := l_index + 1;
1329: dbms_sql.column_value(l_sql_cursor, 1, p_id(l_index));

Line 1327: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP

1323: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
1324: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
1325: l_rows := dbms_sql.execute(l_sql_cursor);
1326: l_index := 0;
1327: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
1328: l_index := l_index + 1;
1329: dbms_sql.column_value(l_sql_cursor, 1, p_id(l_index));
1330: dbms_sql.column_value(l_sql_cursor, 2, p_name(l_index));
1331: END LOOP;

Line 1329: dbms_sql.column_value(l_sql_cursor, 1, p_id(l_index));

1325: l_rows := dbms_sql.execute(l_sql_cursor);
1326: l_index := 0;
1327: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
1328: l_index := l_index + 1;
1329: dbms_sql.column_value(l_sql_cursor, 1, p_id(l_index));
1330: dbms_sql.column_value(l_sql_cursor, 2, p_name(l_index));
1331: END LOOP;
1332: p_count := l_index;
1333:

Line 1330: dbms_sql.column_value(l_sql_cursor, 2, p_name(l_index));

1326: l_index := 0;
1327: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
1328: l_index := l_index + 1;
1329: dbms_sql.column_value(l_sql_cursor, 1, p_id(l_index));
1330: dbms_sql.column_value(l_sql_cursor, 2, p_name(l_index));
1331: END LOOP;
1332: p_count := l_index;
1333:
1334: dbms_sql.close_cursor(l_sql_cursor);

Line 1334: dbms_sql.close_cursor(l_sql_cursor);

1330: dbms_sql.column_value(l_sql_cursor, 2, p_name(l_index));
1331: END LOOP;
1332: p_count := l_index;
1333:
1334: dbms_sql.close_cursor(l_sql_cursor);
1335:
1336: EXCEPTION
1337: WHEN others THEN
1338: IF dbms_sql.is_open(l_sql_cursor) THEN

Line 1338: IF dbms_sql.is_open(l_sql_cursor) THEN

1334: dbms_sql.close_cursor(l_sql_cursor);
1335:
1336: EXCEPTION
1337: WHEN others THEN
1338: IF dbms_sql.is_open(l_sql_cursor) THEN
1339: dbms_sql.close_cursor(l_sql_cursor);
1340: END IF;
1341: END get_id_name;
1342:

Line 1339: dbms_sql.close_cursor(l_sql_cursor);

1335:
1336: EXCEPTION
1337: WHEN others THEN
1338: IF dbms_sql.is_open(l_sql_cursor) THEN
1339: dbms_sql.close_cursor(l_sql_cursor);
1340: END IF;
1341: END get_id_name;
1342:
1343: -- ---------------------------------------------------------------------------

Line 3153: l_sql_cursor := dbms_sql.open_cursor;

3149: END IF;
3150:
3151: l_dynamic_sql := l_dynamic_sql || ' ORDER BY 2';
3152:
3153: l_sql_cursor := dbms_sql.open_cursor;
3154: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
3155: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
3156: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
3157: dbms_sql.define_column(l_sql_cursor, 3, c_name, 80);

Line 3154: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);

3150:
3151: l_dynamic_sql := l_dynamic_sql || ' ORDER BY 2';
3152:
3153: l_sql_cursor := dbms_sql.open_cursor;
3154: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
3155: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
3156: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
3157: dbms_sql.define_column(l_sql_cursor, 3, c_name, 80);
3158: l_rows := dbms_sql.execute(l_sql_cursor);

Line 3155: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);

3151: l_dynamic_sql := l_dynamic_sql || ' ORDER BY 2';
3152:
3153: l_sql_cursor := dbms_sql.open_cursor;
3154: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
3155: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
3156: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
3157: dbms_sql.define_column(l_sql_cursor, 3, c_name, 80);
3158: l_rows := dbms_sql.execute(l_sql_cursor);
3159: l_index := 0;

Line 3156: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);

3152:
3153: l_sql_cursor := dbms_sql.open_cursor;
3154: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
3155: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
3156: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
3157: dbms_sql.define_column(l_sql_cursor, 3, c_name, 80);
3158: l_rows := dbms_sql.execute(l_sql_cursor);
3159: l_index := 0;
3160: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP

Line 3157: dbms_sql.define_column(l_sql_cursor, 3, c_name, 80);

3153: l_sql_cursor := dbms_sql.open_cursor;
3154: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
3155: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
3156: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
3157: dbms_sql.define_column(l_sql_cursor, 3, c_name, 80);
3158: l_rows := dbms_sql.execute(l_sql_cursor);
3159: l_index := 0;
3160: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
3161: l_index := l_index + 1;

Line 3158: l_rows := dbms_sql.execute(l_sql_cursor);

3154: dbms_sql.parse(l_sql_cursor, l_dynamic_sql, dbms_sql.v7);
3155: dbms_sql.define_column(l_sql_cursor, 1, c_id, 15);
3156: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
3157: dbms_sql.define_column(l_sql_cursor, 3, c_name, 80);
3158: l_rows := dbms_sql.execute(l_sql_cursor);
3159: l_index := 0;
3160: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
3161: l_index := l_index + 1;
3162: dbms_sql.column_value(l_sql_cursor, 1, p_person_id(l_index));

Line 3160: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP

3156: dbms_sql.define_column(l_sql_cursor, 2, c_name, 240);
3157: dbms_sql.define_column(l_sql_cursor, 3, c_name, 80);
3158: l_rows := dbms_sql.execute(l_sql_cursor);
3159: l_index := 0;
3160: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
3161: l_index := l_index + 1;
3162: dbms_sql.column_value(l_sql_cursor, 1, p_person_id(l_index));
3163: dbms_sql.column_value(l_sql_cursor, 2, p_person_name(l_index));
3164: dbms_sql.column_value(l_sql_cursor, 3, p_person_type(l_index));

Line 3162: dbms_sql.column_value(l_sql_cursor, 1, p_person_id(l_index));

3158: l_rows := dbms_sql.execute(l_sql_cursor);
3159: l_index := 0;
3160: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
3161: l_index := l_index + 1;
3162: dbms_sql.column_value(l_sql_cursor, 1, p_person_id(l_index));
3163: dbms_sql.column_value(l_sql_cursor, 2, p_person_name(l_index));
3164: dbms_sql.column_value(l_sql_cursor, 3, p_person_type(l_index));
3165: END LOOP;
3166: p_count := l_index;

Line 3163: dbms_sql.column_value(l_sql_cursor, 2, p_person_name(l_index));

3159: l_index := 0;
3160: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
3161: l_index := l_index + 1;
3162: dbms_sql.column_value(l_sql_cursor, 1, p_person_id(l_index));
3163: dbms_sql.column_value(l_sql_cursor, 2, p_person_name(l_index));
3164: dbms_sql.column_value(l_sql_cursor, 3, p_person_type(l_index));
3165: END LOOP;
3166: p_count := l_index;
3167:

Line 3164: dbms_sql.column_value(l_sql_cursor, 3, p_person_type(l_index));

3160: WHILE dbms_sql.fetch_rows(l_sql_cursor) > 0 LOOP
3161: l_index := l_index + 1;
3162: dbms_sql.column_value(l_sql_cursor, 1, p_person_id(l_index));
3163: dbms_sql.column_value(l_sql_cursor, 2, p_person_name(l_index));
3164: dbms_sql.column_value(l_sql_cursor, 3, p_person_type(l_index));
3165: END LOOP;
3166: p_count := l_index;
3167:
3168: dbms_sql.close_cursor(l_sql_cursor);

Line 3168: dbms_sql.close_cursor(l_sql_cursor);

3164: dbms_sql.column_value(l_sql_cursor, 3, p_person_type(l_index));
3165: END LOOP;
3166: p_count := l_index;
3167:
3168: dbms_sql.close_cursor(l_sql_cursor);
3169:
3170: EXCEPTION
3171: WHEN others THEN
3172: IF dbms_sql.is_open(l_sql_cursor) THEN

Line 3172: IF dbms_sql.is_open(l_sql_cursor) THEN

3168: dbms_sql.close_cursor(l_sql_cursor);
3169:
3170: EXCEPTION
3171: WHEN others THEN
3172: IF dbms_sql.is_open(l_sql_cursor) THEN
3173: dbms_sql.close_cursor(l_sql_cursor);
3174: END IF;
3175:
3176:

Line 3173: dbms_sql.close_cursor(l_sql_cursor);

3169:
3170: EXCEPTION
3171: WHEN others THEN
3172: IF dbms_sql.is_open(l_sql_cursor) THEN
3173: dbms_sql.close_cursor(l_sql_cursor);
3174: END IF;
3175:
3176:
3177: END get_people_by_role;