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

Line 279: l_dbms_sql_feedback integer;

275: --
276: procedure seed_benefit_data(p_business_group_id in number) is
277: --
278: l_cursor_handle integer;
279: l_dbms_sql_feedback integer;
280: --
281: begin
282: --
283: hr_utility.set_location('Entering hr_organization.seed_benefit_data',1);

Line 287: l_cursor_handle := dbms_sql.open_cursor;

283: hr_utility.set_location('Entering hr_organization.seed_benefit_data',1);
284: --
285: -- Seed benefit life events
286: --
287: l_cursor_handle := dbms_sql.open_cursor;
288: dbms_sql.parse(l_cursor_handle,
289: 'begin ben_seed_life_events.seed_life_events(:business_group_id); end;',
290: dbms_sql.v7);
291: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

Line 288: dbms_sql.parse(l_cursor_handle,

284: --
285: -- Seed benefit life events
286: --
287: l_cursor_handle := dbms_sql.open_cursor;
288: dbms_sql.parse(l_cursor_handle,
289: 'begin ben_seed_life_events.seed_life_events(:business_group_id); end;',
290: dbms_sql.v7);
291: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
292: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

Line 290: dbms_sql.v7);

286: --
287: l_cursor_handle := dbms_sql.open_cursor;
288: dbms_sql.parse(l_cursor_handle,
289: 'begin ben_seed_life_events.seed_life_events(:business_group_id); end;',
290: dbms_sql.v7);
291: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
292: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
293: dbms_sql.close_cursor(l_cursor_handle);
294: --

Line 291: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

287: l_cursor_handle := dbms_sql.open_cursor;
288: dbms_sql.parse(l_cursor_handle,
289: 'begin ben_seed_life_events.seed_life_events(:business_group_id); end;',
290: dbms_sql.v7);
291: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
292: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
293: dbms_sql.close_cursor(l_cursor_handle);
294: --
295: -- Seed benefit person types

Line 292: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

288: dbms_sql.parse(l_cursor_handle,
289: 'begin ben_seed_life_events.seed_life_events(:business_group_id); end;',
290: dbms_sql.v7);
291: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
292: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
293: dbms_sql.close_cursor(l_cursor_handle);
294: --
295: -- Seed benefit person types
296: --

Line 293: dbms_sql.close_cursor(l_cursor_handle);

289: 'begin ben_seed_life_events.seed_life_events(:business_group_id); end;',
290: dbms_sql.v7);
291: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
292: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
293: dbms_sql.close_cursor(l_cursor_handle);
294: --
295: -- Seed benefit person types
296: --
297: /*

Line 298: l_cursor_handle := dbms_sql.open_cursor;

294: --
295: -- Seed benefit person types
296: --
297: /*
298: l_cursor_handle := dbms_sql.open_cursor;
299: dbms_sql.parse(l_cursor_handle,
300: 'begin ben_seed_person_types.seed_person_types(:business_group_id); end;',
301: dbms_sql.v7);
302: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

Line 299: dbms_sql.parse(l_cursor_handle,

295: -- Seed benefit person types
296: --
297: /*
298: l_cursor_handle := dbms_sql.open_cursor;
299: dbms_sql.parse(l_cursor_handle,
300: 'begin ben_seed_person_types.seed_person_types(:business_group_id); end;',
301: dbms_sql.v7);
302: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
303: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

Line 301: dbms_sql.v7);

297: /*
298: l_cursor_handle := dbms_sql.open_cursor;
299: dbms_sql.parse(l_cursor_handle,
300: 'begin ben_seed_person_types.seed_person_types(:business_group_id); end;',
301: dbms_sql.v7);
302: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
303: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
304: dbms_sql.close_cursor(l_cursor_handle);
305: */

Line 302: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

