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 371: l_prev_assg_status_type per_all_assignments_f.assignment_status_type_id%TYPE;

367: ,P_CALL_FOR_BASE_ASG IN boolean default false
368: ) is
369: --
370: l_proc varchar2(72) := g_package||'update_appl_assg_status';
371: l_prev_assg_status_type per_all_assignments_f.assignment_status_type_id%TYPE;
372: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE := -1;
373: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
374: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
375: --

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

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

Line 373: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

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

Line 374: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

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

Line 377: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

373: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
374: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
375: --
376: l_datetrack_mode varchar2(30);
377: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
378: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;
379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
381: l_base_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

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

Line 380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

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

Line 381: l_base_asg_id per_all_assignments_f.assignment_id%TYPE;

377: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
378: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;
379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
381: l_base_asg_id per_all_assignments_f.assignment_id%TYPE;
382: --
383: cursor csr_assignment_ovn is
384: select object_version_number
385: ,effective_start_date

Line 388: from per_all_assignments_f

384: select object_version_number
385: ,effective_start_date
386: ,assignment_status_type_id
387: ,business_group_id
388: from per_all_assignments_f
389: where assignment_id = p_applicant_assignment_id
390: and p_effective_date
391: between effective_start_date
392: and effective_end_date;

Line 668: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

664: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
665: l_offer_version irc_offers.offer_version%TYPE;
666: l_updated_offer_status irc_offers.offer_status%TYPE;
667: --
668: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
669: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
671: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
672: l_validation_start_date date;

Line 669: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

665: l_offer_version irc_offers.offer_version%TYPE;
666: l_updated_offer_status irc_offers.offer_status%TYPE;
667: --
668: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
669: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
671: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
672: l_validation_start_date date;
673: l_validation_end_date date;

Line 670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

666: l_updated_offer_status irc_offers.offer_status%TYPE;
667: --
668: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
669: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
671: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
672: l_validation_start_date date;
673: l_validation_end_date date;
674: l_org_now_no_manager_warning boolean;

Line 671: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

667: --
668: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
669: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
671: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
672: l_validation_start_date date;
673: l_validation_end_date date;
674: l_org_now_no_manager_warning boolean;
675: --

Line 685: from per_all_assignments_f

681: where offer_id = p_offer_id;
682: --
683: cursor csr_assignment_ovn is
684: select object_version_number
685: from per_all_assignments_f
686: where assignment_id = l_offer_assignment_id;
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc,10);

Line 809: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

805: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
806: --
807: -- Out and In Out variables
808: --
809: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
811: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
812: l_comment_id per_all_assignments_f.comment_id%TYPE;
813: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

806: --
807: -- Out and In Out variables
808: --
809: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
811: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
812: l_comment_id per_all_assignments_f.comment_id%TYPE;
813: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
814: l_payroll_id_updated boolean;

Line 811: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

807: -- Out and In Out variables
808: --
809: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
811: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
812: l_comment_id per_all_assignments_f.comment_id%TYPE;
813: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
814: l_payroll_id_updated boolean;
815: l_other_manager_warning boolean;

Line 812: l_comment_id per_all_assignments_f.comment_id%TYPE;

808: --
809: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
811: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
812: l_comment_id per_all_assignments_f.comment_id%TYPE;
813: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
814: l_payroll_id_updated boolean;
815: l_other_manager_warning boolean;
816: l_hourly_salaried_warning boolean;

Line 813: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

809: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
810: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
811: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
812: l_comment_id per_all_assignments_f.comment_id%TYPE;
813: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
814: l_payroll_id_updated boolean;
815: l_other_manager_warning boolean;
816: l_hourly_salaried_warning boolean;
817: l_no_managers_warning boolean;

Line 835: from per_all_assignments_f

831: --
832: cursor csr_appl_asg_effective_date is
833: select effective_start_date
834: ,object_version_number
835: from per_all_assignments_f
836: where assignment_id = l_applicant_assignment_id
837: and p_effective_date
838: between effective_start_date
839: and effective_end_date;

Line 951: from per_all_assignments_f

947: ,vendor_site_id
948: ,po_header_id
949: ,po_line_id
950: ,projected_assignment_end
951: from per_all_assignments_f
952: where assignment_id = l_offer_assignment_id
953: and p_effective_date
954: between effective_start_date
955: and effective_end_date;

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

1448: ) IS
1449: --
1450: l_proc VARCHAR2(72) := g_package||'other_extended_offers_count';
1451: l_other_extended_offer_count number := 0;
1452: l_person_id per_all_assignments_f.person_id%TYPE := p_person_id;
1453: --
1454: CURSOR csr_person_id is
1455: SELECT person_id
1456: FROM per_all_assignments_f

