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 IRC_OFFER_STATUS_HISTORY

Line 593: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

589: ) is
590: --
591: l_proc varchar2(72) := g_package||'update_latest_offer_flag';
592: l_object_version_number irc_offers.object_version_number%TYPE;
593: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
594: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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;

Line 594: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

590: --
591: l_proc varchar2(72) := g_package||'update_latest_offer_flag';
592: l_object_version_number irc_offers.object_version_number%TYPE;
593: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
594: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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: --

Line 659: irc_offer_status_history_api.create_offer_status_history

655: then
656: --
657: hr_utility.set_location(l_proc, 50);
658: --
659: irc_offer_status_history_api.create_offer_status_history
660: ( p_validate => p_validate
661: ,p_effective_date => p_effective_date
662: ,p_offer_status_history_id => l_offer_status_history_id
663: ,p_offer_id => p_offer_id

Line 1372: ,IRC_OFFER_STATUS_HISTORY otherhistory

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 (
1374: -- Other Extended Offers
1375: otheroffer.offer_status = 'EXTENDED'
1376: OR

Line 1397: from irc_offer_status_history

1393: AND otheroffer.latest_offer = 'Y'
1394: AND otheroffer.applicant_assignment_id <> nvl(p_applicant_assignment_id, -1)
1395: AND decode(hr_general.get_xbg_profile,'Y', otherasg.business_group_id , hr_general.get_business_group_id) = otherasg.business_group_id
1396: AND otherhistory.offer_status_history_id = (select max(offer_status_history_id)
1397: from irc_offer_status_history
1398: where offer_id = otheroffer.offer_id );
1399: --
1400: BEGIN
1401: --

Line 1604: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

1600: l_effective_date date;
1601: l_expiry_date irc_offers.expiry_date%TYPE;
1602: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1603: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1604: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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;

Line 1606: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

1602: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1603: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1604: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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: --

Line 1607: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

1603: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1604: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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;

Line 1827: irc_offer_status_history_api.create_offer_status_history

1823: --
1824: -- Create offer history record for the newly created
1825: -- Offer record.
1826: --
1827: irc_offer_status_history_api.create_offer_status_history
1828: ( p_validate => p_validate
1829: , p_effective_date => l_effective_date
1830: , p_offer_status_history_id => l_offer_status_history_id
1831: , p_offer_id => l_offer_id

Line 2024: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

2020: l_expiry_date irc_offers.expiry_date%TYPE;
2021: l_prev_expiry_date irc_offers.expiry_date%TYPE;
2022: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2023: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2024: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2025: l_prev_offer_status irc_offers.offer_status%TYPE;
2026: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2027: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2028: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

Line 2028: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

2024: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2025: l_prev_offer_status irc_offers.offer_status%TYPE;
2026: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2027: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2028: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2029: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2030: l_mutiple_fields_updated boolean;
2031: l_offer_version irc_offers.offer_version%TYPE;
2032: l_offer_status irc_offers.offer_status%TYPE := p_offer_status;

Line 2029: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

2025: l_prev_offer_status irc_offers.offer_status%TYPE;
2026: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2027: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2028: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2029: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2030: l_mutiple_fields_updated boolean;
2031: l_offer_version irc_offers.offer_version%TYPE;
2032: l_offer_status irc_offers.offer_status%TYPE := p_offer_status;
2033: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;

Line 2052: l_prev_offer_change_reason irc_offer_status_history.change_reason%TYPE;

2048: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;
2049: l_offer_postal_service irc_offers.offer_postal_service%TYPE;
2050: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2051: l_prev_offer_ovn irc_offers.object_version_number%TYPE;
2052: l_prev_offer_change_reason irc_offer_status_history.change_reason%TYPE;
2053: --
2054: -- Declare cursors
2055: --
2056: cursor csr_prev_offer_details is

Line 2076: from irc_offer_status_history

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)
2076: from irc_offer_status_history
2077: where offer_id = p_offer_id;
2078: --
2079: cursor csr_offer_status_history_dets(p_status_history_id number) is
2080: select change_reason

Line 2081: from irc_offer_status_history

2077: where offer_id = p_offer_id;
2078: --
2079: cursor csr_offer_status_history_dets(p_status_history_id number) is
2080: select change_reason
2081: from irc_offer_status_history
2082: where offer_status_history_id = p_status_history_id;
2083: --
2084: cursor csr_offer_record is
2085: select

Line 3028: irc_offer_status_history_api.create_offer_status_history

3024: then
3025: --
3026: hr_utility.set_location(l_proc,140);
3027: --
3028: irc_offer_status_history_api.create_offer_status_history
3029: ( p_validate => p_validate
3030: , p_effective_date => l_effective_date
3031: , p_offer_status_history_id => l_offer_status_history_id
3032: , p_offer_id => p_offer_id

Line 3120: irc_offer_status_history_api.update_offer_status_history

3116: --
3117: end if;
3118: close csr_offer_status_history_id;
3119: --
3120: irc_offer_status_history_api.update_offer_status_history
3121: ( p_validate => p_validate
3122: , p_effective_date => l_effective_date
3123: , p_offer_status_history_id => l_offer_status_history_id
3124: , p_offer_id => p_offer_id

Line 3367: -- Also delete the irc_offer_status_history record.

3363: --
3364: -- Process Logic
3365: --
3366: --
3367: -- Also delete the irc_offer_status_history record.
3368: --
3369: irc_offer_status_history_api.delete_offer_status_history
3370: (
3371: p_validate => p_validate

Line 3369: irc_offer_status_history_api.delete_offer_status_history

3365: --
3366: --
3367: -- Also delete the irc_offer_status_history record.
3368: --
3369: irc_offer_status_history_api.delete_offer_status_history
3370: (
3371: p_validate => p_validate
3372: ,p_offer_id => p_offer_id
3373: ,p_effective_date => l_effective_date

Line 3525: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

3521: l_offer_assignment_exists boolean := true;
3522: l_iof_object_version_number irc_offers.object_version_number%TYPE;
3523: -- Date variables
3524: l_effective_date date;
3525: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
3526: -- Cursors
3527: cursor csr_offer_assignment_1 is
3528: select offer_assignment_id
3529: ,offer_id

Line 3808: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;

3804: l_proc varchar2(72) := g_package||'release_offer';
3805: l_prev_offer_status irc_offers.offer_status%TYPE;
3806: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
3807: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
3808: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
3809: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
3810: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
3811: l_offer_version irc_offers.offer_version%TYPE;
3812: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

Line 3809: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;

3805: l_prev_offer_status irc_offers.offer_status%TYPE;
3806: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
3807: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
3808: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
3809: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
3810: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
3811: l_offer_version irc_offers.offer_version%TYPE;
3812: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
3813: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

Line 3812: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

3808: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
3809: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
3810: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
3811: l_offer_version irc_offers.offer_version%TYPE;
3812: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
3813: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
3814: l_other_extended_offer_count number := 0;
3815: l_prev_expiry_date irc_offers.expiry_date%TYPE;
3816: --

Line 3813: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

3809: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
3810: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
3811: l_offer_version irc_offers.offer_version%TYPE;
3812: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
3813: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
3814: l_other_extended_offer_count number := 0;
3815: l_prev_expiry_date irc_offers.expiry_date%TYPE;
3816: --
3817: cursor csr_prev_to_prev_offer_status is

Line 3821: FROM irc_offer_status_history ios1

3817: cursor csr_prev_to_prev_offer_status is
3818: SELECT ios1.offer_status,
3819: ios1.change_reason,
3820: ios1.decline_reason
3821: FROM irc_offer_status_history ios1
3822: WHERE ios1.offer_status_history_id = (
3823: SELECT Max(ios2.offer_status_history_id) FROM irc_offer_status_history ios2
3824: WHERE ios2.offer_id = p_offer_id
3825: AND 1 =

Line 3823: SELECT Max(ios2.offer_status_history_id) FROM irc_offer_status_history ios2

3819: ios1.change_reason,
3820: ios1.decline_reason
3821: FROM irc_offer_status_history ios1
3822: WHERE ios1.offer_status_history_id = (
3823: SELECT Max(ios2.offer_status_history_id) FROM irc_offer_status_history ios2
3824: WHERE ios2.offer_id = p_offer_id
3825: AND 1 =
3826: (SELECT COUNT(*)
3827: FROM irc_offer_status_history ios3

Line 3827: FROM irc_offer_status_history ios3

3823: SELECT Max(ios2.offer_status_history_id) FROM irc_offer_status_history ios2
3824: WHERE ios2.offer_id = p_offer_id
3825: AND 1 =
3826: (SELECT COUNT(*)
3827: FROM irc_offer_status_history ios3
3828: WHERE ios3.offer_id = p_offer_id
3829: AND ios3.status_change_date > ios2.status_change_date
3830: ));
3831: --

Line 3949: irc_offer_status_history_api.create_offer_status_history

3945: );
3946: --
3947: -- Create the offer status history record with the details
3948: --
3949: irc_offer_status_history_api.create_offer_status_history
3950: ( p_validate => p_validate
3951: , p_effective_date => p_effective_date
3952: , p_offer_id => l_offer_id
3953: , p_offer_status => l_prev_to_prev_offer_status