1: Package Body irc_offers_swi As
2: /* $Header: iriofswi.pkb 120.34 2011/02/03 09:34:37 amikukum ship $ */
3: --
4: -- Package variables
5: --
2: /* $Header: iriofswi.pkb 120.34 2011/02/03 09:34:37 amikukum ship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'irc_offers_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------------< create_offer >-----------------------------|
10: -- ----------------------------------------------------------------------------
98: );
99: --
100: -- Call API
101: --
102: irc_offers_api.create_offer
103: (p_validate => l_validate
104: ,p_effective_date => p_effective_date
105: ,p_offer_status => p_offer_status
106: ,p_discretionary_job_title => p_discretionary_job_title
304: --
305: --
306: -- Call API
307: --
308: irc_offers_api.update_offer
309: (p_validate => l_validate
310: ,p_effective_date => p_effective_date
311: ,p_offer_status => p_offer_status
312: ,p_discretionary_job_title => p_discretionary_job_title
457: --
458: --
459: -- Call API
460: --
461: irc_offers_api.delete_offer
462: (p_validate => l_validate
463: ,p_object_version_number => p_object_version_number
464: ,p_offer_id => p_offer_id
465: ,p_effective_date => p_effective_date
558: --
559: --
560: -- Call API
561: --
562: irc_offers_api.close_offer
563: (p_validate => l_validate
564: ,p_effective_date => p_effective_date
565: ,p_applicant_assignment_id => p_applicant_assignment_id
566: ,p_offer_id => p_offer_id
665: --
666: --
667: -- Call API
668: --
669: irc_offers_api.hold_offer
670: (p_validate => l_validate
671: ,p_effective_date => p_effective_date
672: ,p_offer_id => p_offer_id
673: ,p_respondent_id => p_respondent_id
773: --
774: --
775: -- Call API
776: --
777: irc_offers_api.release_offer
778: (p_validate => l_validate
779: ,p_effective_date => p_effective_date
780: ,p_offer_id => p_offer_id
781: ,p_respondent_id => p_respondent_id
997: );
998: --
999: -- Call API
1000: --
1001: irc_offers_api.create_offer_assignment
1002: (p_assignment_id => p_assignment_id
1003: ,p_effective_start_date => p_effective_start_date
1004: ,p_effective_end_date => p_effective_end_date
1005: ,p_business_group_id => p_business_group_id
1362: --
1363: --
1364: -- Call API
1365: --
1366: irc_offers_api.update_offer_assignment
1367: (p_assignment_id => p_assignment_id
1368: ,p_effective_start_date => p_effective_start_date
1369: ,p_effective_end_date => p_effective_end_date
1370: ,p_business_group_id => p_business_group_id
1623: --
1624: --
1625: -- Call API
1626: --
1627: irc_offers_api.delete_offer_assignment
1628: (p_validate => l_validate
1629: ,p_effective_date => p_effective_date
1630: ,p_offer_assignment_id => p_offer_assignment_id
1631: );
1718: --
1719: --
1720: -- Call API
1721: --
1722: irc_offers_api.upload_offer_letter
1723: (p_validate => l_validate
1724: ,p_offer_letter => p_offer_letter
1725: ,p_offer_id => p_offer_id
1726: ,p_object_version_number => p_object_version_number
2497: l_effective_date date := trunc(sysdate);
2498: --
2499: cursor current_offer_ovn(p_offer_id NUMBER) is
2500: select object_version_number
2501: from irc_offers
2502: where offer_id = p_offer_id;
2503: --
2504:
2505: BEGIN
2859: ,offer_status
2860: ,applicant_assignment_id
2861: ,expiry_date
2862: ,object_version_number
2863: from hr_api_transactions hrt, irc_offers iro
2864: where hrt.transaction_id = p_transaction_id
2865: and hrt.transaction_ref_id = iro.offer_id;
2866: --
2867: cursor csr_offer_history_details(p_offer_id number) is
3232: --
3233: end clear_global_data;
3234: --
3235: --
3236: end irc_offers_swi;