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_ASSIGNMENT_API dependencies on PAY_PEOPLE_GROUPS

Line 15: -- When required this procedure updates the pay_people_groups table after

11: ----------------------------------------------------------------------------
12: -- {Start Of Comments}
13: --
14: -- Description:
15: -- When required this procedure updates the pay_people_groups table after
16: -- the flexfield segments have been inserted to keep the concatenated
17: -- segment string up-to-date.
18: --
19: -- Prerequisites:

Line 20: -- A row must exist in the pay_people_groups table for the

16: -- the flexfield segments have been inserted to keep the concatenated
17: -- segment string up-to-date.
18: --
19: -- Prerequisites:
20: -- A row must exist in the pay_people_groups table for the
21: -- given people_group_id.
22: --
23: -- In Parameters:
24: -- Name Reqd Type Description

Line 46: FROM pay_people_groups

42: ) is
43: --
44: CURSOR csr_chk_pgp is
45: SELECT null
46: FROM pay_people_groups
47: where people_group_id = p_people_group_id
48: and (group_name <> p_group_name
49: or group_name is null);
50: --

Line 62: FROM pay_people_groups

58: PRAGMA AUTONOMOUS_TRANSACTION;
59: --
60: CURSOR csr_pgp_lock is
61: SELECT null
62: FROM pay_people_groups
63: where people_group_id = p_people_group_id
64: for update nowait;
65: --
66: l_exists varchar2(30);

Line 101: update pay_people_groups

97: --
98: -- Lock obtained by this transaction, updating the concatenated
99: -- segment string should be performed.
100: --
101: update pay_people_groups
102: set group_name = p_group_name
103: where people_group_id = p_people_group_id
104: and (group_name <> p_group_name
105: or group_name is null);

Line 3066: l_group_name pay_people_groups.group_name%TYPE;

3062: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3063: l_comment_id per_all_assignments_f.comment_id%TYPE;
3064: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3065: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3066: l_group_name pay_people_groups.group_name%TYPE;
3067: l_old_group_name pay_people_groups.group_name%TYPE;
3068: l_other_manager_warning boolean;
3069: l_effective_date date;
3070: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 3067: l_old_group_name pay_people_groups.group_name%TYPE;

3063: l_comment_id per_all_assignments_f.comment_id%TYPE;
3064: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3065: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3066: l_group_name pay_people_groups.group_name%TYPE;
3067: l_old_group_name pay_people_groups.group_name%TYPE;
3068: l_other_manager_warning boolean;
3069: l_effective_date date;
3070: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3071: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 3503: l_group_name pay_people_groups.group_name%TYPE;

3499: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3500: l_comment_id per_all_assignments_f.comment_id%TYPE;
3501: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3502: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3503: l_group_name pay_people_groups.group_name%TYPE;
3504: l_old_group_name pay_people_groups.group_name%TYPE;
3505: l_other_manager_warning boolean;
3506: l_effective_date date;
3507: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 3504: l_old_group_name pay_people_groups.group_name%TYPE;

3500: l_comment_id per_all_assignments_f.comment_id%TYPE;
3501: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3502: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3503: l_group_name pay_people_groups.group_name%TYPE;
3504: l_old_group_name pay_people_groups.group_name%TYPE;
3505: l_other_manager_warning boolean;
3506: l_effective_date date;
3507: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3508: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 3937: l_group_name pay_people_groups.group_name%TYPE;

3933: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3934: l_comment_id per_all_assignments_f.comment_id%TYPE;
3935: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3936: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3937: l_group_name pay_people_groups.group_name%TYPE;
3938: l_old_group_name pay_people_groups.group_name%TYPE;
3939: l_other_manager_warning boolean;
3940: l_hourly_salaried_warning boolean;
3941: l_effective_date date;

Line 3938: l_old_group_name pay_people_groups.group_name%TYPE;

3934: l_comment_id per_all_assignments_f.comment_id%TYPE;
3935: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3936: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3937: l_group_name pay_people_groups.group_name%TYPE;
3938: l_old_group_name pay_people_groups.group_name%TYPE;
3939: l_other_manager_warning boolean;
3940: l_hourly_salaried_warning boolean;
3941: l_effective_date date;
3942: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 4386: l_group_name pay_people_groups.group_name%TYPE;

4382: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4383: l_comment_id per_all_assignments_f.comment_id%TYPE;
4384: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4385: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4386: l_group_name pay_people_groups.group_name%TYPE;
4387: l_old_group_name pay_people_groups.group_name%TYPE;
4388: l_other_manager_warning boolean;
4389: l_hourly_salaried_warning boolean;
4390: l_effective_date date;

Line 4387: l_old_group_name pay_people_groups.group_name%TYPE;

