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_BCE_DEL dependencies on PQH_BCE_SHD

Line 48: Procedure delete_dml(p_rec in pqh_bce_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_bce_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'delete_dml';
51: --
52: Begin

Line 67: pqh_bce_shd.constraint_error

63: --
64: Exception
65: When hr_api.child_integrity_violated then
66: -- Child integrity has been violated
67: pqh_bce_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_bce_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_bce_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_bce_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_bce_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_bce_shd.g_old_rec.budget_id

159: --
160: pqh_bce_rkd.after_delete
161: (
162: p_bdgt_cmmtmnt_elmnt_id =>p_rec.bdgt_cmmtmnt_elmnt_id
163: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
164: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
165: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id

Line 164: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type

160: pqh_bce_rkd.after_delete
161: (
162: p_bdgt_cmmtmnt_elmnt_id =>p_rec.bdgt_cmmtmnt_elmnt_id
163: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
164: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
165: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id

Line 165: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id

161: (
162: p_bdgt_cmmtmnt_elmnt_id =>p_rec.bdgt_cmmtmnt_elmnt_id
163: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
164: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
165: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id

Line 166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag

162: p_bdgt_cmmtmnt_elmnt_id =>p_rec.bdgt_cmmtmnt_elmnt_id
163: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
164: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
165: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id

Line 167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id

163: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
164: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
165: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
171: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency

Line 168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id

164: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
165: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
171: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
172: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage

Line 169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id

165: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
171: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
172: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
173: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number

Line 170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id

166: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
171: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
172: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
173: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number
174: );

Line 171: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency

167: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
171: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
172: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
173: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number
174: );
175: --

Line 172: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage

168: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
171: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
172: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
173: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number
174: );
175: --
176: exception

Line 173: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number

169: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
170: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
171: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
172: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
173: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number
174: );
175: --
176: exception
177: --

Line 198: p_rec in pqh_bce_shd.g_rec_type

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

Line 208: pqh_bce_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_bce_shd.lck
209: (
210: p_rec.bdgt_cmmtmnt_elmnt_id,
211: p_rec.object_version_number
212: );

Line 243: l_rec pqh_bce_shd.g_rec_type;

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