DBA Data[Home] [Help]

APPS.PAY_CONTINUOUS_CALC dependencies on PAY_GRADE_RULES_F

Line 5547: /* PAY_GRADE_RULES_F */

5543: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 50);
5544: --
5545: end PAY_ELEMENT_TYPES_F_aru;
5546: --
5547: /* PAY_GRADE_RULES_F */
5548: /* name : PAY_GRADE_RULES_F_aru
5549: purpose : This is procedure that records any updates
5550: on grade_rules.
5551: */

Line 5548: /* name : PAY_GRADE_RULES_F_aru

5544: --
5545: end PAY_ELEMENT_TYPES_F_aru;
5546: --
5547: /* PAY_GRADE_RULES_F */
5548: /* name : PAY_GRADE_RULES_F_aru
5549: purpose : This is procedure that records any updates
5550: on grade_rules.
5551: */
5552: procedure PAY_GRADE_RULES_F_aru(

Line 5552: procedure PAY_GRADE_RULES_F_aru(

5548: /* name : PAY_GRADE_RULES_F_aru
5549: purpose : This is procedure that records any updates
5550: on grade_rules.
5551: */
5552: procedure PAY_GRADE_RULES_F_aru(
5553: p_business_group_id in number,
5554: p_legislation_code in varchar2,
5555: p_effective_date in date ,
5556: p_old_GRADE_OR_SPINAL_POINT_ID in NUMBER,

Line 5601: 'PAY_GRADE_RULES_F',

5597: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
5598: --
5599: pay_continuous_calc.event_update(p_business_group_id,
5600: p_legislation_code,
5601: 'PAY_GRADE_RULES_F',
5602: 'GRADE_OR_SPINAL_POINT_ID',
5603: p_old_GRADE_OR_SPINAL_POINT_ID,
5604: p_new_GRADE_OR_SPINAL_POINT_ID,
5605: p_effective_date

Line 5610: 'PAY_GRADE_RULES_F',

5606: );
5607: --
5608: pay_continuous_calc.event_update(p_business_group_id,
5609: p_legislation_code,
5610: 'PAY_GRADE_RULES_F',
5611: 'GRADE_RULE_ID',
5612: p_old_GRADE_RULE_ID,
5613: p_new_GRADE_RULE_ID,
5614: p_effective_date

Line 5619: 'PAY_GRADE_RULES_F',

5615: );
5616: --
5617: pay_continuous_calc.event_update(p_business_group_id,
5618: p_legislation_code,
5619: 'PAY_GRADE_RULES_F',
5620: 'MAXIMUM',
5621: p_old_MAXIMUM,
5622: p_new_MAXIMUM,
5623: p_effective_date

Line 5628: 'PAY_GRADE_RULES_F',

5624: );
5625: --
5626: pay_continuous_calc.event_update(p_business_group_id,
5627: p_legislation_code,
5628: 'PAY_GRADE_RULES_F',
5629: 'MID_VALUE',
5630: p_old_MID_VALUE,
5631: p_new_MID_VALUE,
5632: p_effective_date

Line 5637: 'PAY_GRADE_RULES_F',

5633: );
5634: --
5635: pay_continuous_calc.event_update(p_business_group_id,
5636: p_legislation_code,
5637: 'PAY_GRADE_RULES_F',
5638: 'MINIMUM',
5639: p_old_MINIMUM,
5640: p_new_MINIMUM,
5641: p_effective_date

Line 5646: 'PAY_GRADE_RULES_F',

5642: );
5643: --
5644: pay_continuous_calc.event_update(p_business_group_id,
5645: p_legislation_code,
5646: 'PAY_GRADE_RULES_F',
5647: 'PROGRAM_APPLICATION_ID',
5648: p_old_PROGRAM_APPLICATION_ID,
5649: p_new_PROGRAM_APPLICATION_ID,
5650: p_effective_date

Line 5655: 'PAY_GRADE_RULES_F',

5651: );
5652: --
5653: pay_continuous_calc.event_update(p_business_group_id,
5654: p_legislation_code,
5655: 'PAY_GRADE_RULES_F',
5656: 'PROGRAM_ID',
5657: p_old_PROGRAM_ID,
5658: p_new_PROGRAM_ID,
5659: p_effective_date

Line 5664: 'PAY_GRADE_RULES_F',

5660: );
5661: --
5662: pay_continuous_calc.event_update(p_business_group_id,
5663: p_legislation_code,
5664: 'PAY_GRADE_RULES_F',
5665: 'PROGRAM_UPDATE_DATE',
5666: p_old_PROGRAM_UPDATE_DATE,
5667: p_new_PROGRAM_UPDATE_DATE,
5668: p_effective_date

Line 5673: 'PAY_GRADE_RULES_F',

5669: );
5670: --
5671: pay_continuous_calc.event_update(p_business_group_id,
5672: p_legislation_code,
5673: 'PAY_GRADE_RULES_F',
5674: 'RATE_ID',
5675: p_old_RATE_ID,
5676: p_new_RATE_ID,
5677: p_effective_date

Line 5682: 'PAY_GRADE_RULES_F',

5678: );
5679: --
5680: pay_continuous_calc.event_update(p_business_group_id,
5681: p_legislation_code,
5682: 'PAY_GRADE_RULES_F',
5683: 'RATE_TYPE',
5684: p_old_RATE_TYPE,
5685: p_new_RATE_TYPE,
5686: p_effective_date

Line 5691: 'PAY_GRADE_RULES_F',

5687: );
5688: --
5689: pay_continuous_calc.event_update(p_business_group_id,
5690: p_legislation_code,
5691: 'PAY_GRADE_RULES_F',
5692: 'REQUEST_ID',
5693: p_old_REQUEST_ID,
5694: p_new_REQUEST_ID,
5695: p_effective_date

Line 5700: 'PAY_GRADE_RULES_F',

5696: );
5697: --
5698: pay_continuous_calc.event_update(p_business_group_id,
5699: p_legislation_code,
5700: 'PAY_GRADE_RULES_F',
5701: 'SEQUENCE',
5702: p_old_SEQUENCE,
5703: p_new_SEQUENCE,
5704: p_effective_date

Line 5709: 'PAY_GRADE_RULES_F',

5705: );
5706: --
5707: pay_continuous_calc.event_update(p_business_group_id,
5708: p_legislation_code,
5709: 'PAY_GRADE_RULES_F',
5710: 'VALUE',
5711: p_old_VALUE,
5712: p_new_VALUE,
5713: p_effective_date

Line 5718: 'PAY_GRADE_RULES_F',

5714: );
5715: --
5716: pay_continuous_calc.event_update(p_business_group_id,
5717: p_legislation_code,
5718: 'PAY_GRADE_RULES_F',
5719: 'VALUE',
5720: p_old_VALUE,
5721: p_new_VALUE,
5722: p_effective_date

Line 5729: 'PAY_GRADE_RULES_F',

5725: /* OK it must be a date track change */
5726: --
5727: pay_continuous_calc.event_update(p_business_group_id,
5728: p_legislation_code,
5729: 'PAY_GRADE_RULES_F',
5730: 'EFFECTIVE_END_DATE',
5731: p_old_EFFECTIVE_END_DATE,
5732: p_new_EFFECTIVE_END_DATE,
5733: p_new_effective_end_date,

Line 5740: 'PAY_GRADE_RULES_F',

5736: );
5737: --
5738: pay_continuous_calc.event_update(p_business_group_id,
5739: p_legislation_code,
5740: 'PAY_GRADE_RULES_F',
5741: 'EFFECTIVE_START_DATE',
5742: p_old_EFFECTIVE_START_DATE,
5743: p_new_EFFECTIVE_START_DATE,
5744: p_new_effective_start_date,

Line 5777: end PAY_GRADE_RULES_F_aru;

5773: end if;
5774: pay_continuous_calc.g_event_list.sz := 0;
5775: end;
5776: --
5777: end PAY_GRADE_RULES_F_aru;
5778: --
5779:
5780:
5781: /* PER_ADDRESSES */

Line 6705: /* PAY_GRADE_RULES_F */

6701: hr_utility.set_location(l_proc, 900);
6702: END PER_SPIN_PNT_PLACEMENTS_F_ari;
6703: --
6704:
6705: /* PAY_GRADE_RULES_F */
6706: /* name : PAY_GRADE_RULES_F_ard
6707: purpose : This is procedure that records any Delete on Grade Rules.
6708: */
6709: --

Line 6706: /* name : PAY_GRADE_RULES_F_ard

6702: END PER_SPIN_PNT_PLACEMENTS_F_ari;
6703: --
6704:
6705: /* PAY_GRADE_RULES_F */
6706: /* name : PAY_GRADE_RULES_F_ard
6707: purpose : This is procedure that records any Delete on Grade Rules.
6708: */
6709: --
6710:

Line 6711: procedure PAY_GRADE_RULES_F_ard(

6707: purpose : This is procedure that records any Delete on Grade Rules.
6708: */
6709: --
6710:
6711: procedure PAY_GRADE_RULES_F_ard(
6712: p_business_group_id in number,
6713: p_legislation_code in varchar2,
6714: p_old_grade_rule_id in number,
6715: p_old_effective_start_date in date,

Line 6723: l_proc varchar2(240) := g_package||'.PAY_GRADE_RULES_F_ard';

6719: )
6720: is
6721: l_process_event_id number;
6722: l_object_version_number number;
6723: l_proc varchar2(240) := g_package||'.PAY_GRADE_RULES_F_ard';
6724: begin
6725: hr_utility.set_location(l_proc, 10);
6726: /* If the continuous calc is overriden then do nothing */
6727: if (g_override_cc = TRUE) then

Line 6733: 'PAY_GRADE_RULES_F',

6729: end if;
6730:
6731: pay_continuous_calc.event_update(p_business_group_id,
6732: p_legislation_code,
6733: 'PAY_GRADE_RULES_F',
6734: null,
6735: null,
6736: null,
6737: p_old_effective_start_date,

Line 6771: END PAY_GRADE_RULES_F_ard;

6767: end if;
6768: pay_continuous_calc.g_event_list.sz := 0;
6769: end;
6770: hr_utility.set_location(l_proc, 900);
6771: END PAY_GRADE_RULES_F_ard;
6772:
6773: --
6774: /* PER_ALL_PEOPLE_F */
6775: /* name : PER_ALL_PEOPLE_F_aru

Line 11261: from pay_grade_rules_f pgr,

11257: is
11258: --
11259: cursor grade_chk is
11260: select '' chk
11261: from pay_grade_rules_f pgr,
11262: pay_assignment_actions paa,
11263: per_assignments_f paf
11264: where paa.assignment_action_id = p_assignment_action_id
11265: and pgr.grade_rule_id = p_surrogate_key

Line 11274: from pay_grade_rules_f pgr,

11270: -- and paf.effective_end_date
11271: and paf.grade_id = pgr.grade_or_spinal_point_id
11272: union
11273: select '' chk
11274: from pay_grade_rules_f pgr,
11275: pay_assignment_actions paa,
11276: per_spinal_points psp,
11277: per_spinal_point_steps_f psps,
11278: per_spinal_point_placements_f pspp