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 PER_ASG_SHD

Line 437: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,

433:
434: -- now update the assignments table
435: -- we must lock the row before we update it
436:
437: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,
438: p_datetrack_mode => 'CORRECTION',
439: p_assignment_id =>p_assignment_id,
440: p_object_version_number =>l_ovn,
441: p_validation_start_date =>l_validation_start_date,

Line 901: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,

897:
898: -- now update the assignments table
899: -- we must lock the row before we update it
900:
901: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,
902: p_datetrack_mode => 'CORRECTION',
903: p_assignment_id =>p_assignment_id,
904: p_object_version_number =>l_ovn,
905: p_validation_start_date =>l_validation_start_date,

Line 1036: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,

1032:
1033: -- now update the assignments table
1034: -- we must lock the row before we update it
1035:
1036: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,
1037: p_datetrack_mode => 'CORRECTION',
1038: p_assignment_id =>p_assignment_id,
1039: p_object_version_number =>l_ovn,
1040: p_validation_start_date =>l_validation_start_date,

Line 11333: per_asg_shd.lck

11329: l_cagr_id_flex_num := p_cagr_id_flex_num;
11330: --
11331: if (p_cagr_id_flex_num = hr_api.g_number)
11332: then
11333: per_asg_shd.lck
11334: (p_effective_date => l_effective_date,
11335: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
11336: p_datetrack_mode => p_datetrack_update_mode,
11337: p_assignment_id => p_assignment_id,

Line 11342: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;

11338: p_object_version_number => p_object_version_number,
11339: p_validation_start_date => l_unused_start_date,
11340: p_validation_end_date => l_unused_end_date
11341: );
11342: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
11343: -- l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
11344: -- commented out for bug 2359997
11345: end if;
11346: --

Line 11343: -- l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;

11339: p_validation_start_date => l_unused_start_date,
11340: p_validation_end_date => l_unused_end_date
11341: );
11342: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
11343: -- l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
11344: -- commented out for bug 2359997
11345: end if;
11346: --
11347: --

Line 11351: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;

11347: --
11348: -- Bug 4003788 added the check for the cagr_id_flex_num also
11349: if l_cag_null_ind = 0 and l_cagr_id_flex_num is not null -- bug 2359997
11350: then
11351: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
11352: --
11353: hr_cgd_upd.upd_or_sel
11354: (p_segment1 => l_cag_segment1
11355: ,p_segment2 => l_cag_segment2

Line 12415: per_asg_shd.lck

12411: l_cagr_id_flex_num := p_cagr_id_flex_num;
12412: --
12413: If (p_cagr_id_flex_num = hr_api.g_number) THEN
12414: --
12415: per_asg_shd.lck
12416: (p_effective_date => l_effective_date,
12417: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
12418: p_datetrack_mode => p_datetrack_update_mode,
12419: p_assignment_id => p_assignment_id,

Line 12425: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;

12421: p_validation_start_date => l_unused_start_date,
12422: p_validation_end_date => l_unused_end_date
12423: );
12424: --
12425: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
12426: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
12427: --
12428: End if;
12429: --

Line 12426: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;

12422: p_validation_end_date => l_unused_end_date
12423: );
12424: --
12425: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
12426: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
12427: --
12428: End if;
12429: --
12430: hr_cgd_upd.upd_or_sel

Line 13063: l_api_updating := per_asg_shd.api_updating

13059: -- Validation in addition to Table Handlers
13060: --
13061: -- Retrieve current assignment details from database.
13062: --
13063: l_api_updating := per_asg_shd.api_updating
13064: (p_assignment_id => p_assignment_id
13065: ,p_effective_date => l_effective_date
13066: ,p_object_version_number => l_object_version_number);
13067: --

Line 13089: l_people_group_id := per_asg_shd.g_old_rec.people_group_id;

13085: if g_debug then
13086: hr_utility.set_location(l_proc, 40);
13087: end if;
13088: --
13089: l_people_group_id := per_asg_shd.g_old_rec.people_group_id;
13090: --
13091: END IF;
13092: --
13093: if g_debug then

