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_BPR_DEL dependencies on PQH_BPR_SHD

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

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

Line 64: pqh_bpr_shd.constraint_error

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

Line 102: Procedure pre_delete(p_rec in pqh_bpr_shd.g_rec_type) is

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

Line 144: Procedure post_delete(p_rec in pqh_bpr_shd.g_rec_type) is

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

Line 159: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id

155: --
156: pqh_bpr_rkd.after_delete
157: (
158: p_budget_period_id =>p_rec.budget_period_id
159: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
160: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
161: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent

Line 160: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id

156: pqh_bpr_rkd.after_delete
157: (
158: p_budget_period_id =>p_rec.budget_period_id
159: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
160: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
161: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent

Line 161: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id

157: (
158: p_budget_period_id =>p_rec.budget_period_id
159: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
160: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
161: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value

Line 162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent

158: p_budget_period_id =>p_rec.budget_period_id
159: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
160: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
161: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value

Line 163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent

159: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
160: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
161: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value

Line 164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent

160: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
161: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd

Line 165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value

161: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd

Line 166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value

162: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd

Line 167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value

163: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available

Line 168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd

164: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
172: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available

Line 169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd

165: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
172: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
173: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available

Line 170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd

166: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
172: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
173: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
174: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number

Line 171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available

167: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
172: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
173: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
174: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number
175: );

Line 172: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available

168: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
172: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
173: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
174: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number
175: );
176: --

Line 173: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available

169: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
172: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
173: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
174: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number
175: );
176: --
177: exception

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

170: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
171: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
172: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
173: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
174: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number
175: );
176: --
177: exception
178: --

Line 198: p_rec in pqh_bpr_shd.g_rec_type

194: -- |---------------------------------< del >----------------------------------|
195: -- ----------------------------------------------------------------------------
196: Procedure del
197: (
198: p_rec in pqh_bpr_shd.g_rec_type
199: ) is
200: --
201: l_proc varchar2(72) := g_package||'del';
202: --

Line 208: pqh_bpr_shd.lck

204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: -- We must lock the row which we need to delete.
207: --
208: pqh_bpr_shd.lck
209: (
210: p_rec.budget_period_id,
211: p_rec.object_version_number
212: );

Line 240: l_rec pqh_bpr_shd.g_rec_type;

236: p_budget_period_id in number,
237: p_object_version_number in number
238: ) is
239: --
240: l_rec pqh_bpr_shd.g_rec_type;
241: l_proc varchar2(72) := g_package||'del';
242: --
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);