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_VLD_DEL dependencies on PQH_VLD_SHD

Line 52: (p_rec in pqh_vld_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in pqh_vld_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: pqh_vld_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: pqh_vld_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in pqh_vld_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in pqh_vld_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in pqh_vld_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in pqh_vld_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => pqh_vld_shd.g_old_rec.pension_fund_type_code

164: pqh_vld_rkd.after_delete
165: (p_validation_id
166: => p_rec.validation_id
167: ,p_pension_fund_type_code_o
168: => pqh_vld_shd.g_old_rec.pension_fund_type_code
169: ,p_pension_fund_id_o
170: => pqh_vld_shd.g_old_rec.pension_fund_id
171: ,p_business_group_id_o
172: => pqh_vld_shd.g_old_rec.business_group_id

Line 170: => pqh_vld_shd.g_old_rec.pension_fund_id

166: => p_rec.validation_id
167: ,p_pension_fund_type_code_o
168: => pqh_vld_shd.g_old_rec.pension_fund_type_code
169: ,p_pension_fund_id_o
170: => pqh_vld_shd.g_old_rec.pension_fund_id
171: ,p_business_group_id_o
172: => pqh_vld_shd.g_old_rec.business_group_id
173: ,p_person_id_o
174: => pqh_vld_shd.g_old_rec.person_id

Line 172: => pqh_vld_shd.g_old_rec.business_group_id

168: => pqh_vld_shd.g_old_rec.pension_fund_type_code
169: ,p_pension_fund_id_o
170: => pqh_vld_shd.g_old_rec.pension_fund_id
171: ,p_business_group_id_o
172: => pqh_vld_shd.g_old_rec.business_group_id
173: ,p_person_id_o
174: => pqh_vld_shd.g_old_rec.person_id
175: ,p_request_date_o
176: => pqh_vld_shd.g_old_rec.request_date

Line 174: => pqh_vld_shd.g_old_rec.person_id

170: => pqh_vld_shd.g_old_rec.pension_fund_id
171: ,p_business_group_id_o
172: => pqh_vld_shd.g_old_rec.business_group_id
173: ,p_person_id_o
174: => pqh_vld_shd.g_old_rec.person_id
175: ,p_request_date_o
176: => pqh_vld_shd.g_old_rec.request_date
177: ,p_completion_date_o
178: => pqh_vld_shd.g_old_rec.completion_date

Line 176: => pqh_vld_shd.g_old_rec.request_date

172: => pqh_vld_shd.g_old_rec.business_group_id
173: ,p_person_id_o
174: => pqh_vld_shd.g_old_rec.person_id
175: ,p_request_date_o
176: => pqh_vld_shd.g_old_rec.request_date
177: ,p_completion_date_o
178: => pqh_vld_shd.g_old_rec.completion_date
179: ,p_previous_employer_id_o
180: => pqh_vld_shd.g_old_rec.previous_employer_id

Line 178: => pqh_vld_shd.g_old_rec.completion_date

174: => pqh_vld_shd.g_old_rec.person_id
175: ,p_request_date_o
176: => pqh_vld_shd.g_old_rec.request_date
177: ,p_completion_date_o
178: => pqh_vld_shd.g_old_rec.completion_date
179: ,p_previous_employer_id_o
180: => pqh_vld_shd.g_old_rec.previous_employer_id
181: ,p_previously_validated_flag_o
182: => pqh_vld_shd.g_old_rec.previously_validated_flag

Line 180: => pqh_vld_shd.g_old_rec.previous_employer_id

176: => pqh_vld_shd.g_old_rec.request_date
177: ,p_completion_date_o
178: => pqh_vld_shd.g_old_rec.completion_date
179: ,p_previous_employer_id_o
180: => pqh_vld_shd.g_old_rec.previous_employer_id
181: ,p_previously_validated_flag_o
182: => pqh_vld_shd.g_old_rec.previously_validated_flag
183: ,p_status_o
184: => pqh_vld_shd.g_old_rec.status

Line 182: => pqh_vld_shd.g_old_rec.previously_validated_flag

178: => pqh_vld_shd.g_old_rec.completion_date
179: ,p_previous_employer_id_o
180: => pqh_vld_shd.g_old_rec.previous_employer_id
181: ,p_previously_validated_flag_o
182: => pqh_vld_shd.g_old_rec.previously_validated_flag
183: ,p_status_o
184: => pqh_vld_shd.g_old_rec.status
185: ,p_employer_amount_o
186: => pqh_vld_shd.g_old_rec.employer_amount

Line 184: => pqh_vld_shd.g_old_rec.status

180: => pqh_vld_shd.g_old_rec.previous_employer_id
181: ,p_previously_validated_flag_o
182: => pqh_vld_shd.g_old_rec.previously_validated_flag
183: ,p_status_o
184: => pqh_vld_shd.g_old_rec.status
185: ,p_employer_amount_o
186: => pqh_vld_shd.g_old_rec.employer_amount
187: ,p_employer_currency_code_o
188: => pqh_vld_shd.g_old_rec.employer_currency_code

Line 186: => pqh_vld_shd.g_old_rec.employer_amount

182: => pqh_vld_shd.g_old_rec.previously_validated_flag
183: ,p_status_o
184: => pqh_vld_shd.g_old_rec.status
185: ,p_employer_amount_o
186: => pqh_vld_shd.g_old_rec.employer_amount
187: ,p_employer_currency_code_o
188: => pqh_vld_shd.g_old_rec.employer_currency_code
189: ,p_employee_amount_o
190: => pqh_vld_shd.g_old_rec.employee_amount

Line 188: => pqh_vld_shd.g_old_rec.employer_currency_code

184: => pqh_vld_shd.g_old_rec.status
185: ,p_employer_amount_o
186: => pqh_vld_shd.g_old_rec.employer_amount
187: ,p_employer_currency_code_o
188: => pqh_vld_shd.g_old_rec.employer_currency_code
189: ,p_employee_amount_o
190: => pqh_vld_shd.g_old_rec.employee_amount
191: ,p_employee_currency_code_o
192: => pqh_vld_shd.g_old_rec.employee_currency_code

Line 190: => pqh_vld_shd.g_old_rec.employee_amount

186: => pqh_vld_shd.g_old_rec.employer_amount
187: ,p_employer_currency_code_o
188: => pqh_vld_shd.g_old_rec.employer_currency_code
189: ,p_employee_amount_o
190: => pqh_vld_shd.g_old_rec.employee_amount
191: ,p_employee_currency_code_o
192: => pqh_vld_shd.g_old_rec.employee_currency_code
193: ,p_deduction_per_period_o
194: => pqh_vld_shd.g_old_rec.deduction_per_period

Line 192: => pqh_vld_shd.g_old_rec.employee_currency_code

188: => pqh_vld_shd.g_old_rec.employer_currency_code
189: ,p_employee_amount_o
190: => pqh_vld_shd.g_old_rec.employee_amount
191: ,p_employee_currency_code_o
192: => pqh_vld_shd.g_old_rec.employee_currency_code
193: ,p_deduction_per_period_o
194: => pqh_vld_shd.g_old_rec.deduction_per_period
195: ,p_deduction_currency_code_o
196: => pqh_vld_shd.g_old_rec.deduction_currency_code

Line 194: => pqh_vld_shd.g_old_rec.deduction_per_period

190: => pqh_vld_shd.g_old_rec.employee_amount
191: ,p_employee_currency_code_o
192: => pqh_vld_shd.g_old_rec.employee_currency_code
193: ,p_deduction_per_period_o
194: => pqh_vld_shd.g_old_rec.deduction_per_period
195: ,p_deduction_currency_code_o
196: => pqh_vld_shd.g_old_rec.deduction_currency_code
197: ,p_percent_of_salary_o
198: => pqh_vld_shd.g_old_rec.percent_of_salary

Line 196: => pqh_vld_shd.g_old_rec.deduction_currency_code

192: => pqh_vld_shd.g_old_rec.employee_currency_code
193: ,p_deduction_per_period_o
194: => pqh_vld_shd.g_old_rec.deduction_per_period
195: ,p_deduction_currency_code_o
196: => pqh_vld_shd.g_old_rec.deduction_currency_code
197: ,p_percent_of_salary_o
198: => pqh_vld_shd.g_old_rec.percent_of_salary
199: ,p_object_version_number_o
200: => pqh_vld_shd.g_old_rec.object_version_number

Line 198: => pqh_vld_shd.g_old_rec.percent_of_salary

194: => pqh_vld_shd.g_old_rec.deduction_per_period
195: ,p_deduction_currency_code_o
196: => pqh_vld_shd.g_old_rec.deduction_currency_code
197: ,p_percent_of_salary_o
198: => pqh_vld_shd.g_old_rec.percent_of_salary
199: ,p_object_version_number_o
200: => pqh_vld_shd.g_old_rec.object_version_number
201: );
202: --

Line 200: => pqh_vld_shd.g_old_rec.object_version_number

196: => pqh_vld_shd.g_old_rec.deduction_currency_code
197: ,p_percent_of_salary_o
198: => pqh_vld_shd.g_old_rec.percent_of_salary
199: ,p_object_version_number_o
200: => pqh_vld_shd.g_old_rec.object_version_number
201: );
202: --
203: exception
204: --

Line 220: (p_rec in pqh_vld_shd.g_rec_type

216: -- ----------------------------------------------------------------------------
217: -- |---------------------------------< del >----------------------------------|
218: -- ----------------------------------------------------------------------------
219: Procedure del
220: (p_rec in pqh_vld_shd.g_rec_type
221: ) is
222: --
223: l_proc varchar2(72) := g_package||'del';
224: --

Line 230: pqh_vld_shd.lck

226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: -- We must lock the row which we need to delete.
229: --
230: pqh_vld_shd.lck
231: (p_rec.validation_id
232: ,p_rec.object_version_number
233: );
234: --

Line 267: l_rec pqh_vld_shd.g_rec_type;

263: (p_validation_id in number
264: ,p_object_version_number in number
265: ) is
266: --
267: l_rec pqh_vld_shd.g_rec_type;
268: l_proc varchar2(72) := g_package||'del';
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);