Line 13099: IF per_asg_shd.g_old_rec.assignment_type <> 'C' THEN

13095: end if;
13096: --
13097: -- Check that the assignment is an employee assignment.
13098: --
13099: IF per_asg_shd.g_old_rec.assignment_type <> 'C' THEN
13100: --
13101: if g_debug then
13102: hr_utility.set_location(l_proc, 60);
13103: end if;

Line 13118: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;

13114: -- Process Logic
13115: --
13116: -- Populate l_business_group_id from g_old_rec for cursor csr_grp_idsel
13117: --
13118: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;
13119: --
13120: -- Start of bug fix 3553286
13121: -- This procedure will return the job_id and organization_id of a position
13122: --

Line 13136: l_organization_id:=per_asg_shd.g_old_rec.organization_id;

13132: --
13133: --
13134: IF (l_org_id = hr_api.g_number) THEN -- Bug 3553286
13135: --
13136: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
13137: --
13138: ELSE
13139: --
13140: l_organization_id := l_org_id; -- Bug 3553286

Line 13146: l_location_id:=per_asg_shd.g_old_rec.location_id;

13142: END IF;
13143: --
13144: IF (p_location_id=hr_api.g_number) THEN
13145: --
13146: l_location_id:=per_asg_shd.g_old_rec.location_id;
13147: --
13148: ELSE
13149: --
13150: l_location_id:=p_location_id;

Line 13320: IF (per_asg_shd.g_old_rec.organization_id = l_business_group_id AND

13316: --
13317: IF l_effective_date BETWEEN l_sec_effective_start_date AND
13318: l_sec_effective_end_date THEN
13319: --
13320: IF (per_asg_shd.g_old_rec.organization_id = l_business_group_id AND
13321: l_org_id <> l_business_group_id) THEN -- Bug 3553286
13322: --
13323: hr_security_internal.clear_from_person_list
13324: (per_asg_shd.g_old_rec.person_id);

Line 13324: (per_asg_shd.g_old_rec.person_id);

13320: IF (per_asg_shd.g_old_rec.organization_id = l_business_group_id AND
13321: l_org_id <> l_business_group_id) THEN -- Bug 3553286
13322: --
13323: hr_security_internal.clear_from_person_list
13324: (per_asg_shd.g_old_rec.person_id);
13325: --
13326: END IF;
13327: --
13328: hr_security_internal.add_to_person_list(l_effective_date,p_assignment_id);

Line 13350: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))

