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.

APPS.PER_CNL_DEL dependencies on PER_CNL_SHD

Line 52: (p_rec in per_cnl_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_cnl_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: per_cnl_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: per_cnl_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in per_cnl_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_cnl_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in per_cnl_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in per_cnl_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 166: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code

162: begin
163: --
164: per_cnl_rkd.after_delete
165: (p_location_id => p_rec.location_id
166: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
167: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
168: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
169: ,p_description_o => per_cnl_shd.g_old_rec.description
170: ,p_style_o => per_cnl_shd.g_old_rec.style

Line 167: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context

163: --
164: per_cnl_rkd.after_delete
165: (p_location_id => p_rec.location_id
166: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
167: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
168: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
169: ,p_description_o => per_cnl_shd.g_old_rec.description
170: ,p_style_o => per_cnl_shd.g_old_rec.style
171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1

Line 168: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code

164: per_cnl_rkd.after_delete
165: (p_location_id => p_rec.location_id
166: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
167: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
168: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
169: ,p_description_o => per_cnl_shd.g_old_rec.description
170: ,p_style_o => per_cnl_shd.g_old_rec.style
171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2

Line 169: ,p_description_o => per_cnl_shd.g_old_rec.description

165: (p_location_id => p_rec.location_id
166: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
167: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
168: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
169: ,p_description_o => per_cnl_shd.g_old_rec.description
170: ,p_style_o => per_cnl_shd.g_old_rec.style
171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3

Line 170: ,p_style_o => per_cnl_shd.g_old_rec.style

166: ,p_configuration_code_o => per_cnl_shd.g_old_rec.configuration_code
167: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
168: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
169: ,p_description_o => per_cnl_shd.g_old_rec.description
170: ,p_style_o => per_cnl_shd.g_old_rec.style
171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city

Line 171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1

167: ,p_configuration_context_o => per_cnl_shd.g_old_rec.configuration_context
168: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
169: ,p_description_o => per_cnl_shd.g_old_rec.description
170: ,p_style_o => per_cnl_shd.g_old_rec.style
171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
175: ,p_country_o => per_cnl_shd.g_old_rec.country

Line 172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2

168: ,p_location_code_o => per_cnl_shd.g_old_rec.location_code
169: ,p_description_o => per_cnl_shd.g_old_rec.description
170: ,p_style_o => per_cnl_shd.g_old_rec.style
171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
175: ,p_country_o => per_cnl_shd.g_old_rec.country
176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code

Line 173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3

169: ,p_description_o => per_cnl_shd.g_old_rec.description
170: ,p_style_o => per_cnl_shd.g_old_rec.style
171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
175: ,p_country_o => per_cnl_shd.g_old_rec.country
176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1

Line 174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city

170: ,p_style_o => per_cnl_shd.g_old_rec.style
171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
175: ,p_country_o => per_cnl_shd.g_old_rec.country
176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2

Line 175: ,p_country_o => per_cnl_shd.g_old_rec.country

171: ,p_address_line_1_o => per_cnl_shd.g_old_rec.address_line_1
172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
175: ,p_country_o => per_cnl_shd.g_old_rec.country
176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3

Line 176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code

172: ,p_address_line_2_o => per_cnl_shd.g_old_rec.address_line_2
173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
175: ,p_country_o => per_cnl_shd.g_old_rec.country
176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1

Line 177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1

173: ,p_address_line_3_o => per_cnl_shd.g_old_rec.address_line_3
174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
175: ,p_country_o => per_cnl_shd.g_old_rec.country
176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2

Line 178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2

174: ,p_town_or_city_o => per_cnl_shd.g_old_rec.town_or_city
175: ,p_country_o => per_cnl_shd.g_old_rec.country
176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3

Line 179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3

175: ,p_country_o => per_cnl_shd.g_old_rec.country
176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13

Line 180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1

176: ,p_postal_code_o => per_cnl_shd.g_old_rec.postal_code
177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14

Line 181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2

177: ,p_region_1_o => per_cnl_shd.g_old_rec.region_1
178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15

Line 182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3

178: ,p_region_2_o => per_cnl_shd.g_old_rec.region_2
179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16

Line 183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13

179: ,p_region_3_o => per_cnl_shd.g_old_rec.region_3
180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17

Line 184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14

180: ,p_telephone_number_1_o => per_cnl_shd.g_old_rec.telephone_number_1
181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18

Line 185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15

181: ,p_telephone_number_2_o => per_cnl_shd.g_old_rec.telephone_number_2
182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
189: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19

Line 186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16

182: ,p_telephone_number_3_o => per_cnl_shd.g_old_rec.telephone_number_3
183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
189: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
190: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20

Line 187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17

183: ,p_loc_information13_o => per_cnl_shd.g_old_rec.loc_information13
184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
189: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
190: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
191: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number

Line 188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18

184: ,p_loc_information14_o => per_cnl_shd.g_old_rec.loc_information14
185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
189: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
190: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
191: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number
192: );

Line 189: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19

185: ,p_loc_information15_o => per_cnl_shd.g_old_rec.loc_information15
186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
189: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
190: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
191: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number
192: );
193: --

Line 190: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20

186: ,p_loc_information16_o => per_cnl_shd.g_old_rec.loc_information16
187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
189: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
190: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
191: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number
192: );
193: --
194: exception

Line 191: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number

187: ,p_loc_information17_o => per_cnl_shd.g_old_rec.loc_information17
188: ,p_loc_information18_o => per_cnl_shd.g_old_rec.loc_information18
189: ,p_loc_information19_o => per_cnl_shd.g_old_rec.loc_information19
190: ,p_loc_information20_o => per_cnl_shd.g_old_rec.loc_information20
191: ,p_object_version_number_o => per_cnl_shd.g_old_rec.object_version_number
192: );
193: --
194: exception
195: --

Line 211: (p_rec in per_cnl_shd.g_rec_type

207: -- ----------------------------------------------------------------------------
208: -- |---------------------------------< del >----------------------------------|
209: -- ----------------------------------------------------------------------------
210: Procedure del
211: (p_rec in per_cnl_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'del';
215: --

Line 221: per_cnl_shd.lck

217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: -- We must lock the row which we need to delete.
220: --
221: per_cnl_shd.lck
222: (p_rec.location_id
223: ,p_rec.object_version_number
224: );
225: --

Line 258: l_rec per_cnl_shd.g_rec_type;

254: (p_location_id in number
255: ,p_object_version_number in number
256: ) is
257: --
258: l_rec per_cnl_shd.g_rec_type;
259: l_proc varchar2(72) := g_package||'del';
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);