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.IRC_OFFERS_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 27: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

23: l_proc varchar2(72) := g_package||'create_offer_assignment_copy';
24: --
25: -- Out and In Out variables
26: --
27: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
28: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
29: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
30: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
31: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 28: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

24: --
25: -- Out and In Out variables
26: --
27: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
28: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
29: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
30: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
31: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
32: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 29: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

25: -- Out and In Out variables
26: --
27: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
28: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
29: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
30: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
31: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
32: l_comment_id per_all_assignments_f.comment_id%TYPE;
33: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 30: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

26: --
27: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
28: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
29: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
30: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
31: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
32: l_comment_id per_all_assignments_f.comment_id%TYPE;
33: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
34: l_other_manager_warning boolean;

Line 31: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;

27: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
28: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
29: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
30: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
31: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
32: l_comment_id per_all_assignments_f.comment_id%TYPE;
33: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
34: l_other_manager_warning boolean;
35: l_hourly_salaried_warning boolean;

Line 32: l_comment_id per_all_assignments_f.comment_id%TYPE;

28: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
29: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
30: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
31: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
32: l_comment_id per_all_assignments_f.comment_id%TYPE;
33: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
34: l_other_manager_warning boolean;
35: l_hourly_salaried_warning boolean;
36:

Line 33: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

29: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
30: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
31: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
32: l_comment_id per_all_assignments_f.comment_id%TYPE;
33: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
34: l_other_manager_warning boolean;
35: l_hourly_salaried_warning boolean;
36:
37: l_validation_start_date date;

Line 42: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

38: l_validation_end_date date;
39: --
40: -- variables to be set
41: --
42: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
43: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
44: --
45: -- Date Variables
46: --

Line 43: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

39: --
40: -- variables to be set
41: --
42: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
43: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
44: --
45: -- Date Variables
46: --
47: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 47: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

43: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
44: --
45: -- Date Variables
46: --
47: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
48: l_effective_date date;
49: l_program_update_date per_all_assignments_f.program_update_date%TYPE;
50: --
51: -- Define cursor

Line 49: l_program_update_date per_all_assignments_f.program_update_date%TYPE;

45: -- Date Variables
46: --
47: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
48: l_effective_date date;
49: l_program_update_date per_all_assignments_f.program_update_date%TYPE;
50: --
51: -- Define cursor
52: --
53: cursor csr_assignment_record is

Line 158: from per_all_assignments_f

154: ,applicant_rank
155: ,grade_ladder_pgm_id
156: ,supervisor_assignment_id
157: ,object_version_number
158: from per_all_assignments_f
159: where assignment_id = p_source_assignment_id
160: and p_effective_date
161: between effective_start_date
162: and effective_end_date;

Line 370: l_prev_assg_status_type per_all_assignments_f.assignment_status_type_id%TYPE;

366: ,P_CHANGE_REASON IN VARCHAR2 default null
367: ) is
368: --
369: l_proc varchar2(72) := g_package||'update_appl_assg_status';
370: l_prev_assg_status_type per_all_assignments_f.assignment_status_type_id%TYPE;
371: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE := -1;
372: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
373: --
374: l_datetrack_mode varchar2(30);

Line 371: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE := -1;

367: ) is
368: --
369: l_proc varchar2(72) := g_package||'update_appl_assg_status';
370: l_prev_assg_status_type per_all_assignments_f.assignment_status_type_id%TYPE;
371: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE := -1;
372: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
373: --
374: l_datetrack_mode varchar2(30);
375: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 372: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

368: --
369: l_proc varchar2(72) := g_package||'update_appl_assg_status';
370: l_prev_assg_status_type per_all_assignments_f.assignment_status_type_id%TYPE;
371: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE := -1;
372: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
373: --
374: l_datetrack_mode varchar2(30);
375: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
376: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;

Line 375: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

371: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE := -1;
372: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
373: --
374: l_datetrack_mode varchar2(30);
375: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
376: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;
377: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
378: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
379: --

Line 377: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

373: --
374: l_datetrack_mode varchar2(30);
375: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
376: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;
377: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
378: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
379: --
380: cursor csr_assignment_ovn is
381: select object_version_number

Line 378: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

