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.PQH_RLS_UPD dependencies on PQH_RLS_SHD

Line 55: ( p_rec in out NOCOPY pqh_rls_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: ( p_rec in out NOCOPY pqh_rls_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 121: pqh_rls_shd.constraint_error

117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: pqh_rls_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --

Line 126: pqh_rls_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --
126: pqh_rls_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --

Line 131: pqh_rls_shd.constraint_error

127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --
131: pqh_rls_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: --
135: Raise;

Line 171: ( p_rec in pqh_rls_shd.g_rec_type

167: --
168: -- {End Of Comments}
169: -- ----------------------------------------------------------------------------
170: Procedure pre_update
171: ( p_rec in pqh_rls_shd.g_rec_type
172: ) is
173: --
174: l_proc varchar2(72) := g_package||'pre_update';
175: --

Line 219: ,p_rec in pqh_rls_shd.g_rec_type

215: -- mvankada
216: -- Added Developer DF columns
217: Procedure post_update
218: (p_effective_date in date
219: ,p_rec in pqh_rls_shd.g_rec_type
220: ) is
221: --
222: l_start_date date := trunc(sysdate);
223: l_expiration_date date := to_date('31/12/4712','DD/MM/RRRR');

Line 269: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name

265: ,p_information27 => p_rec.information27
266: ,p_information28 => p_rec.information28
267: ,p_information29 => p_rec.information29
268: ,p_information30 => p_rec.information30
269: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
270: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
271: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id

Line 270: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd

266: ,p_information28 => p_rec.information28
267: ,p_information29 => p_rec.information29
268: ,p_information30 => p_rec.information30
269: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
270: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
271: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category

Line 271: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag

267: ,p_information29 => p_rec.information29
268: ,p_information30 => p_rec.information30
269: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
270: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
271: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1

Line 272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number

268: ,p_information30 => p_rec.information30
269: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
270: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
271: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2

Line 273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id

269: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
270: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
271: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3

Line 274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category

270: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
271: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4

Line 275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1

271: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5

Line 276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2

272: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6

Line 277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3

273: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7

Line 278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4

274: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8

Line 279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5

275: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9

Line 280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6

276: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10

Line 281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7

277: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11

Line 282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8

278: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12

Line 283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9

279: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13

Line 284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10

280: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14

Line 285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11

281: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15

Line 286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12

282: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16

Line 287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13

283: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17

Line 288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14

284: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18

Line 289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15

285: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19

Line 290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16

286: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20

Line 291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17

287: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21

Line 292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18

288: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22

Line 293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19

289: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23

Line 294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20

290: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24

Line 295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21

291: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25

Line 296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22

292: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26

Line 297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23

293: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27

Line 298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24

294: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
302: ,p_information28_o => pqh_rls_shd.g_old_rec.information28

Line 299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25

295: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
302: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
303: ,p_information29_o => pqh_rls_shd.g_old_rec.information29

Line 300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26

296: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
302: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
303: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
304: ,p_information30_o => pqh_rls_shd.g_old_rec.information30

Line 301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27

297: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
302: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
303: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
304: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
305: );

Line 302: ,p_information28_o => pqh_rls_shd.g_old_rec.information28

298: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
302: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
303: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
304: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
305: );
306: --

Line 303: ,p_information29_o => pqh_rls_shd.g_old_rec.information29

299: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
302: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
303: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
304: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
305: );
306: --
307: if nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'N'

Line 304: ,p_information30_o => pqh_rls_shd.g_old_rec.information30

300: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
301: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
302: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
303: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
304: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
305: );
306: --
307: if nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'N'
308: and p_rec.enable_flag = 'Y' then

Line 307: if nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'N'

303: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
304: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
305: );
306: --
307: if nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'N'
308: and p_rec.enable_flag = 'Y' then
309: hr_utility.set_location('Role enabled'||l_proc,10);
310: declare
311: l_user_name varchar2(50);

Line 364: elsif nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y'

360: p_expiration_date => l_expiration_date);
361: hr_utility.set_location('sync user done'||l_proc, 21);
362: end loop;
363: end;
364: elsif nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y'
365: and p_rec.enable_flag = 'N' then
366: hr_utility.set_location('role being disabled '||l_proc, 30);
367: declare
368: l_plist wf_parameter_list_t;

