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_BST_DEL dependencies on PQH_BST_SHD

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

Line 64: pqh_bst_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_bst_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_bst_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_bst_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin

Line 145: p_effective_date in date,p_rec in pqh_bst_shd.g_rec_type) is

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

Line 160: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id

156: --
157: pqh_bst_rkd.after_delete
158: (
159: p_budget_set_id =>p_rec.budget_set_id
160: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
161: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
162: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent

Line 161: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id

157: pqh_bst_rkd.after_delete
158: (
159: p_budget_set_id =>p_rec.budget_set_id
160: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
161: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
162: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value

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

158: (
159: p_budget_set_id =>p_rec.budget_set_id
160: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
161: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
162: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value

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

159: p_budget_set_id =>p_rec.budget_set_id
160: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
161: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
162: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value

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

160: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
161: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
162: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available

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

161: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
162: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
169: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available

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

162: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
163: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
169: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available
170: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available

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

163: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
169: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available
170: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available
171: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number

Line 168: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available

164: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
165: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
166: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
167: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
168: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
169: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available
170: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available
171: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number
172: ,p_budget_unit1_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd

Line 169: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available

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

Line 170: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available

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

Line 171: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number

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

Line 172: ,p_budget_unit1_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd

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

Line 173: ,p_budget_unit2_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd

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

Line 174: ,p_budget_unit3_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd

170: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available
171: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number
172: ,p_budget_unit1_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd
173: ,p_budget_unit2_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd
174: ,p_budget_unit3_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd
175: );
176: --
177: exception
178: --

Line 199: p_rec in pqh_bst_shd.g_rec_type

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

Line 209: pqh_bst_shd.lck

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

Line 244: l_rec pqh_bst_shd.g_rec_type;

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