Line 1456: FROM per_all_assignments_f

1452: l_person_id per_all_assignments_f.person_id%TYPE := p_person_id;
1453: --
1454: CURSOR csr_person_id is
1455: SELECT person_id
1456: FROM per_all_assignments_f
1457: WHERE assignment_id = p_applicant_assignment_id
1458: AND p_effective_date
1459: BETWEEN effective_start_date
1460: AND effective_end_date;

Line 1465: ,PER_ALL_ASSIGNMENTS_F otherasg

1461: --
1462: CURSOR csr_other_extended_offers IS
1463: SELECT count(otheroffer.offer_id)
1464: FROM IRC_OFFERS otheroffer
1465: ,PER_ALL_ASSIGNMENTS_F otherasg
1466: ,PER_ALL_PEOPLE_F per
1467: ,PER_ALL_PEOPLE_F linkper
1468: ,IRC_OFFER_STATUS_HISTORY otherhistory
1469: WHERE (

Line 1723: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

1719: l_latest_offer irc_offers.latest_offer%TYPE;
1720: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
1721: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
1722: l_offer_version irc_offers.offer_version%TYPE;
1723: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
1724: --
1725: l_updated_offer_id irc_offers.offer_id%TYPE;
1726: l_updated_offer_status irc_offers.offer_status%TYPE;
1727: l_updated_appl_assignment_id irc_offers.applicant_assignment_id%TYPE;

Line 2166: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

2162:
2163: l_create_new_version boolean := false;
2164: l_other_extended_offer_count number := 0;
2165: --
2166: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2167: l_validation_start_date date;
2168: l_validation_end_date date;
2169: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2170: l_org_now_no_manager_warning boolean;

Line 2169: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

2165: --
2166: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2167: l_validation_start_date date;
2168: l_validation_end_date date;
2169: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2170: l_org_now_no_manager_warning boolean;
2171: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2172: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2173: --

Line 2171: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

2167: l_validation_start_date date;
2168: l_validation_end_date date;
2169: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2170: l_org_now_no_manager_warning boolean;
2171: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2172: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2173: --
2174: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

Line 2172: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

2168: l_validation_end_date date;
2169: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2170: l_org_now_no_manager_warning boolean;
2171: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
2172: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
2173: --
2174: l_prev_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
2175: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;

Line 2199: from per_all_assignments_f

2195: --
2196: cursor csr_assignment_record is
2197: select object_version_number
2198: ,effective_end_date
2199: from per_all_assignments_f
2200: where assignment_id = l_prev_offer_assignment_id;
2201: --
2202: cursor csr_offer_status_history_id is
2203: select HISTORY.offer_status_history_id

Line 3420: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

3416: --
3417: l_proc varchar2(72) := g_package||'delete_offer';
3418: l_offer_id irc_offers.offer_id%TYPE;
3419: l_prev_offer_status irc_offers.offer_status%TYPE;
3420: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3421: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3422: l_effective_date date;
3423: l_validation_start_date date;
3424: l_validation_end_date date;

Line 3421: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

3417: l_proc varchar2(72) := g_package||'delete_offer';
3418: l_offer_id irc_offers.offer_id%TYPE;
3419: l_prev_offer_status irc_offers.offer_status%TYPE;
3420: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3421: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
3422: l_effective_date date;
3423: l_validation_start_date date;
3424: l_validation_end_date date;
3425: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;

Line 3428: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3424: l_validation_end_date date;
3425: l_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
3426: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;
3427: l_offer_status irc_offers.offer_status%TYPE;
3428: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3429: l_asg_object_version_number number(9);
3430: l_org_now_no_manager_warning boolean;
3431: --
3432: cursor csr_prev_offer_rec is

Line 3451: from per_all_assignments_f

3447: where applicant_assignment_id = l_applicant_assignment_id );
3448: --
3449: cursor csr_assignment_ovn is
3450: select object_version_number
3451: from per_all_assignments_f
3452: where assignment_id = l_offer_assignment_id;
3453: --
3454: begin
3455: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3666: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

3662: l_manager_terminates varchar2(1);
3663: l_user_id varchar2(250);
3664: --
3665: CURSOR csr_applicant_userid
3666: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3667: ,p_effective_date IN DATE
3668: )
3669: IS
3670: select user_id

Line 3671: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,

3667: ,p_effective_date IN DATE
3668: )
3669: IS
3670: select user_id
3671: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,
3672: per_all_people_f linkppf
3673: where p_effective_date between paf.effective_start_date and
3674: paf.effective_end_date
3675: and p_effective_date between usr.start_date and

Line 4341: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;

4337: l_proc varchar2(72) := g_package||'create_offer_assignment';
4338: --
4339: -- Out and In Out variables
4340: --
4341: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4342: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4343: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4344: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4345: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;

