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 352: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,

348:
349: -- now update the assignments table
350: -- we must lock the row before we update it
351:
352: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,
353: p_datetrack_mode => 'CORRECTION',
354: p_assignment_id =>p_assignment_id,
355: p_object_version_number =>l_ovn,
356: p_validation_start_date =>l_validation_start_date,

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

471:
472: -- now update the assignments table
473: -- we must lock the row before we update it
474:
475: per_asg_shd.lck (p_effective_date =>l_asg_end_date ,
476: p_datetrack_mode => 'CORRECTION',
477: p_assignment_id =>p_assignment_id,
478: p_object_version_number =>l_ovn,
479: p_validation_start_date =>l_validation_start_date,

Line 10753: per_asg_shd.lck

10749: l_cagr_id_flex_num := p_cagr_id_flex_num;
10750: --
10751: if (p_cagr_id_flex_num = hr_api.g_number)
10752: then
10753: per_asg_shd.lck
10754: (p_effective_date => l_effective_date,
10755: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
10756: p_datetrack_mode => p_datetrack_update_mode,
10757: p_assignment_id => p_assignment_id,

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

10758: p_object_version_number => p_object_version_number,
10759: p_validation_start_date => l_unused_start_date,
10760: p_validation_end_date => l_unused_end_date
10761: );
10762: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
10763: -- l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
10764: -- commented out for bug 2359997
10765: end if;
10766: --

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

10759: p_validation_start_date => l_unused_start_date,
10760: p_validation_end_date => l_unused_end_date
10761: );
10762: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
10763: -- l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
10764: -- commented out for bug 2359997
10765: end if;
10766: --
10767: --

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

10767: --
10768: -- Bug 4003788 added the check for the cagr_id_flex_num also
10769: if l_cag_null_ind = 0 and l_cagr_id_flex_num is not null -- bug 2359997
10770: then
10771: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
10772: --
10773: hr_cgd_upd.upd_or_sel
10774: (p_segment1 => l_cag_segment1
10775: ,p_segment2 => l_cag_segment2

Line 11814: per_asg_shd.lck

11810: l_cagr_id_flex_num := p_cagr_id_flex_num;
11811: --
11812: If (p_cagr_id_flex_num = hr_api.g_number) THEN
11813: --
11814: per_asg_shd.lck
11815: (p_effective_date => l_effective_date,
11816: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
11817: p_datetrack_mode => p_datetrack_update_mode,
11818: p_assignment_id => p_assignment_id,

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

11820: p_validation_start_date => l_unused_start_date,
11821: p_validation_end_date => l_unused_end_date
11822: );
11823: --
11824: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
11825: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
11826: --
11827: End if;
11828: --

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

11821: p_validation_end_date => l_unused_end_date
11822: );
11823: --
11824: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
11825: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
11826: --
11827: End if;
11828: --
11829: hr_cgd_upd.upd_or_sel

Line 12462: l_api_updating := per_asg_shd.api_updating

12458: -- Validation in addition to Table Handlers
12459: --
12460: -- Retrieve current assignment details from database.
12461: --
12462: l_api_updating := per_asg_shd.api_updating
12463: (p_assignment_id => p_assignment_id
12464: ,p_effective_date => l_effective_date
12465: ,p_object_version_number => l_object_version_number);
12466: --

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

12484: if g_debug then
12485: hr_utility.set_location(l_proc, 40);
12486: end if;
12487: --
12488: l_people_group_id := per_asg_shd.g_old_rec.people_group_id;
12489: --
12490: END IF;
12491: --
12492: if g_debug then

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

12494: end if;
12495: --
12496: -- Check that the assignment is an employee assignment.
12497: --
12498: IF per_asg_shd.g_old_rec.assignment_type <> 'C' THEN
12499: --
12500: if g_debug then
12501: hr_utility.set_location(l_proc, 60);
12502: end if;

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

12513: -- Process Logic
12514: --
12515: -- Populate l_business_group_id from g_old_rec for cursor csr_grp_idsel
12516: --
12517: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;
12518: --
12519: -- Start of bug fix 3553286
12520: -- This procedure will return the job_id and organization_id of a position
12521: --

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

12531: --
12532: --
12533: IF (l_org_id = hr_api.g_number) THEN -- Bug 3553286
12534: --
12535: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
12536: --
12537: ELSE
12538: --
12539: l_organization_id := l_org_id; -- Bug 3553286

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

