eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PHN_DEL dependencies on PER_PHN_SHD

Line 45: Procedure delete_dml(p_rec in per_phn_shd.g_rec_type) is

41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in per_phn_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 62: per_phn_shd.constraint_error

58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: per_phn_shd.constraint_error
63: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
64: When Others Then
65: Raise;
66: End delete_dml;

Line 100: Procedure pre_delete(p_rec in per_phn_shd.g_rec_type) is

96: -- Internal Table Handler Use Only.
97: --
98: -- {End Of Comments}
99: -- ----------------------------------------------------------------------------
100: Procedure pre_delete(p_rec in per_phn_shd.g_rec_type) is
101: --
102: l_proc varchar2(72) := g_package||'pre_delete';
103: --
104: Begin

Line 142: Procedure post_delete(p_rec in per_phn_shd.g_rec_type) is

138: -- Internal table Handler Use Only.
139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure post_delete(p_rec in per_phn_shd.g_rec_type) is
143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin

Line 155: ,p_date_from_o => per_phn_shd.g_old_rec.date_from

151: begin
152: per_phn_rkd.after_delete
153: (
154: p_phone_id => p_rec.phone_id
155: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
156: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
157: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id

Line 156: ,p_date_to_o => per_phn_shd.g_old_rec.date_to

152: per_phn_rkd.after_delete
153: (
154: p_phone_id => p_rec.phone_id
155: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
156: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
157: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table

Line 157: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type

153: (
154: p_phone_id => p_rec.phone_id
155: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
156: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
157: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category

Line 158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number

154: p_phone_id => p_rec.phone_id
155: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
156: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
157: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1

Line 159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id

155: ,p_date_from_o => per_phn_shd.g_old_rec.date_from
156: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
157: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2

Line 160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table

156: ,p_date_to_o => per_phn_shd.g_old_rec.date_to
157: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3

Line 161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category

157: ,p_phone_type_o => per_phn_shd.g_old_rec.phone_type
158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4

Line 162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1

158: ,p_phone_number_o => per_phn_shd.g_old_rec.phone_number
159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5

Line 163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2

159: ,p_parent_id_o => per_phn_shd.g_old_rec.parent_id
160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6

Line 164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3

160: ,p_parent_table_o => per_phn_shd.g_old_rec.parent_table
161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7

Line 165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4

161: ,p_attribute_category_o => per_phn_shd.g_old_rec.attribute_category
162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8

Line 166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5

162: ,p_attribute1_o => per_phn_shd.g_old_rec.attribute1
163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9

Line 167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6

163: ,p_attribute2_o => per_phn_shd.g_old_rec.attribute2
164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10

Line 168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7

164: ,p_attribute3_o => per_phn_shd.g_old_rec.attribute3
165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11

Line 169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8

165: ,p_attribute4_o => per_phn_shd.g_old_rec.attribute4
166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12

Line 170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9

166: ,p_attribute5_o => per_phn_shd.g_old_rec.attribute5
167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13

Line 171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10

167: ,p_attribute6_o => per_phn_shd.g_old_rec.attribute6
168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14

Line 172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11

168: ,p_attribute7_o => per_phn_shd.g_old_rec.attribute7
169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15

Line 173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12

169: ,p_attribute8_o => per_phn_shd.g_old_rec.attribute8
170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16

Line 174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13

170: ,p_attribute9_o => per_phn_shd.g_old_rec.attribute9
171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17

Line 175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14

171: ,p_attribute10_o => per_phn_shd.g_old_rec.attribute10
172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18

Line 176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15

172: ,p_attribute11_o => per_phn_shd.g_old_rec.attribute11
173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19

Line 177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16

173: ,p_attribute12_o => per_phn_shd.g_old_rec.attribute12
174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20

Line 178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17

174: ,p_attribute13_o => per_phn_shd.g_old_rec.attribute13
175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21

Line 179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18

175: ,p_attribute14_o => per_phn_shd.g_old_rec.attribute14
176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22

Line 180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19

176: ,p_attribute15_o => per_phn_shd.g_old_rec.attribute15
177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23

Line 181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20

177: ,p_attribute16_o => per_phn_shd.g_old_rec.attribute16
178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24

Line 182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21

178: ,p_attribute17_o => per_phn_shd.g_old_rec.attribute17
179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25

Line 183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22

179: ,p_attribute18_o => per_phn_shd.g_old_rec.attribute18
180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26

Line 184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23

180: ,p_attribute19_o => per_phn_shd.g_old_rec.attribute19
181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27

Line 185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24

181: ,p_attribute20_o => per_phn_shd.g_old_rec.attribute20
182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28

Line 186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25

182: ,p_attribute21_o => per_phn_shd.g_old_rec.attribute21
183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29

Line 187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26

183: ,p_attribute22_o => per_phn_shd.g_old_rec.attribute22
184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30

Line 188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27

184: ,p_attribute23_o => per_phn_shd.g_old_rec.attribute23
185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
192: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge

Line 189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28

185: ,p_attribute24_o => per_phn_shd.g_old_rec.attribute24
186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
192: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
193: ,p_validity_o => per_phn_shd.g_old_rec.validity

Line 190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29

186: ,p_attribute25_o => per_phn_shd.g_old_rec.attribute25
187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
192: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
193: ,p_validity_o => per_phn_shd.g_old_rec.validity
194: ,p_object_version_number_o

Line 191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30

187: ,p_attribute26_o => per_phn_shd.g_old_rec.attribute26
188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
192: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
193: ,p_validity_o => per_phn_shd.g_old_rec.validity
194: ,p_object_version_number_o
195: => per_phn_shd.g_old_rec.object_version_number

Line 192: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge

188: ,p_attribute27_o => per_phn_shd.g_old_rec.attribute27
189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
192: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
193: ,p_validity_o => per_phn_shd.g_old_rec.validity
194: ,p_object_version_number_o
195: => per_phn_shd.g_old_rec.object_version_number
196: );

Line 193: ,p_validity_o => per_phn_shd.g_old_rec.validity

189: ,p_attribute28_o => per_phn_shd.g_old_rec.attribute28
190: ,p_attribute29_o => per_phn_shd.g_old_rec.attribute29
191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
192: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
193: ,p_validity_o => per_phn_shd.g_old_rec.validity
194: ,p_object_version_number_o
195: => per_phn_shd.g_old_rec.object_version_number
196: );
197: exception

Line 195: => per_phn_shd.g_old_rec.object_version_number

191: ,p_attribute30_o => per_phn_shd.g_old_rec.attribute30
192: ,p_party_id_o => per_phn_shd.g_old_rec.party_id -- HR/TCA merge
193: ,p_validity_o => per_phn_shd.g_old_rec.validity
194: ,p_object_version_number_o
195: => per_phn_shd.g_old_rec.object_version_number
196: );
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error

Line 214: p_rec in per_phn_shd.g_rec_type,

210: -- |---------------------------------< del >----------------------------------|
211: -- ----------------------------------------------------------------------------
212: Procedure del
213: (
214: p_rec in per_phn_shd.g_rec_type,
215: p_validate in boolean default false
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'del';

Line 234: per_phn_shd.lck

230: End If;
231: --
232: -- We must lock the row which we need to delete.
233: --
234: per_phn_shd.lck
235: (
236: p_rec.phone_id,
237: p_rec.object_version_number
238: );

Line 290: l_rec per_phn_shd.g_rec_type;

286: p_object_version_number in number,
287: p_validate in boolean default false
288: ) is
289: --
290: l_rec per_phn_shd.g_rec_type;
291: l_proc varchar2(72) := g_package||'del';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);