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_DYNSQL dependencies on HR_UTILITY

Line 193: hr_utility.set_location(c_indent,10);

189: -- Note that we implicitly assume that the assignment is on a
190: -- payroll, in the joins to element link, hence no reference
191: -- to link_to_all_payrolls_flag.
192: begin
193: hr_utility.set_location(c_indent,10);
194: -- Bugfix 2827092 following lines temporarily removed from below
195: -- piv.value_set_id,
196: -- value_set_id,
197: select pee.element_entry_id,

Line 289: hr_utility.set_location(c_indent,18);

285: -- previous day. This ensures the date effective
286: -- stuff below will work correctly.
287: val_date := (p_effective_date - 1);
288: else
289: hr_utility.set_location(c_indent,18);
290: -- Check if update really required
291: -- ie changing entry value
292: select eev.screen_entry_value
293: into old_value

Line 313: hr_utility.set_location(c_indent,20);

309: -- Not correction - validation date is effective date.
310: val_date := p_effective_date;
311: end if;
312: --
313: hr_utility.set_location(c_indent,20);
314:
315: /* bug 6655722
316: select max(pee.effective_end_date)
317: into max_effend

Line 328: hr_utility.set_location(c_indent,30);

324: -- are not fired.
325: pay_continuous_calc.g_override_cc := TRUE;
326: --
327:
328: hr_utility.set_location(c_indent,30);
329:
330: --bug 6655722
331: -- Ok, we have the information - now we need to perform
332: -- the date track update (UPDATE_CHANGE_INSERT).

Line 387: hr_utility.trace('IV='||r_entry_value.input_value_id);

383: entry_val_list(r_entry_value.input_value_id) :=
384: r_entry_value.screen_entry_value;
385: end if;
386: --
387: hr_utility.trace('IV='||r_entry_value.input_value_id);
388: hr_utility.trace('VAL='||r_entry_value.screen_entry_value);
389: hr_utility.trace('TAB='||entry_val_list(r_entry_value.input_value_id));
390: hr_utility.trace('DATE='||val_date);
391: --

Line 388: hr_utility.trace('VAL='||r_entry_value.screen_entry_value);

384: r_entry_value.screen_entry_value;
385: end if;
386: --
387: hr_utility.trace('IV='||r_entry_value.input_value_id);
388: hr_utility.trace('VAL='||r_entry_value.screen_entry_value);
389: hr_utility.trace('TAB='||entry_val_list(r_entry_value.input_value_id));
390: hr_utility.trace('DATE='||val_date);
391: --
392: if entry_val_list(r_entry_value.input_value_id) is not null then

Line 389: hr_utility.trace('TAB='||entry_val_list(r_entry_value.input_value_id));

385: end if;
386: --
387: hr_utility.trace('IV='||r_entry_value.input_value_id);
388: hr_utility.trace('VAL='||r_entry_value.screen_entry_value);
389: hr_utility.trace('TAB='||entry_val_list(r_entry_value.input_value_id));
390: hr_utility.trace('DATE='||val_date);
391: --
392: if entry_val_list(r_entry_value.input_value_id) is not null then
393: --

Line 390: hr_utility.trace('DATE='||val_date);

386: --
387: hr_utility.trace('IV='||r_entry_value.input_value_id);
388: hr_utility.trace('VAL='||r_entry_value.screen_entry_value);
389: hr_utility.trace('TAB='||entry_val_list(r_entry_value.input_value_id));
390: hr_utility.trace('DATE='||val_date);
391: --
392: if entry_val_list(r_entry_value.input_value_id) is not null then
393: --
394: -- A non-null entry value has been encountered, therefore set the

Line 417: hr_utility.set_location(c_indent,40);

413: IF entry_record_exists%NOTFOUND THEN
414: --
415: -- Now, update the effective_end_date of existing entry.
416: -- Note : using val_date.
417: hr_utility.set_location(c_indent,40);
418: update pay_element_entries_f pee
419: set pee.effective_end_date = (p_effective_date - 1)
420: where pee.element_entry_id = update_ee_id
421: and val_date between

Line 426: hr_utility.set_location(c_indent,50);

422: pee.effective_start_date and pee.effective_end_date;
423: --
424: -- Finally (for entry), we wish to insert the new
425: -- entry record.
426: hr_utility.set_location(c_indent,50);
427: --
428: -- Bugfix 3110853
429: -- Derive the OVN before inserting
430: --

Line 609: hr_utility.trace('IV='||entry_value.input_value_id);

605: /*
606: for entry_value in get_entry_values(update_ee_id, p_effective_date) loop
607: entry_val_list(entry_value.input_value_id) :=
608: entry_value.screen_entry_value;
609: hr_utility.trace('IV='||entry_value.input_value_id);
610: hr_utility.trace('VAL='||entry_value.screen_entry_value);
611: hr_utility.trace('TAB='||entry_val_list(entry_value.input_value_id));
612: hr_utility.trace('DATE='||val_date);
613: end loop;

Line 610: hr_utility.trace('VAL='||entry_value.screen_entry_value);

606: for entry_value in get_entry_values(update_ee_id, p_effective_date) loop
607: entry_val_list(entry_value.input_value_id) :=
608: entry_value.screen_entry_value;
609: hr_utility.trace('IV='||entry_value.input_value_id);
610: hr_utility.trace('VAL='||entry_value.screen_entry_value);
611: hr_utility.trace('TAB='||entry_val_list(entry_value.input_value_id));
612: hr_utility.trace('DATE='||val_date);
613: end loop;
614: */

