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_DYNSQL

Line 1: package body hr_dynsql as

1: package body hr_dynsql as
2: /* $Header: pydynsql.pkb 120.30.12010000.2 2008/10/01 06:13:09 ankagarw ship $ */
3: -- cache for get_tax_unit
4: g_cached boolean := FALSE;
5: g_tax_unit pay_legislation_rules.rule_mode%type;

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

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

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

898: --
899: payroll := (payid is not null);
900: --
901: -- Now check for specific inclusions being specified.
902: hr_utility.set_location('hr_dynsql.setinfo',10);
903: include := TRUE;
904: begin
905: select null
906: into dummy

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

915: end;
916: --
917: -- Now check for specific exclusions.
918: exclude := TRUE;
919: hr_utility.set_location('hr_dynsql.setinfo',15);
920: begin
921: select null
922: into dummy
923: from sys.dual

Line 2205: pay_proc_logging.PY_ENTRY('hr_dynsql.pyrsql');

2201: l_asg_set_id number;
2202: l_inc_or_excl HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;
2203: begin
2204: --
2205: pay_proc_logging.PY_ENTRY('hr_dynsql.pyrsql');
2206: --
2207: --
2208: hr_utility.trace('sqlid = '||sqlid);
2209: hr_utility.trace('timedepflg = '||timedepflg);

Line 2642: pay_proc_logging.PY_EXIT('hr_dynsql.pyrsql');

2638: end if;
2639: end if;
2640: len := length(sqlstr); -- return the length of the string.
2641: --
2642: pay_proc_logging.PY_EXIT('hr_dynsql.pyrsql');
2643: --
2644: end pyrsql;
2645: --
2646: ---------------------------- adv_override_check ----------------------------