12541: END IF;
12542: --
12543: IF (p_location_id=hr_api.g_number) THEN
12544: --
12545: l_location_id:=per_asg_shd.g_old_rec.location_id;
12546: --
12547: ELSE
12548: --
12549: l_location_id:=p_location_id;

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

12715: --
12716: IF l_effective_date BETWEEN l_sec_effective_start_date AND
12717: l_sec_effective_end_date THEN
12718: --
12719: IF (per_asg_shd.g_old_rec.organization_id = l_business_group_id AND
12720: l_org_id <> l_business_group_id) THEN -- Bug 3553286
12721: --
12722: hr_security_internal.clear_from_person_list
12723: (per_asg_shd.g_old_rec.person_id);

Line 12723: (per_asg_shd.g_old_rec.person_id);

12719: IF (per_asg_shd.g_old_rec.organization_id = l_business_group_id AND
12720: l_org_id <> l_business_group_id) THEN -- Bug 3553286
12721: --
12722: hr_security_internal.clear_from_person_list
12723: (per_asg_shd.g_old_rec.person_id);
12724: --
12725: END IF;
12726: --
12727: hr_security_internal.add_to_person_list(l_effective_date,p_assignment_id);

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

12745: /*
12746: IF (p_pay_basis_id <> hr_api.g_number or
12747: p_pay_basis_id is null ) and
12748: (nvl(p_pay_basis_id,hr_api.g_number) <>
12749: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
12750: then
12751: open csr_get_salary;
12752: fetch csr_get_salary into l_element_entry_id;
12753: if csr_get_salary%found then

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

12778: if g_debug then
12779: hr_utility.set_location(l_proc, 150);
12780: end if;
12781: --
12782: l_new_payroll_id := per_asg_shd.g_old_rec.payroll_id;
12783: else
12784: --
12785: if g_debug then
12786: hr_utility.set_location(l_proc, 160);

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

12794: end if;
12795: --
12796: hrentmnt.maintain_entries_asg
12797: (p_assignment_id => p_assignment_id
12798: ,p_old_payroll_id => per_asg_shd.g_old_rec.payroll_id
12799: ,p_new_payroll_id => l_new_payroll_id
12800: ,p_business_group_id => l_business_group_id
12801: ,p_operation => 'ASG_CRITERIA'
12802: ,p_actual_term_date => null

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

12820: */
12821: --
12822: -- Bug 3545065, Grade should not be maintained for CWK asg
12823: /*
12824: IF (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
12825: p_grade_id IS NULL) OR
12826: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
12827: p_grade_id IS NOT NULL AND
12828: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND

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

12822: -- Bug 3545065, Grade should not be maintained for CWK asg
12823: /*
12824: IF (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
12825: p_grade_id IS NULL) OR
12826: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
12827: p_grade_id IS NOT NULL AND
12828: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
12829: p_grade_id <> hr_api.g_number) THEN
12830: --

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

12824: IF (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
12825: p_grade_id IS NULL) OR
12826: (per_asg_shd.g_old_rec.grade_id IS NOT NULL AND
12827: p_grade_id IS NOT NULL AND
12828: per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
12829: p_grade_id <> hr_api.g_number) THEN
12830: --
12831: if g_debug then
12832: hr_utility.set_location(l_proc, 190);

Line 15624: l_api_updating := per_asg_shd.api_updating

15620: -- Validation in addition to Table Handlers
15621: --
15622: -- Retrieve current assignment details from database.
15623: --
15624: l_api_updating := per_asg_shd.api_updating
15625: (p_assignment_id => p_assignment_id
15626: ,p_effective_date => l_effective_date
15627: ,p_object_version_number => l_object_version_number);
15628: --

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

15646: if g_debug then
15647: hr_utility.set_location(l_proc, 100);
15648: end if;
15649: --
15650: -- l_people_group_id := per_asg_shd.g_old_rec.people_group_id; bug 2359997
15651: end if;
15652: --
15653: if g_debug then
15654: hr_utility.set_location(l_proc, 110);

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

15655: end if;
15656: --
15657: -- Check that the assignment is an employee assignment.
15658: --
15659: if per_asg_shd.g_old_rec.assignment_type <> 'E'
15660: then
15661: --
15662: if g_debug then
15663: hr_utility.set_location(l_proc, 120);

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

15679: --
15680: -- Set special_ceiling_step_id to null if grade_id is being changed or is
15681: -- null.
15682: --
15683: -- if per_asg_shd.g_old_rec.grade_id <> p_grade_id
15684: -- or p_grade_id is null
15685: -- then
15686: -- --
15687: -- --

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

15691: -- --
15692: -- if p_special_ceiling_step_id = hr_api.g_number then
15693: -- --
15694: -- --
15695: -- l_special_ceiling_step_id := per_asg_shd.g_old_rec.special_ceiling_step_id;
15696: -- else
15697: -- --
15698: -- --
15699: -- l_special_ceiling_step_id := p_special_ceiling_step_id;

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

15715: -- allow updation of p_ceiling_step_id even though
15716: -- the grade is assigned to assignment but not passed
15717: -- to api.
15718: --
15719: if (per_asg_shd.g_old_rec.grade_id <> p_grade_id AND
15720: p_grade_id <> hr_api.g_number AND -- 3485599
15721: p_special_ceiling_step_id IS NOT NULL) then
15722: --
15723: if g_debug then

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

15777: if g_debug then
15778: hr_utility.set_location(l_proc, 190);
15779: end if;
15780: --
15781: l_special_ceiling_step_id := per_asg_shd.g_old_rec.special_ceiling_step_id;
15782: --
15783: else
15784: --
15785: if g_debug then

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

15796: end if;
15797: --
15798: -- Populate l_business_group_id from g_old_rec for cursor csr_grp_idsel
15799: --
15800: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;
15801: --
15802: -- Start of bug fix 3553286
15803: -- This procedure will return the job_id and organization_id of a position
15804: --

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

15813: -- validation to work
15814: --
15815: --
15816: if (l_org_id = hr_api.g_number) then -- Bug 3553286
15817: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
15818: else
15819: l_organization_id:= l_org_id; -- Bug 3553286
15820: end if;
15821: --

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

15819: l_organization_id:= l_org_id; -- Bug 3553286
15820: end if;
15821: --
15822: if (p_location_id=hr_api.g_number) then
15823: l_location_id:=per_asg_shd.g_old_rec.location_id;
15824: else
15825: l_location_id:=p_location_id;
15826: end if;
15827: --

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

15871: --
15872: if l_pgp_null_ind = 0 -- bug 2359997
15873: then
15874: --
15875: l_people_group_id := per_asg_shd.g_old_rec.people_group_id;
15876: -- 4103321 modified the if statement
15877:
15878: if l_people_group_id is not null then
15879: open c_pgp_segments;

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

16065: close get_sec_date_range;
16066: --
16067: if l_effective_date between l_sec_effective_start_date
16068: and l_sec_effective_end_date then
16069: if (per_asg_shd.g_old_rec.organization_id = l_business_group_id
16070: and l_org_id <> l_business_group_id) then -- Bug 3553286
16071: hr_security_internal.clear_from_person_list
16072: (per_asg_shd.g_old_rec.person_id);
16073: end if;

Line 16072: (per_asg_shd.g_old_rec.person_id);

16068: and l_sec_effective_end_date then
16069: if (per_asg_shd.g_old_rec.organization_id = l_business_group_id
16070: and l_org_id <> l_business_group_id) then -- Bug 3553286
16071: hr_security_internal.clear_from_person_list
16072: (per_asg_shd.g_old_rec.person_id);
16073: end if;
16074: hr_security_internal.add_to_person_list(l_effective_date,p_assignment_id);
16075: end if;
16076: --

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

16085: --
16086: if (p_pay_basis_id <> hr_api.g_number or
16087: p_pay_basis_id is null ) and
16088: (nvl(p_pay_basis_id,hr_api.g_number) <>
16089: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number))
16090: then
16091: -- start of bug fix 4464072
16092: -- commented out the following part and newly defined
16093:

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

16155: if g_debug then
16156: hr_utility.set_location(l_proc, 300);
16157: end if;
16158: --
16159: l_new_payroll_id := per_asg_shd.g_old_rec.payroll_id;
16160: else
16161: --
16162: if g_debug then
16163: hr_utility.set_location(l_proc, 310);

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

16169: if g_debug then
16170: hr_utility.set_location(l_proc, 320);
16171: end if;
16172: --
16173: hr_utility.set_location('p_old_pg_id :'||to_char(per_asg_shd.g_old_rec.payroll_id),325);
16174: hr_utility.set_location('p_new_pg_id :'||to_char(l_people_group_id),325);
16175: --
16176: hrentmnt.maintain_entries_asg
16177: (p_assignment_id => p_assignment_id

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

16174: hr_utility.set_location('p_new_pg_id :'||to_char(l_people_group_id),325);
16175: --
16176: hrentmnt.maintain_entries_asg
16177: (p_assignment_id => p_assignment_id
16178: ,p_old_payroll_id => per_asg_shd.g_old_rec.payroll_id
16179: ,p_new_payroll_id => l_new_payroll_id
16180: ,p_business_group_id => l_business_group_id
16181: ,p_operation => 'ASG_CRITERIA'
16182: ,p_actual_term_date => null

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

16185: ,p_dt_mode => l_new_dt_update_mode
16186: ,p_validation_start_date => l_validation_start_date
16187: ,p_validation_end_date => l_validation_end_date
16188: ,p_entries_changed => l_entries_changed
16189: ,p_old_people_group_id => per_asg_shd.g_old_rec.people_group_id
16190: ,p_new_people_group_id => l_people_group_id
16191: );
16192: --
16193: -- Bug 630826 fix ends

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

16199: if l_entries_changed_warning <> 'S' then
16200: l_entries_changed_warning := nvl(l_entries_changed, 'N');
16201: end if;
16202: --
16203: IF ( per_asg_shd.g_old_rec.grade_id is not null
16204: AND p_grade_id is null)
16205: OR ( per_asg_shd.g_old_rec.grade_id is not null
16206: AND p_grade_id is not null
16207: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id

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

16201: end if;
16202: --
16203: IF ( per_asg_shd.g_old_rec.grade_id is not null
16204: AND p_grade_id is null)
16205: OR ( per_asg_shd.g_old_rec.grade_id is not null
16206: AND p_grade_id is not null
16207: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id
16208: AND p_grade_id <> hr_api.g_number)
16209: then

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

16203: IF ( per_asg_shd.g_old_rec.grade_id is not null
16204: AND p_grade_id is null)
16205: OR ( per_asg_shd.g_old_rec.grade_id is not null
16206: AND p_grade_id is not null
16207: AND per_asg_shd.g_old_rec.grade_id <> p_grade_id
16208: AND p_grade_id <> hr_api.g_number)
16209: then
16210: --
16211: if g_debug then

Line 17063: l_api_updating := per_asg_shd.api_updating

17059: ,p_argument_value => l_object_version_number);
17060: --
17061: -- Retrieve current assignment details from database.
17062: --
17063: l_api_updating := per_asg_shd.api_updating
17064: (p_assignment_id => p_assignment_id
17065: ,p_effective_date => l_effective_date
17066: ,p_object_version_number => l_object_version_number);
17067: --

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

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;
17094: --
17095: if g_debug then
17096: hr_utility.set_location(l_proc, 45);
17097: end if;

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

17098: --
17099: if l_people_group_id is null
17100: then
17101: --
17102: l_people_group_id := per_asg_shd.g_old_rec.people_group_id;
17103: l_pgp_null_ind := 0;
17104: else
17105: -- get segment values
17106: open c_pgp_segments;

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

17214: end if;
17215: --
17216: -- Check that the assignment is an applicant assignment.
17217: --
17218: if per_asg_shd.g_old_rec.assignment_type <> 'A'
17219: then
17220: --
17221: if g_debug then
17222: hr_utility.set_location(l_proc, 70);

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

17439: -- insert the profile options and effective date for the flexfield
17440: -- validation to work
17441: --
17442: if (p_organization_id=hr_api.g_number) then
17443: l_organization_id:=per_asg_shd.g_old_rec.organization_id;
17444: else
17445: l_organization_id:=p_organization_id;
17446: end if;
17447: --

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

17445: l_organization_id:=p_organization_id;
17446: end if;
17447: --
17448: if (p_location_id=hr_api.g_number) then
17449: l_location_id:=per_asg_shd.g_old_rec.location_id;
17450: else
17451: l_location_id:=p_location_id;
17452: end if;
17453: --

Line 17690: per_asg_shd.lck

17686: --
17687: l_cagr_id_flex_num := p_cagr_id_flex_num;
17688: --
17689: if (p_cagr_id_flex_num = hr_api.g_number) THEN
17690: per_asg_shd.lck
17691: (p_effective_date => l_effective_date,
17692: -- Bug 3430504. Pass l_effective_date in place of p_effective_date.
17693: p_datetrack_mode => p_datetrack_update_mode,
17694: p_assignment_id => p_assignment_id,

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

17695: p_object_version_number => p_object_version_number,
17696: p_validation_start_date => l_unused_start_date,
17697: p_validation_end_date => l_unused_end_date
17698: );
17699: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
17700: --l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
17701: end if;
17702: --
17703: if l_cag_null_ind = 0

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

17696: p_validation_start_date => l_unused_start_date,
17697: p_validation_end_date => l_unused_end_date
17698: );
17699: l_cagr_id_flex_num := per_asg_shd.g_old_rec.cagr_id_flex_num;
17700: --l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
17701: end if;
17702: --
17703: if l_cag_null_ind = 0
17704: then

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

17701: end if;
17702: --
17703: if l_cag_null_ind = 0
17704: then
17705: l_cagr_grade_def_id := per_asg_shd.g_old_rec.cagr_grade_def_id;
17706: --
17707: hr_cgd_upd.upd_or_sel
17708: (p_segment1 => l_cag_segment1
17709: ,p_segment2 => l_cag_segment2

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

17725: ,p_segment18 => l_cag_segment18
17726: ,p_segment19 => l_cag_segment19
17727: ,p_segment20 => l_cag_segment20
17728: ,p_id_flex_num => l_cagr_id_flex_num
17729: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
17730: ,p_cagr_grade_def_id => l_cagr_grade_def_id
17731: ,p_concatenated_segments => l_cagr_concatenated_segments
17732: );
17733: --

Line 17850: if per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id

17846: ,p_supervisor_assignment_id => p_supervisor_assignment_id
17847: );
17848: --
17849: -- ***** Start new code for bug 2276928 **************
17850: if per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id
17851: and p_assignment_status_type_id<>hr_api.g_number then
17852: IRC_ASG_STATUS_API.create_irc_asg_status
17853: (p_assignment_id => p_assignment_id
17854: , p_assignment_status_type_id => p_assignment_status_type_id

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

17863: -- When the vacancy is changes, move the letter request line to a letter request
17864: -- with that vacancy.
17865: -- When the assignemnt status is changed, create new letter request lines.
17866: --
17867: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id
17868: AND p_assignment_status_type_id<>hr_api.g_number
17869: )
17870: OR
17871: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND

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

17867: IF (per_asg_shd.g_old_rec.assignment_status_type_id<>p_assignment_status_type_id
17868: AND p_assignment_status_type_id<>hr_api.g_number
17869: )
17870: OR
17871: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
17872: nvl(p_vacancy_id,-1) <> hr_api.g_number
17873: ) THEN
17874: --
17875: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND

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

17871: ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
17872: nvl(p_vacancy_id,-1) <> hr_api.g_number
17873: ) THEN
17874: --
17875: IF ( nvl(per_asg_shd.g_old_rec.vacancy_id,-1) <> nvl(p_vacancy_id,-1) AND
17876: nvl(p_vacancy_id,-1) <> hr_api.g_number ) THEN
17877: --
17878: delete from per_letter_request_lines plrl
17879: where plrl.assignment_id = p_assignment_id

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

17904: per_applicant_pkg.check_for_letter_requests
17905: (p_business_group_id => l_business_group_id
17906: ,p_per_system_status => null
17907: ,p_assignment_status_type_id => p_assignment_status_type_id
17908: ,p_person_id => per_asg_shd.g_old_rec.person_id
17909: ,p_assignment_id => p_assignment_id
17910: ,p_effective_start_date => l_effective_start_date
17911: ,p_validation_start_date => l_effective_start_date
17912: ,p_vacancy_id => p_vacancy_id

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

17926: --
17927: if l_effective_date between l_sec_effective_start_date
17928: and l_sec_effective_end_date
17929: then
17930: if(per_asg_shd.g_old_rec.organization_id = l_business_group_id
17931: and p_organization_id <> l_business_group_id)
17932: then
17933: hr_security_internal.clear_from_person_list
17934: (per_asg_shd.g_old_rec.person_id);

Line 17934: (per_asg_shd.g_old_rec.person_id);

17930: if(per_asg_shd.g_old_rec.organization_id = l_business_group_id
17931: and p_organization_id <> l_business_group_id)
17932: then
17933: hr_security_internal.clear_from_person_list
17934: (per_asg_shd.g_old_rec.person_id);
17935: end if;
17936: --fix for bug 5938120 starts here
17937: open csr_get_assign(per_asg_shd.g_old_rec.person_id);
17938: LOOP

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

17933: hr_security_internal.clear_from_person_list
17934: (per_asg_shd.g_old_rec.person_id);
17935: end if;
17936: --fix for bug 5938120 starts here
17937: open csr_get_assign(per_asg_shd.g_old_rec.person_id);
17938: LOOP
17939: fetch csr_get_assign into l_assignment_id;
17940: exit when csr_get_assign%NOTFOUND;
17941: hr_security_internal.add_to_person_list(l_effective_date,l_assignment_id);