13346: /*
13347: IF (p_pay_basis_id <> hr_api.g_number or
13348: p_pay_basis_id is null ) and
13349: (nvl(p_pay_basis_id,hr_api.g_number) <>
13350: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
13351: then
13352: open csr_get_salary;
13353: fetch csr_get_salary into l_element_entry_id;
13354: if csr_get_salary%found then

Line 13383: l_new_payroll_id := per_asg_shd.g_old_rec.payroll_id;

13379: if g_debug then
13380: hr_utility.set_location(l_proc, 150);
13381: end if;
13382: --
13383: l_new_payroll_id := per_asg_shd.g_old_rec.payroll_id;
13384: else
13385: --
13386: if g_debug then
13387: hr_utility.set_location(l_proc, 160);

Line 13399: ,p_old_payroll_id => per_asg_shd.g_old_rec.payroll_id

13395: end if;
13396: --
13397: hrentmnt.maintain_entries_asg
13398: (p_assignment_id => p_assignment_id
13399: ,p_old_payroll_id => per_asg_shd.g_old_rec.payroll_id
13400: ,p_new_payroll_id => l_new_payroll_id
13401: ,p_business_group_id => l_business_group_id
13402: ,p_operation => 'ASG_CRITERIA'
13403: ,p_actual_term_date => null

Line 13425: IF (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND

13421: */
13422: --
13423: -- Bug 3545065, Grade should not be maintained for CWK asg
13424: /*
13425: IF (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
13426: p_grade_id IS NULL) OR
13427: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
13428: p_grade_id IS NOT NULL AND
13429: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND

Line 13427: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND

13423: -- Bug 3545065, Grade should not be maintained for CWK asg
13424: /*
13425: IF (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
13426: p_grade_id IS NULL) OR
13427: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
13428: p_grade_id IS NOT NULL AND
13429: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
13430: p_grade_id <> hr_api.g_number) THEN
13431: --

Line 13429: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND

13425: IF (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
13426: p_grade_id IS NULL) OR
13427: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
13428: p_grade_id IS NOT NULL AND
13429: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
13430: p_grade_id <> hr_api.g_number) THEN
13431: --
13432: if g_debug then
13433: hr_utility.set_location(l_proc, 190);

Line 16281: l_api_updating := per_asg_shd.api_updating

16277: -- Validation in addition to Table Handlers
16278: --
16279: -- Retrieve current assignment details from database.
16280: --
16281: l_api_updating := per_asg_shd.api_updating
16282: (p_assignment_id => p_assignment_id
16283: ,p_effective_date => l_effective_date
16284: ,p_object_version_number => l_object_version_number);
16285: --

Line 16307: -- l_people_group_id := per_asg_shd.g_old_rec.people_group_id; bug 2359997

16303: if g_debug then
16304: hr_utility.set_location(l_proc, 100);
16305: end if;
16306: --
16307: -- l_people_group_id := per_asg_shd.g_old_rec.people_group_id; bug 2359997
16308: end if;
16309: --
16310: if g_debug then
16311: hr_utility.set_location(l_proc, 110);

Line 16316: if per_asg_shd.g_old_rec.assignment_type <> 'E'

16312: end if;
16313: --
16314: -- Check that the assignment is an employee assignment.
16315: --
16316: if per_asg_shd.g_old_rec.assignment_type <> 'E'
16317: then
16318: --
16319: if g_debug then
16320: hr_utility.set_location(l_proc, 120);

Line 16340: -- if per_asg_shd.g_old_rec.grade_id <> p_grade_id

16336: --
16337: -- Set special_ceiling_step_id to null if grade_id is being changed or is
16338: -- null.
16339: --
16340: -- if per_asg_shd.g_old_rec.grade_id <> p_grade_id
16341: -- or p_grade_id is null
16342: -- then
16343: -- --
16344: -- --

Line 16352: -- l_special_ceiling_step_id := per_asg_shd.g_old_rec.special_ceiling_step_id;

16348: -- --
16349: -- if p_special_ceiling_step_id = hr_api.g_number then
16350: -- --
16351: -- --
16352: -- l_special_ceiling_step_id := per_asg_shd.g_old_rec.special_ceiling_step_id;
16353: -- else
16354: -- --
16355: -- --
16356: -- l_special_ceiling_step_id := p_special_ceiling_step_id;

Line 16376: if (per_asg_shd.g_old_rec.grade_id <> p_grade_id AND

16372: -- allow updation of p_ceiling_step_id even though
16373: -- the grade is assigned to assignment but not passed
16374: -- to api.
16375: --
16376: if (per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
16377: p_grade_id <> hr_api.g_number AND -- 3485599
16378: p_special_ceiling_step_id IS NOT NULL) then
16379: --
16380: if g_debug then

Line 16438: l_special_ceiling_step_id := per_asg_shd.g_old_rec.special_ceiling_step_id;

16434: if g_debug then
16435: hr_utility.set_location(l_proc, 190);
16436: end if;
16437: --
16438: l_special_ceiling_step_id := per_asg_shd.g_old_rec.special_ceiling_step_id;
16439: --
16440: else
16441: --
16442: if g_debug then

Line 16457: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;

16453: end if;
16454: --
16455: -- Populate l_business_group_id from g_old_rec for cursor csr_grp_idsel
16456: --
16457: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;
16458: --
16459: -- Start of bug fix 3553286
16460: -- This procedure will return the job_id and organization_id of a position
16461: --

Line 16474: l_organization_id:=per_asg_shd.g_old_rec.organization_id;

16470: -- validation to work
16471: --
16472: --
16473: if (l_org_id = hr_api.g_number) then -- Bug 3553286
16474: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
16475: else
16476: l_organization_id:= l_org_id; -- Bug 3553286
16477: end if;
16478: --

Line 16480: l_location_id:=per_asg_shd.g_old_rec.location_id;

16476: l_organization_id:= l_org_id; -- Bug 3553286
16477: end if;
16478: --
16479: if (p_location_id=hr_api.g_number) then
16480: l_location_id:=per_asg_shd.g_old_rec.location_id;
16481: else
16482: l_location_id:=p_location_id;
16483: end if;
16484: --

Line 16538: l_people_group_id := nvl(l_people_group_id,per_asg_shd.g_old_rec.people_group_id);

16534: open csr_get_people_group_id;
16535: fetch csr_get_people_group_id into l_people_group_id;
16536: close csr_get_people_group_id;
16537:
16538: l_people_group_id := nvl(l_people_group_id,per_asg_shd.g_old_rec.people_group_id);
16539:
16540: -- End of changes for bug#12874349
16541: --
16542: --l_people_group_id := per_asg_shd.g_old_rec.people_group_id;

Line 16542: --l_people_group_id := per_asg_shd.g_old_rec.people_group_id;

16538: l_people_group_id := nvl(l_people_group_id,per_asg_shd.g_old_rec.people_group_id);
16539:
16540: -- End of changes for bug#12874349
16541: --
16542: --l_people_group_id := per_asg_shd.g_old_rec.people_group_id;
16543:
16544: -- 4103321 modified the if statement
16545:
16546: if l_people_group_id is not null then

Line 16737: if (per_asg_shd.g_old_rec.organization_id = l_business_group_id

16733: close get_sec_date_range;
16734: --
16735: if l_effective_date between l_sec_effective_start_date
16736: and l_sec_effective_end_date then
16737: if (per_asg_shd.g_old_rec.organization_id = l_business_group_id
16738: and l_org_id <> l_business_group_id) then -- Bug 3553286
16739: hr_security_internal.clear_from_person_list
16740: (per_asg_shd.g_old_rec.person_id);
16741: end if;

Line 16740: (per_asg_shd.g_old_rec.person_id);

16736: and l_sec_effective_end_date then
16737: if (per_asg_shd.g_old_rec.organization_id = l_business_group_id
16738: and l_org_id <> l_business_group_id) then -- Bug 3553286
16739: hr_security_internal.clear_from_person_list
16740: (per_asg_shd.g_old_rec.person_id);
16741: end if;
16742: hr_security_internal.add_to_person_list(l_effective_date,p_assignment_id);
16743: end if;
16744: --

Line 16757: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))

16753: --
16754: if (p_pay_basis_id <> hr_api.g_number or
16755: p_pay_basis_id is null ) and
16756: (nvl(p_pay_basis_id,hr_api.g_number) <>
16757: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
16758: then
16759: -- start of bug fix 4464072
16760: -- commented out the following part and newly defined
16761:

Line 16976: l_new_payroll_id := per_asg_shd.g_old_rec.payroll_id;

16972: if g_debug then
16973: hr_utility.set_location(l_proc, 300);
16974: end if;
16975: --
16976: l_new_payroll_id := per_asg_shd.g_old_rec.payroll_id;
16977: else
16978: --
16979: if g_debug then
16980: hr_utility.set_location(l_proc, 310);

Line 16990: hr_utility.set_location('p_old_pg_id :'||to_char(per_asg_shd.g_old_rec.payroll_id),325);

16986: if g_debug then
16987: hr_utility.set_location(l_proc, 320);
16988: end if;
16989: --
16990: hr_utility.set_location('p_old_pg_id :'||to_char(per_asg_shd.g_old_rec.payroll_id),325);
16991: hr_utility.set_location('p_new_pg_id :'||to_char(l_people_group_id),325);
16992: --
16993: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_grade_id:' || p_grade_id,11); -- Bug#13960540
16994: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_s_grd_id:' || per_asg_shd.g_old_rec.grade_id,11);

Line 16994: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_s_grd_id:' || per_asg_shd.g_old_rec.grade_id,11);

16990: hr_utility.set_location('p_old_pg_id :'||to_char(per_asg_shd.g_old_rec.payroll_id),325);
16991: hr_utility.set_location('p_new_pg_id :'||to_char(l_people_group_id),325);
16992: --
16993: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_grade_id:' || p_grade_id,11); -- Bug#13960540
16994: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_s_grd_id:' || per_asg_shd.g_old_rec.grade_id,11);
16995: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_old_org_id:' || per_asg_shd.g_old_rec.organization_id,11);
16996: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_new_org_id:' || l_organization_id,11);
16997: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_old_emp_cat:' || per_asg_shd.g_old_rec.employment_category,11);
16998: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_new_emp_cat:' || p_employment_category,11); -- Bug#13960540

Line 16995: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_old_org_id:' || per_asg_shd.g_old_rec.organization_id,11);

16991: hr_utility.set_location('p_new_pg_id :'||to_char(l_people_group_id),325);
16992: --
16993: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_grade_id:' || p_grade_id,11); -- Bug#13960540
16994: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_s_grd_id:' || per_asg_shd.g_old_rec.grade_id,11);
16995: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_old_org_id:' || per_asg_shd.g_old_rec.organization_id,11);
16996: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_new_org_id:' || l_organization_id,11);
16997: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_old_emp_cat:' || per_asg_shd.g_old_rec.employment_category,11);
16998: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_new_emp_cat:' || p_employment_category,11); -- Bug#13960540
16999:

Line 16997: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_old_emp_cat:' || per_asg_shd.g_old_rec.employment_category,11);

16993: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_grade_id:' || p_grade_id,11); -- Bug#13960540
16994: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_s_grd_id:' || per_asg_shd.g_old_rec.grade_id,11);
16995: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_old_org_id:' || per_asg_shd.g_old_rec.organization_id,11);
16996: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_new_org_id:' || l_organization_id,11);
16997: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_old_emp_cat:' || per_asg_shd.g_old_rec.employment_category,11);
16998: hr_utility.set_location('peasgapi.pkb.hrentmnt.maintain_entries_asg..p_new_emp_cat:' || p_employment_category,11); -- Bug#13960540
16999:
17000: --
17001: hrentmnt.maintain_entries_asg

Line 17003: ,p_old_payroll_id => per_asg_shd.g_old_rec.payroll_id

16999:
17000: --
17001: hrentmnt.maintain_entries_asg
17002: (p_assignment_id => p_assignment_id
17003: ,p_old_payroll_id => per_asg_shd.g_old_rec.payroll_id
17004: ,p_new_payroll_id => l_new_payroll_id
17005: ,p_business_group_id => l_business_group_id
17006: ,p_operation => 'ASG_CRITERIA'
17007: ,p_actual_term_date => null

Line 17014: ,p_old_people_group_id => per_asg_shd.g_old_rec.people_group_id

17010: ,p_dt_mode => l_new_dt_update_mode
17011: ,p_validation_start_date => l_validation_start_date
17012: ,p_validation_end_date => l_validation_end_date
17013: ,p_entries_changed => l_entries_changed
17014: ,p_old_people_group_id => per_asg_shd.g_old_rec.people_group_id
17015: ,p_new_people_group_id => l_people_group_id
17016: ,p_old_grade_id => per_asg_shd.g_old_rec.grade_id -- Added for Bug#13960540
17017: ,p_new_grade_id => p_grade_id -- Added for Bug#13960540
17018: ,p_old_organization_id => per_asg_shd.g_old_rec.organization_id -- Added for Bug#13960540

Line 17016: ,p_old_grade_id => per_asg_shd.g_old_rec.grade_id -- Added for Bug#13960540

17012: ,p_validation_end_date => l_validation_end_date
17013: ,p_entries_changed => l_entries_changed
17014: ,p_old_people_group_id => per_asg_shd.g_old_rec.people_group_id
17015: ,p_new_people_group_id => l_people_group_id
17016: ,p_old_grade_id => per_asg_shd.g_old_rec.grade_id -- Added for Bug#13960540
17017: ,p_new_grade_id => p_grade_id -- Added for Bug#13960540
17018: ,p_old_organization_id => per_asg_shd.g_old_rec.organization_id -- Added for Bug#13960540
17019: ,p_new_organization_id => l_organization_id -- Added for Bug#13960540
17020: ,p_old_employment_category => per_asg_shd.g_old_rec.employment_category -- Added for Bug#13960540

Line 17018: ,p_old_organization_id => per_asg_shd.g_old_rec.organization_id -- Added for Bug#13960540

17014: ,p_old_people_group_id => per_asg_shd.g_old_rec.people_group_id
17015: ,p_new_people_group_id => l_people_group_id
17016: ,p_old_grade_id => per_asg_shd.g_old_rec.grade_id -- Added for Bug#13960540
17017: ,p_new_grade_id => p_grade_id -- Added for Bug#13960540
17018: ,p_old_organization_id => per_asg_shd.g_old_rec.organization_id -- Added for Bug#13960540
17019: ,p_new_organization_id => l_organization_id -- Added for Bug#13960540
17020: ,p_old_employment_category => per_asg_shd.g_old_rec.employment_category -- Added for Bug#13960540
17021: ,p_new_employment_category => p_employment_category -- Added for Bug#13960540
17022: );

Line 17020: ,p_old_employment_category => per_asg_shd.g_old_rec.employment_category -- Added for Bug#13960540

17016: ,p_old_grade_id => per_asg_shd.g_old_rec.grade_id -- Added for Bug#13960540
17017: ,p_new_grade_id => p_grade_id -- Added for Bug#13960540
17018: ,p_old_organization_id => per_asg_shd.g_old_rec.organization_id -- Added for Bug#13960540
17019: ,p_new_organization_id => l_organization_id -- Added for Bug#13960540
17020: ,p_old_employment_category => per_asg_shd.g_old_rec.employment_category -- Added for Bug#13960540
17021: ,p_new_employment_category => p_employment_category -- Added for Bug#13960540
17022: );
17023: --
17024: -- Bug 630826 fix ends

Line 17049: IF ( per_asg_shd.g_old_rec.grade_id is not null

17045: if l_entries_changed_warning <> 'S' then
17046: l_entries_changed_warning := nvl(l_entries_changed, 'N');
17047: end if;
17048: --
17049: IF ( per_asg_shd.g_old_rec.grade_id is not null
17050: AND p_grade_id is null)
17051: OR ( per_asg_shd.g_old_rec.grade_id is not null
17052: AND p_grade_id is not null
17053: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id

Line 17051: OR ( per_asg_shd.g_old_rec.grade_id is not null

17047: end if;
17048: --
17049: IF ( per_asg_shd.g_old_rec.grade_id is not null
17050: AND p_grade_id is null)
17051: OR ( per_asg_shd.g_old_rec.grade_id is not null
17052: AND p_grade_id is not null
17053: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id
17054: AND p_grade_id <> hr_api.g_number)
17055: then

Line 17053: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id

17049: IF ( per_asg_shd.g_old_rec.grade_id is not null
17050: AND p_grade_id is null)
17051: OR ( per_asg_shd.g_old_rec.grade_id is not null
17052: AND p_grade_id is not null
17053: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id
17054: AND p_grade_id <> hr_api.g_number)
17055: then
17056: --
17057: if g_debug then

Line 17910: l_api_updating := per_asg_shd.api_updating

17906: ,p_argument_value => l_object_version_number);
17907: --
17908: -- Retrieve current assignment details from database.
17909: --
17910: l_api_updating := per_asg_shd.api_updating
17911: (p_assignment_id => p_assignment_id
17912: ,p_effective_date => l_effective_date
17913: ,p_object_version_number => l_object_version_number);
17914: --

Line 17940: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;

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;
17941: --
17942: if g_debug then
17943: hr_utility.set_location(l_proc, 45);
17944: end if;

Line 17949: l_people_group_id := per_asg_shd.g_old_rec.people_group_id;

17945: --
17946: if l_people_group_id is null
17947: then
17948: --
17949: l_people_group_id := per_asg_shd.g_old_rec.people_group_id;
17950: l_pgp_null_ind := 0;
17951: else
17952: -- get segment values
17953: open c_pgp_segments;

Line 18065: if per_asg_shd.g_old_rec.assignment_type <> 'A'

18061: end if;
18062: --
18063: -- Check that the assignment is an applicant assignment.
18064: --
18065: if per_asg_shd.g_old_rec.assignment_type <> 'A'
18066: then
18067: --
18068: if g_debug then
18069: hr_utility.set_location(l_proc, 70);

Line 18290: l_organization_id:=per_asg_shd.g_old_rec.organization_id;

18286: -- insert the profile options and effective date for the flexfield
18287: -- validation to work
18288: --
18289: if (p_organization_id=hr_api.g_number) then
18290: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
18291: else
18292: l_organization_id:=p_organization_id;
18293: end if;
18294: --

Line 18296: l_location_id:=per_asg_shd.g_old_rec.location_id;

18292: l_organization_id:=p_organization_id;
18293: end if;
18294: --
18295: if (p_location_id=hr_api.g_number) then
18296: l_location_id:=per_asg_shd.g_old_rec.location_id;
18297: else
18298: l_location_id:=p_location_id;
18299: end if;
18300: --

Line 18537: per_asg_shd.lck

18533: --
18534: l_cagr_id_flex_num := p_cagr_id_flex_num;
18535: --
18536: if (p_cagr_id_flex_num = hr_api.g_number) THEN
18537: per_asg_shd.lck
18538: (p_effective_date => l_effective_date,
18539: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
18540: p_datetrack_mode => p_datetrack_update_mode,
18541: p_assignment_id => p_assignment_id,

Line 18546: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;

18542: p_object_version_number => p_object_version_number,
18543: p_validation_start_date => l_unused_start_date,
18544: p_validation_end_date => l_unused_end_date
18545: );
18546: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
18547: --l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
18548: end if;
18549: --
18550: if l_cag_null_ind = 0

Line 18547: --l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;

18543: p_validation_start_date => l_unused_start_date,
18544: p_validation_end_date => l_unused_end_date
18545: );
18546: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
18547: --l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
18548: end if;
18549: --
18550: if l_cag_null_ind = 0
18551: then

Line 18552: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;

18548: end if;
18549: --
18550: if l_cag_null_ind = 0
18551: then
18552: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
18553: --
18554: hr_cgd_upd.upd_or_sel
18555: (p_segment1 => l_cag_segment1
18556: ,p_segment2 => l_cag_segment2

Line 18576: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id

18572: ,p_segment18 => l_cag_segment18
18573: ,p_segment19 => l_cag_segment19
18574: ,p_segment20 => l_cag_segment20
18575: ,p_id_flex_num => l_cagr_id_flex_num
18576: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
18577: ,p_cagr_grade_def_id => l_cagr_grade_def_id
18578: ,p_concatenated_segments => l_cagr_concatenated_segments
18579: );
18580: --

Line 18698: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id AND

18694: );
18695: --
18696: -- ***** Start new code for bug 2276928 **************
18697: -- modified the below if condition for bug 7657734
18698: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id AND
18699: p_assignment_status_type_id<>hr_api.g_number)
18700: -- modified for bug 9496344
18701: OR ( ( p_change_reason is null OR (p_change_reason <> hr_api.g_varchar2)) AND
18702: ( nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>

Line 18702: ( nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>

18698: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id AND
18699: p_assignment_status_type_id<>hr_api.g_number)
18700: -- modified for bug 9496344
18701: OR ( ( p_change_reason is null OR (p_change_reason <> hr_api.g_varchar2)) AND
18702: ( nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
18703: nvl(p_change_reason, hr_api.g_varchar2))) THEN
18704: -- end of 9496344
18705: --12427559
18706:

Line 18708: l_asg_status_type_id := per_asg_shd.g_old_rec.assignment_status_type_id;

18704: -- end of 9496344
18705: --12427559
18706:
18707: if p_assignment_status_type_id = hr_api.g_number or p_assignment_status_type_id is null then
18708: l_asg_status_type_id := per_asg_shd.g_old_rec.assignment_status_type_id;
18709:
18710: else
18711:
18712: l_asg_status_type_id := p_assignment_status_type_id;

Line 18730: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id

18726: -- When the vacancy is changes, move the letter request line to a letter request
18727: -- with that vacancy.
18728: -- When the assignemnt status is changed, create new letter request lines.
18729: --
18730: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id
18731: AND p_assignment_status_type_id<>hr_api.g_number
18732: )
18733: OR
18734: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND

Line 18734: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND

18730: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id
18731: AND p_assignment_status_type_id<>hr_api.g_number
18732: )
18733: OR
18734: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
18735: nvl(p_vacancy_id,-1) <> hr_api.g_number
18736: ) THEN
18737: --
18738: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND

Line 18738: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND

18734: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
18735: nvl(p_vacancy_id,-1) <> hr_api.g_number
18736: ) THEN
18737: --
18738: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
18739: nvl(p_vacancy_id,-1) <> hr_api.g_number ) THEN
18740: --
18741: delete from per_letter_request_lines plrl
18742: where plrl.assignment_id = p_assignment_id

Line 18771: ,p_person_id => per_asg_shd.g_old_rec.person_id

18767: per_applicant_pkg.check_for_letter_requests
18768: (p_business_group_id => l_business_group_id
18769: ,p_per_system_status => null
18770: ,p_assignment_status_type_id => p_assignment_status_type_id
18771: ,p_person_id => per_asg_shd.g_old_rec.person_id
18772: ,p_assignment_id => p_assignment_id
18773: ,p_effective_start_date => l_effective_start_date
18774: ,p_validation_start_date => l_effective_start_date
18775: ,p_vacancy_id => p_vacancy_id

Line 18793: if(per_asg_shd.g_old_rec.organization_id = l_business_group_id

18789: --
18790: if l_effective_date between l_sec_effective_start_date
18791: and l_sec_effective_end_date
18792: then
18793: if(per_asg_shd.g_old_rec.organization_id = l_business_group_id
18794: and p_organization_id <> l_business_group_id)
18795: then
18796: hr_security_internal.clear_from_person_list
18797: (per_asg_shd.g_old_rec.person_id);

Line 18797: (per_asg_shd.g_old_rec.person_id);

18793: if(per_asg_shd.g_old_rec.organization_id = l_business_group_id
18794: and p_organization_id <> l_business_group_id)
18795: then
18796: hr_security_internal.clear_from_person_list
18797: (per_asg_shd.g_old_rec.person_id);
18798: end if;
18799: --fix for bug 5938120 starts here
18800: open csr_get_assign(per_asg_shd.g_old_rec.person_id);
18801: LOOP

Line 18800: open csr_get_assign(per_asg_shd.g_old_rec.person_id);

18796: hr_security_internal.clear_from_person_list
18797: (per_asg_shd.g_old_rec.person_id);
18798: end if;
18799: --fix for bug 5938120 starts here
18800: open csr_get_assign(per_asg_shd.g_old_rec.person_id);
18801: LOOP
18802: fetch csr_get_assign into l_assignment_id;
18803: exit when csr_get_assign%NOTFOUND;
18804: hr_security_internal.add_to_person_list(l_effective_date,l_assignment_id);