PACKAGE BODY: APPS.IRC_ASG_STATUS_BK1

Source

1 package body IRC_ASG_STATUS_BK1 as
2 /* $Header: iriasapi.pkb 120.13 2011/05/10 13:54:00 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2012/11/27 03:53:06 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_IRC_ASG_STATUS_A
6 (P_ASSIGNMENT_ID in NUMBER
7 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
8 ,P_STATUS_CHANGE_REASON in VARCHAR2
9 ,P_ASSIGNMENT_STATUS_ID in NUMBER
10 ,P_OBJECT_VERSION_NUMBER in NUMBER
11 ,P_STATUS_CHANGE_DATE in DATE
12 ,P_STATUS_CHANGE_COMMENTS in VARCHAR2
13 ,P_STATUS_CHANGE_BY in VARCHAR2
14 )is
15 l_commit_unit_number number;
16 l_legislation_code   varchar2(30);
17 begin
18 hr_utility.set_location('Entering: IRC_ASG_STATUS_BK1.CREATE_IRC_ASG_STATUS_A', 10);
19 l_commit_unit_number := hr_api.return_commit_unit;
20 if hr_api.call_app_hooks then
21 irc_asg_status_be1.CREATE_IRC_ASG_STATUS_A
22 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
23 ,P_ASSIGNMENT_STATUS_TYPE_ID => P_ASSIGNMENT_STATUS_TYPE_ID
24 ,P_STATUS_CHANGE_REASON => P_STATUS_CHANGE_REASON
25 ,P_ASSIGNMENT_STATUS_ID => P_ASSIGNMENT_STATUS_ID
26 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
27 ,P_STATUS_CHANGE_DATE => P_STATUS_CHANGE_DATE
28 ,P_STATUS_CHANGE_COMMENTS => P_STATUS_CHANGE_COMMENTS
29 ,P_STATUS_CHANGE_BY => P_STATUS_CHANGE_BY
30 );
31 end if;
32 hr_multi_message.end_validation_set;
33 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_IRC_ASG_STATUS', 'AP');
34 hr_utility.set_location(' Leaving: IRC_ASG_STATUS_BK1.CREATE_IRC_ASG_STATUS_A', 20);
35 end CREATE_IRC_ASG_STATUS_A;
36 procedure CREATE_IRC_ASG_STATUS_B
37 (P_ASSIGNMENT_ID in NUMBER
38 ,P_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
39 ,P_STATUS_CHANGE_REASON in VARCHAR2
40 ,P_STATUS_CHANGE_DATE in DATE
41 ,P_STATUS_CHANGE_COMMENTS in VARCHAR2
42 ,P_STATUS_CHANGE_BY in VARCHAR2
43 )is
44 begin
45 hr_utility.set_location('Entering: IRC_ASG_STATUS_BK1.CREATE_IRC_ASG_STATUS_B', 10);
46 hr_utility.set_location(' Leaving: IRC_ASG_STATUS_BK1.CREATE_IRC_ASG_STATUS_B', 20);
47 end CREATE_IRC_ASG_STATUS_B;
48 end IRC_ASG_STATUS_BK1;