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.
PACKAGE BODY: APPS.PER_ADD_RKI

Source


1 package body PER_ADD_RKI as
2 /* $Header: peaddrhi.pkb 120.8 2011/11/15 11:36:00 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2012/11/27 04:02:27 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_INSERT
6 (P_ADDRESS_ID in NUMBER
7 ,P_BUSINESS_GROUP_ID in NUMBER
8 ,P_PERSON_ID in NUMBER
9 ,P_DATE_FROM in DATE
10 ,P_PRIMARY_FLAG in VARCHAR2
11 ,P_STYLE in VARCHAR2
12 ,P_ADDRESS_LINE1 in VARCHAR2
13 ,P_ADDRESS_LINE2 in VARCHAR2
14 ,P_ADDRESS_LINE3 in VARCHAR2
15 ,P_ADDRESS_TYPE in VARCHAR2
16 ,P_COMMENTS in CLOB
17 ,P_COUNTRY in VARCHAR2
18 ,P_DATE_TO in DATE
19 ,P_POSTAL_CODE in VARCHAR2
20 ,P_REGION_1 in VARCHAR2
21 ,P_REGION_2 in VARCHAR2
22 ,P_REGION_3 in VARCHAR2
23 ,P_TELEPHONE_NUMBER_1 in VARCHAR2
24 ,P_TELEPHONE_NUMBER_2 in VARCHAR2
25 ,P_TELEPHONE_NUMBER_3 in VARCHAR2
26 ,P_TOWN_OR_CITY in VARCHAR2
27 ,P_REQUEST_ID in NUMBER
28 ,P_PROGRAM_APPLICATION_ID in NUMBER
29 ,P_PROGRAM_ID in NUMBER
30 ,P_PROGRAM_UPDATE_DATE in DATE
31 ,P_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2
32 ,P_ADDR_ATTRIBUTE1 in VARCHAR2
33 ,P_ADDR_ATTRIBUTE2 in VARCHAR2
34 ,P_ADDR_ATTRIBUTE3 in VARCHAR2
35 ,P_ADDR_ATTRIBUTE4 in VARCHAR2
36 ,P_ADDR_ATTRIBUTE5 in VARCHAR2
37 ,P_ADDR_ATTRIBUTE6 in VARCHAR2
38 ,P_ADDR_ATTRIBUTE7 in VARCHAR2
39 ,P_ADDR_ATTRIBUTE8 in VARCHAR2
40 ,P_ADDR_ATTRIBUTE9 in VARCHAR2
41 ,P_ADDR_ATTRIBUTE10 in VARCHAR2
42 ,P_ADDR_ATTRIBUTE11 in VARCHAR2
43 ,P_ADDR_ATTRIBUTE12 in VARCHAR2
44 ,P_ADDR_ATTRIBUTE13 in VARCHAR2
45 ,P_ADDR_ATTRIBUTE14 in VARCHAR2
46 ,P_ADDR_ATTRIBUTE15 in VARCHAR2
47 ,P_ADDR_ATTRIBUTE16 in VARCHAR2
48 ,P_ADDR_ATTRIBUTE17 in VARCHAR2
49 ,P_ADDR_ATTRIBUTE18 in VARCHAR2
50 ,P_ADDR_ATTRIBUTE19 in VARCHAR2
51 ,P_ADDR_ATTRIBUTE20 in VARCHAR2
52 ,P_ADD_INFORMATION13 in VARCHAR2
53 ,P_ADD_INFORMATION14 in VARCHAR2
54 ,P_ADD_INFORMATION15 in VARCHAR2
55 ,P_ADD_INFORMATION16 in VARCHAR2
56 ,P_ADD_INFORMATION17 in VARCHAR2
57 ,P_ADD_INFORMATION18 in VARCHAR2
58 ,P_ADD_INFORMATION19 in VARCHAR2
59 ,P_ADD_INFORMATION20 in VARCHAR2
60 ,P_OBJECT_VERSION_NUMBER in NUMBER
61 ,P_EFFECTIVE_DATE in DATE
62 ,P_VALIDATE_COUNTY in BOOLEAN
63 ,P_PARTY_ID in NUMBER
64 )is
65 l_commit_unit_number number;
66 l_legislation_code   varchar2(30);
67 begin
68 hr_utility.set_location('Entering: PER_ADD_RKI.AFTER_INSERT', 10);
69 l_commit_unit_number := hr_api.return_commit_unit;
70 if hr_api.call_app_hooks then
71 PQP_Address_Synchronization.ADDR_DDF_INS
72 (P_ADDRESS_ID => P_ADDRESS_ID
73 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
74 ,P_PERSON_ID => P_PERSON_ID
75 ,P_PARTY_ID => P_PARTY_ID
76 ,P_DATE_FROM => P_DATE_FROM
77 ,P_PRIMARY_FLAG => P_PRIMARY_FLAG
78 ,P_STYLE => P_STYLE
79 ,P_ADDRESS_LINE1 => P_ADDRESS_LINE1
80 ,P_ADDRESS_LINE2 => P_ADDRESS_LINE2
81 ,P_ADDRESS_LINE3 => P_ADDRESS_LINE3
82 ,P_ADDRESS_TYPE => P_ADDRESS_TYPE
83 ,P_COUNTRY => P_COUNTRY
84 ,P_DATE_TO => P_DATE_TO
85 ,P_POSTAL_CODE => P_POSTAL_CODE
86 ,P_REGION_1 => P_REGION_1
87 ,P_REGION_2 => P_REGION_2
88 ,P_REGION_3 => P_REGION_3
89 ,P_TELEPHONE_NUMBER_1 => P_TELEPHONE_NUMBER_1
90 ,P_TELEPHONE_NUMBER_2 => P_TELEPHONE_NUMBER_2
91 ,P_TELEPHONE_NUMBER_3 => P_TELEPHONE_NUMBER_3
92 ,P_TOWN_OR_CITY => P_TOWN_OR_CITY
93 ,P_ADD_INFORMATION13 => P_ADD_INFORMATION13
94 ,P_ADD_INFORMATION14 => P_ADD_INFORMATION14
95 ,P_ADD_INFORMATION15 => P_ADD_INFORMATION15
96 ,P_ADD_INFORMATION16 => P_ADD_INFORMATION16
97 ,P_ADD_INFORMATION17 => P_ADD_INFORMATION17
98 ,P_ADD_INFORMATION18 => P_ADD_INFORMATION18
99 ,P_ADD_INFORMATION19 => P_ADD_INFORMATION19
100 ,P_ADD_INFORMATION20 => P_ADD_INFORMATION20
101 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
102 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
103 ,P_VALIDATE_COUNTY => P_VALIDATE_COUNTY
104 );
105 end if;
106 if hr_api.call_leg_hooks then
107 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
108 if l_legislation_code = 'IN' then
109 PER_IN_ADD_LEG_HOOK.CHECK_PER_ADDRESS_INS
110 (P_STYLE => P_STYLE
111 ,P_ADDRESS_ID => P_ADDRESS_ID
112 ,P_ADD_INFORMATION14 => P_ADD_INFORMATION14
113 ,P_ADD_INFORMATION15 => P_ADD_INFORMATION15
114 ,P_POSTAL_CODE => P_POSTAL_CODE
115 );
116 elsif l_legislation_code = 'KR' then
117 PER_KR_ADDRESS_UPDATE_HOOK_PKG.UPDATE_ADDRESS_LINE1_AI
118 (P_ADDRESS_ID => P_ADDRESS_ID
119 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
120 ,P_PERSON_ID => P_PERSON_ID
121 ,P_STYLE => P_STYLE
122 ,P_ADD_INFORMATION17 => P_ADD_INFORMATION17
123 );
124 end if;
125 end if;
126 hr_api.validate_commit_unit(l_commit_unit_number, 'PER_ADDRESSES', 'AI');
127 hr_utility.set_location(' Leaving: PER_ADD_RKI.AFTER_INSERT', 20);
128 end AFTER_INSERT;
129 end PER_ADD_RKI;