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.46.12020000.10 2012/12/11 09:32:49 panumala ship $ */
3: -- cache for get_tax_unit
4: g_cached boolean := FALSE;
5: g_tax_unit pay_legislation_rules.rule_mode%type;

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 2242: pay_proc_logging.PY_ENTRY('hr_dynsql.pyrsql');

2238: l_asg_set_id number;
2239: l_inc_or_excl HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;
2240: begin
2241: --
2242: pay_proc_logging.PY_ENTRY('hr_dynsql.pyrsql');
2243: --
2244: --
2245: hr_utility.trace('sqlid = '||sqlid);
2246: hr_utility.trace('timedepflg = '||timedepflg);

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

2696: end if;
2697: end if;
2698: len := length(sqlstr); -- return the length of the string.
2699: --
2700: pay_proc_logging.PY_EXIT('hr_dynsql.pyrsql');
2701: --
2702: end pyrsql;
2703: --
2704: ---------------------------- adv_override_check ----------------------------

Line 2818: hr_dynsql.get_tax_unit(pay_asg.assignment_id,

2814: ''U'',
2815: :chunk_number,
2816: pay_assignment_actions_s.nextval,
2817: 1,
2818: hr_dynsql.get_tax_unit(pay_asg.assignment_id,
2819: pay_pac.effective_date),
2820: ''U'',
2821: pay_asg.assignment_id';
2822: --

Line 2833: hr_dynsql.get_tax_unit(pay_asg.assignment_id,

2829: ''U'',
2830: :chunk_number,
2831: pay_assignment_actions_s.nextval,
2832: 1,
2833: hr_dynsql.get_tax_unit(pay_asg.assignment_id,
2834: pay_pac.effective_date),
2835: ''U'',
2836: null';
2837: --

Line 2852: hr_dynsql.get_tax_unit(pay_asg.assignment_id,

2848: ''U'',
2849: :chunk_number,
2850: 1,
2851: 1,
2852: hr_dynsql.get_tax_unit(pay_asg.assignment_id,
2853: pay_pac.effective_date),
2854: ''U'',
2855: null';
2856: -- Bug 8725368 : Parent assignment action id is also picked

Line 2870: hr_dynsql.get_tax_unit(pay_asg.assignment_id,

2866: ''U'',
2867: :chunk_number,
2868: 1,
2869: 1,
2870: hr_dynsql.get_tax_unit(pay_asg.assignment_id,
2871: pay_pac.effective_date),
2872: ''U'',
2873: null';
2874: --

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

3096: and pay_pee.element_entry_id = pay_pev.element_entry_id
3097: and pay_pee.element_entry_id = pay_pev2.element_entry_id
3098: and pay_pev.input_value_id = pay_piv.input_value_id
3099: and pay_piv2.input_value_id = pay_pev2.input_value_id
3100: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''
3101: and TRANSLATE(UPPER(pay_piv.name), '' '', ''_'') =
3102: (select TRANSLATE(UPPER(pay_hrl3.meaning), '' '', ''_'')
3103: from hr_lookups pay_hrl3
3104: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''

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

3146: and pay_pee.element_entry_id = pay_pev.element_entry_id
3147: and pay_pee.element_entry_id = pay_pev2.element_entry_id
3148: and pay_pev.input_value_id = pay_piv.input_value_id
3149: and pay_piv2.input_value_id = pay_pev2.input_value_id
3150: and hr_dynsql.adv_override_check(pay_pee.element_entry_id,pay_pac.effective_date,pay_pac.end_date) = ''Y''
3151: and TRANSLATE(UPPER(pay_piv.name), '' '', ''_'') =
3152: (select TRANSLATE(UPPER(pay_hrl3.meaning), '' '', ''_'')
3153: from hr_lookups pay_hrl3
3154: WHERE pay_hrl3.lookup_type = ''NAME_TRANSLATIONS''

Line 3495: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id

3491:
3492: -- and not exists clause to exclude people failing interlock rules.
3493: -- this one is for time dependent legislation.
3494: intdep := '
3495: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id
3496: + decode(pay_pos.person_id, null, 0, 0),
3497: pay_pac.effective_date) = ''N''';
3498: -- Bug 14740436 : Removed Decode function
3499: intdepaset := '

Line 3500: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id,

3496: + decode(pay_pos.person_id, null, 0, 0),
3497: pay_pac.effective_date) = ''N''';
3498: -- Bug 14740436 : Removed Decode function
3499: intdepaset := '
3500: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id,
3501: pay_pac.effective_date) = ''N''';
3502: --
3503: intbaldep := '
3504: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id

Line 3504: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id

3500: and hr_dynsql.person_sequence_locked(pay_pos.period_of_service_id,
3501: pay_pac.effective_date) = ''N''';
3502: --
3503: intbaldep := '
3504: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id
3505: + decode(pay_pos.person_id, null, 0, 0),
3506: pay_pac.effective_date) = ''N''';
3507: --
3508: intbaldepaset := '

Line 3509: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id

3505: + decode(pay_pos.person_id, null, 0, 0),
3506: pay_pac.effective_date) = ''N''';
3507: --
3508: intbaldepaset := '
3509: and hr_dynsql.bal_person_sequence_locked(pay_pos.period_of_service_id
3510: + decode(pay_inc.include_or_exclude, null, 0, 0),
3511: pay_pac.effective_date) = ''N''';
3512: --
3513: intretdep := '

Line 3514: and hr_dynsql.ret_person_sequence_locked(pay_pos.period_of_service_id

3510: + decode(pay_inc.include_or_exclude, null, 0, 0),
3511: pay_pac.effective_date) = ''N''';
3512: --
3513: intretdep := '
3514: and hr_dynsql.ret_person_sequence_locked(pay_pos.period_of_service_id
3515: + decode(pay_pos.person_id, null, 0, 0),
3516: pay_pac.effective_date) = ''N''';
3517: --
3518: intretdepaset := '

Line 3519: and hr_dynsql.ret_person_sequence_locked(pay_pos.period_of_service_id

3515: + decode(pay_pos.person_id, null, 0, 0),
3516: pay_pac.effective_date) = ''N''';
3517: --
3518: intretdepaset := '
3519: and hr_dynsql.ret_person_sequence_locked(pay_pos.period_of_service_id
3520: + decode(pay_inc.include_or_exclude, null, 0, 0),
3521: pay_pac.effective_date) = ''N''';
3522: --
3523: intgrpdep := '

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

3520: + decode(pay_inc.include_or_exclude, null, 0, 0),
3521: pay_pac.effective_date) = ''N''';
3522: --
3523: intgrpdep := '
3524: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,
3525: pay_pac.effective_date) = ''N''';
3526: --
3527: intgrpdepbal := '
3528: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,

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

3524: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,
3525: pay_pac.effective_date) = ''N''';
3526: --
3527: intgrpdepbal := '
3528: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,
3529: pay_pac.effective_date,
3530: ''B'') = ''N''';
3531: --
3532: intgrpdepret := '

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

3529: pay_pac.effective_date,
3530: ''B'') = ''N''';
3531: --
3532: intgrpdepret := '
3533: and hr_dynsql.process_group_seq_locked(pay_asg.assignment_id,
3534: pay_pac.effective_date,
3535: ''Y'') = ''N''';
3536: --
3537: intretgrpdep := '

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

3538: and not exists (select ''''
3539: from pay_object_groups pay_pog_asg2
3540: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3541: and pay_pog_asg2.source_type = ''PAF''
3542: and hr_dynsql.process_group_seq_locked(pay_pog_asg2.source_id,
3543: pay_pac.effective_date,
3544: ''Y'') <> ''N''
3545: )';
3546: --

Line 3750: end hr_dynsql;

3746: -- for update clause to lock assignment and period of service.
3747: fupdate := '
3748: for update of pay_asg.assignment_id, pay_pos.period_of_service_id';
3749: --
3750: end hr_dynsql;