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' and p_rec.enable_flag = 'Y') or (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')) then

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' and p_rec.enable_flag = 'Y') or (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')) then
308: hr_utility.set_location('Role enabled'||l_proc,10);

Line 307: if ((nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'N' and p_rec.enable_flag = 'Y') or (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')) then

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' and p_rec.enable_flag = 'Y') or (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')) then
308: hr_utility.set_location('Role enabled'||l_proc,10);
309: declare
310: l_user_name varchar2(50);
311: l_plist wf_parameter_list_t;

Line 336: if (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')

332: WF_EVENT.AddParameterToList('orclWFOrigSystem','PQH_ROLE', l_plist);
333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);
335: WF_EVENT.AddParameterToList('RAISEERRORS','FALSE',l_plist);
336: if (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')
337: then
338: WF_EVENT.AddParameterToList('UPDATEONLY','TRUE',l_plist);
339: end if;
340:

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

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

Line 460: ( p_rec in out NOCOPY pqh_rls_shd.g_rec_type

456: --
457: -- {End Of Comments}
458: -- ----------------------------------------------------------------------------
459: Procedure convert_defs
460: ( p_rec in out NOCOPY pqh_rls_shd.g_rec_type
461: ) is
462: --
463: Begin
464: --

Line 472: pqh_rls_shd.g_old_rec.role_name;

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

Line 476: pqh_rls_shd.g_old_rec.role_type_cd;

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

Line 480: pqh_rls_shd.g_old_rec.enable_flag;

476: pqh_rls_shd.g_old_rec.role_type_cd;
477: End If;
478: If (p_rec.enable_flag = hr_api.g_varchar2) then
479: p_rec.enable_flag :=
480: pqh_rls_shd.g_old_rec.enable_flag;
481: End If;
482: If (p_rec.business_group_id = hr_api.g_number) then
483: p_rec.business_group_id :=
484: pqh_rls_shd.g_old_rec.business_group_id;

Line 484: pqh_rls_shd.g_old_rec.business_group_id;

480: pqh_rls_shd.g_old_rec.enable_flag;
481: End If;
482: If (p_rec.business_group_id = hr_api.g_number) then
483: p_rec.business_group_id :=
484: pqh_rls_shd.g_old_rec.business_group_id;
485: End If;
486: --
487: -- mvankada
488: -- For Developer DF columns

Line 492: pqh_rls_shd.g_old_rec.information_category;

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

Line 496: pqh_rls_shd.g_old_rec.information1;

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

Line 500: pqh_rls_shd.g_old_rec.information2;

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

Line 504: pqh_rls_shd.g_old_rec.information3;

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

Line 508: pqh_rls_shd.g_old_rec.information4;

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

Line 512: pqh_rls_shd.g_old_rec.information5;

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

Line 516: pqh_rls_shd.g_old_rec.information6;

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

Line 520: pqh_rls_shd.g_old_rec.information7;

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

Line 524: pqh_rls_shd.g_old_rec.information8;

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

Line 528: pqh_rls_shd.g_old_rec.information9;

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

Line 532: pqh_rls_shd.g_old_rec.information10;

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

Line 536: pqh_rls_shd.g_old_rec.information11;

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

Line 540: pqh_rls_shd.g_old_rec.information12;

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

Line 544: pqh_rls_shd.g_old_rec.information13;

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

Line 548: pqh_rls_shd.g_old_rec.information14;

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

Line 552: pqh_rls_shd.g_old_rec.information15;

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

Line 556: pqh_rls_shd.g_old_rec.information16;

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

Line 560: pqh_rls_shd.g_old_rec.information17;

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

Line 564: pqh_rls_shd.g_old_rec.information18;

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

Line 568: pqh_rls_shd.g_old_rec.information19;

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

Line 572: pqh_rls_shd.g_old_rec.information20;

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

Line 576: pqh_rls_shd.g_old_rec.information21;

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

Line 580: pqh_rls_shd.g_old_rec.information22;

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

Line 584: pqh_rls_shd.g_old_rec.information23;

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

Line 588: pqh_rls_shd.g_old_rec.information24;

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

Line 592: pqh_rls_shd.g_old_rec.information25;

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

Line 596: pqh_rls_shd.g_old_rec.information26;

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

Line 600: pqh_rls_shd.g_old_rec.information27;

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

Line 604: pqh_rls_shd.g_old_rec.information28;

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

Line 608: pqh_rls_shd.g_old_rec.information29;

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

Line 612: pqh_rls_shd.g_old_rec.information30;

608: pqh_rls_shd.g_old_rec.information29;
609: End If;
610: If (p_rec.information30 = hr_api.g_varchar2) then
611: p_rec.information30 :=
612: pqh_rls_shd.g_old_rec.information30;
613: End If;
614:
615: End convert_defs;
616: --

Line 622: ,p_rec in out NOCOPY pqh_rls_shd.g_rec_type

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

Line 632: pqh_rls_shd.lck

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

Line 713: l_rec pqh_rls_shd.g_rec_type;

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

Line 725: pqh_rls_shd.convert_args

721: --
722: -- mvanakda
723: -- Added DDF Columns
724: l_rec :=
725: pqh_rls_shd.convert_args
726: (p_role_id
727: ,p_role_name
728: ,p_role_type_cd
729: ,p_enable_flag