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_RAN_DEL dependencies on PAY_RAN_SHD

Line 52: (p_rec in pay_ran_shd.g_rec_type

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

Line 75: pay_ran_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: pay_ran_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 pay_ran_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_ran_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_ran_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_ran_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => pay_ran_shd.g_old_rec.range_table_id

164: pay_ran_rkd.after_delete
165: (p_range_id
166: => p_rec.range_id
167: ,p_range_table_id_o
168: => pay_ran_shd.g_old_rec.range_table_id
169: ,p_low_band_o
170: => pay_ran_shd.g_old_rec.low_band
171: ,p_high_band_o
172: => pay_ran_shd.g_old_rec.high_band

Line 170: => pay_ran_shd.g_old_rec.low_band

166: => p_rec.range_id
167: ,p_range_table_id_o
168: => pay_ran_shd.g_old_rec.range_table_id
169: ,p_low_band_o
170: => pay_ran_shd.g_old_rec.low_band
171: ,p_high_band_o
172: => pay_ran_shd.g_old_rec.high_band
173: ,p_amount1_o => pay_ran_shd.g_old_rec.amount1
174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2

Line 172: => pay_ran_shd.g_old_rec.high_band

168: => pay_ran_shd.g_old_rec.range_table_id
169: ,p_low_band_o
170: => pay_ran_shd.g_old_rec.low_band
171: ,p_high_band_o
172: => pay_ran_shd.g_old_rec.high_band
173: ,p_amount1_o => pay_ran_shd.g_old_rec.amount1
174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2
175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3
176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4

Line 173: ,p_amount1_o => pay_ran_shd.g_old_rec.amount1

169: ,p_low_band_o
170: => pay_ran_shd.g_old_rec.low_band
171: ,p_high_band_o
172: => pay_ran_shd.g_old_rec.high_band
173: ,p_amount1_o => pay_ran_shd.g_old_rec.amount1
174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2
175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3
176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4
177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5

Line 174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2

170: => pay_ran_shd.g_old_rec.low_band
171: ,p_high_band_o
172: => pay_ran_shd.g_old_rec.high_band
173: ,p_amount1_o => pay_ran_shd.g_old_rec.amount1
174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2
175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3
176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4
177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5
178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6

Line 175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3

171: ,p_high_band_o
172: => pay_ran_shd.g_old_rec.high_band
173: ,p_amount1_o => pay_ran_shd.g_old_rec.amount1
174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2
175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3
176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4
177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5
178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6
179: ,p_amount7_o => pay_ran_shd.g_old_rec.amount7

Line 176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4

172: => pay_ran_shd.g_old_rec.high_band
173: ,p_amount1_o => pay_ran_shd.g_old_rec.amount1
174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2
175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3
176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4
177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5
178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6
179: ,p_amount7_o => pay_ran_shd.g_old_rec.amount7
180: ,p_amount8_o => pay_ran_shd.g_old_rec.amount8

Line 177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5

173: ,p_amount1_o => pay_ran_shd.g_old_rec.amount1
174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2
175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3
176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4
177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5
178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6
179: ,p_amount7_o => pay_ran_shd.g_old_rec.amount7
180: ,p_amount8_o => pay_ran_shd.g_old_rec.amount8
181: ,p_effective_start_date_o

Line 178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6

174: ,p_amount2_o => pay_ran_shd.g_old_rec.amount2
175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3
176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4
177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5
178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6
179: ,p_amount7_o => pay_ran_shd.g_old_rec.amount7
180: ,p_amount8_o => pay_ran_shd.g_old_rec.amount8
181: ,p_effective_start_date_o
182: => pay_ran_shd.g_old_rec.effective_start_date

Line 179: ,p_amount7_o => pay_ran_shd.g_old_rec.amount7

175: ,p_amount3_o => pay_ran_shd.g_old_rec.amount3
176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4
177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5
178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6
179: ,p_amount7_o => pay_ran_shd.g_old_rec.amount7
180: ,p_amount8_o => pay_ran_shd.g_old_rec.amount8
181: ,p_effective_start_date_o
182: => pay_ran_shd.g_old_rec.effective_start_date
183: ,p_effective_end_date_o

Line 180: ,p_amount8_o => pay_ran_shd.g_old_rec.amount8

176: ,p_amount4_o => pay_ran_shd.g_old_rec.amount4
177: ,p_amount5_o => pay_ran_shd.g_old_rec.amount5
178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6
179: ,p_amount7_o => pay_ran_shd.g_old_rec.amount7
180: ,p_amount8_o => pay_ran_shd.g_old_rec.amount8
181: ,p_effective_start_date_o
182: => pay_ran_shd.g_old_rec.effective_start_date
183: ,p_effective_end_date_o
184: => pay_ran_shd.g_old_rec.effective_end_date

Line 182: => pay_ran_shd.g_old_rec.effective_start_date

178: ,p_amount6_o => pay_ran_shd.g_old_rec.amount6
179: ,p_amount7_o => pay_ran_shd.g_old_rec.amount7
180: ,p_amount8_o => pay_ran_shd.g_old_rec.amount8
181: ,p_effective_start_date_o
182: => pay_ran_shd.g_old_rec.effective_start_date
183: ,p_effective_end_date_o
184: => pay_ran_shd.g_old_rec.effective_end_date
185: ,p_object_version_number_o
186: => pay_ran_shd.g_old_rec.object_version_number

Line 184: => pay_ran_shd.g_old_rec.effective_end_date

180: ,p_amount8_o => pay_ran_shd.g_old_rec.amount8
181: ,p_effective_start_date_o
182: => pay_ran_shd.g_old_rec.effective_start_date
183: ,p_effective_end_date_o
184: => pay_ran_shd.g_old_rec.effective_end_date
185: ,p_object_version_number_o
186: => pay_ran_shd.g_old_rec.object_version_number
187: );
188: --

Line 186: => pay_ran_shd.g_old_rec.object_version_number

182: => pay_ran_shd.g_old_rec.effective_start_date
183: ,p_effective_end_date_o
184: => pay_ran_shd.g_old_rec.effective_end_date
185: ,p_object_version_number_o
186: => pay_ran_shd.g_old_rec.object_version_number
187: );
188: --
189: exception
190: --

Line 206: (p_rec in pay_ran_shd.g_rec_type

202: -- ----------------------------------------------------------------------------
203: -- |---------------------------------< del >----------------------------------|
204: -- ----------------------------------------------------------------------------
205: Procedure del
206: (p_rec in pay_ran_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'del';
210: --

Line 216: pay_ran_shd.lck

212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- We must lock the row which we need to delete.
215: --
216: pay_ran_shd.lck
217: (p_rec.range_id
218: ,p_rec.object_version_number
219: );
220: --

Line 256: l_rec pay_ran_shd.g_rec_type;

252: (p_range_id in number
253: ,p_object_version_number in number
254: ) is
255: --
256: l_rec pay_ran_shd.g_rec_type;
257: l_proc varchar2(72) := g_package||'del';
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);