4383: l_comment_id per_all_assignments_f.comment_id%TYPE;
4384: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4385: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4386: l_group_name pay_people_groups.group_name%TYPE;
4387: l_old_group_name pay_people_groups.group_name%TYPE;
4388: l_other_manager_warning boolean;
4389: l_hourly_salaried_warning boolean;
4390: l_effective_date date;
4391: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 4596: from pay_people_groups

4592: segment27,
4593: segment28,
4594: segment29,
4595: segment30
4596: from pay_people_groups
4597: where people_group_id = l_people_group_id;
4598: --
4599: -- bug 2359997 get hr_soft_coding_keyflex segment values where
4600: -- soft_coding_keyflex_id is known

Line 4689: -- a value then get segment values from pay_people_groups.

4685: -- Replaced p_group_name by p_pgp_concat_segments
4686: l_old_group_name:=p_pgp_concat_segments;
4687: --
4688: -- Bug 2359997 - if p_people_group_id enters with
4689: -- a value then get segment values from pay_people_groups.
4690: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
4691: -- per_cagr_grades_def
4692: --
4693: --

Line 5900: l_old_group_name pay_people_groups.group_name%TYPE;

5896: --
5897: l_proc VARCHAR2(72) := g_package||'create_secondary_cwk_asg';
5898: l_effective_date DATE;
5899: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5900: l_old_group_name pay_people_groups.group_name%TYPE;
5901: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
5902: l_other_manager_warning BOOLEAN;
5903: l_hourly_salaried_warning BOOLEAN;
5904: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 5913: l_group_name pay_people_groups.group_name%TYPE;

5909: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
5910: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5911: l_comment_id per_all_assignments_f.comment_id%TYPE;
5912: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
5913: l_group_name pay_people_groups.group_name%TYPE;
5914: l_session_id NUMBER;
5915: l_business_group_id per_business_groups.business_group_id%TYPE;
5916: l_legislation_code per_business_groups.legislation_code%TYPE;
5917: l_pop_date_start DATE;

Line 12236: l_people_group_name pay_people_groups.group_name%TYPE;

12232: --
12233: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
12234: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
12235: l_entries_changed_warning varchar2(1) := 'N';
12236: l_people_group_name pay_people_groups.group_name%TYPE;
12237: l_old_group_name pay_people_groups.group_name%TYPE;
12238: l_no_managers_warning boolean;
12239: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
12240: l_org_now_no_manager_warning boolean;

Line 12237: l_old_group_name pay_people_groups.group_name%TYPE;

12233: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
12234: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
12235: l_entries_changed_warning varchar2(1) := 'N';
12236: l_people_group_name pay_people_groups.group_name%TYPE;
12237: l_old_group_name pay_people_groups.group_name%TYPE;
12238: l_no_managers_warning boolean;
12239: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
12240: l_org_now_no_manager_warning boolean;
12241: l_other_manager_warning boolean;

Line 14779: l_group_name pay_people_groups.group_name%TYPE;

14775: --
14776: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
14777: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
14778: l_entries_changed_warning varchar2(1) := 'N';
14779: l_group_name pay_people_groups.group_name%TYPE;
14780: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
14781: l_org_now_no_manager_warning boolean;
14782: l_other_manager_warning boolean;
14783: l_people_group_id per_all_assignments_f.people_group_id%TYPE

Line 15007: l_group_name pay_people_groups.group_name%TYPE;

15003: --
15004: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15005: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15006: l_entries_changed_warning varchar2(1) := 'N';
15007: l_group_name pay_people_groups.group_name%TYPE;
15008: l_old_group_name pay_people_groups.group_name%TYPE;
15009: l_no_managers_warning boolean;
15010: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15011: l_org_now_no_manager_warning boolean;

Line 15008: l_old_group_name pay_people_groups.group_name%TYPE;

15004: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15005: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15006: l_entries_changed_warning varchar2(1) := 'N';
15007: l_group_name pay_people_groups.group_name%TYPE;
15008: l_old_group_name pay_people_groups.group_name%TYPE;
15009: l_no_managers_warning boolean;
15010: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15011: l_org_now_no_manager_warning boolean;
15012: l_other_manager_warning boolean;

Line 15221: l_group_name pay_people_groups.group_name%TYPE;

15217: --
15218: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15219: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15220: l_entries_changed_warning varchar2(1) := 'N';
15221: l_group_name pay_people_groups.group_name%TYPE;
15222: l_old_group_name pay_people_groups.group_name%TYPE;
15223: l_no_managers_warning boolean;
15224: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15225: l_org_now_no_manager_warning boolean;

Line 15222: l_old_group_name pay_people_groups.group_name%TYPE;

15218: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15219: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15220: l_entries_changed_warning varchar2(1) := 'N';
15221: l_group_name pay_people_groups.group_name%TYPE;
15222: l_old_group_name pay_people_groups.group_name%TYPE;
15223: l_no_managers_warning boolean;
15224: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15225: l_org_now_no_manager_warning boolean;
15226: l_other_manager_warning boolean;

