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_SWI dependencies on IRC_OFFERS

Line 1: Package Body irc_offers_swi As

1: Package Body irc_offers_swi As
2: /* $Header: iriofswi.pkb 120.24.12010000.3 2009/01/07 15:24:36 avarri ship $ */
3: --
4: -- Package variables
5: --

Line 6: g_package varchar2(33) := 'irc_offers_swi.';

2: /* $Header: iriofswi.pkb 120.24.12010000.3 2009/01/07 15:24:36 avarri ship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'irc_offers_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------------< create_offer >-----------------------------|
10: -- ----------------------------------------------------------------------------

Line 100: irc_offers_api.create_offer

96: );
97: --
98: -- Call API
99: --
100: irc_offers_api.create_offer
101: (p_validate => l_validate
102: ,p_effective_date => p_effective_date
103: ,p_offer_status => p_offer_status
104: ,p_discretionary_job_title => p_discretionary_job_title

Line 304: irc_offers_api.update_offer

300: --
301: --
302: -- Call API
303: --
304: irc_offers_api.update_offer
305: (p_validate => l_validate
306: ,p_effective_date => p_effective_date
307: ,p_offer_status => p_offer_status
308: ,p_discretionary_job_title => p_discretionary_job_title

Line 457: irc_offers_api.delete_offer

453: --
454: --
455: -- Call API
456: --
457: irc_offers_api.delete_offer
458: (p_validate => l_validate
459: ,p_object_version_number => p_object_version_number
460: ,p_offer_id => p_offer_id
461: ,p_effective_date => p_effective_date

Line 558: irc_offers_api.close_offer

554: --
555: --
556: -- Call API
557: --
558: irc_offers_api.close_offer
559: (p_validate => l_validate
560: ,p_effective_date => p_effective_date
561: ,p_applicant_assignment_id => p_applicant_assignment_id
562: ,p_offer_id => p_offer_id

Line 665: irc_offers_api.hold_offer

661: --
662: --
663: -- Call API
664: --
665: irc_offers_api.hold_offer
666: (p_validate => l_validate
667: ,p_effective_date => p_effective_date
668: ,p_offer_id => p_offer_id
669: ,p_respondent_id => p_respondent_id

Line 773: irc_offers_api.release_offer

769: --
770: --
771: -- Call API
772: --
773: irc_offers_api.release_offer
774: (p_validate => l_validate
775: ,p_effective_date => p_effective_date
776: ,p_offer_id => p_offer_id
777: ,p_respondent_id => p_respondent_id

Line 997: irc_offers_api.create_offer_assignment

993: );
994: --
995: -- Call API
996: --
997: irc_offers_api.create_offer_assignment
998: (p_assignment_id => p_assignment_id
999: ,p_effective_start_date => p_effective_start_date
1000: ,p_effective_end_date => p_effective_end_date
1001: ,p_business_group_id => p_business_group_id

Line 1362: irc_offers_api.update_offer_assignment

1358: --
1359: --
1360: -- Call API
1361: --
1362: irc_offers_api.update_offer_assignment
1363: (p_assignment_id => p_assignment_id
1364: ,p_effective_start_date => p_effective_start_date
1365: ,p_effective_end_date => p_effective_end_date
1366: ,p_business_group_id => p_business_group_id

Line 1623: irc_offers_api.delete_offer_assignment

1619: --
1620: --
1621: -- Call API
1622: --
1623: irc_offers_api.delete_offer_assignment
1624: (p_validate => l_validate
1625: ,p_effective_date => p_effective_date
1626: ,p_offer_assignment_id => p_offer_assignment_id
1627: );

Line 1718: irc_offers_api.upload_offer_letter

1714: --
1715: --
1716: -- Call API
1717: --
1718: irc_offers_api.upload_offer_letter
1719: (p_validate => l_validate
1720: ,p_offer_letter => p_offer_letter
1721: ,p_offer_id => p_offer_id
1722: ,p_object_version_number => p_object_version_number

Line 2497: from irc_offers

2493: l_effective_date date := trunc(sysdate);
2494: --
2495: cursor current_offer_ovn(p_offer_id NUMBER) is
2496: select object_version_number
2497: from irc_offers
2498: where offer_id = p_offer_id;
2499: --
2500:
2501: BEGIN

Line 2859: from hr_api_transactions hrt, irc_offers iro

2855: ,offer_status
2856: ,applicant_assignment_id
2857: ,expiry_date
2858: ,object_version_number
2859: from hr_api_transactions hrt, irc_offers iro
2860: where hrt.transaction_id = p_transaction_id
2861: and hrt.transaction_ref_id = iro.offer_id;
2862: --
2863: cursor csr_offer_history_details(p_offer_id number) is

Line 3175: end irc_offers_swi;

3171: commit;
3172: hr_utility.set_location(' Exiting:' || l_proc,20);
3173: end;
3174:
3175: end irc_offers_swi;