DBA Data[Home] [Help]

APPS.PAY_CONTINUOUS_CALC dependencies on PAY_GRADE_RULES_F

Line 5579: /* PAY_GRADE_RULES_F */

5575: hr_utility.set_location('pay_continuous_calc.PAY_ELEMENT_TYPES_F_aru', 50);
5576: --
5577: end PAY_ELEMENT_TYPES_F_aru;
5578: --
5579: /* PAY_GRADE_RULES_F */
5580: /* name : PAY_GRADE_RULES_F_aru
5581: purpose : This is procedure that records any updates
5582: on grade_rules.
5583: */

Line 5580: /* name : PAY_GRADE_RULES_F_aru

5576: --
5577: end PAY_ELEMENT_TYPES_F_aru;
5578: --
5579: /* PAY_GRADE_RULES_F */
5580: /* name : PAY_GRADE_RULES_F_aru
5581: purpose : This is procedure that records any updates
5582: on grade_rules.
5583: */
5584: procedure PAY_GRADE_RULES_F_aru(

Line 5584: procedure PAY_GRADE_RULES_F_aru(

5580: /* name : PAY_GRADE_RULES_F_aru
5581: purpose : This is procedure that records any updates
5582: on grade_rules.
5583: */
5584: procedure PAY_GRADE_RULES_F_aru(
5585: p_business_group_id in number,
5586: p_legislation_code in varchar2,
5587: p_effective_date in date ,
5588: p_old_GRADE_OR_SPINAL_POINT_ID in NUMBER,

Line 5633: 'PAY_GRADE_RULES_F',

5629: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
5630: --
5631: pay_continuous_calc.event_update(p_business_group_id,
5632: p_legislation_code,
5633: 'PAY_GRADE_RULES_F',
5634: 'GRADE_OR_SPINAL_POINT_ID',
5635: p_old_GRADE_OR_SPINAL_POINT_ID,
5636: p_new_GRADE_OR_SPINAL_POINT_ID,
5637: p_effective_date

Line 5642: 'PAY_GRADE_RULES_F',

5638: );
5639: --
5640: pay_continuous_calc.event_update(p_business_group_id,
5641: p_legislation_code,
5642: 'PAY_GRADE_RULES_F',
5643: 'GRADE_RULE_ID',
5644: p_old_GRADE_RULE_ID,
5645: p_new_GRADE_RULE_ID,
5646: p_effective_date

Line 5651: 'PAY_GRADE_RULES_F',

5647: );
5648: --
5649: pay_continuous_calc.event_update(p_business_group_id,
5650: p_legislation_code,
5651: 'PAY_GRADE_RULES_F',
5652: 'MAXIMUM',
5653: p_old_MAXIMUM,
5654: p_new_MAXIMUM,
5655: p_effective_date

Line 5660: 'PAY_GRADE_RULES_F',

5656: );
5657: --
5658: pay_continuous_calc.event_update(p_business_group_id,
5659: p_legislation_code,
5660: 'PAY_GRADE_RULES_F',
5661: 'MID_VALUE',
5662: p_old_MID_VALUE,
5663: p_new_MID_VALUE,
5664: p_effective_date

Line 5669: 'PAY_GRADE_RULES_F',

5665: );
5666: --
5667: pay_continuous_calc.event_update(p_business_group_id,
5668: p_legislation_code,
5669: 'PAY_GRADE_RULES_F',
5670: 'MINIMUM',
5671: p_old_MINIMUM,
5672: p_new_MINIMUM,
5673: p_effective_date

Line 5678: 'PAY_GRADE_RULES_F',

5674: );
5675: --
5676: pay_continuous_calc.event_update(p_business_group_id,
5677: p_legislation_code,
5678: 'PAY_GRADE_RULES_F',
5679: 'PROGRAM_APPLICATION_ID',
5680: p_old_PROGRAM_APPLICATION_ID,
5681: p_new_PROGRAM_APPLICATION_ID,
5682: p_effective_date

Line 5687: 'PAY_GRADE_RULES_F',

5683: );
5684: --
5685: pay_continuous_calc.event_update(p_business_group_id,
5686: p_legislation_code,
5687: 'PAY_GRADE_RULES_F',
5688: 'PROGRAM_ID',
5689: p_old_PROGRAM_ID,
5690: p_new_PROGRAM_ID,
5691: p_effective_date

Line 5696: 'PAY_GRADE_RULES_F',

5692: );
5693: --
5694: pay_continuous_calc.event_update(p_business_group_id,
5695: p_legislation_code,
5696: 'PAY_GRADE_RULES_F',
5697: 'PROGRAM_UPDATE_DATE',
5698: p_old_PROGRAM_UPDATE_DATE,
5699: p_new_PROGRAM_UPDATE_DATE,
5700: p_effective_date

Line 5705: 'PAY_GRADE_RULES_F',

5701: );
5702: --
5703: pay_continuous_calc.event_update(p_business_group_id,
5704: p_legislation_code,
5705: 'PAY_GRADE_RULES_F',
5706: 'RATE_ID',
5707: p_old_RATE_ID,
5708: p_new_RATE_ID,
5709: p_effective_date

Line 5714: 'PAY_GRADE_RULES_F',

5710: );
5711: --
5712: pay_continuous_calc.event_update(p_business_group_id,
5713: p_legislation_code,
5714: 'PAY_GRADE_RULES_F',
5715: 'RATE_TYPE',
5716: p_old_RATE_TYPE,
5717: p_new_RATE_TYPE,
5718: p_effective_date

Line 5723: 'PAY_GRADE_RULES_F',

5719: );
5720: --
5721: pay_continuous_calc.event_update(p_business_group_id,
5722: p_legislation_code,
5723: 'PAY_GRADE_RULES_F',
5724: 'REQUEST_ID',
5725: p_old_REQUEST_ID,
5726: p_new_REQUEST_ID,
5727: p_effective_date

Line 5732: 'PAY_GRADE_RULES_F',

5728: );
5729: --
5730: pay_continuous_calc.event_update(p_business_group_id,
5731: p_legislation_code,
5732: 'PAY_GRADE_RULES_F',
5733: 'SEQUENCE',
5734: p_old_SEQUENCE,
5735: p_new_SEQUENCE,
5736: p_effective_date

Line 5741: 'PAY_GRADE_RULES_F',

5737: );
5738: --
5739: pay_continuous_calc.event_update(p_business_group_id,
5740: p_legislation_code,
5741: 'PAY_GRADE_RULES_F',
5742: 'VALUE',
5743: p_old_VALUE,
5744: p_new_VALUE,
5745: p_effective_date

Line 5750: 'PAY_GRADE_RULES_F',

5746: );
5747: --
5748: pay_continuous_calc.event_update(p_business_group_id,
5749: p_legislation_code,
5750: 'PAY_GRADE_RULES_F',
5751: 'VALUE',
5752: p_old_VALUE,
5753: p_new_VALUE,
5754: p_effective_date

Line 5761: 'PAY_GRADE_RULES_F',

5757: /* OK it must be a date track change */
5758: --
5759: pay_continuous_calc.event_update(p_business_group_id,
5760: p_legislation_code,
5761: 'PAY_GRADE_RULES_F',
5762: 'EFFECTIVE_END_DATE',
5763: p_old_EFFECTIVE_END_DATE,
5764: p_new_EFFECTIVE_END_DATE,
5765: p_new_effective_end_date,

Line 5772: 'PAY_GRADE_RULES_F',

5768: );
5769: --
5770: pay_continuous_calc.event_update(p_business_group_id,
5771: p_legislation_code,
5772: 'PAY_GRADE_RULES_F',
5773: 'EFFECTIVE_START_DATE',
5774: p_old_EFFECTIVE_START_DATE,
5775: p_new_EFFECTIVE_START_DATE,
5776: p_new_effective_start_date,

Line 5809: end PAY_GRADE_RULES_F_aru;

5805: end if;
5806: pay_continuous_calc.g_event_list.sz := 0;
5807: end;
5808: --
5809: end PAY_GRADE_RULES_F_aru;
5810: --
5811:
5812:
5813: /* PER_ADDRESSES */

Line 6737: /* PAY_GRADE_RULES_F */

6733: hr_utility.set_location(l_proc, 900);
6734: END PER_SPIN_PNT_PLACEMENTS_F_ari;
6735: --
6736:
6737: /* PAY_GRADE_RULES_F */
6738: /* name : PAY_GRADE_RULES_F_ard
6739: purpose : This is procedure that records any Delete on Grade Rules.
6740: */
6741: --

Line 6738: /* name : PAY_GRADE_RULES_F_ard

6734: END PER_SPIN_PNT_PLACEMENTS_F_ari;
6735: --
6736:
6737: /* PAY_GRADE_RULES_F */
6738: /* name : PAY_GRADE_RULES_F_ard
6739: purpose : This is procedure that records any Delete on Grade Rules.
6740: */
6741: --
6742:

Line 6743: procedure PAY_GRADE_RULES_F_ard(

6739: purpose : This is procedure that records any Delete on Grade Rules.
6740: */
6741: --
6742:
6743: procedure PAY_GRADE_RULES_F_ard(
6744: p_business_group_id in number,
6745: p_legislation_code in varchar2,
6746: p_old_grade_rule_id in number,
6747: p_old_effective_start_date in date,

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

6751: )
6752: is
6753: l_process_event_id number;
6754: l_object_version_number number;
6755: l_proc varchar2(240) := g_package||'.PAY_GRADE_RULES_F_ard';
6756: begin
6757: hr_utility.set_location(l_proc, 10);
6758: /* If the continuous calc is overriden then do nothing */
6759: if (g_override_cc = TRUE) then

Line 6765: 'PAY_GRADE_RULES_F',

6761: end if;
6762:
6763: pay_continuous_calc.event_update(p_business_group_id,
6764: p_legislation_code,
6765: 'PAY_GRADE_RULES_F',
6766: null,
6767: null,
6768: null,
6769: p_old_effective_start_date,

Line 6803: END PAY_GRADE_RULES_F_ard;

6799: end if;
6800: pay_continuous_calc.g_event_list.sz := 0;
6801: end;
6802: hr_utility.set_location(l_proc, 900);
6803: END PAY_GRADE_RULES_F_ard;
6804:
6805: --
6806: /* PER_ALL_PEOPLE_F */
6807: /* name : PER_ALL_PEOPLE_F_aru

Line 11293: from pay_grade_rules_f pgr,

11289: is
11290: --
11291: cursor grade_chk is
11292: select '' chk
11293: from pay_grade_rules_f pgr,
11294: pay_assignment_actions paa,
11295: per_assignments_f paf
11296: where paa.assignment_action_id = p_assignment_action_id
11297: and pgr.grade_rule_id = p_surrogate_key

Line 11306: from pay_grade_rules_f pgr,

11302: -- and paf.effective_end_date
11303: and paf.grade_id = pgr.grade_or_spinal_point_id
11304: union
11305: select '' chk
11306: from pay_grade_rules_f pgr,
11307: pay_assignment_actions paa,
11308: per_spinal_points psp,
11309: per_spinal_point_steps_f psps,
11310: per_spinal_point_placements_f pspp