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 103: -- are updated into the table pay_people_groups

99: --
100: -- Bug#7601790
101: -- Added the code to check whether p_group_name is greater
102: -- than 240 characters. If yes, only first 240 characters
103: -- are updated into the table pay_people_groups
104: --
105: -- fix for Bug#7601790 starts
106:
107: l_group_name1:=p_group_name;

Line 117: update pay_people_groups

113: --
114: -- Lock obtained by this transaction, updating the concatenated
115: -- segment string should be performed.
116: --
117: update pay_people_groups
118: --set group_name = p_group_name fix for Bug#7601790
119: set group_name = l_group_name1
120: where people_group_id = p_people_group_id
121: and (group_name <> p_group_name

Line 3633: l_group_name pay_people_groups.group_name%TYPE;

3629: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3630: l_comment_id per_all_assignments_f.comment_id%TYPE;
3631: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3632: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3633: l_group_name pay_people_groups.group_name%TYPE;
3634: l_old_group_name pay_people_groups.group_name%TYPE;
3635: l_other_manager_warning boolean;
3636: l_effective_date date;
3637: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 3634: l_old_group_name pay_people_groups.group_name%TYPE;

3630: l_comment_id per_all_assignments_f.comment_id%TYPE;
3631: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3632: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
3633: l_group_name pay_people_groups.group_name%TYPE;
3634: l_old_group_name pay_people_groups.group_name%TYPE;
3635: l_other_manager_warning boolean;
3636: l_effective_date date;
3637: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
3638: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 4070: l_group_name pay_people_groups.group_name%TYPE;

4066: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4067: l_comment_id per_all_assignments_f.comment_id%TYPE;
4068: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4069: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4070: l_group_name pay_people_groups.group_name%TYPE;
4071: l_old_group_name pay_people_groups.group_name%TYPE;
4072: l_other_manager_warning boolean;
4073: l_effective_date date;
4074: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 4071: l_old_group_name pay_people_groups.group_name%TYPE;

4067: l_comment_id per_all_assignments_f.comment_id%TYPE;
4068: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4069: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4070: l_group_name pay_people_groups.group_name%TYPE;
4071: l_old_group_name pay_people_groups.group_name%TYPE;
4072: l_other_manager_warning boolean;
4073: l_effective_date date;
4074: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4075: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 4504: l_group_name pay_people_groups.group_name%TYPE;

4500: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4501: l_comment_id per_all_assignments_f.comment_id%TYPE;
4502: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4503: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4504: l_group_name pay_people_groups.group_name%TYPE;
4505: l_old_group_name pay_people_groups.group_name%TYPE;
4506: l_other_manager_warning boolean;
4507: l_hourly_salaried_warning boolean;
4508: l_effective_date date;

Line 4505: l_old_group_name pay_people_groups.group_name%TYPE;

4501: l_comment_id per_all_assignments_f.comment_id%TYPE;
4502: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4503: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4504: l_group_name pay_people_groups.group_name%TYPE;
4505: l_old_group_name pay_people_groups.group_name%TYPE;
4506: l_other_manager_warning boolean;
4507: l_hourly_salaried_warning boolean;
4508: l_effective_date date;
4509: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 4953: l_group_name pay_people_groups.group_name%TYPE;

4949: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4950: l_comment_id per_all_assignments_f.comment_id%TYPE;
4951: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4952: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4953: l_group_name pay_people_groups.group_name%TYPE;
4954: l_old_group_name pay_people_groups.group_name%TYPE;
4955: l_other_manager_warning boolean;
4956: l_hourly_salaried_warning boolean;
4957: l_effective_date date;

Line 4954: l_old_group_name pay_people_groups.group_name%TYPE;

4950: l_comment_id per_all_assignments_f.comment_id%TYPE;
4951: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4952: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4953: l_group_name pay_people_groups.group_name%TYPE;
4954: l_old_group_name pay_people_groups.group_name%TYPE;
4955: l_other_manager_warning boolean;
4956: l_hourly_salaried_warning boolean;
4957: l_effective_date date;
4958: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 5163: from pay_people_groups

5159: segment27,
5160: segment28,
5161: segment29,
5162: segment30
5163: from pay_people_groups
5164: where people_group_id = l_people_group_id;
5165: --
5166: -- bug 2359997 get hr_soft_coding_keyflex segment values where
5167: -- soft_coding_keyflex_id is known

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

5252: -- Replaced p_group_name by p_pgp_concat_segments
5253: l_old_group_name:=p_pgp_concat_segments;
5254: --
5255: -- Bug 2359997 - if p_people_group_id enters with
5256: -- a value then get segment values from pay_people_groups.
5257: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
5258: -- per_cagr_grades_def
5259: --
5260: --

Line 6467: l_old_group_name pay_people_groups.group_name%TYPE;

6463: --
6464: l_proc VARCHAR2(72) := g_package||'create_secondary_cwk_asg';
6465: l_effective_date DATE;
6466: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
6467: l_old_group_name pay_people_groups.group_name%TYPE;
6468: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6469: l_other_manager_warning BOOLEAN;
6470: l_hourly_salaried_warning BOOLEAN;
6471: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 6480: l_group_name pay_people_groups.group_name%TYPE;

6476: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
6477: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
6478: l_comment_id per_all_assignments_f.comment_id%TYPE;
6479: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
6480: l_group_name pay_people_groups.group_name%TYPE;
6481: l_session_id NUMBER;
6482: l_business_group_id per_business_groups.business_group_id%TYPE;
6483: l_legislation_code per_business_groups.legislation_code%TYPE;
6484: l_pop_date_start DATE;

Line 12837: l_people_group_name pay_people_groups.group_name%TYPE;

12833: --
12834: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
12835: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
12836: l_entries_changed_warning varchar2(1) := 'N';
12837: l_people_group_name pay_people_groups.group_name%TYPE;
12838: l_old_group_name pay_people_groups.group_name%TYPE;
12839: l_no_managers_warning boolean;
12840: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
12841: l_org_now_no_manager_warning boolean;

Line 12838: l_old_group_name pay_people_groups.group_name%TYPE;

12834: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
12835: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
12836: l_entries_changed_warning varchar2(1) := 'N';
12837: l_people_group_name pay_people_groups.group_name%TYPE;
12838: l_old_group_name pay_people_groups.group_name%TYPE;
12839: l_no_managers_warning boolean;
12840: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
12841: l_org_now_no_manager_warning boolean;
12842: l_other_manager_warning boolean;

Line 15380: l_group_name pay_people_groups.group_name%TYPE;

15376: --
15377: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15378: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15379: l_entries_changed_warning varchar2(1) := 'N';
15380: l_group_name pay_people_groups.group_name%TYPE;
15381: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15382: l_org_now_no_manager_warning boolean;
15383: l_other_manager_warning boolean;
15384: l_people_group_id per_all_assignments_f.people_group_id%TYPE

Line 15608: l_group_name pay_people_groups.group_name%TYPE;

15604: --
15605: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15606: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15607: l_entries_changed_warning varchar2(1) := 'N';
15608: l_group_name pay_people_groups.group_name%TYPE;
15609: l_old_group_name pay_people_groups.group_name%TYPE;
15610: l_no_managers_warning boolean;
15611: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15612: l_org_now_no_manager_warning boolean;

Line 15609: l_old_group_name pay_people_groups.group_name%TYPE;

15605: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15606: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15607: l_entries_changed_warning varchar2(1) := 'N';
15608: l_group_name pay_people_groups.group_name%TYPE;
15609: l_old_group_name pay_people_groups.group_name%TYPE;
15610: l_no_managers_warning boolean;
15611: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15612: l_org_now_no_manager_warning boolean;
15613: l_other_manager_warning boolean;

Line 15823: l_group_name pay_people_groups.group_name%TYPE;

15819: --
15820: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15821: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15822: l_entries_changed_warning varchar2(1) := 'N';
15823: l_group_name pay_people_groups.group_name%TYPE;
15824: l_old_group_name pay_people_groups.group_name%TYPE;
15825: l_no_managers_warning boolean;
15826: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15827: l_org_now_no_manager_warning boolean;

Line 15824: l_old_group_name pay_people_groups.group_name%TYPE;

15820: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
15821: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
15822: l_entries_changed_warning varchar2(1) := 'N';
15823: l_group_name pay_people_groups.group_name%TYPE;
15824: l_old_group_name pay_people_groups.group_name%TYPE;
15825: l_no_managers_warning boolean;
15826: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
15827: l_org_now_no_manager_warning boolean;
15828: l_other_manager_warning boolean;

Line 15978: from pay_people_groups

15974: segment27,
15975: segment28,
15976: segment29,
15977: segment30
15978: from pay_people_groups
15979: where people_group_id = l_people_group_id;
15980: --
15981: cursor csr_get_legislation_code is
15982: select bus.legislation_code

Line 16057: l_old_conc_segs pay_people_groups.group_name%type;

16053: -- End of 3553286
16054: --
16055: -- Start of 4103321
16056: l_old_pgp_segments c_pgp_segments%rowtype;
16057: l_old_conc_segs pay_people_groups.group_name%type;
16058: -- End of 4103321
16059:
16060: /* commented the code for Bug#14248434 */
16061: -- Start changes for bug 12911607

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

16143: --
16144: END IF;
16145: --
16146: -- Bug 2359997 - if p_people_group_id enters with
16147: -- a value then get segment values from pay_people_groups.
16148: --
16149: if g_debug then
16150: hr_utility.set_location(l_proc, 60);
16151: end if;

Line 17569: l_group_name pay_people_groups.group_name%TYPE;

17565: l_assignment_status_id number;
17566: l_asg_status_ovn number;
17567: --
17568: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
17569: l_group_name pay_people_groups.group_name%TYPE;
17570: l_old_group_name pay_people_groups.group_name%TYPE;
17571: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
17572: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
17573: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 17570: l_old_group_name pay_people_groups.group_name%TYPE;

17566: l_asg_status_ovn number;
17567: --
17568: l_people_group_id per_all_assignments_f.people_group_id%TYPE := p_people_group_id;
17569: l_group_name pay_people_groups.group_name%TYPE;
17570: l_old_group_name pay_people_groups.group_name%TYPE;
17571: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
17572: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
17573: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
17574: l_proc varchar2(72) := g_package||'update_apl_asg';

Line 17774: from pay_people_groups

17770: segment27,
17771: segment28,
17772: segment29,
17773: segment30
17774: from pay_people_groups
17775: where people_group_id = l_people_group_id;
17776: --
17777: -- bug 2230915 get hr_soft_coding_keyflex segment values where
17778: -- soft_coding_keyflex_id is known

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

17932: -- Populate l_business_group_id from g_old_rec for cursor csr_grp_idsel
17933: -- Populate l_people_group_id from g_old_rec for upd_or_sel_key_flex
17934: -- 2230915 only populate l_people_group_id from g_old_rec
17935: -- if p_people_group_id did not enter with a value. If it did enter with
17936: -- a value then get segment values from pay_people_groups.
17937: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
17938: -- per_cagr_grades_def
17939: --
17940: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;

Line 19250: l_group_name pay_people_groups.group_name%TYPE;

19246: -- Internal working variables
19247: --
19248: l_business_group_id per_business_groups.business_group_id%TYPE;
19249: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
19250: l_group_name pay_people_groups.group_name%TYPE;
19251: l_proc varchar2(72);
19252: l_api_updating boolean;
19253: --
19254: begin

Line 19958: l_group_name pay_people_groups.group_name%TYPE;

19954: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19957: l_comment_id per_all_assignments_f.comment_id%TYPE;
19958: l_group_name pay_people_groups.group_name%TYPE;
19959: l_old_group_name pay_people_groups.group_name%TYPE;
19960: --
19961: l_application_id per_applications.application_id%TYPE;
19962: l_business_group_id per_business_groups.business_group_id%TYPE;

Line 19959: l_old_group_name pay_people_groups.group_name%TYPE;

19955: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
19956: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
19957: l_comment_id per_all_assignments_f.comment_id%TYPE;
19958: l_group_name pay_people_groups.group_name%TYPE;
19959: l_old_group_name pay_people_groups.group_name%TYPE;
19960: --
19961: l_application_id per_applications.application_id%TYPE;
19962: l_business_group_id per_business_groups.business_group_id%TYPE;
19963: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 20171: from pay_people_groups

20167: segment27,
20168: segment28,
20169: segment29,
20170: segment30
20171: from pay_people_groups
20172: where people_group_id = l_people_group_id;
20173: --
20174: -- bug 2230915 get hr_soft_coding_keyflex segment values where
20175: -- soft_coding_keyflex_id is known

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

20303: --
20304: close csr_get_derived_details;
20305: --
20306: -- Bug 2230915 - if p_people_group_id enters with
20307: -- a value then get segment values from pay_people_groups.
20308: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
20309: -- per_cagr_grades_def
20310: --
20311: --

Line 21674: l_group_name pay_people_groups.group_name%TYPE;

21670: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
21671: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
21672: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
21673: l_comment_id per_all_assignments_f.comment_id%TYPE;
21674: l_group_name pay_people_groups.group_name%TYPE;
21675: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
21676: l_application_id per_applications.application_id%TYPE;
21677: l_business_group_id per_business_groups.business_group_id%TYPE;
21678: l_legislation_code per_business_groups.legislation_code%TYPE;