374: l_datetrack_mode varchar2(30);
375: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
376: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;
377: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
378: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
379: --
380: cursor csr_assignment_ovn is
381: select object_version_number
382: ,effective_start_date

Line 384: from per_all_assignments_f

380: cursor csr_assignment_ovn is
381: select object_version_number
382: ,effective_start_date
383: ,assignment_status_type_id
384: from per_all_assignments_f
385: where assignment_id = p_applicant_assignment_id
386: and p_effective_date
387: between effective_start_date
388: and effective_end_date;

Line 599: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

595: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
596: l_offer_version irc_offers.offer_version%TYPE;
597: l_updated_offer_status irc_offers.offer_status%TYPE;
598: --
599: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
600: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
601: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
602: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
603: l_validation_start_date date;

Line 600: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

596: l_offer_version irc_offers.offer_version%TYPE;
597: l_updated_offer_status irc_offers.offer_status%TYPE;
598: --
599: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
600: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
601: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
602: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
603: l_validation_start_date date;
604: l_validation_end_date date;

Line 601: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

597: l_updated_offer_status irc_offers.offer_status%TYPE;
598: --
599: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
600: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
601: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
602: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
603: l_validation_start_date date;
604: l_validation_end_date date;
605: l_org_now_no_manager_warning boolean;

Line 602: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

598: --
599: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
600: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
601: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
602: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
603: l_validation_start_date date;
604: l_validation_end_date date;
605: l_org_now_no_manager_warning boolean;
606: --

Line 616: from per_all_assignments_f

612: where offer_id = p_offer_id;
613: --
614: cursor csr_assignment_ovn is
615: select object_version_number
616: from per_all_assignments_f
617: where assignment_id = l_offer_assignment_id;
618: --
619: Begin
620: hr_utility.set_location('Entering:'||l_proc,10);

Line 740: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

736: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
737: --
738: -- Out and In Out variables
739: --
740: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
741: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
742: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
743: l_comment_id per_all_assignments_f.comment_id%TYPE;
744: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 741: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

737: --
738: -- Out and In Out variables
739: --
740: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
741: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
742: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
743: l_comment_id per_all_assignments_f.comment_id%TYPE;
744: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
745: l_payroll_id_updated boolean;

Line 742: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

738: -- Out and In Out variables
739: --
740: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
741: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
742: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
743: l_comment_id per_all_assignments_f.comment_id%TYPE;
744: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
745: l_payroll_id_updated boolean;
746: l_other_manager_warning boolean;

Line 743: l_comment_id per_all_assignments_f.comment_id%TYPE;

739: --
740: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
741: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
742: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
743: l_comment_id per_all_assignments_f.comment_id%TYPE;
744: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
745: l_payroll_id_updated boolean;
746: l_other_manager_warning boolean;
747: l_hourly_salaried_warning boolean;

Line 744: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

740: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
741: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
742: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
743: l_comment_id per_all_assignments_f.comment_id%TYPE;
744: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
745: l_payroll_id_updated boolean;
746: l_other_manager_warning boolean;
747: l_hourly_salaried_warning boolean;
748: l_no_managers_warning boolean;

Line 766: from per_all_assignments_f

762: --
763: cursor csr_appl_asg_effective_date is
764: select effective_start_date
765: ,object_version_number
766: from per_all_assignments_f
767: where assignment_id = l_applicant_assignment_id
768: and p_effective_date
769: between effective_start_date
770: and effective_end_date;

Line 882: from per_all_assignments_f

878: ,vendor_site_id
879: ,po_header_id
880: ,po_line_id
881: ,projected_assignment_end
882: from per_all_assignments_f
883: where assignment_id = l_offer_assignment_id
884: and p_effective_date
885: between effective_start_date
886: and effective_end_date;

Line 1356: l_person_id per_all_assignments_f.person_id%TYPE := p_person_id;

1352: ) IS
1353: --
1354: l_proc VARCHAR2(72) := g_package||'other_extended_offers_count';
1355: l_other_extended_offer_count number := 0;
1356: l_person_id per_all_assignments_f.person_id%TYPE := p_person_id;
1357: --
1358: CURSOR csr_person_id is
1359: SELECT person_id
1360: FROM per_all_assignments_f

Line 1360: FROM per_all_assignments_f