Line 15376: from pay_people_groups

15372: segment27,
15373: segment28,
15374: segment29,
15375: segment30
15376: from pay_people_groups
15377: where people_group_id = l_people_group_id;
15378: --
15379: cursor csr_get_legislation_code is
15380: select bus.legislation_code

Line 15447: l_old_conc_segs pay_people_groups.group_name%type;

15443: -- End of 3553286
15444: --
15445: -- Start of 4103321
15446: l_old_pgp_segments c_pgp_segments%rowtype;
15447: l_old_conc_segs pay_people_groups.group_name%type;
15448: -- End of 4103321
15449: --
15450: begin
15451: if g_debug then

Line 15491: -- a value then get segment values from pay_people_groups.

15487: --
15488: END IF;
15489: --
15490: -- Bug 2359997 - if p_people_group_id enters with
15491: -- a value then get segment values from pay_people_groups.
15492: --
15493: if g_debug then
15494: hr_utility.set_location(l_proc, 60);
15495: end if;

Line 16723: l_group_name pay_people_groups.group_name%TYPE;

16719: l_assignment_status_id number;
16720: l_asg_status_ovn number;
16721: --
16722: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
16723: l_group_name pay_people_groups.group_name%TYPE;
16724: l_old_group_name pay_people_groups.group_name%TYPE;
16725: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
16726: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
16727: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 16724: l_old_group_name pay_people_groups.group_name%TYPE;

16720: l_asg_status_ovn number;
16721: --
16722: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
16723: l_group_name pay_people_groups.group_name%TYPE;
16724: l_old_group_name pay_people_groups.group_name%TYPE;
16725: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
16726: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
16727: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
16728: l_proc varchar2(72) := g_package||'update_apl_asg';

Line 16928: from pay_people_groups

16924: segment27,
16925: segment28,
16926: segment29,
16927: segment30
16928: from pay_people_groups
16929: where people_group_id = l_people_group_id;
16930: --
16931: -- bug 2230915 get hr_soft_coding_keyflex segment values where
16932: -- soft_coding_keyflex_id is known

Line 17089: -- a value then get segment values from pay_people_groups.

17085: -- Populate l_business_group_id from g_old_rec for cursor csr_grp_idsel
17086: -- Populate l_people_group_id from g_old_rec for upd_or_sel_key_flex
17087: -- 2230915 only populate l_people_group_id from g_old_rec
17088: -- if p_people_group_id did not enter with a value. If it did enter with
17089: -- a value then get segment values from pay_people_groups.
17090: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
17091: -- per_cagr_grades_def
17092: --
17093: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;

Line 18387: l_group_name pay_people_groups.group_name%TYPE;

18383: -- Internal working variables
18384: --
18385: l_business_group_id per_business_groups.business_group_id%TYPE;
18386: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
18387: l_group_name pay_people_groups.group_name%TYPE;
18388: l_proc varchar2(72);
18389: l_api_updating boolean;
18390: --
18391: begin

Line 19095: l_group_name pay_people_groups.group_name%TYPE;

19091: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19094: l_comment_id per_all_assignments_f.comment_id%TYPE;
19095: l_group_name pay_people_groups.group_name%TYPE;
19096: l_old_group_name pay_people_groups.group_name%TYPE;
19097: --
19098: l_application_id per_applications.application_id%TYPE;
19099: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 19096: l_old_group_name pay_people_groups.group_name%TYPE;

19092: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19093: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19094: l_comment_id per_all_assignments_f.comment_id%TYPE;
19095: l_group_name pay_people_groups.group_name%TYPE;
19096: l_old_group_name pay_people_groups.group_name%TYPE;
19097: --
19098: l_application_id per_applications.application_id%TYPE;
19099: l_business_group_id per_business_groups.business_group_id%TYPE;
19100: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 19308: from pay_people_groups

19304: segment27,
19305: segment28,
19306: segment29,
19307: segment30
19308: from pay_people_groups
19309: where people_group_id = l_people_group_id;
19310: --
19311: -- bug 2230915 get hr_soft_coding_keyflex segment values where
19312: -- soft_coding_keyflex_id is known

Line 19444: -- a value then get segment values from pay_people_groups.

19440: --
19441: close csr_get_derived_details;
19442: --
19443: -- Bug 2230915 - if p_people_group_id enters with
19444: -- a value then get segment values from pay_people_groups.
19445: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
19446: -- per_cagr_grades_def
19447: --
19448: --

Line 20811: l_group_name pay_people_groups.group_name%TYPE;

20807: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
20808: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
20809: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
20810: l_comment_id per_all_assignments_f.comment_id%TYPE;
20811: l_group_name pay_people_groups.group_name%TYPE;
20812: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
20813: l_application_id per_applications.application_id%TYPE;
20814: l_business_group_id per_business_groups.business_group_id%TYPE;
20815: l_legislation_code per_business_groups.legislation_code%TYPE;