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

Line 275: sql_cursor := dbms_sql.open_cursor;

271: l_rows number;
272: begin
273: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date',
274: 30);
275: sql_cursor := dbms_sql.open_cursor;
276: dbms_sql.parse(sql_cursor, p_asg_vdate_cursor, dbms_sql.v7);
277: dbms_sql.bind_variable (sql_cursor, 'ASSIGNMENT_ID',
278: p_assignment_id);
279: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED',

Line 276: dbms_sql.parse(sql_cursor, p_asg_vdate_cursor, dbms_sql.v7);

272: begin
273: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date',
274: 30);
275: sql_cursor := dbms_sql.open_cursor;
276: dbms_sql.parse(sql_cursor, p_asg_vdate_cursor, dbms_sql.v7);
277: dbms_sql.bind_variable (sql_cursor, 'ASSIGNMENT_ID',
278: p_assignment_id);
279: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED',
280: p_virtual_date);

Line 277: dbms_sql.bind_variable (sql_cursor, 'ASSIGNMENT_ID',

273: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date',
274: 30);
275: sql_cursor := dbms_sql.open_cursor;
276: dbms_sql.parse(sql_cursor, p_asg_vdate_cursor, dbms_sql.v7);
277: dbms_sql.bind_variable (sql_cursor, 'ASSIGNMENT_ID',
278: p_assignment_id);
279: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED',
280: p_virtual_date);
281: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED',

Line 279: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED',

275: sql_cursor := dbms_sql.open_cursor;
276: dbms_sql.parse(sql_cursor, p_asg_vdate_cursor, dbms_sql.v7);
277: dbms_sql.bind_variable (sql_cursor, 'ASSIGNMENT_ID',
278: p_assignment_id);
279: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED',
280: p_virtual_date);
281: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED',
282: p_virtual_date);
283: dbms_sql.define_column (sql_cursor, 1, l_virtual_date);

Line 281: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED',

277: dbms_sql.bind_variable (sql_cursor, 'ASSIGNMENT_ID',
278: p_assignment_id);
279: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED',
280: p_virtual_date);
281: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED',
282: p_virtual_date);
283: dbms_sql.define_column (sql_cursor, 1, l_virtual_date);
284: l_rows := dbms_sql.execute(sql_cursor);
285: l_rows := dbms_sql.fetch_rows (sql_cursor);

Line 283: dbms_sql.define_column (sql_cursor, 1, l_virtual_date);

279: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED',
280: p_virtual_date);
281: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED',
282: p_virtual_date);
283: dbms_sql.define_column (sql_cursor, 1, l_virtual_date);
284: l_rows := dbms_sql.execute(sql_cursor);
285: l_rows := dbms_sql.fetch_rows (sql_cursor);
286: if l_rows > 0 then
287: hr_utility.set_location(

Line 284: l_rows := dbms_sql.execute(sql_cursor);

280: p_virtual_date);
281: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED',
282: p_virtual_date);
283: dbms_sql.define_column (sql_cursor, 1, l_virtual_date);
284: l_rows := dbms_sql.execute(sql_cursor);
285: l_rows := dbms_sql.fetch_rows (sql_cursor);
286: if l_rows > 0 then
287: hr_utility.set_location(
288: 'pay_us_tax_bals_pkg.get_virtual_date', 40);

Line 285: l_rows := dbms_sql.fetch_rows (sql_cursor);

281: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED',
282: p_virtual_date);
283: dbms_sql.define_column (sql_cursor, 1, l_virtual_date);
284: l_rows := dbms_sql.execute(sql_cursor);
285: l_rows := dbms_sql.fetch_rows (sql_cursor);
286: if l_rows > 0 then
287: hr_utility.set_location(
288: 'pay_us_tax_bals_pkg.get_virtual_date', 40);
289: dbms_sql.column_value (sql_cursor, 1, l_virtual_date);

Line 289: dbms_sql.column_value (sql_cursor, 1, l_virtual_date);

285: l_rows := dbms_sql.fetch_rows (sql_cursor);
286: if l_rows > 0 then
287: hr_utility.set_location(
288: 'pay_us_tax_bals_pkg.get_virtual_date', 40);
289: dbms_sql.column_value (sql_cursor, 1, l_virtual_date);
290: --
291: select max(ppf.effective_end_date)
292: into l_virtual_date2
293: from per_assignments_f paf,

Line 331: dbms_sql.close_cursor(sql_cursor);

327: 'pay_us_tax_bals_pkg.get_virtual_date', 50);
328: local_error('get_virtual_date', 1);
329: end if;
330: --
331: dbms_sql.close_cursor(sql_cursor);
332: end;
333: --
334: return l_res_date;
335: end;

Line 445: sql_cursor := dbms_sql.open_cursor;

441: --
442: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 30);
443: begin
444: --
445: sql_cursor := dbms_sql.open_cursor;
446: dbms_sql.parse(sql_cursor, l_asg_data_cursor, dbms_sql.v7);
447: dbms_sql.bind_variable (sql_cursor, 'TAX_UNIT_ID', p_gre_id);
448: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED', p_virtual_date);
449: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED', p_virtual_date);

Line 446: dbms_sql.parse(sql_cursor, l_asg_data_cursor, dbms_sql.v7);