1356: l_person_id per_all_assignments_f.person_id%TYPE := p_person_id;
1357: --
1358: CURSOR csr_person_id is
1359: SELECT person_id
1360: FROM per_all_assignments_f
1361: WHERE assignment_id = p_applicant_assignment_id
1362: AND p_effective_date
1363: BETWEEN effective_start_date
1364: AND effective_end_date;

Line 1369: ,PER_ALL_ASSIGNMENTS_F otherasg

1365: --
1366: CURSOR csr_other_extended_offers IS
1367: SELECT count(otheroffer.offer_id)
1368: FROM IRC_OFFERS otheroffer
1369: ,PER_ALL_ASSIGNMENTS_F otherasg
1370: ,PER_ALL_PEOPLE_F per
1371: ,PER_ALL_PEOPLE_F linkper
1372: ,IRC_OFFER_STATUS_HISTORY otherhistory
1373: WHERE (

Line 1609: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

1605: l_latest_offer irc_offers.latest_offer%TYPE;
1606: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
1607: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
1608: l_offer_version irc_offers.offer_version%TYPE;
1609: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
1610: --
1611: l_updated_offer_id irc_offers.offer_id%TYPE;
1612: l_updated_offer_status irc_offers.offer_status%TYPE;
1613: l_updated_appl_assignment_id irc_offers.applicant_assignment_id%TYPE;

Line 2038: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

2034:
2035: l_create_new_version boolean := false;
2036: l_other_extended_offer_count number := 0;
2037: --
2038: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2039: l_validation_start_date date;
2040: l_validation_end_date date;
2041: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2042: l_org_now_no_manager_warning boolean;

Line 2041: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

2037: --
2038: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2039: l_validation_start_date date;
2040: l_validation_end_date date;
2041: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2042: l_org_now_no_manager_warning boolean;
2043: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2044: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2045: --

Line 2043: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

2039: l_validation_start_date date;
2040: l_validation_end_date date;
2041: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2042: l_org_now_no_manager_warning boolean;
2043: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2044: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2045: --
2046: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2047: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

Line 2044: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

2040: l_validation_end_date date;
2041: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2042: l_org_now_no_manager_warning boolean;
2043: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2044: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2045: --
2046: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2047: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
2048: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;

Line 2071: from per_all_assignments_f

2067: --
2068: cursor csr_assignment_record is
2069: select object_version_number
2070: ,effective_end_date
2071: from per_all_assignments_f
2072: where assignment_id = l_prev_offer_assignment_id;
2073: --
2074: cursor csr_offer_status_history_id is
2075: select max(offer_status_history_id)

Line 3269: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

3265: --
3266: l_proc varchar2(72) := g_package||'delete_offer';
3267: l_offer_id irc_offers.offer_id%TYPE;
3268: l_prev_offer_status irc_offers.offer_status%TYPE;
3269: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3270: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3271: l_effective_date date;
3272: l_validation_start_date date;
3273: l_validation_end_date date;

Line 3270: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

3266: l_proc varchar2(72) := g_package||'delete_offer';
3267: l_offer_id irc_offers.offer_id%TYPE;
3268: l_prev_offer_status irc_offers.offer_status%TYPE;
3269: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3270: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3271: l_effective_date date;
3272: l_validation_start_date date;
3273: l_validation_end_date date;
3274: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

Line 3277: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3273: l_validation_end_date date;
3274: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
3275: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
3276: l_offer_status irc_offers.offer_status%TYPE;
3277: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3278: l_asg_object_version_number number(9);
3279: l_org_now_no_manager_warning boolean;
3280: --
3281: cursor csr_prev_offer_rec is

Line 3300: from per_all_assignments_f

3296: where applicant_assignment_id = l_applicant_assignment_id );
3297: --
3298: cursor csr_assignment_ovn is
3299: select object_version_number
3300: from per_all_assignments_f
3301: where assignment_id = l_offer_assignment_id;
3302: --
3303: begin
3304: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4098: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;

4094: l_proc varchar2(72) := g_package||'create_offer_assignment';
4095: --
4096: -- Out and In Out variables
4097: --
4098: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4099: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4100: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4101: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4102: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;

Line 4099: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

4095: --
4096: -- Out and In Out variables
4097: --
4098: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4099: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4100: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4101: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4102: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4103: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 4100: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

