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_BDT_DEL dependencies on PQH_BDT_SHD

Line 45: Procedure delete_dml(p_rec in pqh_bdt_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_bdt_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 64: pqh_bdt_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_bdt_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_bdt_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_bdt_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_bdt_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_bdt_shd.g_rec_type) is
145: --
146: l_proc varchar2(72) := g_package||'post_delete';
147: --
148: Begin

Line 159: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id

155: --
156: pqh_bdt_rkd.after_delete
157: (
158: p_budget_detail_id =>p_rec.budget_detail_id
159: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
160: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
161: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id

Line 160: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id

156: pqh_bdt_rkd.after_delete
157: (
158: p_budget_detail_id =>p_rec.budget_detail_id
159: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
160: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
161: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent

Line 161: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id

157: (
158: p_budget_detail_id =>p_rec.budget_detail_id
159: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
160: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
161: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd

Line 162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id

158: p_budget_detail_id =>p_rec.budget_detail_id
159: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
160: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
161: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value

Line 163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id

159: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
160: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
161: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available

Line 164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent

160: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
161: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent

Line 165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd

161: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd

Line 166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value

162: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value

Line 167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available

163: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available

Line 168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent

164: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent

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

165: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd

Line 170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value

166: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value

Line 171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available

167: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
175: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available

Line 172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent

168: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
175: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
176: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status

Line 173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd

169: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
175: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
176: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
177: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number

Line 174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value

170: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
175: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
176: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
177: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number
178: );

Line 175: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available

171: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
175: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
176: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
177: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number
178: );
179: --

Line 176: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status

172: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
175: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
176: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
177: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number
178: );
179: --
180: exception

Line 177: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number

173: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
174: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
175: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
176: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
177: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number
178: );
179: --
180: exception
181: --

Line 201: p_rec in pqh_bdt_shd.g_rec_type

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

Line 211: pqh_bdt_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_bdt_shd.lck
212: (
213: p_rec.budget_detail_id,
214: p_rec.object_version_number
215: );

Line 243: l_rec pqh_bdt_shd.g_rec_type;

239: p_budget_detail_id in number,
240: p_object_version_number in number
241: ) is
242: --
243: l_rec pqh_bdt_shd.g_rec_type;
244: l_proc varchar2(72) := g_package||'del';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);