Line 456: ( p_rec in out NOCOPY pqh_rls_shd.g_rec_type

452: --
453: -- {End Of Comments}
454: -- ----------------------------------------------------------------------------
455: Procedure convert_defs
456: ( p_rec in out NOCOPY pqh_rls_shd.g_rec_type
457: ) is
458: --
459: Begin
460: --

Line 468: pqh_rls_shd.g_old_rec.role_name;

464: -- is being used then we must set to the 'current' argument value.
465: --
466: If (p_rec.role_name = hr_api.g_varchar2) then
467: p_rec.role_name :=
468: pqh_rls_shd.g_old_rec.role_name;
469: End If;
470: If (p_rec.role_type_cd = hr_api.g_varchar2) then
471: p_rec.role_type_cd :=
472: pqh_rls_shd.g_old_rec.role_type_cd;

Line 472: pqh_rls_shd.g_old_rec.role_type_cd;

468: pqh_rls_shd.g_old_rec.role_name;
469: End If;
470: If (p_rec.role_type_cd = hr_api.g_varchar2) then
471: p_rec.role_type_cd :=
472: pqh_rls_shd.g_old_rec.role_type_cd;
473: End If;
474: If (p_rec.enable_flag = hr_api.g_varchar2) then
475: p_rec.enable_flag :=
476: pqh_rls_shd.g_old_rec.enable_flag;

Line 476: pqh_rls_shd.g_old_rec.enable_flag;

472: pqh_rls_shd.g_old_rec.role_type_cd;
473: End If;
474: If (p_rec.enable_flag = hr_api.g_varchar2) then
475: p_rec.enable_flag :=
476: pqh_rls_shd.g_old_rec.enable_flag;
477: End If;
478: If (p_rec.business_group_id = hr_api.g_number) then
479: p_rec.business_group_id :=
480: pqh_rls_shd.g_old_rec.business_group_id;

Line 480: pqh_rls_shd.g_old_rec.business_group_id;

476: pqh_rls_shd.g_old_rec.enable_flag;
477: End If;
478: If (p_rec.business_group_id = hr_api.g_number) then
479: p_rec.business_group_id :=
480: pqh_rls_shd.g_old_rec.business_group_id;
481: End If;
482: --
483: -- mvankada
484: -- For Developer DF columns

Line 488: pqh_rls_shd.g_old_rec.information_category;

484: -- For Developer DF columns
485:
486: If (p_rec.information_category = hr_api.g_varchar2) then
487: p_rec.information_category :=
488: pqh_rls_shd.g_old_rec.information_category;
489: End If;
490: If (p_rec.information1 = hr_api.g_varchar2) then
491: p_rec.information1 :=
492: pqh_rls_shd.g_old_rec.information1;

Line 492: pqh_rls_shd.g_old_rec.information1;

488: pqh_rls_shd.g_old_rec.information_category;
489: End If;
490: If (p_rec.information1 = hr_api.g_varchar2) then
491: p_rec.information1 :=
492: pqh_rls_shd.g_old_rec.information1;
493: End If;
494: If (p_rec.information2 = hr_api.g_varchar2) then
495: p_rec.information2 :=
496: pqh_rls_shd.g_old_rec.information2;

Line 496: pqh_rls_shd.g_old_rec.information2;

492: pqh_rls_shd.g_old_rec.information1;
493: End If;
494: If (p_rec.information2 = hr_api.g_varchar2) then
495: p_rec.information2 :=
496: pqh_rls_shd.g_old_rec.information2;
497: End If;
498: If (p_rec.information3 = hr_api.g_varchar2) then
499: p_rec.information3 :=
500: pqh_rls_shd.g_old_rec.information3;

Line 500: pqh_rls_shd.g_old_rec.information3;

496: pqh_rls_shd.g_old_rec.information2;
497: End If;
498: If (p_rec.information3 = hr_api.g_varchar2) then
499: p_rec.information3 :=
500: pqh_rls_shd.g_old_rec.information3;
501: End If;
502: If (p_rec.information4 = hr_api.g_varchar2) then
503: p_rec.information4 :=
504: pqh_rls_shd.g_old_rec.information4;

Line 504: pqh_rls_shd.g_old_rec.information4;

500: pqh_rls_shd.g_old_rec.information3;
501: End If;
502: If (p_rec.information4 = hr_api.g_varchar2) then
503: p_rec.information4 :=
504: pqh_rls_shd.g_old_rec.information4;
505: End If;
506: If (p_rec.information5 = hr_api.g_varchar2) then
507: p_rec.information5 :=
508: pqh_rls_shd.g_old_rec.information5;

Line 508: pqh_rls_shd.g_old_rec.information5;

504: pqh_rls_shd.g_old_rec.information4;
505: End If;
506: If (p_rec.information5 = hr_api.g_varchar2) then
507: p_rec.information5 :=
508: pqh_rls_shd.g_old_rec.information5;
509: End If;
510: If (p_rec.information6 = hr_api.g_varchar2) then
511: p_rec.information6 :=
512: pqh_rls_shd.g_old_rec.information6;

Line 512: pqh_rls_shd.g_old_rec.information6;

508: pqh_rls_shd.g_old_rec.information5;
509: End If;
510: If (p_rec.information6 = hr_api.g_varchar2) then
511: p_rec.information6 :=
512: pqh_rls_shd.g_old_rec.information6;
513: End If;
514: If (p_rec.information7 = hr_api.g_varchar2) then
515: p_rec.information7 :=
516: pqh_rls_shd.g_old_rec.information7;

Line 516: pqh_rls_shd.g_old_rec.information7;

512: pqh_rls_shd.g_old_rec.information6;
513: End If;
514: If (p_rec.information7 = hr_api.g_varchar2) then
515: p_rec.information7 :=
516: pqh_rls_shd.g_old_rec.information7;
517: End If;
518: If (p_rec.information8 = hr_api.g_varchar2) then
519: p_rec.information8 :=
520: pqh_rls_shd.g_old_rec.information8;

Line 520: pqh_rls_shd.g_old_rec.information8;

516: pqh_rls_shd.g_old_rec.information7;
517: End If;
518: If (p_rec.information8 = hr_api.g_varchar2) then
519: p_rec.information8 :=
520: pqh_rls_shd.g_old_rec.information8;
521: End If;
522: If (p_rec.information9 = hr_api.g_varchar2) then
523: p_rec.information9 :=
524: pqh_rls_shd.g_old_rec.information9;

Line 524: pqh_rls_shd.g_old_rec.information9;

520: pqh_rls_shd.g_old_rec.information8;
521: End If;
522: If (p_rec.information9 = hr_api.g_varchar2) then
523: p_rec.information9 :=
524: pqh_rls_shd.g_old_rec.information9;
525: End If;
526: If (p_rec.information10 = hr_api.g_varchar2) then
527: p_rec.information10 :=
528: pqh_rls_shd.g_old_rec.information10;

Line 528: pqh_rls_shd.g_old_rec.information10;

524: pqh_rls_shd.g_old_rec.information9;
525: End If;
526: If (p_rec.information10 = hr_api.g_varchar2) then
527: p_rec.information10 :=
528: pqh_rls_shd.g_old_rec.information10;
529: End If;
530: If (p_rec.information11 = hr_api.g_varchar2) then
531: p_rec.information11 :=
532: pqh_rls_shd.g_old_rec.information11;

Line 532: pqh_rls_shd.g_old_rec.information11;

528: pqh_rls_shd.g_old_rec.information10;
529: End If;
530: If (p_rec.information11 = hr_api.g_varchar2) then
531: p_rec.information11 :=
532: pqh_rls_shd.g_old_rec.information11;
533: End If;
534: If (p_rec.information12 = hr_api.g_varchar2) then
535: p_rec.information12 :=
536: pqh_rls_shd.g_old_rec.information12;

Line 536: pqh_rls_shd.g_old_rec.information12;

532: pqh_rls_shd.g_old_rec.information11;
533: End If;
534: If (p_rec.information12 = hr_api.g_varchar2) then
535: p_rec.information12 :=
536: pqh_rls_shd.g_old_rec.information12;
537: End If;
538: If (p_rec.information13 = hr_api.g_varchar2) then
539: p_rec.information13 :=
540: pqh_rls_shd.g_old_rec.information13;

Line 540: pqh_rls_shd.g_old_rec.information13;

536: pqh_rls_shd.g_old_rec.information12;
537: End If;
538: If (p_rec.information13 = hr_api.g_varchar2) then
539: p_rec.information13 :=
540: pqh_rls_shd.g_old_rec.information13;
541: End If;
542: If (p_rec.information14 = hr_api.g_varchar2) then
543: p_rec.information14 :=
544: pqh_rls_shd.g_old_rec.information14;

Line 544: pqh_rls_shd.g_old_rec.information14;

540: pqh_rls_shd.g_old_rec.information13;
541: End If;
542: If (p_rec.information14 = hr_api.g_varchar2) then
543: p_rec.information14 :=
544: pqh_rls_shd.g_old_rec.information14;
545: End If;
546: If (p_rec.information15 = hr_api.g_varchar2) then
547: p_rec.information15 :=
548: pqh_rls_shd.g_old_rec.information15;

Line 548: pqh_rls_shd.g_old_rec.information15;

544: pqh_rls_shd.g_old_rec.information14;
545: End If;
546: If (p_rec.information15 = hr_api.g_varchar2) then
547: p_rec.information15 :=
548: pqh_rls_shd.g_old_rec.information15;
549: End If;
550: If (p_rec.information16 = hr_api.g_varchar2) then
551: p_rec.information16 :=
552: pqh_rls_shd.g_old_rec.information16;

Line 552: pqh_rls_shd.g_old_rec.information16;

548: pqh_rls_shd.g_old_rec.information15;
549: End If;
550: If (p_rec.information16 = hr_api.g_varchar2) then
551: p_rec.information16 :=
552: pqh_rls_shd.g_old_rec.information16;
553: End If;
554: If (p_rec.information17 = hr_api.g_varchar2) then
555: p_rec.information17 :=
556: pqh_rls_shd.g_old_rec.information17;

Line 556: pqh_rls_shd.g_old_rec.information17;

552: pqh_rls_shd.g_old_rec.information16;
553: End If;
554: If (p_rec.information17 = hr_api.g_varchar2) then
555: p_rec.information17 :=
556: pqh_rls_shd.g_old_rec.information17;
557: End If;
558: If (p_rec.information18 = hr_api.g_varchar2) then
559: p_rec.information18 :=
560: pqh_rls_shd.g_old_rec.information18;

Line 560: pqh_rls_shd.g_old_rec.information18;

556: pqh_rls_shd.g_old_rec.information17;
557: End If;
558: If (p_rec.information18 = hr_api.g_varchar2) then
559: p_rec.information18 :=
560: pqh_rls_shd.g_old_rec.information18;
561: End If;
562: If (p_rec.information19 = hr_api.g_varchar2) then
563: p_rec.information19 :=
564: pqh_rls_shd.g_old_rec.information19;

Line 564: pqh_rls_shd.g_old_rec.information19;

560: pqh_rls_shd.g_old_rec.information18;
561: End If;
562: If (p_rec.information19 = hr_api.g_varchar2) then
563: p_rec.information19 :=
564: pqh_rls_shd.g_old_rec.information19;
565: End If;
566: If (p_rec.information20 = hr_api.g_varchar2) then
567: p_rec.information20 :=
568: pqh_rls_shd.g_old_rec.information20;

Line 568: pqh_rls_shd.g_old_rec.information20;

564: pqh_rls_shd.g_old_rec.information19;
565: End If;
566: If (p_rec.information20 = hr_api.g_varchar2) then
567: p_rec.information20 :=
568: pqh_rls_shd.g_old_rec.information20;
569: End If;
570: If (p_rec.information21 = hr_api.g_varchar2) then
571: p_rec.information21 :=
572: pqh_rls_shd.g_old_rec.information21;

Line 572: pqh_rls_shd.g_old_rec.information21;

568: pqh_rls_shd.g_old_rec.information20;
569: End If;
570: If (p_rec.information21 = hr_api.g_varchar2) then
571: p_rec.information21 :=
572: pqh_rls_shd.g_old_rec.information21;
573: End If;
574: If (p_rec.information22 = hr_api.g_varchar2) then
575: p_rec.information22 :=
576: pqh_rls_shd.g_old_rec.information22;

Line 576: pqh_rls_shd.g_old_rec.information22;

572: pqh_rls_shd.g_old_rec.information21;
573: End If;
574: If (p_rec.information22 = hr_api.g_varchar2) then
575: p_rec.information22 :=
576: pqh_rls_shd.g_old_rec.information22;
577: End If;
578: If (p_rec.information23 = hr_api.g_varchar2) then
579: p_rec.information23 :=
580: pqh_rls_shd.g_old_rec.information23;

Line 580: pqh_rls_shd.g_old_rec.information23;

576: pqh_rls_shd.g_old_rec.information22;
577: End If;
578: If (p_rec.information23 = hr_api.g_varchar2) then
579: p_rec.information23 :=
580: pqh_rls_shd.g_old_rec.information23;
581: End If;
582: If (p_rec.information24 = hr_api.g_varchar2) then
583: p_rec.information24 :=
584: pqh_rls_shd.g_old_rec.information24;

Line 584: pqh_rls_shd.g_old_rec.information24;

580: pqh_rls_shd.g_old_rec.information23;
581: End If;
582: If (p_rec.information24 = hr_api.g_varchar2) then
583: p_rec.information24 :=
584: pqh_rls_shd.g_old_rec.information24;
585: End If;
586: If (p_rec.information25 = hr_api.g_varchar2) then
587: p_rec.information25 :=
588: pqh_rls_shd.g_old_rec.information25;

Line 588: pqh_rls_shd.g_old_rec.information25;

584: pqh_rls_shd.g_old_rec.information24;
585: End If;
586: If (p_rec.information25 = hr_api.g_varchar2) then
587: p_rec.information25 :=
588: pqh_rls_shd.g_old_rec.information25;
589: End If;
590: If (p_rec.information26 = hr_api.g_varchar2) then
591: p_rec.information26 :=
592: pqh_rls_shd.g_old_rec.information26;

Line 592: pqh_rls_shd.g_old_rec.information26;

588: pqh_rls_shd.g_old_rec.information25;
589: End If;
590: If (p_rec.information26 = hr_api.g_varchar2) then
591: p_rec.information26 :=
592: pqh_rls_shd.g_old_rec.information26;
593: End If;
594: If (p_rec.information27 = hr_api.g_varchar2) then
595: p_rec.information27 :=
596: pqh_rls_shd.g_old_rec.information27;

Line 596: pqh_rls_shd.g_old_rec.information27;

592: pqh_rls_shd.g_old_rec.information26;
593: End If;
594: If (p_rec.information27 = hr_api.g_varchar2) then
595: p_rec.information27 :=
596: pqh_rls_shd.g_old_rec.information27;
597: End If;
598: If (p_rec.information28 = hr_api.g_varchar2) then
599: p_rec.information28 :=
600: pqh_rls_shd.g_old_rec.information28;

Line 600: pqh_rls_shd.g_old_rec.information28;

596: pqh_rls_shd.g_old_rec.information27;
597: End If;
598: If (p_rec.information28 = hr_api.g_varchar2) then
599: p_rec.information28 :=
600: pqh_rls_shd.g_old_rec.information28;
601: End If;
602: If (p_rec.information29 = hr_api.g_varchar2) then
603: p_rec.information29 :=
604: pqh_rls_shd.g_old_rec.information29;

Line 604: pqh_rls_shd.g_old_rec.information29;

600: pqh_rls_shd.g_old_rec.information28;
601: End If;
602: If (p_rec.information29 = hr_api.g_varchar2) then
603: p_rec.information29 :=
604: pqh_rls_shd.g_old_rec.information29;
605: End If;
606: If (p_rec.information30 = hr_api.g_varchar2) then
607: p_rec.information30 :=
608: pqh_rls_shd.g_old_rec.information30;

Line 608: pqh_rls_shd.g_old_rec.information30;

604: pqh_rls_shd.g_old_rec.information29;
605: End If;
606: If (p_rec.information30 = hr_api.g_varchar2) then
607: p_rec.information30 :=
608: pqh_rls_shd.g_old_rec.information30;
609: End If;
610:
611: End convert_defs;
612: --

Line 618: ,p_rec in out NOCOPY pqh_rls_shd.g_rec_type

614: -- |---------------------------------< upd >----------------------------------|
615: -- ----------------------------------------------------------------------------
616: Procedure upd
617: (p_effective_date in date
618: ,p_rec in out NOCOPY pqh_rls_shd.g_rec_type
619: ) is
620: --
621: l_proc varchar2(72) := g_package||'upd';
622: --

Line 628: pqh_rls_shd.lck

624: hr_utility.set_location('Entering:'||l_proc,5);
625: --
626: -- We must lock the row which we need to update.
627: --
628: pqh_rls_shd.lck
629: (p_rec.role_id
630: ,p_rec.object_version_number
631: );
632: --

Line 709: l_rec pqh_rls_shd.g_rec_type;

705: ,p_information29 in varchar2
706: ,p_information30 in varchar2
707: ) is
708: --
709: l_rec pqh_rls_shd.g_rec_type;
710: l_proc varchar2(72) := g_package||'upd';
711: --
712: Begin
713: hr_utility.set_location('Entering:'||l_proc,5);

Line 721: pqh_rls_shd.convert_args

717: --
718: -- mvanakda
719: -- Added DDF Columns
720: l_rec :=
721: pqh_rls_shd.convert_args
722: (p_role_id
723: ,p_role_name
724: ,p_role_type_cd
725: ,p_enable_flag