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_DEL dependencies on PQH_RLS_SHD

Line 52: ( p_rec in pqh_rls_shd.g_rec_type

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

Line 75: pqh_rls_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: pqh_rls_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 pqh_rls_shd.g_rec_type) is

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

Line 158: Procedure post_delete( p_rec in pqh_rls_shd.g_rec_type) is

154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: -- mvanakda
157: -- Added Developer DF Columns
158: Procedure post_delete( p_rec in pqh_rls_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'post_delete';
161: l_start_date date := trunc(sysdate);
162: --

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

167:
168:
169: pqh_rls_rkd.after_delete
170: (p_role_id => p_rec.role_id
171: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
172: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
173: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
174: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id

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

168:
169: pqh_rls_rkd.after_delete
170: (p_role_id => p_rec.role_id
171: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
172: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
173: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
174: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category

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

169: pqh_rls_rkd.after_delete
170: (p_role_id => p_rec.role_id
171: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
172: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
173: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
174: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1

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

170: (p_role_id => p_rec.role_id
171: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
172: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
173: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
174: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2

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

171: ,p_role_name_o => pqh_rls_shd.g_old_rec.role_name
172: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
173: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
174: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3

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

172: ,p_role_type_cd_o => pqh_rls_shd.g_old_rec.role_type_cd
173: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
174: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4

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

173: ,p_enable_flag_o => pqh_rls_shd.g_old_rec.enable_flag
174: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5

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

174: ,p_object_version_number_o => pqh_rls_shd.g_old_rec.object_version_number
175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6

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

175: ,p_business_group_id_o => pqh_rls_shd.g_old_rec.business_group_id
176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7

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

176: ,p_information_category_o => pqh_rls_shd.g_old_rec.information_category
177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8

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

177: ,p_information1_o => pqh_rls_shd.g_old_rec.information1
178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9

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

178: ,p_information2_o => pqh_rls_shd.g_old_rec.information2
179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10

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

179: ,p_information3_o => pqh_rls_shd.g_old_rec.information3
180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11

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

180: ,p_information4_o => pqh_rls_shd.g_old_rec.information4
181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12

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

181: ,p_information5_o => pqh_rls_shd.g_old_rec.information5
182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13

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

182: ,p_information6_o => pqh_rls_shd.g_old_rec.information6
183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14

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

183: ,p_information7_o => pqh_rls_shd.g_old_rec.information7
184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15

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

184: ,p_information8_o => pqh_rls_shd.g_old_rec.information8
185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16

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

185: ,p_information9_o => pqh_rls_shd.g_old_rec.information9
186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17

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

186: ,p_information10_o => pqh_rls_shd.g_old_rec.information10
187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18

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

187: ,p_information11_o => pqh_rls_shd.g_old_rec.information11
188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19

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

188: ,p_information12_o => pqh_rls_shd.g_old_rec.information12
189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20

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

189: ,p_information13_o => pqh_rls_shd.g_old_rec.information13
190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21

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

190: ,p_information14_o => pqh_rls_shd.g_old_rec.information14
191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22

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

191: ,p_information15_o => pqh_rls_shd.g_old_rec.information15
192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23

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

192: ,p_information16_o => pqh_rls_shd.g_old_rec.information16
193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24

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

193: ,p_information17_o => pqh_rls_shd.g_old_rec.information17
194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25

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

194: ,p_information18_o => pqh_rls_shd.g_old_rec.information18
195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26

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

195: ,p_information19_o => pqh_rls_shd.g_old_rec.information19
196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
203: ,p_information27_o => pqh_rls_shd.g_old_rec.information27

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

196: ,p_information20_o => pqh_rls_shd.g_old_rec.information20
197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
203: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
204: ,p_information28_o => pqh_rls_shd.g_old_rec.information28

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

197: ,p_information21_o => pqh_rls_shd.g_old_rec.information21
198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
203: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
204: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
205: ,p_information29_o => pqh_rls_shd.g_old_rec.information29

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

198: ,p_information22_o => pqh_rls_shd.g_old_rec.information22
199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
203: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
204: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
205: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
206: ,p_information30_o => pqh_rls_shd.g_old_rec.information30

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

199: ,p_information23_o => pqh_rls_shd.g_old_rec.information23
200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
203: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
204: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
205: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
206: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
207: );

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

200: ,p_information24_o => pqh_rls_shd.g_old_rec.information24
201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
203: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
204: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
205: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
206: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
207: );
208: --

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

201: ,p_information25_o => pqh_rls_shd.g_old_rec.information25
202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
203: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
204: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
205: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
206: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
207: );
208: --
209: if nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y'

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

202: ,p_information26_o => pqh_rls_shd.g_old_rec.information26
203: ,p_information27_o => pqh_rls_shd.g_old_rec.information27
204: ,p_information28_o => pqh_rls_shd.g_old_rec.information28
205: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
206: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
207: );
208: --
209: if nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y'
210: then

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

205: ,p_information29_o => pqh_rls_shd.g_old_rec.information29
206: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
207: );
208: --
209: if nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y'
210: then
211: declare
212: l_plist wf_parameter_list_t;
213: --

Line 277: ( p_effective_date in date, p_rec in pqh_rls_shd.g_rec_type

273: -- ----------------------------------------------------------------------------
274: -- |---------------------------------< del >----------------------------------|
275: -- ----------------------------------------------------------------------------
276: Procedure del
277: ( p_effective_date in date, p_rec in pqh_rls_shd.g_rec_type
278: ) is
279: --
280: l_proc varchar2(72) := g_package||'del';
281: --

Line 287: pqh_rls_shd.lck

283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- We must lock the row which we need to delete.
286: --
287: pqh_rls_shd.lck
288: (p_rec.role_id
289: ,p_rec.object_version_number
290: );
291: --

Line 319: l_rec pqh_rls_shd.g_rec_type;

315: ,p_role_id in number
316: ,p_object_version_number in number
317: ) is
318: --
319: l_rec pqh_rls_shd.g_rec_type;
320: l_proc varchar2(72) := g_package||'del';
321: --
322: Begin
323: hr_utility.set_location('Entering:'||l_proc, 5);