Line 611: hr_utility.trace('TAB='||entry_val_list(entry_value.input_value_id));

607: entry_val_list(entry_value.input_value_id) :=
608: entry_value.screen_entry_value;
609: hr_utility.trace('IV='||entry_value.input_value_id);
610: hr_utility.trace('VAL='||entry_value.screen_entry_value);
611: hr_utility.trace('TAB='||entry_val_list(entry_value.input_value_id));
612: hr_utility.trace('DATE='||val_date);
613: end loop;
614: */
615:

Line 612: hr_utility.trace('DATE='||val_date);

608: entry_value.screen_entry_value;
609: hr_utility.trace('IV='||entry_value.input_value_id);
610: hr_utility.trace('VAL='||entry_value.screen_entry_value);
611: hr_utility.trace('TAB='||entry_val_list(entry_value.input_value_id));
612: hr_utility.trace('DATE='||val_date);
613: end loop;
614: */
615:
616:

Line 631: hr_utility.set_location(c_indent,60);

627: --
628: -- We now wish to perform the update on the entry values.
629: -- This is a similar process to the entry stuff.
630:
631: hr_utility.set_location(c_indent,60);
632:
633: /* bug 6655772
634: delete from pay_element_entry_values_f eev
635: where eev.element_entry_id = update_ee_id

Line 641: hr_utility.set_location(c_indent,70);

637: */
638: --
639: -- Fix the end date of the entry values.
640: -- Note : using val_date.
641: hr_utility.set_location(c_indent,70);
642: update pay_element_entry_values_f eev
643: set eev.effective_end_date = (p_effective_date - 1)
644: where eev.element_entry_id = update_ee_id
645: and val_date between

Line 651: hr_utility.set_location(c_indent,80);

647: --
648: -- Now we insert the new entry values row.
649: -- We set the new entry value as required.
650: -- Note : using val_date.
651: hr_utility.set_location(c_indent,80);
652: for update_values in upd_entry_values(update_ee_id, p_effective_date) loop
653: -- Enhancement 3478848
654: -- Removed this, this check is now performed when the entry
655: -- values are initially fetched, above.

Line 724: hr_utility.set_location(c_indent,90);