Line 2758: hr_dynsql.get_tax_unit(pay_asg.assignment_id,

2754: ''U'',
2755: :chunk_number,
2756: pay_assignment_actions_s.nextval,
2757: 1,
2758: hr_dynsql.get_tax_unit(pay_asg.assignment_id,
2759: pay_pac.effective_date),
2760: ''U'',
2761: pay_asg.assignment_id';
2762: --

Line 2773: hr_dynsql.get_tax_unit(pay_asg.assignment_id,

2769: ''U'',
2770: :chunk_number,
2771: pay_assignment_actions_s.nextval,
2772: 1,
2773: hr_dynsql.get_tax_unit(pay_asg.assignment_id,
2774: pay_pac.effective_date),
2775: ''U'',
2776: null';
2777: --

Line 2792: hr_dynsql.get_tax_unit(pay_asg.assignment_id,

2788: ''U'',
2789: :chunk_number,
2790: 1,
2791: 1,
2792: hr_dynsql.get_tax_unit(pay_asg.assignment_id,
2793: pay_pac.effective_date),
2794: ''U'',
2795: null';
2796: --

Line 3022: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''

3018: and pay_pee.element_entry_id = pay_pev.element_entry_id
3019: and pay_pee.element_entry_id = pay_pev2.element_entry_id
3020: and pay_pev.input_value_id = pay_piv.input_value_id
3021: and pay_piv2.input_value_id = pay_pev2.input_value_id
3022: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''
3023: and TRANSLATE(UPPER(pay_piv.name), '' '', ''_'') =
3024: (select TRANSLATE(UPPER(pay_hrl3.meaning), '' '', ''_'')
3025: from hr_lookups pay_hrl3
3026: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''

Line 3072: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''

3068: and pay_pee.element_entry_id = pay_pev.element_entry_id
3069: and pay_pee.element_entry_id = pay_pev2.element_entry_id
3070: and pay_pev.input_value_id = pay_piv.input_value_id
3071: and pay_piv2.input_value_id = pay_pev2.input_value_id
3072: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''
3073: and TRANSLATE(UPPER(pay_piv.name), '' '', ''_'') =
3074: (select TRANSLATE(UPPER(pay_hrl3.meaning), '' '', ''_'')
3075: from hr_lookups pay_hrl3
3076: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''

Line 3415: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id

3411:
3412: -- and not exists clause to exclude people failing interlock rules.
3413: -- this one is for time dependent legislation.
3414: intdep := '
3415: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id
3416: + decode(pay_pos.person_id, null, 0, 0),
3417: pay_pac.effective_date) = ''N''';
3418: --
3419: intdepaset := '

Line 3420: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id

3416: + decode(pay_pos.person_id, null, 0, 0),
3417: pay_pac.effective_date) = ''N''';
3418: --
3419: intdepaset := '
3420: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id
3421: + decode(pay_inc.last_update_login, null, 0, 0)
3422: + decode(pay_as2.position_id, null, 0, 0),
3423: pay_pac.effective_date) = ''N''';
3424: --

Line 3426: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id

3422: + decode(pay_as2.position_id, null, 0, 0),
3423: pay_pac.effective_date) = ''N''';
3424: --
3425: intbaldep := '
3426: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id
3427: + decode(pay_pos.person_id, null, 0, 0),
3428: pay_pac.effective_date) = ''N''';
3429: --
3430: intbaldepaset := '

Line 3431: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id

3427: + decode(pay_pos.person_id, null, 0, 0),
3428: pay_pac.effective_date) = ''N''';
3429: --
3430: intbaldepaset := '
3431: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id
3432: + decode(pay_inc.include_or_exclude, null, 0, 0),
3433: pay_pac.effective_date) = ''N''';
3434: --
3435: intretdep := '

Line 3436: and hr_dynsql.ret_person_sequence_locked(pay_pos.period_of_service_id

3432: + decode(pay_inc.include_or_exclude, null, 0, 0),
3433: pay_pac.effective_date) = ''N''';
3434: --
3435: intretdep := '
3436: and hr_dynsql.ret_person_sequence_locked(pay_pos.period_of_service_id
3437: + decode(pay_pos.person_id, null, 0, 0),
3438: pay_pac.effective_date) = ''N''';
3439: --
3440: intretdepaset := '

Line 3441: and hr_dynsql.ret_person_sequence_locked(pay_pos.period_of_service_id

3437: + decode(pay_pos.person_id, null, 0, 0),
3438: pay_pac.effective_date) = ''N''';
3439: --
3440: intretdepaset := '
3441: and hr_dynsql.ret_person_sequence_locked(pay_pos.period_of_service_id
3442: + decode(pay_inc.include_or_exclude, null, 0, 0),
3443: pay_pac.effective_date) = ''N''';
3444: --
3445: intgrpdep := '

Line 3446: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,

3442: + decode(pay_inc.include_or_exclude, null, 0, 0),
3443: pay_pac.effective_date) = ''N''';
3444: --
3445: intgrpdep := '
3446: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,
3447: pay_pac.effective_date) = ''N''';
3448: --
3449: intgrpdepbal := '
3450: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,

Line 3450: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,

3446: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,
3447: pay_pac.effective_date) = ''N''';
3448: --
3449: intgrpdepbal := '
3450: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,
3451: pay_pac.effective_date,
3452: ''B'') = ''N''';
3453: --
3454: intgrpdepret := '

Line 3455: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,

3451: pay_pac.effective_date,
3452: ''B'') = ''N''';
3453: --
3454: intgrpdepret := '
3455: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,
3456: pay_pac.effective_date,
3457: ''Y'') = ''N''';
3458: --
3459: intretgrpdep := '

Line 3464: and hr_dynsql.process_group_seq_locked(pay_pog_asg2.source_id,

3460: and not exists (select ''''
3461: from pay_object_groups pay_pog_asg2
3462: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3463: and pay_pog_asg2.source_type = ''PAF''
3464: and hr_dynsql.process_group_seq_locked(pay_pog_asg2.source_id,
3465: pay_pac.effective_date,
3466: ''Y'') <> ''N''
3467: )';
3468: --

Line 3630: end hr_dynsql;

3626: -- for update clause to lock assignment and period of service.
3627: fupdate := '
3628: for update of pay_asg.assignment_id, pay_pos.period_of_service_id';
3629: --
3630: end hr_dynsql;