298: l_cursor_handle := dbms_sql.open_cursor;
299: dbms_sql.parse(l_cursor_handle,
300: 'begin ben_seed_person_types.seed_person_types(:business_group_id); end;',
301: dbms_sql.v7);
302: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
303: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
304: dbms_sql.close_cursor(l_cursor_handle);
305: */
306: --

Line 303: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

299: dbms_sql.parse(l_cursor_handle,
300: 'begin ben_seed_person_types.seed_person_types(:business_group_id); end;',
301: dbms_sql.v7);
302: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
303: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
304: dbms_sql.close_cursor(l_cursor_handle);
305: */
306: --
307: -- Seed enrollment action item types.

Line 304: dbms_sql.close_cursor(l_cursor_handle);

300: 'begin ben_seed_person_types.seed_person_types(:business_group_id); end;',
301: dbms_sql.v7);
302: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
303: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
304: dbms_sql.close_cursor(l_cursor_handle);
305: */
306: --
307: -- Seed enrollment action item types.
308: --

Line 309: l_cursor_handle := dbms_sql.open_cursor;

305: */
306: --
307: -- Seed enrollment action item types.
308: --
309: l_cursor_handle := dbms_sql.open_cursor;
310: dbms_sql.parse(l_cursor_handle,
311: 'begin ben_seed_action_item_types.seed_action_item_types(:business_group_id); end;',
312: dbms_sql.v7);
313: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

Line 310: dbms_sql.parse(l_cursor_handle,

306: --
307: -- Seed enrollment action item types.
308: --
309: l_cursor_handle := dbms_sql.open_cursor;
310: dbms_sql.parse(l_cursor_handle,
311: 'begin ben_seed_action_item_types.seed_action_item_types(:business_group_id); end;',
312: dbms_sql.v7);
313: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
314: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

Line 312: dbms_sql.v7);

308: --
309: l_cursor_handle := dbms_sql.open_cursor;
310: dbms_sql.parse(l_cursor_handle,
311: 'begin ben_seed_action_item_types.seed_action_item_types(:business_group_id); end;',
312: dbms_sql.v7);
313: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
314: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
315: dbms_sql.close_cursor(l_cursor_handle);
316: --

Line 313: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

309: l_cursor_handle := dbms_sql.open_cursor;
310: dbms_sql.parse(l_cursor_handle,
311: 'begin ben_seed_action_item_types.seed_action_item_types(:business_group_id); end;',
312: dbms_sql.v7);
313: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
314: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
315: dbms_sql.close_cursor(l_cursor_handle);
316: --
317: -- Seed communication types.

Line 314: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

310: dbms_sql.parse(l_cursor_handle,
311: 'begin ben_seed_action_item_types.seed_action_item_types(:business_group_id); end;',
312: dbms_sql.v7);
313: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
314: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
315: dbms_sql.close_cursor(l_cursor_handle);
316: --
317: -- Seed communication types.
318: --

Line 315: dbms_sql.close_cursor(l_cursor_handle);

311: 'begin ben_seed_action_item_types.seed_action_item_types(:business_group_id); end;',
312: dbms_sql.v7);
313: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
314: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
315: dbms_sql.close_cursor(l_cursor_handle);
316: --
317: -- Seed communication types.
318: --
319: l_cursor_handle := dbms_sql.open_cursor;

Line 319: l_cursor_handle := dbms_sql.open_cursor;

315: dbms_sql.close_cursor(l_cursor_handle);
316: --
317: -- Seed communication types.
318: --
319: l_cursor_handle := dbms_sql.open_cursor;
320: dbms_sql.parse(l_cursor_handle,
321: 'begin ben_seed_communication_types.seed_communication_types(:business_group_id); end;',
322: dbms_sql.v7);
323: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

Line 320: dbms_sql.parse(l_cursor_handle,

316: --
317: -- Seed communication types.
318: --
319: l_cursor_handle := dbms_sql.open_cursor;
320: dbms_sql.parse(l_cursor_handle,
321: 'begin ben_seed_communication_types.seed_communication_types(:business_group_id); end;',
322: dbms_sql.v7);
323: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
324: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

Line 322: dbms_sql.v7);