720: raise;
721: end;
722: --
723: -- Return element_entry_id that we updated.
724: hr_utility.set_location(c_indent,90);
725: p_element_entry_id := update_ee_id;
726: end update_recurring_ee;
727: --
728: ----------------------------- stop_recurring_ee --------------------------

Line 761: hr_utility.set_location(c_indent,10);

757: -- Note that we implicitly assume that the assignment is on a
758: -- payroll, in the joins to element link, hence no reference
759: -- to link_to_all_payrolls_flag.
760: begin
761: hr_utility.set_location(c_indent,10);
762: select pee.element_entry_id,
763: pel.element_link_id,
764: pee.effective_start_date
765: into stop_ee_id, link_id, stop_ee_start_date

Line 815: hr_utility.set_message(801, 'HR_6304_ELE_ENTRY_DT_DEL_ADJ');

811: when no_data_found then null;
812: end;
813: --
814: if v_error_flag = 'Y' then
815: hr_utility.set_message(801, 'HR_6304_ELE_ENTRY_DT_DEL_ADJ');
816: hr_utility.raise_error;
817: end if;
818: --
819: -- Check the start date of the date effective element entry, if the date

Line 816: hr_utility.raise_error;

812: end;
813: --
814: if v_error_flag = 'Y' then
815: hr_utility.set_message(801, 'HR_6304_ELE_ENTRY_DT_DEL_ADJ');
816: hr_utility.raise_error;
817: end if;
818: --
819: -- Check the start date of the date effective element entry, if the date
820: -- is greater than the date_earned then error, since the entry is stopped

Line 824: hr_utility.set_message(801, 'HR_51338_HRPROC_STOP_EE_DATE');

820: -- is greater than the date_earned then error, since the entry is stopped
821: -- as of date earned.
822: --
823: if stop_ee_start_date > p_date_earned then
824: hr_utility.set_message(801, 'HR_51338_HRPROC_STOP_EE_DATE');
825: hr_utility.raise_error;
826: end if;
827: --
828: -- Ok, perform date track delete (DELETE).

Line 825: hr_utility.raise_error;

821: -- as of date earned.
822: --
823: if stop_ee_start_date > p_date_earned then
824: hr_utility.set_message(801, 'HR_51338_HRPROC_STOP_EE_DATE');
825: hr_utility.raise_error;
826: end if;
827: --
828: -- Ok, perform date track delete (DELETE).
829: -- This means we delete any future entries and values

Line 896: hr_utility.set_location('hr_dynsql.setinfo',5);

892: payid number; -- payroll_id.
893: dummy number; -- dummy cos selects need something to select into.
894: begin
895: -- start by selecting the information about payroll and formula.
896: hr_utility.set_location('hr_dynsql.setinfo',5);
897: select has.payroll_id,
898: nvl(has.formula_id,0)
899: into payid,
900: formula

Line 907: hr_utility.set_location('hr_dynsql.setinfo',10);

903: --
904: payroll := (payid is not null);
905: --
906: -- Now check for specific inclusions being specified.
907: hr_utility.set_location('hr_dynsql.setinfo',10);
908: include := TRUE;
909: begin
910: select null
911: into dummy

Line 924: hr_utility.set_location('hr_dynsql.setinfo',15);

920: end;
921: --
922: -- Now check for specific exclusions.
923: exclude := TRUE;
924: hr_utility.set_location('hr_dynsql.setinfo',15);
925: begin
926: select null
927: into dummy
928: from sys.dual

Line 1865: hr_utility.set_message(801, 'PAY_34958_ARCRGE_MUST_EXIST');

1861: and prfm.effective_end_date;
1862: --
1863: /* Range code should always be set */
1864: if (range_proc is null) then
1865: hr_utility.set_message(801, 'PAY_34958_ARCRGE_MUST_EXIST');
1866: hr_utility.raise_error;
1867: end if;
1868: --
1869: statem := 'BEGIN '||range_proc||'(:pactid, :sqlstr); END;';