442: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 30);
443: begin
444: --
445: sql_cursor := dbms_sql.open_cursor;
446: dbms_sql.parse(sql_cursor, l_asg_data_cursor, dbms_sql.v7);
447: dbms_sql.bind_variable (sql_cursor, 'TAX_UNIT_ID', p_gre_id);
448: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED', p_virtual_date);
449: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED', p_virtual_date);
450: dbms_sql.define_column (sql_cursor, 1, l_asg_id);

Line 447: dbms_sql.bind_variable (sql_cursor, 'TAX_UNIT_ID', p_gre_id);

443: begin
444: --
445: sql_cursor := dbms_sql.open_cursor;
446: dbms_sql.parse(sql_cursor, l_asg_data_cursor, dbms_sql.v7);
447: dbms_sql.bind_variable (sql_cursor, 'TAX_UNIT_ID', p_gre_id);
448: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED', p_virtual_date);
449: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED', p_virtual_date);
450: dbms_sql.define_column (sql_cursor, 1, l_asg_id);
451: --

Line 448: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED', p_virtual_date);

444: --
445: sql_cursor := dbms_sql.open_cursor;
446: dbms_sql.parse(sql_cursor, l_asg_data_cursor, dbms_sql.v7);
447: dbms_sql.bind_variable (sql_cursor, 'TAX_UNIT_ID', p_gre_id);
448: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED', p_virtual_date);
449: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED', p_virtual_date);
450: dbms_sql.define_column (sql_cursor, 1, l_asg_id);
451: --
452: -- Does the cursor require the jurisdiction code. Hence balance

Line 449: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED', p_virtual_date);

445: sql_cursor := dbms_sql.open_cursor;
446: dbms_sql.parse(sql_cursor, l_asg_data_cursor, dbms_sql.v7);
447: dbms_sql.bind_variable (sql_cursor, 'TAX_UNIT_ID', p_gre_id);
448: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED', p_virtual_date);
449: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED', p_virtual_date);
450: dbms_sql.define_column (sql_cursor, 1, l_asg_id);
451: --
452: -- Does the cursor require the jurisdiction code. Hence balance
453: -- type.

Line 450: dbms_sql.define_column (sql_cursor, 1, l_asg_id);

446: dbms_sql.parse(sql_cursor, l_asg_data_cursor, dbms_sql.v7);
447: dbms_sql.bind_variable (sql_cursor, 'TAX_UNIT_ID', p_gre_id);
448: dbms_sql.bind_variable (sql_cursor, 'DATE_EARNED', p_virtual_date);
449: dbms_sql.bind_variable (sql_cursor, 'DATE2_EARNED', p_virtual_date);
450: dbms_sql.define_column (sql_cursor, 1, l_asg_id);
451: --
452: -- Does the cursor require the jurisdiction code. Hence balance
453: -- type.
454: --

Line 461: dbms_sql.bind_variable (sql_cursor, 'BALANCE_TYPE_ID',

457: into l_balance_type_id
458: from pay_defined_balances
459: where defined_balance_id = l_defined_balance_id;
460: --
461: dbms_sql.bind_variable (sql_cursor, 'BALANCE_TYPE_ID',
462: l_balance_type_id);
463: dbms_sql.bind_variable (sql_cursor, 'JURISDICTION_CODE',
464: p_jurisdiction_code);
465: end if;

Line 463: dbms_sql.bind_variable (sql_cursor, 'JURISDICTION_CODE',

459: where defined_balance_id = l_defined_balance_id;
460: --
461: dbms_sql.bind_variable (sql_cursor, 'BALANCE_TYPE_ID',
462: l_balance_type_id);
463: dbms_sql.bind_variable (sql_cursor, 'JURISDICTION_CODE',
464: p_jurisdiction_code);
465: end if;
466: l_rows := dbms_sql.execute(sql_cursor);
467: l_rows := 1;

Line 466: l_rows := dbms_sql.execute(sql_cursor);

462: l_balance_type_id);
463: dbms_sql.bind_variable (sql_cursor, 'JURISDICTION_CODE',
464: p_jurisdiction_code);
465: end if;
466: l_rows := dbms_sql.execute(sql_cursor);
467: l_rows := 1;
468: cnt := 0;
469: --
470: -- Loop through all the contributing assignments, go get there

Line 474: l_rows := dbms_sql.fetch_rows (sql_cursor);

470: -- Loop through all the contributing assignments, go get there
471: -- balance value and add onto the running total.
472: --
473: while (l_rows <> 0) loop
474: l_rows := dbms_sql.fetch_rows (sql_cursor);
475: cnt := cnt + 1;
476: if l_rows > 0 then
477: hr_utility.set_location(
478: 'pay_us_tax_bals_pkg.get_grp_asg_value', 40);

Line 479: dbms_sql.column_value (sql_cursor, 1, l_asg_id);

475: cnt := cnt + 1;
476: if l_rows > 0 then
477: hr_utility.set_location(
478: 'pay_us_tax_bals_pkg.get_grp_asg_value', 40);
479: dbms_sql.column_value (sql_cursor, 1, l_asg_id);
480: --
481: l_virtual_date := get_virtual_date(l_asg_id, p_virtual_date,
482: l_asg_balance_time,
483: l_asg_vdate_cursor);

Line 496: dbms_sql.close_cursor(sql_cursor);

492: );
493: end if;
494: end loop;
495: --
496: dbms_sql.close_cursor(sql_cursor);
497: end;
498: else
499: --
500: -- No latets balances available. Run the route.