318: --
319: l_cursor_handle := dbms_sql.open_cursor;
320: dbms_sql.parse(l_cursor_handle,
321: 'begin ben_seed_communication_types.seed_communication_types(:business_group_id); end;',
322: dbms_sql.v7);
323: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
324: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
325: dbms_sql.close_cursor(l_cursor_handle);
326: --

Line 323: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

319: l_cursor_handle := dbms_sql.open_cursor;
320: dbms_sql.parse(l_cursor_handle,
321: 'begin ben_seed_communication_types.seed_communication_types(:business_group_id); end;',
322: dbms_sql.v7);
323: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
324: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
325: dbms_sql.close_cursor(l_cursor_handle);
326: --
327: -- Seed regulations.

Line 324: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

320: dbms_sql.parse(l_cursor_handle,
321: 'begin ben_seed_communication_types.seed_communication_types(:business_group_id); end;',
322: dbms_sql.v7);
323: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
324: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
325: dbms_sql.close_cursor(l_cursor_handle);
326: --
327: -- Seed regulations.
328: --

Line 325: dbms_sql.close_cursor(l_cursor_handle);

321: 'begin ben_seed_communication_types.seed_communication_types(:business_group_id); end;',
322: dbms_sql.v7);
323: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
324: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
325: dbms_sql.close_cursor(l_cursor_handle);
326: --
327: -- Seed regulations.
328: --
329: l_cursor_handle := dbms_sql.open_cursor;

Line 329: l_cursor_handle := dbms_sql.open_cursor;

325: dbms_sql.close_cursor(l_cursor_handle);
326: --
327: -- Seed regulations.
328: --
329: l_cursor_handle := dbms_sql.open_cursor;
330: dbms_sql.parse(l_cursor_handle,
331: 'begin ben_seed_regulations.seed_regulations(:business_group_id); end;',
332: dbms_sql.v7);
333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

Line 330: dbms_sql.parse(l_cursor_handle,

326: --
327: -- Seed regulations.
328: --
329: l_cursor_handle := dbms_sql.open_cursor;
330: dbms_sql.parse(l_cursor_handle,
331: 'begin ben_seed_regulations.seed_regulations(:business_group_id); end;',
332: dbms_sql.v7);
333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
334: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

Line 332: dbms_sql.v7);

328: --
329: l_cursor_handle := dbms_sql.open_cursor;
330: dbms_sql.parse(l_cursor_handle,
331: 'begin ben_seed_regulations.seed_regulations(:business_group_id); end;',
332: dbms_sql.v7);
333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
334: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
335: dbms_sql.close_cursor(l_cursor_handle);
336: --

Line 333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);

329: l_cursor_handle := dbms_sql.open_cursor;
330: dbms_sql.parse(l_cursor_handle,
331: 'begin ben_seed_regulations.seed_regulations(:business_group_id); end;',
332: dbms_sql.v7);
333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
334: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
335: dbms_sql.close_cursor(l_cursor_handle);
336: --
337: hr_utility.set_location('Leaving hr_organization.seed_benefit_data',1);

Line 334: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);

330: dbms_sql.parse(l_cursor_handle,
331: 'begin ben_seed_regulations.seed_regulations(:business_group_id); end;',
332: dbms_sql.v7);
333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
334: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
335: dbms_sql.close_cursor(l_cursor_handle);
336: --
337: hr_utility.set_location('Leaving hr_organization.seed_benefit_data',1);
338: --

Line 335: dbms_sql.close_cursor(l_cursor_handle);

331: 'begin ben_seed_regulations.seed_regulations(:business_group_id); end;',
332: dbms_sql.v7);
333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
334: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
335: dbms_sql.close_cursor(l_cursor_handle);
336: --
337: hr_utility.set_location('Leaving hr_organization.seed_benefit_data',1);
338: --
339: end seed_benefit_data;