Line 1866: hr_utility.raise_error;

1862: --
1863: /* Range code should always be set */
1864: if (range_proc is null) then
1865: hr_utility.set_message(801, 'PAY_34958_ARCRGE_MUST_EXIST');
1866: hr_utility.raise_error;
1867: end if;
1868: --
1869: statem := 'BEGIN '||range_proc||'(:pactid, :sqlstr); END;';
1870: --

Line 2245: hr_utility.trace('sqlid = '||sqlid);

2241: --
2242: pay_proc_logging.PY_ENTRY('hr_dynsql.pyrsql');
2243: --
2244: --
2245: hr_utility.trace('sqlid = '||sqlid);
2246: hr_utility.trace('timedepflg = '||timedepflg);
2247: hr_utility.trace('interlock = '||interlock);
2248: hr_utility.trace('action = '||action);
2249: hr_utility.trace('pactid = '||pactid);

Line 2246: hr_utility.trace('timedepflg = '||timedepflg);

2242: pay_proc_logging.PY_ENTRY('hr_dynsql.pyrsql');
2243: --
2244: --
2245: hr_utility.trace('sqlid = '||sqlid);
2246: hr_utility.trace('timedepflg = '||timedepflg);
2247: hr_utility.trace('interlock = '||interlock);
2248: hr_utility.trace('action = '||action);
2249: hr_utility.trace('pactid = '||pactid);
2250: hr_utility.trace('chkno = '||chkno);

Line 2247: hr_utility.trace('interlock = '||interlock);

2243: --
2244: --
2245: hr_utility.trace('sqlid = '||sqlid);
2246: hr_utility.trace('timedepflg = '||timedepflg);
2247: hr_utility.trace('interlock = '||interlock);
2248: hr_utility.trace('action = '||action);
2249: hr_utility.trace('pactid = '||pactid);
2250: hr_utility.trace('chkno = '||chkno);
2251:

Line 2248: hr_utility.trace('action = '||action);

2244: --
2245: hr_utility.trace('sqlid = '||sqlid);
2246: hr_utility.trace('timedepflg = '||timedepflg);
2247: hr_utility.trace('interlock = '||interlock);
2248: hr_utility.trace('action = '||action);
2249: hr_utility.trace('pactid = '||pactid);
2250: hr_utility.trace('chkno = '||chkno);
2251:
2252: if (chkno is null) then

Line 2249: hr_utility.trace('pactid = '||pactid);

2245: hr_utility.trace('sqlid = '||sqlid);
2246: hr_utility.trace('timedepflg = '||timedepflg);
2247: hr_utility.trace('interlock = '||interlock);
2248: hr_utility.trace('action = '||action);
2249: hr_utility.trace('pactid = '||pactid);
2250: hr_utility.trace('chkno = '||chkno);
2251:
2252: if (chkno is null) then
2253: range := nopoprange;

Line 2250: hr_utility.trace('chkno = '||chkno);

2246: hr_utility.trace('timedepflg = '||timedepflg);
2247: hr_utility.trace('interlock = '||interlock);
2248: hr_utility.trace('action = '||action);
2249: hr_utility.trace('pactid = '||pactid);
2250: hr_utility.trace('chkno = '||chkno);
2251:
2252: if (chkno is null) then
2253: range := nopoprange;
2254: else

Line 2368: hr_utility.trace('sqlstr: ' ||sqlstr);

2364: sqlstr := rrsel || alladeasg || orderby;
2365: else
2366: sqlstr := null; -- should not reach this!!
2367: end if;
2368: hr_utility.trace('sqlstr: ' ||sqlstr);
2369: elsif (action = PYG_AT_RCS) then
2370: if (sqlid = PY_ALLASG) then
2371: sqlstr := asactsel || allrcsasg || range;
2372: if (interlock = 'N') then