APPS.PER_BUDGETS_PKG dependencies on DBMS_SQL

Line 163: l_dyn_curs := dbms_sql.open_cursor;

159: BEGIN
160: --
161: hr_utility.set_location('Entering:'||l_proc, 5);
162:
163: l_dyn_curs := dbms_sql.open_cursor;
164: --
165: -- Determine if the OTA_TP_MEASUREEMNT_TYPES table exists
166: --
167: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);

Line 167: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);

163: l_dyn_curs := dbms_sql.open_cursor;
164: --
165: -- Determine if the OTA_TP_MEASUREEMNT_TYPES table exists
166: --
167: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);
168: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
169: --
170: if dbms_sql.last_row_count > 0 then
171: -- Check that the training plan measurement record exists

Line 168: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);

164: --
165: -- Determine if the OTA_TP_MEASUREEMNT_TYPES table exists
166: --
167: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);
168: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
169: --
170: if dbms_sql.last_row_count > 0 then
171: -- Check that the training plan measurement record exists
172: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);

Line 170: if dbms_sql.last_row_count > 0 then

166: --
167: dbms_sql.parse(l_dyn_curs,l_stmt_chk_tpc_exist,dbms_sql.v7);
168: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
169: --
170: if dbms_sql.last_row_count > 0 then
171: -- Check that the training plan measurement record exists
172: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
173: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
174: --

Line 172: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);

168: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
169: --
170: if dbms_sql.last_row_count > 0 then
171: -- Check that the training plan measurement record exists
172: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
173: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
174: --
175: if dbms_sql.last_row_count < 1 then
176: dbms_sql.close_cursor(l_dyn_curs);

Line 173: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);

169: --
170: if dbms_sql.last_row_count > 0 then
171: -- Check that the training plan measurement record exists
172: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
173: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
174: --
175: if dbms_sql.last_row_count < 1 then
176: dbms_sql.close_cursor(l_dyn_curs);
177: hr_utility.set_message(800,'PER_52869_MEASURE_NOT_EXISTS');

Line 175: if dbms_sql.last_row_count < 1 then

171: -- Check that the training plan measurement record exists
172: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
173: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
174: --
175: if dbms_sql.last_row_count < 1 then
176: dbms_sql.close_cursor(l_dyn_curs);
177: hr_utility.set_message(800,'PER_52869_MEASURE_NOT_EXISTS');
178: hr_utility.raise_error;
179: end if;

Line 176: dbms_sql.close_cursor(l_dyn_curs);

172: dbms_sql.parse(l_dyn_curs,l_stmt_get_tpc_rows,dbms_sql.v7);
173: l_dyn_rows := dbms_sql.execute_and_fetch(l_dyn_curs);
174: --
175: if dbms_sql.last_row_count < 1 then
176: dbms_sql.close_cursor(l_dyn_curs);
177: hr_utility.set_message(800,'PER_52869_MEASURE_NOT_EXISTS');
178: hr_utility.raise_error;
179: end if;
180: end if;

Line 181: if dbms_sql.is_open(l_dyn_curs) then

177: hr_utility.set_message(800,'PER_52869_MEASURE_NOT_EXISTS');
178: hr_utility.raise_error;
179: end if;
180: end if;
181: if dbms_sql.is_open(l_dyn_curs) then
182: dbms_sql.close_cursor(l_dyn_curs);
183: end if;
184:
185: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 182: dbms_sql.close_cursor(l_dyn_curs);

178: hr_utility.raise_error;
179: end if;
180: end if;
181: if dbms_sql.is_open(l_dyn_curs) then
182: dbms_sql.close_cursor(l_dyn_curs);
183: end if;
184:
185: hr_utility.set_location(' Leaving:'|| l_proc, 10);
186: --