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_BVR_DEL dependencies on PQH_BVR_SHD

Line 48: Procedure delete_dml(p_rec in pqh_bvr_shd.g_rec_type) is

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

Line 67: pqh_bvr_shd.constraint_error

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

Line 105: Procedure pre_delete(p_rec in pqh_bvr_shd.g_rec_type) is

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

Line 148: p_effective_date in date,p_rec in pqh_bvr_shd.g_rec_type) is

144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure post_delete(
148: p_effective_date in date,p_rec in pqh_bvr_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'post_delete';
151: --
152: Begin

Line 163: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id

159: --
160: pqh_bvr_rkd.after_delete
161: (
162: p_budget_version_id =>p_rec.budget_version_id
163: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
164: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
165: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag

Line 164: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number

160: pqh_bvr_rkd.after_delete
161: (
162: p_budget_version_id =>p_rec.budget_version_id
163: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
164: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
165: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status

Line 165: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from

161: (
162: p_budget_version_id =>p_rec.budget_version_id
163: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
164: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
165: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd

Line 166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to

162: p_budget_version_id =>p_rec.budget_version_id
163: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
164: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
165: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number

Line 167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag

163: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
164: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
165: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value

Line 168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status

164: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
165: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value

Line 169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd

165: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value

Line 170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number

166: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
174: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available

Line 171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value

167: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
174: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
175: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available

Line 172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value

168: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
174: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
175: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
176: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available

Line 173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value

169: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
174: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
175: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
176: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available
177: );

Line 174: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available

170: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
174: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
175: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
176: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available
177: );
178: --

Line 175: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available

171: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
174: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
175: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
176: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available
177: );
178: --
179: exception

Line 176: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available

172: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
173: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
174: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
175: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
176: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available
177: );
178: --
179: exception
180: --

Line 201: p_rec in pqh_bvr_shd.g_rec_type

197: -- ----------------------------------------------------------------------------
198: Procedure del
199: (
200: p_effective_date in date,
201: p_rec in pqh_bvr_shd.g_rec_type
202: ) is
203: --
204: l_proc varchar2(72) := g_package||'del';
205: --

Line 211: pqh_bvr_shd.lck

207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: -- We must lock the row which we need to delete.
210: --
211: pqh_bvr_shd.lck
212: (
213: p_rec.budget_version_id,
214: p_rec.object_version_number
215: );

Line 246: l_rec pqh_bvr_shd.g_rec_type;

242: p_budget_version_id in number,
243: p_object_version_number in number
244: ) is
245: --
246: l_rec pqh_bvr_shd.g_rec_type;
247: l_proc varchar2(72) := g_package||'del';
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);