PACKAGE BODY: APPS.BEN_XCL_RKI

Source

1 package body ben_xcl_RKI as
2 /* $Header: bexclrhi.pkb 115.7 2002/12/24 21:28:21 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2008/11/06 01:54:44 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_INSERT
6 (P_EXT_CHG_EVT_LOG_ID in NUMBER
7 ,P_CHG_EVT_CD in VARCHAR2
8 ,P_CHG_EFF_DT in DATE
9 ,P_CHG_USER_ID in NUMBER
10 ,P_PRMTR_01 in VARCHAR2
11 ,P_PRMTR_02 in VARCHAR2
12 ,P_PRMTR_03 in VARCHAR2
13 ,P_PRMTR_04 in VARCHAR2
14 ,P_PRMTR_05 in VARCHAR2
15 ,P_PRMTR_06 in VARCHAR2
16 ,P_PRMTR_07 in VARCHAR2
17 ,P_PRMTR_08 in VARCHAR2
18 ,P_PRMTR_09 in VARCHAR2
19 ,P_PRMTR_10 in VARCHAR2
20 ,P_PERSON_ID in NUMBER
21 ,P_BUSINESS_GROUP_ID in NUMBER
22 ,P_OBJECT_VERSION_NUMBER in NUMBER
23 ,P_EFFECTIVE_DATE in DATE
24 ,P_CHG_ACTL_DT in DATE
25 ,P_NEW_VAL1 in VARCHAR2
26 ,P_NEW_VAL2 in VARCHAR2
27 ,P_NEW_VAL3 in VARCHAR2
28 ,P_NEW_VAL4 in VARCHAR2
29 ,P_NEW_VAL5 in VARCHAR2
30 ,P_NEW_VAL6 in VARCHAR2
31 ,P_OLD_VAL1 in VARCHAR2
32 ,P_OLD_VAL2 in VARCHAR2
33 ,P_OLD_VAL3 in VARCHAR2
34 ,P_OLD_VAL4 in VARCHAR2
35 ,P_OLD_VAL5 in VARCHAR2
36 ,P_OLD_VAL6 in VARCHAR2
37 )is
38 l_commit_unit_number number;
39 l_legislation_code   varchar2(30);
40 begin
41 hr_utility.set_location('Entering: ben_xcl_RKI.AFTER_INSERT', 10);
42 l_commit_unit_number := hr_api.return_commit_unit;
43 if hr_api.call_leg_hooks then
44 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
45 if l_legislation_code = 'NL' then
46 PQP_NL_ABP_FUNCTIONS.UPD_CHG_EVT
47 (P_EXT_CHG_EVT_LOG_ID => P_EXT_CHG_EVT_LOG_ID
48 ,P_CHG_EVT_CD => P_CHG_EVT_CD
49 ,P_CHG_EFF_DT => P_CHG_EFF_DT
50 ,P_CHG_USER_ID => P_CHG_USER_ID
51 ,P_PRMTR_01 => P_PRMTR_01
52 ,P_PRMTR_02 => P_PRMTR_02
53 ,P_PRMTR_03 => P_PRMTR_03
54 ,P_PRMTR_04 => P_PRMTR_04
55 ,P_PRMTR_05 => P_PRMTR_05
56 ,P_PRMTR_06 => P_PRMTR_06
57 ,P_PRMTR_07 => P_PRMTR_07
58 ,P_PRMTR_08 => P_PRMTR_08
59 ,P_PRMTR_09 => P_PRMTR_09
60 ,P_PRMTR_10 => P_PRMTR_10
61 ,P_PERSON_ID => P_PERSON_ID
62 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
63 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
64 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
65 ,P_CHG_ACTL_DT => P_CHG_ACTL_DT
66 ,P_NEW_VAL1 => P_NEW_VAL1
67 ,P_NEW_VAL2 => P_NEW_VAL2
68 ,P_NEW_VAL3 => P_NEW_VAL3
69 ,P_NEW_VAL4 => P_NEW_VAL4
70 ,P_NEW_VAL5 => P_NEW_VAL5
71 ,P_NEW_VAL6 => P_NEW_VAL6
72 ,P_OLD_VAL1 => P_OLD_VAL1
73 ,P_OLD_VAL2 => P_OLD_VAL2
74 ,P_OLD_VAL3 => P_OLD_VAL3
75 ,P_OLD_VAL4 => P_OLD_VAL4
76 ,P_OLD_VAL5 => P_OLD_VAL5
77 ,P_OLD_VAL6 => P_OLD_VAL6
78 );
79 end if;
80 end if;
81 hr_api.validate_commit_unit(l_commit_unit_number, 'BEN_EXT_CHG_EVT_LOG', 'AI');
82 hr_utility.set_location(' Leaving: ben_xcl_RKI.AFTER_INSERT', 20);
83 end AFTER_INSERT;
84 end ben_xcl_RKI;