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.PAY_PYR_DEL dependencies on PAY_PYR_SHD

Line 52: (p_rec IN pay_pyr_shd.g_rec_type

48: --
49: -- {END Of Comments}
50: -- ----------------------------------------------------------------------------
51: PROCEDURE delete_dml
52: (p_rec IN pay_pyr_shd.g_rec_type
53: ) IS
54: --
55: l_proc VARCHAR2(72) := g_package||'delete_dml';
56: --

Line 60: pay_pyr_shd.g_api_dml := TRUE; -- Set the api dml status

56: --
57: BEGIN
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: pay_pyr_shd.g_api_dml := TRUE; -- Set the api dml status
61: --
62: -- Delete the pay_rates row.
63: --
64: delete FROM pay_rates

Line 67: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status

63: --
64: delete FROM pay_rates
65: WHERE rate_id = p_rec.rate_id;
66: --
67: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: EXCEPTION

Line 74: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status

70: --
71: EXCEPTION
72: WHEN hr_api.child_integrity_violated THEN
73: -- Child integrity has been violated
74: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
75: pay_pyr_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: WHEN Others THEN
78: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status

Line 75: pay_pyr_shd.constraint_error

71: EXCEPTION
72: WHEN hr_api.child_integrity_violated THEN
73: -- Child integrity has been violated
74: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
75: pay_pyr_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: WHEN Others THEN
78: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
79: Raise;

Line 78: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status

74: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
75: pay_pyr_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: WHEN Others THEN
78: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
79: Raise;
80: END delete_dml;
81: --
82: -- ----------------------------------------------------------------------------

Line 114: PROCEDURE pre_delete(p_rec IN pay_pyr_shd.g_rec_type) IS

110: -- Internal Row Handler Use Only.
111: --
112: -- {END Of Comments}
113: -- ----------------------------------------------------------------------------
114: PROCEDURE pre_delete(p_rec IN pay_pyr_shd.g_rec_type) IS
115: --
116: l_proc VARCHAR2(72) := g_package||'pre_delete';
117: --
118: BEGIN

Line 156: PROCEDURE post_delete(p_rec IN pay_pyr_shd.g_rec_type) IS

152: -- Internal Row Handler Use Only.
153: --
154: -- {END Of Comments}
155: -- -----------------------------------------------------------------------------
156: PROCEDURE post_delete(p_rec IN pay_pyr_shd.g_rec_type) IS
157: --
158: l_proc VARCHAR2(72) := g_package||'post_delete';
159: --
160: BEGIN

Line 168: => pay_pyr_shd.g_old_rec.business_group_id

164: pay_pyr_rkd.after_delete
165: (p_rate_id
166: => p_rec.rate_id
167: ,p_business_group_id_o
168: => pay_pyr_shd.g_old_rec.business_group_id
169: ,p_parent_spine_id_o
170: => pay_pyr_shd.g_old_rec.parent_spine_id
171: ,p_name_o
172: => pay_pyr_shd.g_old_rec.name

Line 170: => pay_pyr_shd.g_old_rec.parent_spine_id

166: => p_rec.rate_id
167: ,p_business_group_id_o
168: => pay_pyr_shd.g_old_rec.business_group_id
169: ,p_parent_spine_id_o
170: => pay_pyr_shd.g_old_rec.parent_spine_id
171: ,p_name_o
172: => pay_pyr_shd.g_old_rec.name
173: ,p_rate_type_o
174: => pay_pyr_shd.g_old_rec.rate_type

Line 172: => pay_pyr_shd.g_old_rec.name

168: => pay_pyr_shd.g_old_rec.business_group_id
169: ,p_parent_spine_id_o
170: => pay_pyr_shd.g_old_rec.parent_spine_id
171: ,p_name_o
172: => pay_pyr_shd.g_old_rec.name
173: ,p_rate_type_o
174: => pay_pyr_shd.g_old_rec.rate_type
175: ,p_rate_uom_o
176: => pay_pyr_shd.g_old_rec.rate_uom

Line 174: => pay_pyr_shd.g_old_rec.rate_type

170: => pay_pyr_shd.g_old_rec.parent_spine_id
171: ,p_name_o
172: => pay_pyr_shd.g_old_rec.name
173: ,p_rate_type_o
174: => pay_pyr_shd.g_old_rec.rate_type
175: ,p_rate_uom_o
176: => pay_pyr_shd.g_old_rec.rate_uom
177: ,p_comments_o
178: => pay_pyr_shd.g_old_rec.comments

Line 176: => pay_pyr_shd.g_old_rec.rate_uom

172: => pay_pyr_shd.g_old_rec.name
173: ,p_rate_type_o
174: => pay_pyr_shd.g_old_rec.rate_type
175: ,p_rate_uom_o
176: => pay_pyr_shd.g_old_rec.rate_uom
177: ,p_comments_o
178: => pay_pyr_shd.g_old_rec.comments
179: ,p_request_id_o
180: => pay_pyr_shd.g_old_rec.request_id

Line 178: => pay_pyr_shd.g_old_rec.comments

174: => pay_pyr_shd.g_old_rec.rate_type
175: ,p_rate_uom_o
176: => pay_pyr_shd.g_old_rec.rate_uom
177: ,p_comments_o
178: => pay_pyr_shd.g_old_rec.comments
179: ,p_request_id_o
180: => pay_pyr_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => pay_pyr_shd.g_old_rec.program_application_id

Line 180: => pay_pyr_shd.g_old_rec.request_id

176: => pay_pyr_shd.g_old_rec.rate_uom
177: ,p_comments_o
178: => pay_pyr_shd.g_old_rec.comments
179: ,p_request_id_o
180: => pay_pyr_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => pay_pyr_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => pay_pyr_shd.g_old_rec.program_id

Line 182: => pay_pyr_shd.g_old_rec.program_application_id

178: => pay_pyr_shd.g_old_rec.comments
179: ,p_request_id_o
180: => pay_pyr_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => pay_pyr_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => pay_pyr_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => pay_pyr_shd.g_old_rec.program_update_date

Line 184: => pay_pyr_shd.g_old_rec.program_id

180: => pay_pyr_shd.g_old_rec.request_id
181: ,p_program_application_id_o
182: => pay_pyr_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => pay_pyr_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => pay_pyr_shd.g_old_rec.program_update_date
187: ,p_attribute_category_o
188: => pay_pyr_shd.g_old_rec.attribute_category

Line 186: => pay_pyr_shd.g_old_rec.program_update_date

182: => pay_pyr_shd.g_old_rec.program_application_id
183: ,p_program_id_o
184: => pay_pyr_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => pay_pyr_shd.g_old_rec.program_update_date
187: ,p_attribute_category_o
188: => pay_pyr_shd.g_old_rec.attribute_category
189: ,p_attribute1_o
190: => pay_pyr_shd.g_old_rec.attribute1

Line 188: => pay_pyr_shd.g_old_rec.attribute_category

184: => pay_pyr_shd.g_old_rec.program_id
185: ,p_program_update_date_o
186: => pay_pyr_shd.g_old_rec.program_update_date
187: ,p_attribute_category_o
188: => pay_pyr_shd.g_old_rec.attribute_category
189: ,p_attribute1_o
190: => pay_pyr_shd.g_old_rec.attribute1
191: ,p_attribute2_o
192: => pay_pyr_shd.g_old_rec.attribute2

Line 190: => pay_pyr_shd.g_old_rec.attribute1

186: => pay_pyr_shd.g_old_rec.program_update_date
187: ,p_attribute_category_o
188: => pay_pyr_shd.g_old_rec.attribute_category
189: ,p_attribute1_o
190: => pay_pyr_shd.g_old_rec.attribute1
191: ,p_attribute2_o
192: => pay_pyr_shd.g_old_rec.attribute2
193: ,p_attribute3_o
194: => pay_pyr_shd.g_old_rec.attribute3

Line 192: => pay_pyr_shd.g_old_rec.attribute2

188: => pay_pyr_shd.g_old_rec.attribute_category
189: ,p_attribute1_o
190: => pay_pyr_shd.g_old_rec.attribute1
191: ,p_attribute2_o
192: => pay_pyr_shd.g_old_rec.attribute2
193: ,p_attribute3_o
194: => pay_pyr_shd.g_old_rec.attribute3
195: ,p_attribute4_o
196: => pay_pyr_shd.g_old_rec.attribute4

Line 194: => pay_pyr_shd.g_old_rec.attribute3

190: => pay_pyr_shd.g_old_rec.attribute1
191: ,p_attribute2_o
192: => pay_pyr_shd.g_old_rec.attribute2
193: ,p_attribute3_o
194: => pay_pyr_shd.g_old_rec.attribute3
195: ,p_attribute4_o
196: => pay_pyr_shd.g_old_rec.attribute4
197: ,p_attribute5_o
198: => pay_pyr_shd.g_old_rec.attribute5

Line 196: => pay_pyr_shd.g_old_rec.attribute4

192: => pay_pyr_shd.g_old_rec.attribute2
193: ,p_attribute3_o
194: => pay_pyr_shd.g_old_rec.attribute3
195: ,p_attribute4_o
196: => pay_pyr_shd.g_old_rec.attribute4
197: ,p_attribute5_o
198: => pay_pyr_shd.g_old_rec.attribute5
199: ,p_attribute6_o
200: => pay_pyr_shd.g_old_rec.attribute6

Line 198: => pay_pyr_shd.g_old_rec.attribute5

194: => pay_pyr_shd.g_old_rec.attribute3
195: ,p_attribute4_o
196: => pay_pyr_shd.g_old_rec.attribute4
197: ,p_attribute5_o
198: => pay_pyr_shd.g_old_rec.attribute5
199: ,p_attribute6_o
200: => pay_pyr_shd.g_old_rec.attribute6
201: ,p_attribute7_o
202: => pay_pyr_shd.g_old_rec.attribute7

Line 200: => pay_pyr_shd.g_old_rec.attribute6

196: => pay_pyr_shd.g_old_rec.attribute4
197: ,p_attribute5_o
198: => pay_pyr_shd.g_old_rec.attribute5
199: ,p_attribute6_o
200: => pay_pyr_shd.g_old_rec.attribute6
201: ,p_attribute7_o
202: => pay_pyr_shd.g_old_rec.attribute7
203: ,p_attribute8_o
204: => pay_pyr_shd.g_old_rec.attribute8

Line 202: => pay_pyr_shd.g_old_rec.attribute7

198: => pay_pyr_shd.g_old_rec.attribute5
199: ,p_attribute6_o
200: => pay_pyr_shd.g_old_rec.attribute6
201: ,p_attribute7_o
202: => pay_pyr_shd.g_old_rec.attribute7
203: ,p_attribute8_o
204: => pay_pyr_shd.g_old_rec.attribute8
205: ,p_attribute9_o
206: => pay_pyr_shd.g_old_rec.attribute9

Line 204: => pay_pyr_shd.g_old_rec.attribute8

200: => pay_pyr_shd.g_old_rec.attribute6
201: ,p_attribute7_o
202: => pay_pyr_shd.g_old_rec.attribute7
203: ,p_attribute8_o
204: => pay_pyr_shd.g_old_rec.attribute8
205: ,p_attribute9_o
206: => pay_pyr_shd.g_old_rec.attribute9
207: ,p_attribute10_o
208: => pay_pyr_shd.g_old_rec.attribute10

Line 206: => pay_pyr_shd.g_old_rec.attribute9

202: => pay_pyr_shd.g_old_rec.attribute7
203: ,p_attribute8_o
204: => pay_pyr_shd.g_old_rec.attribute8
205: ,p_attribute9_o
206: => pay_pyr_shd.g_old_rec.attribute9
207: ,p_attribute10_o
208: => pay_pyr_shd.g_old_rec.attribute10
209: ,p_attribute11_o
210: => pay_pyr_shd.g_old_rec.attribute11

Line 208: => pay_pyr_shd.g_old_rec.attribute10

204: => pay_pyr_shd.g_old_rec.attribute8
205: ,p_attribute9_o
206: => pay_pyr_shd.g_old_rec.attribute9
207: ,p_attribute10_o
208: => pay_pyr_shd.g_old_rec.attribute10
209: ,p_attribute11_o
210: => pay_pyr_shd.g_old_rec.attribute11
211: ,p_attribute12_o
212: => pay_pyr_shd.g_old_rec.attribute12

Line 210: => pay_pyr_shd.g_old_rec.attribute11

206: => pay_pyr_shd.g_old_rec.attribute9
207: ,p_attribute10_o
208: => pay_pyr_shd.g_old_rec.attribute10
209: ,p_attribute11_o
210: => pay_pyr_shd.g_old_rec.attribute11
211: ,p_attribute12_o
212: => pay_pyr_shd.g_old_rec.attribute12
213: ,p_attribute13_o
214: => pay_pyr_shd.g_old_rec.attribute13

Line 212: => pay_pyr_shd.g_old_rec.attribute12

208: => pay_pyr_shd.g_old_rec.attribute10
209: ,p_attribute11_o
210: => pay_pyr_shd.g_old_rec.attribute11
211: ,p_attribute12_o
212: => pay_pyr_shd.g_old_rec.attribute12
213: ,p_attribute13_o
214: => pay_pyr_shd.g_old_rec.attribute13
215: ,p_attribute14_o
216: => pay_pyr_shd.g_old_rec.attribute14

Line 214: => pay_pyr_shd.g_old_rec.attribute13

210: => pay_pyr_shd.g_old_rec.attribute11
211: ,p_attribute12_o
212: => pay_pyr_shd.g_old_rec.attribute12
213: ,p_attribute13_o
214: => pay_pyr_shd.g_old_rec.attribute13
215: ,p_attribute14_o
216: => pay_pyr_shd.g_old_rec.attribute14
217: ,p_attribute15_o
218: => pay_pyr_shd.g_old_rec.attribute15

Line 216: => pay_pyr_shd.g_old_rec.attribute14

212: => pay_pyr_shd.g_old_rec.attribute12
213: ,p_attribute13_o
214: => pay_pyr_shd.g_old_rec.attribute13
215: ,p_attribute14_o
216: => pay_pyr_shd.g_old_rec.attribute14
217: ,p_attribute15_o
218: => pay_pyr_shd.g_old_rec.attribute15
219: ,p_attribute16_o
220: => pay_pyr_shd.g_old_rec.attribute16

Line 218: => pay_pyr_shd.g_old_rec.attribute15

214: => pay_pyr_shd.g_old_rec.attribute13
215: ,p_attribute14_o
216: => pay_pyr_shd.g_old_rec.attribute14
217: ,p_attribute15_o
218: => pay_pyr_shd.g_old_rec.attribute15
219: ,p_attribute16_o
220: => pay_pyr_shd.g_old_rec.attribute16
221: ,p_attribute17_o
222: => pay_pyr_shd.g_old_rec.attribute17

Line 220: => pay_pyr_shd.g_old_rec.attribute16

216: => pay_pyr_shd.g_old_rec.attribute14
217: ,p_attribute15_o
218: => pay_pyr_shd.g_old_rec.attribute15
219: ,p_attribute16_o
220: => pay_pyr_shd.g_old_rec.attribute16
221: ,p_attribute17_o
222: => pay_pyr_shd.g_old_rec.attribute17
223: ,p_attribute18_o
224: => pay_pyr_shd.g_old_rec.attribute18

Line 222: => pay_pyr_shd.g_old_rec.attribute17

218: => pay_pyr_shd.g_old_rec.attribute15
219: ,p_attribute16_o
220: => pay_pyr_shd.g_old_rec.attribute16
221: ,p_attribute17_o
222: => pay_pyr_shd.g_old_rec.attribute17
223: ,p_attribute18_o
224: => pay_pyr_shd.g_old_rec.attribute18
225: ,p_attribute19_o
226: => pay_pyr_shd.g_old_rec.attribute19

Line 224: => pay_pyr_shd.g_old_rec.attribute18

220: => pay_pyr_shd.g_old_rec.attribute16
221: ,p_attribute17_o
222: => pay_pyr_shd.g_old_rec.attribute17
223: ,p_attribute18_o
224: => pay_pyr_shd.g_old_rec.attribute18
225: ,p_attribute19_o
226: => pay_pyr_shd.g_old_rec.attribute19
227: ,p_attribute20_o
228: => pay_pyr_shd.g_old_rec.attribute20

Line 226: => pay_pyr_shd.g_old_rec.attribute19

222: => pay_pyr_shd.g_old_rec.attribute17
223: ,p_attribute18_o
224: => pay_pyr_shd.g_old_rec.attribute18
225: ,p_attribute19_o
226: => pay_pyr_shd.g_old_rec.attribute19
227: ,p_attribute20_o
228: => pay_pyr_shd.g_old_rec.attribute20
229: ,p_rate_basis_o
230: => pay_pyr_shd.g_old_rec.rate_basis

Line 228: => pay_pyr_shd.g_old_rec.attribute20

224: => pay_pyr_shd.g_old_rec.attribute18
225: ,p_attribute19_o
226: => pay_pyr_shd.g_old_rec.attribute19
227: ,p_attribute20_o
228: => pay_pyr_shd.g_old_rec.attribute20
229: ,p_rate_basis_o
230: => pay_pyr_shd.g_old_rec.rate_basis
231: ,p_asg_rate_type_o
232: => pay_pyr_shd.g_old_rec.asg_rate_type

Line 230: => pay_pyr_shd.g_old_rec.rate_basis

226: => pay_pyr_shd.g_old_rec.attribute19
227: ,p_attribute20_o
228: => pay_pyr_shd.g_old_rec.attribute20
229: ,p_rate_basis_o
230: => pay_pyr_shd.g_old_rec.rate_basis
231: ,p_asg_rate_type_o
232: => pay_pyr_shd.g_old_rec.asg_rate_type
233: ,p_object_version_number_o
234: => pay_pyr_shd.g_old_rec.object_version_number

Line 232: => pay_pyr_shd.g_old_rec.asg_rate_type

228: => pay_pyr_shd.g_old_rec.attribute20
229: ,p_rate_basis_o
230: => pay_pyr_shd.g_old_rec.rate_basis
231: ,p_asg_rate_type_o
232: => pay_pyr_shd.g_old_rec.asg_rate_type
233: ,p_object_version_number_o
234: => pay_pyr_shd.g_old_rec.object_version_number
235: );
236: --

Line 234: => pay_pyr_shd.g_old_rec.object_version_number

230: => pay_pyr_shd.g_old_rec.rate_basis
231: ,p_asg_rate_type_o
232: => pay_pyr_shd.g_old_rec.asg_rate_type
233: ,p_object_version_number_o
234: => pay_pyr_shd.g_old_rec.object_version_number
235: );
236: --
237: exception
238: --

Line 254: (p_rec IN pay_pyr_shd.g_rec_type

250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< del >----------------------------------|
252: -- ----------------------------------------------------------------------------
253: PROCEDURE del
254: (p_rec IN pay_pyr_shd.g_rec_type
255: ) IS
256: --
257: l_proc VARCHAR2(72) := g_package||'del';
258: --

Line 264: pay_pyr_shd.lck

260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: -- We must lock the row which we need to delete.
263: --
264: pay_pyr_shd.lck
265: (p_rec.rate_id
266: ,p_rec.object_version_number
267: );
268: --

Line 301: l_rec pay_pyr_shd.g_rec_type;

297: (p_rate_id IN NUMBER
298: ,p_object_version_number IN NUMBER
299: ,p_rate_type IN VARCHAR2) IS
300: --
301: l_rec pay_pyr_shd.g_rec_type;
302: l_proc VARCHAR2(72) := g_package||'del';
303: --
304: BEGIN
305: hr_utility.set_location('Entering:'||l_proc, 5);