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 662: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

658: ) is
659: --
660: l_proc varchar2(72) := g_package||'update_latest_offer_flag';
661: l_object_version_number irc_offers.object_version_number%TYPE;
662: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
663: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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;

Line 663: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

659: --
660: l_proc varchar2(72) := g_package||'update_latest_offer_flag';
661: l_object_version_number irc_offers.object_version_number%TYPE;
662: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
663: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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: --

Line 728: irc_offer_status_history_api.create_offer_status_history

724: then
725: --
726: hr_utility.set_location(l_proc, 50);
727: --
728: irc_offer_status_history_api.create_offer_status_history
729: ( p_validate => p_validate
730: ,p_effective_date => p_effective_date
731: ,p_offer_status_history_id => l_offer_status_history_id
732: ,p_offer_id => p_offer_id

Line 1468: ,IRC_OFFER_STATUS_HISTORY otherhistory

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 (
1470: -- Other Extended Offers
1471: otheroffer.offer_status = 'EXTENDED'
1472: OR

Line 1496: FROM irc_offer_status_history iosh1

1492: AND decode(hr_general.get_xbg_profile,'Y', otherasg.business_group_id , hr_general.get_business_group_id) = otherasg.business_group_id
1493: AND otheroffer.offer_id = otherhistory.offer_id
1494: AND NOT EXISTS
1495: (SELECT 1
1496: FROM irc_offer_status_history iosh1
1497: WHERE iosh1.offer_id = otherhistory.offer_id
1498: AND iosh1.status_change_date > otherhistory.status_change_date
1499: )
1500: AND otherhistory.offer_status_history_id =

Line 1502: FROM irc_offer_status_history iosh2

1498: AND iosh1.status_change_date > otherhistory.status_change_date
1499: )
1500: AND otherhistory.offer_status_history_id =
1501: (SELECT MAX(iosh2.offer_status_history_id)
1502: FROM irc_offer_status_history iosh2
1503: WHERE iosh2.offer_id = otherhistory.offer_id
1504: AND iosh2.status_change_date = otherhistory.status_change_date
1505: );
1506: --

Line 1718: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

1714: l_effective_date date;
1715: l_expiry_date irc_offers.expiry_date%TYPE;
1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1717: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1718: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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;

Line 1720: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

1716: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
1717: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
1718: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%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: --

Line 1721: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

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

Line 1955: irc_offer_status_history_api.create_offer_status_history

1951: --
1952: -- Create offer history record for the newly created
1953: -- Offer record.
1954: --
1955: irc_offer_status_history_api.create_offer_status_history
1956: ( p_validate => p_validate
1957: , p_effective_date => l_effective_date
1958: , p_offer_status_history_id => l_offer_status_history_id
1959: , p_offer_id => l_offer_id

Line 2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

2148: l_expiry_date irc_offers.expiry_date%TYPE;
2149: l_prev_expiry_date irc_offers.expiry_date%TYPE;
2150: l_proposed_start_date irc_offers.proposed_start_date%TYPE;
2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

Line 2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2158: l_mutiple_fields_updated boolean;
2159: l_offer_version irc_offers.offer_version%TYPE;
2160: l_offer_status irc_offers.offer_status%TYPE := p_offer_status;

Line 2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2158: l_mutiple_fields_updated boolean;
2159: l_offer_version irc_offers.offer_version%TYPE;
2160: l_offer_status irc_offers.offer_status%TYPE := p_offer_status;
2161: l_offer_assignment_id irc_offers.offer_assignment_id%TYPE;

Line 2180: l_prev_offer_change_reason irc_offer_status_history.change_reason%TYPE;

2176: l_offer_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE;
2177: l_offer_postal_service irc_offers.offer_postal_service%TYPE;
2178: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2179: l_prev_offer_ovn irc_offers.object_version_number%TYPE;
2180: l_prev_offer_change_reason irc_offer_status_history.change_reason%TYPE;
2181: --
2182: -- Declare cursors
2183: --
2184: cursor csr_prev_offer_details is

Line 2204: from irc_offer_status_history HISTORY

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
2204: from irc_offer_status_history HISTORY
2205: where HISTORY.offer_id = p_offer_id
2206: and NOT EXISTS
2207: (SELECT 1
2208: FROM irc_offer_status_history iosh1

Line 2208: FROM irc_offer_status_history iosh1

2204: from irc_offer_status_history HISTORY
2205: where HISTORY.offer_id = p_offer_id
2206: and NOT EXISTS
2207: (SELECT 1
2208: FROM irc_offer_status_history iosh1
2209: WHERE iosh1.offer_id = HISTORY.offer_id
2210: AND iosh1.status_change_date > HISTORY.status_change_date
2211: )
2212: AND HISTORY.offer_status_history_id =

Line 2214: FROM irc_offer_status_history iosh2

2210: AND iosh1.status_change_date > HISTORY.status_change_date
2211: )
2212: AND HISTORY.offer_status_history_id =
2213: (SELECT MAX(iosh2.offer_status_history_id)
2214: FROM irc_offer_status_history iosh2
2215: WHERE iosh2.offer_id = HISTORY.offer_id
2216: AND iosh2.status_change_date = HISTORY.status_change_date
2217: );
2218: --

Line 2221: from irc_offer_status_history

2217: );
2218: --
2219: cursor csr_offer_status_history_dets(p_status_history_id number) is
2220: select change_reason
2221: from irc_offer_status_history
2222: where offer_status_history_id = p_status_history_id;
2223: --
2224: cursor csr_offer_record is
2225: select

Line 3169: irc_offer_status_history_api.create_offer_status_history

3165: then
3166: --
3167: hr_utility.set_location(l_proc,140);
3168: --
3169: irc_offer_status_history_api.create_offer_status_history
3170: ( p_validate => p_validate
3171: , p_effective_date => l_effective_date
3172: , p_offer_status_history_id => l_offer_status_history_id
3173: , p_offer_id => p_offer_id

Line 3271: irc_offer_status_history_api.update_offer_status_history

3267: --
3268: end if;
3269: close csr_offer_status_history_id;
3270: --
3271: irc_offer_status_history_api.update_offer_status_history
3272: ( p_validate => p_validate
3273: , p_effective_date => l_effective_date
3274: , p_offer_status_history_id => l_offer_status_history_id
3275: , p_offer_id => p_offer_id

Line 3518: -- Also delete the irc_offer_status_history record.

3514: --
3515: -- Process Logic
3516: --
3517: --
3518: -- Also delete the irc_offer_status_history record.
3519: --
3520: irc_offer_status_history_api.delete_offer_status_history
3521: (
3522: p_validate => p_validate

Line 3520: irc_offer_status_history_api.delete_offer_status_history

3516: --
3517: --
3518: -- Also delete the irc_offer_status_history record.
3519: --
3520: irc_offer_status_history_api.delete_offer_status_history
3521: (
3522: p_validate => p_validate
3523: ,p_offer_id => p_offer_id
3524: ,p_effective_date => l_effective_date

Line 3661: l_change_reason irc_offer_status_history.change_reason%TYPE;

3657: ( P_EFFECTIVE_DATE IN date
3658: ,P_APPLICANT_ASSIGNMENT_ID IN number
3659: ) RETURN VARCHAR2 Is
3660: l_proc varchar2(72) := g_package||'get_offer_close_reason';
3661: l_change_reason irc_offer_status_history.change_reason%TYPE;
3662: l_manager_terminates varchar2(1);
3663: l_user_id varchar2(250);
3664: --
3665: CURSOR csr_applicant_userid

Line 3751: l_change_reason irc_offer_status_history.change_reason%TYPE;

3747: l_prev_offer_status irc_offers.offer_status%TYPE;
3748: l_offer_version irc_offers.offer_version%TYPE;
3749: l_offer_assignment_exists boolean := true;
3750: l_iof_object_version_number irc_offers.object_version_number%TYPE;
3751: l_change_reason irc_offer_status_history.change_reason%TYPE;
3752: -- Date variables
3753: l_effective_date date;
3754: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
3755: -- Cursors

Line 3754: l_status_change_date irc_offer_status_history.status_change_date%TYPE;

3750: l_iof_object_version_number irc_offers.object_version_number%TYPE;
3751: l_change_reason irc_offer_status_history.change_reason%TYPE;
3752: -- Date variables
3753: l_effective_date date;
3754: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
3755: -- Cursors
3756: cursor csr_offer_assignment_1 is
3757: select offer_assignment_id
3758: ,offer_id

Line 4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;

4039: l_proc varchar2(72) := g_package||'release_offer';
4040: l_prev_offer_status irc_offers.offer_status%TYPE;
4041: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
4042: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4046: l_offer_version irc_offers.offer_version%TYPE;
4047: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

Line 4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;

4040: l_prev_offer_status irc_offers.offer_status%TYPE;
4041: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
4042: l_prev_applicant_assignment_id irc_offers.applicant_assignment_id%TYPE;
4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4046: l_offer_version irc_offers.offer_version%TYPE;
4047: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
4048: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

Line 4047: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;

4043: l_prev_to_prev_change_reason irc_offer_status_history.change_reason%TYPE;
4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4046: l_offer_version irc_offers.offer_version%TYPE;
4047: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
4048: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
4049: l_other_extended_offer_count number := 0;
4050: l_prev_expiry_date irc_offers.expiry_date%TYPE;
4051: --

Line 4048: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;

4044: l_prev_to_prev_decline_reason irc_offer_status_history.decline_reason%TYPE;
4045: l_offer_id irc_offers.offer_id%TYPE := p_offer_id;
4046: l_offer_version irc_offers.offer_version%TYPE;
4047: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
4048: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
4049: l_other_extended_offer_count number := 0;
4050: l_prev_expiry_date irc_offers.expiry_date%TYPE;
4051: --
4052: cursor csr_prev_to_prev_offer_status is

Line 4056: FROM irc_offer_status_history ios1

4052: cursor csr_prev_to_prev_offer_status is
4053: SELECT ios1.offer_status,
4054: ios1.change_reason,
4055: ios1.decline_reason
4056: FROM irc_offer_status_history ios1
4057: WHERE EXISTS ( SELECT 1
4058: FROM irc_offer_status_history iosh1
4059: WHERE iosh1.offer_id = p_offer_id
4060: AND iosh1.status_change_date > ios1.status_change_date

Line 4058: FROM irc_offer_status_history iosh1

4054: ios1.change_reason,
4055: ios1.decline_reason
4056: FROM irc_offer_status_history ios1
4057: WHERE EXISTS ( SELECT 1
4058: FROM irc_offer_status_history iosh1
4059: WHERE iosh1.offer_id = p_offer_id
4060: AND iosh1.status_change_date > ios1.status_change_date
4061: )
4062: AND ios1.offer_status_history_id = (SELECT MAX(iosh2.offer_status_history_id)

Line 4063: FROM irc_offer_status_history iosh2

4059: WHERE iosh1.offer_id = p_offer_id
4060: AND iosh1.status_change_date > ios1.status_change_date
4061: )
4062: AND ios1.offer_status_history_id = (SELECT MAX(iosh2.offer_status_history_id)
4063: FROM irc_offer_status_history iosh2
4064: WHERE iosh2.offer_id = p_offer_id
4065: AND iosh2.status_change_date = ios1.status_change_date
4066: )
4067: AND 1 =

Line 4069: FROM irc_offer_status_history ios3

4065: AND iosh2.status_change_date = ios1.status_change_date
4066: )
4067: AND 1 =
4068: (SELECT COUNT(*)
4069: FROM irc_offer_status_history ios3
4070: WHERE ios3.offer_id = p_offer_id
4071: AND ios3.status_change_date > ios1.status_change_date
4072: );
4073: --

Line 4192: irc_offer_status_history_api.create_offer_status_history

4188: );
4189: --
4190: -- Create the offer status history record with the details
4191: --
4192: irc_offer_status_history_api.create_offer_status_history
4193: ( p_validate => p_validate
4194: , p_effective_date => p_effective_date
4195: , p_offer_id => l_offer_id
4196: , p_offer_status => l_prev_to_prev_offer_status