4096: -- Out and In Out variables
4097: --
4098: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4099: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4100: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4101: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4102: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4103: l_comment_id per_all_assignments_f.comment_id%TYPE;
4104: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 4101: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

4097: --
4098: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4099: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4100: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4101: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4102: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4103: l_comment_id per_all_assignments_f.comment_id%TYPE;
4104: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4105: l_other_manager_warning boolean;

Line 4102: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;

4098: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4099: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4100: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4101: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4102: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4103: l_comment_id per_all_assignments_f.comment_id%TYPE;
4104: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4105: l_other_manager_warning boolean;
4106: l_hourly_salaried_warning boolean;

Line 4103: l_comment_id per_all_assignments_f.comment_id%TYPE;

4099: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4100: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4101: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4102: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4103: l_comment_id per_all_assignments_f.comment_id%TYPE;
4104: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4105: l_other_manager_warning boolean;
4106: l_hourly_salaried_warning boolean;
4107: --

Line 4104: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

4100: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4101: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4102: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4103: l_comment_id per_all_assignments_f.comment_id%TYPE;
4104: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4105: l_other_manager_warning boolean;
4106: l_hourly_salaried_warning boolean;
4107: --
4108: -- variables to be set

Line 4110: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

4106: l_hourly_salaried_warning boolean;
4107: --
4108: -- variables to be set
4109: --
4110: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4111: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
4112: --
4113: -- Date Variables
4114: --

Line 4111: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

4107: --
4108: -- variables to be set
4109: --
4110: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4111: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
4112: --
4113: -- Date Variables
4114: --
4115: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 4115: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

4111: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
4112: --
4113: -- Date Variables
4114: --
4115: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4116: l_program_update_date per_all_assignments_f.program_update_date%TYPE;
4117: l_placement_date_start date;
4118: l_projected_assignment_end date;
4119: l_effective_date date;

Line 4116: l_program_update_date per_all_assignments_f.program_update_date%TYPE;

4112: --
4113: -- Date Variables
4114: --
4115: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4116: l_program_update_date per_all_assignments_f.program_update_date%TYPE;
4117: l_placement_date_start date;
4118: l_projected_assignment_end date;
4119: l_effective_date date;
4120: Begin

Line 4465: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4461: --
4462: l_proc varchar2(72) := g_package||'update_offer_assignment';
4463: l_create_new_version boolean := false;
4464:
4465: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4466: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4467: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4468: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4469: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 4466: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

4462: l_proc varchar2(72) := g_package||'update_offer_assignment';
4463: l_create_new_version boolean := false;
4464:
4465: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4466: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4467: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4468: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4469: l_comment_id per_all_assignments_f.comment_id%TYPE;
4470: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;

Line 4467: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

4463: l_create_new_version boolean := false;
4464:
4465: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4466: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4467: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4468: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4469: l_comment_id per_all_assignments_f.comment_id%TYPE;
4470: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;
4471: l_payroll_id_updated boolean;

Line 4468: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

4464:
4465: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4466: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4467: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4468: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4469: l_comment_id per_all_assignments_f.comment_id%TYPE;
4470: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;
4471: l_payroll_id_updated boolean;
4472: l_other_manager_warning boolean;

Line 4469: l_comment_id per_all_assignments_f.comment_id%TYPE;

4465: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4466: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4467: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4468: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4469: l_comment_id per_all_assignments_f.comment_id%TYPE;
4470: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;
4471: l_payroll_id_updated boolean;
4472: l_other_manager_warning boolean;
4473: l_hourly_salaried_warning boolean;

Line 4470: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;

4466: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4467: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4468: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4469: l_comment_id per_all_assignments_f.comment_id%TYPE;
4470: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;
4471: l_payroll_id_updated boolean;
4472: l_other_manager_warning boolean;
4473: l_hourly_salaried_warning boolean;
4474: l_no_managers_warning boolean;

Line 4494: from per_all_assignments_f

4490: where offer_id = p_offer_id;
4491: --
4492: cursor csr_asg_effective_start_date is
4493: select effective_start_date
4494: from per_all_assignments_f
4495: where assignment_id = P_ASSIGNMENT_ID
4496: and p_effective_date
4497: between effective_start_date
4498: and effective_end_date;