Line 4342: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

4338: --
4339: -- Out and In Out variables
4340: --
4341: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4342: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4343: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4344: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4345: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4346: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 4343: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

4339: -- Out and In Out variables
4340: --
4341: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4342: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4343: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4344: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4345: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4346: l_comment_id per_all_assignments_f.comment_id%TYPE;
4347: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 4344: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

4340: --
4341: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4342: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4343: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4344: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4345: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4346: l_comment_id per_all_assignments_f.comment_id%TYPE;
4347: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4348: l_other_manager_warning boolean;

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

4341: l_offer_assignment_id per_all_assignments_f.assignment_id%TYPE;
4342: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4343: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4344: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4345: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4346: l_comment_id per_all_assignments_f.comment_id%TYPE;
4347: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4348: l_other_manager_warning boolean;
4349: l_hourly_salaried_warning boolean;

Line 4346: l_comment_id per_all_assignments_f.comment_id%TYPE;

4342: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4343: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4344: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4345: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4346: l_comment_id per_all_assignments_f.comment_id%TYPE;
4347: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4348: l_other_manager_warning boolean;
4349: l_hourly_salaried_warning boolean;
4350: --

Line 4347: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

4343: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4344: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4345: l_assignment_number per_all_assignments_f.assignment_number%TYPE := p_assignment_number;
4346: l_comment_id per_all_assignments_f.comment_id%TYPE;
4347: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4348: l_other_manager_warning boolean;
4349: l_hourly_salaried_warning boolean;
4350: --
4351: -- variables to be set

Line 4353: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

4349: l_hourly_salaried_warning boolean;
4350: --
4351: -- variables to be set
4352: --
4353: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4354: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
4355: --
4356: -- Date Variables
4357: --

Line 4354: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

4350: --
4351: -- variables to be set
4352: --
4353: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4354: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
4355: --
4356: -- Date Variables
4357: --
4358: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

Line 4358: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

4354: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
4355: --
4356: -- Date Variables
4357: --
4358: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4359: l_program_update_date per_all_assignments_f.program_update_date%TYPE;
4360: l_placement_date_start date;
4361: l_projected_assignment_end date;
4362: l_effective_date date;

Line 4359: l_program_update_date per_all_assignments_f.program_update_date%TYPE;

4355: --
4356: -- Date Variables
4357: --
4358: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
4359: l_program_update_date per_all_assignments_f.program_update_date%TYPE;
4360: l_placement_date_start date;
4361: l_projected_assignment_end date;
4362: l_effective_date date;
4363: Begin

Line 4708: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4704: --
4705: l_proc varchar2(72) := g_package||'update_offer_assignment';
4706: l_create_new_version boolean := false;
4707:
4708: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4709: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4710: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4711: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4712: l_comment_id per_all_assignments_f.comment_id%TYPE;

Line 4709: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

4705: l_proc varchar2(72) := g_package||'update_offer_assignment';
4706: l_create_new_version boolean := false;
4707:
4708: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4709: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4710: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4711: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4712: l_comment_id per_all_assignments_f.comment_id%TYPE;
4713: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;

Line 4710: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

4706: l_create_new_version boolean := false;
4707:
4708: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4709: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4710: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4711: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4712: l_comment_id per_all_assignments_f.comment_id%TYPE;
4713: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;
4714: l_payroll_id_updated boolean;

Line 4711: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

4707:
4708: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4709: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4710: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4711: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4712: l_comment_id per_all_assignments_f.comment_id%TYPE;
4713: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;
4714: l_payroll_id_updated boolean;
4715: l_other_manager_warning boolean;

Line 4712: l_comment_id per_all_assignments_f.comment_id%TYPE;

4708: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4709: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4710: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4711: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4712: l_comment_id per_all_assignments_f.comment_id%TYPE;
4713: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;
4714: l_payroll_id_updated boolean;
4715: l_other_manager_warning boolean;
4716: l_hourly_salaried_warning boolean;

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

4709: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4710: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
4711: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4712: l_comment_id per_all_assignments_f.comment_id%TYPE;
4713: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE := p_asg_object_version_number;
4714: l_payroll_id_updated boolean;
4715: l_other_manager_warning boolean;
4716: l_hourly_salaried_warning boolean;
4717: l_no_managers_warning boolean;

Line 4737: from per_all_assignments_f

4733: where offer_id = p_offer_id;
4734: --
4735: cursor csr_asg_effective_start_date is
4736: select effective_start_date
4737: from per_all_assignments_f
4738: where assignment_id = P_ASSIGNMENT_ID
4739: and p_effective_date
4740: between effective_start_date
4741: and effective_end_date;