PACKAGE BODY: APPS.IRC_OFFER_STATUS_HISTORY_BK2

Source

1 package body IRC_OFFER_STATUS_HISTORY_BK2 as
2 /* $Header: iriosapi.pkb 120.3.12000000.2 2007/06/22 13:37:33 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:31:30 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_OFFER_STATUS_HISTORY_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_OFFER_STATUS_HISTORY_ID in NUMBER
8 ,P_STATUS_CHANGE_DATE in DATE
9 ,P_CHANGE_REASON in VARCHAR2
10 ,P_DECLINE_REASON in VARCHAR2
11 ,P_NOTE_TEXT in VARCHAR2
12 ,P_OBJECT_VERSION_NUMBER in NUMBER
13 )is
14 l_commit_unit_number number;
15 l_legislation_code   varchar2(30);
16 begin
17 hr_utility.set_location('Entering: IRC_OFFER_STATUS_HISTORY_BK2.UPDATE_OFFER_STATUS_HISTORY_A', 10);
18 l_commit_unit_number := hr_api.return_commit_unit;
19 if hr_api.call_app_hooks then
20 irc_offer_status_history_be2.UPDATE_OFFER_STATUS_HISTORY_A
21 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
22 ,P_OFFER_STATUS_HISTORY_ID => P_OFFER_STATUS_HISTORY_ID
23 ,P_STATUS_CHANGE_DATE => P_STATUS_CHANGE_DATE
24 ,P_CHANGE_REASON => P_CHANGE_REASON
25 ,P_DECLINE_REASON => P_DECLINE_REASON
26 ,P_NOTE_TEXT => P_NOTE_TEXT
27 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
28 );
29 end if;
30 hr_multi_message.end_validation_set;
31 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_OFFER_STATUS_HISTORY', 'AP');
32 hr_utility.set_location(' Leaving: IRC_OFFER_STATUS_HISTORY_BK2.UPDATE_OFFER_STATUS_HISTORY_A', 20);
33 end UPDATE_OFFER_STATUS_HISTORY_A;
34 procedure UPDATE_OFFER_STATUS_HISTORY_B
35 (P_EFFECTIVE_DATE in DATE
36 ,P_OFFER_STATUS_HISTORY_ID in NUMBER
37 ,P_STATUS_CHANGE_DATE in DATE
38 ,P_CHANGE_REASON in VARCHAR2
39 ,P_DECLINE_REASON in VARCHAR2
40 ,P_NOTE_TEXT in VARCHAR2
41 )is
42 begin
43 hr_utility.set_location('Entering: IRC_OFFER_STATUS_HISTORY_BK2.UPDATE_OFFER_STATUS_HISTORY_B', 10);
44 hr_utility.set_location(' Leaving: IRC_OFFER_STATUS_HISTORY_BK2.UPDATE_OFFER_STATUS_HISTORY_B', 20);
45 end UPDATE_OFFER_STATUS_HISTORY_B;
46 end IRC_OFFER_STATUS_HISTORY_BK2;