[Home] [Help]
44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_wdt_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
98: --
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: pqh_wdt_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: pqh_wdt_shd.constraint_error
102: pqh_wdt_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: pqh_wdt_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: pqh_wdt_shd.constraint_error
106: pqh_wdt_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: pqh_wdt_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When Others Then
113: Raise;
114: End update_dml;
144: -- Internal Row Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_update(p_rec in pqh_wdt_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'pre_update';
151: --
152: Begin
187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure post_update(
191: p_effective_date in date,p_rec in pqh_wdt_shd.g_rec_type) is
192: --
193: l_proc varchar2(72) := g_package||'post_update';
194: --
195: Begin
232: ,p_old_unit3_value =>p_rec.old_unit3_value
233: ,p_defer_flag =>p_rec.defer_flag
234: ,p_propagation_method =>p_rec.propagation_method
235: ,p_effective_date =>p_effective_date
236: ,p_worksheet_id_o =>pqh_wdt_shd.g_old_rec.worksheet_id
237: ,p_organization_id_o =>pqh_wdt_shd.g_old_rec.organization_id
238: ,p_job_id_o =>pqh_wdt_shd.g_old_rec.job_id
239: ,p_position_id_o =>pqh_wdt_shd.g_old_rec.position_id
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
233: ,p_defer_flag =>p_rec.defer_flag
234: ,p_propagation_method =>p_rec.propagation_method
235: ,p_effective_date =>p_effective_date
236: ,p_worksheet_id_o =>pqh_wdt_shd.g_old_rec.worksheet_id
237: ,p_organization_id_o =>pqh_wdt_shd.g_old_rec.organization_id
238: ,p_job_id_o =>pqh_wdt_shd.g_old_rec.job_id
239: ,p_position_id_o =>pqh_wdt_shd.g_old_rec.position_id
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
234: ,p_propagation_method =>p_rec.propagation_method
235: ,p_effective_date =>p_effective_date
236: ,p_worksheet_id_o =>pqh_wdt_shd.g_old_rec.worksheet_id
237: ,p_organization_id_o =>pqh_wdt_shd.g_old_rec.organization_id
238: ,p_job_id_o =>pqh_wdt_shd.g_old_rec.job_id
239: ,p_position_id_o =>pqh_wdt_shd.g_old_rec.position_id
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
235: ,p_effective_date =>p_effective_date
236: ,p_worksheet_id_o =>pqh_wdt_shd.g_old_rec.worksheet_id
237: ,p_organization_id_o =>pqh_wdt_shd.g_old_rec.organization_id
238: ,p_job_id_o =>pqh_wdt_shd.g_old_rec.job_id
239: ,p_position_id_o =>pqh_wdt_shd.g_old_rec.position_id
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
236: ,p_worksheet_id_o =>pqh_wdt_shd.g_old_rec.worksheet_id
237: ,p_organization_id_o =>pqh_wdt_shd.g_old_rec.organization_id
238: ,p_job_id_o =>pqh_wdt_shd.g_old_rec.job_id
239: ,p_position_id_o =>pqh_wdt_shd.g_old_rec.position_id
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
237: ,p_organization_id_o =>pqh_wdt_shd.g_old_rec.organization_id
238: ,p_job_id_o =>pqh_wdt_shd.g_old_rec.job_id
239: ,p_position_id_o =>pqh_wdt_shd.g_old_rec.position_id
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
238: ,p_job_id_o =>pqh_wdt_shd.g_old_rec.job_id
239: ,p_position_id_o =>pqh_wdt_shd.g_old_rec.position_id
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
239: ,p_position_id_o =>pqh_wdt_shd.g_old_rec.position_id
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
240: ,p_grade_id_o =>pqh_wdt_shd.g_old_rec.grade_id
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
241: ,p_position_transaction_id_o =>pqh_wdt_shd.g_old_rec.position_transaction_id
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
242: ,p_budget_detail_id_o =>pqh_wdt_shd.g_old_rec.budget_detail_id
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
243: ,p_parent_worksheet_detail_id_o =>pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
244: ,p_user_id_o =>pqh_wdt_shd.g_old_rec.user_id
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
245: ,p_action_cd_o =>pqh_wdt_shd.g_old_rec.action_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
246: ,p_budget_unit1_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit1_percent
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
247: ,p_budget_unit1_value_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
248: ,p_budget_unit2_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit2_percent
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
249: ,p_budget_unit2_value_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
250: ,p_budget_unit3_percent_o =>pqh_wdt_shd.g_old_rec.budget_unit3_percent
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
251: ,p_budget_unit3_value_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
252: ,p_object_version_number_o =>pqh_wdt_shd.g_old_rec.object_version_number
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
253: ,p_budget_unit1_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
261: ,p_old_unit2_value_o =>pqh_wdt_shd.g_old_rec.old_unit2_value
254: ,p_budget_unit2_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
261: ,p_old_unit2_value_o =>pqh_wdt_shd.g_old_rec.old_unit2_value
262: ,p_old_unit3_value_o =>pqh_wdt_shd.g_old_rec.old_unit3_value
255: ,p_budget_unit3_value_type_cd_o =>pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
261: ,p_old_unit2_value_o =>pqh_wdt_shd.g_old_rec.old_unit2_value
262: ,p_old_unit3_value_o =>pqh_wdt_shd.g_old_rec.old_unit3_value
263: ,p_defer_flag_o =>pqh_wdt_shd.g_old_rec.defer_flag
256: ,p_status_o =>pqh_wdt_shd.g_old_rec.status
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
261: ,p_old_unit2_value_o =>pqh_wdt_shd.g_old_rec.old_unit2_value
262: ,p_old_unit3_value_o =>pqh_wdt_shd.g_old_rec.old_unit3_value
263: ,p_defer_flag_o =>pqh_wdt_shd.g_old_rec.defer_flag
264: ,p_propagation_method_o =>pqh_wdt_shd.g_old_rec.propagation_method
257: ,p_budget_unit1_available_o =>pqh_wdt_shd.g_old_rec.budget_unit1_available
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
261: ,p_old_unit2_value_o =>pqh_wdt_shd.g_old_rec.old_unit2_value
262: ,p_old_unit3_value_o =>pqh_wdt_shd.g_old_rec.old_unit3_value
263: ,p_defer_flag_o =>pqh_wdt_shd.g_old_rec.defer_flag
264: ,p_propagation_method_o =>pqh_wdt_shd.g_old_rec.propagation_method
265: );
258: ,p_budget_unit2_available_o =>pqh_wdt_shd.g_old_rec.budget_unit2_available
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
261: ,p_old_unit2_value_o =>pqh_wdt_shd.g_old_rec.old_unit2_value
262: ,p_old_unit3_value_o =>pqh_wdt_shd.g_old_rec.old_unit3_value
263: ,p_defer_flag_o =>pqh_wdt_shd.g_old_rec.defer_flag
264: ,p_propagation_method_o =>pqh_wdt_shd.g_old_rec.propagation_method
265: );
266: --
259: ,p_budget_unit3_available_o =>pqh_wdt_shd.g_old_rec.budget_unit3_available
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
261: ,p_old_unit2_value_o =>pqh_wdt_shd.g_old_rec.old_unit2_value
262: ,p_old_unit3_value_o =>pqh_wdt_shd.g_old_rec.old_unit3_value
263: ,p_defer_flag_o =>pqh_wdt_shd.g_old_rec.defer_flag
264: ,p_propagation_method_o =>pqh_wdt_shd.g_old_rec.propagation_method
265: );
266: --
267: exception
260: ,p_old_unit1_value_o =>pqh_wdt_shd.g_old_rec.old_unit1_value
261: ,p_old_unit2_value_o =>pqh_wdt_shd.g_old_rec.old_unit2_value
262: ,p_old_unit3_value_o =>pqh_wdt_shd.g_old_rec.old_unit3_value
263: ,p_defer_flag_o =>pqh_wdt_shd.g_old_rec.defer_flag
264: ,p_propagation_method_o =>pqh_wdt_shd.g_old_rec.propagation_method
265: );
266: --
267: exception
268: --
322: -- Internal Row Handler Use Only.
323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure convert_defs(p_rec in out nocopy pqh_wdt_shd.g_rec_type) is
327: --
328: l_proc varchar2(72) := g_package||'convert_defs';
329: --
330: Begin
337: -- is being used then we must set to the 'current' argument value.
338: --
339: If (p_rec.worksheet_id = hr_api.g_number) then
340: p_rec.worksheet_id :=
341: pqh_wdt_shd.g_old_rec.worksheet_id;
342: End If;
343: If (p_rec.organization_id = hr_api.g_number) then
344: p_rec.organization_id :=
345: pqh_wdt_shd.g_old_rec.organization_id;
341: pqh_wdt_shd.g_old_rec.worksheet_id;
342: End If;
343: If (p_rec.organization_id = hr_api.g_number) then
344: p_rec.organization_id :=
345: pqh_wdt_shd.g_old_rec.organization_id;
346: End If;
347: If (p_rec.job_id = hr_api.g_number) then
348: p_rec.job_id :=
349: pqh_wdt_shd.g_old_rec.job_id;
345: pqh_wdt_shd.g_old_rec.organization_id;
346: End If;
347: If (p_rec.job_id = hr_api.g_number) then
348: p_rec.job_id :=
349: pqh_wdt_shd.g_old_rec.job_id;
350: End If;
351: If (p_rec.position_id = hr_api.g_number) then
352: p_rec.position_id :=
353: pqh_wdt_shd.g_old_rec.position_id;
349: pqh_wdt_shd.g_old_rec.job_id;
350: End If;
351: If (p_rec.position_id = hr_api.g_number) then
352: p_rec.position_id :=
353: pqh_wdt_shd.g_old_rec.position_id;
354: End If;
355: If (p_rec.grade_id = hr_api.g_number) then
356: p_rec.grade_id :=
357: pqh_wdt_shd.g_old_rec.grade_id;
353: pqh_wdt_shd.g_old_rec.position_id;
354: End If;
355: If (p_rec.grade_id = hr_api.g_number) then
356: p_rec.grade_id :=
357: pqh_wdt_shd.g_old_rec.grade_id;
358: End If;
359: If (p_rec.position_transaction_id = hr_api.g_number) then
360: p_rec.position_transaction_id :=
361: pqh_wdt_shd.g_old_rec.position_transaction_id;
357: pqh_wdt_shd.g_old_rec.grade_id;
358: End If;
359: If (p_rec.position_transaction_id = hr_api.g_number) then
360: p_rec.position_transaction_id :=
361: pqh_wdt_shd.g_old_rec.position_transaction_id;
362: End If;
363: If (p_rec.budget_detail_id = hr_api.g_number) then
364: p_rec.budget_detail_id :=
365: pqh_wdt_shd.g_old_rec.budget_detail_id;
361: pqh_wdt_shd.g_old_rec.position_transaction_id;
362: End If;
363: If (p_rec.budget_detail_id = hr_api.g_number) then
364: p_rec.budget_detail_id :=
365: pqh_wdt_shd.g_old_rec.budget_detail_id;
366: End If;
367: If (p_rec.parent_worksheet_detail_id = hr_api.g_number) then
368: p_rec.parent_worksheet_detail_id :=
369: pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id;
365: pqh_wdt_shd.g_old_rec.budget_detail_id;
366: End If;
367: If (p_rec.parent_worksheet_detail_id = hr_api.g_number) then
368: p_rec.parent_worksheet_detail_id :=
369: pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id;
370: End If;
371: If (p_rec.user_id = hr_api.g_number) then
372: p_rec.user_id :=
373: pqh_wdt_shd.g_old_rec.user_id;
369: pqh_wdt_shd.g_old_rec.parent_worksheet_detail_id;
370: End If;
371: If (p_rec.user_id = hr_api.g_number) then
372: p_rec.user_id :=
373: pqh_wdt_shd.g_old_rec.user_id;
374: End If;
375: If (p_rec.action_cd = hr_api.g_varchar2) then
376: p_rec.action_cd :=
377: pqh_wdt_shd.g_old_rec.action_cd;
373: pqh_wdt_shd.g_old_rec.user_id;
374: End If;
375: If (p_rec.action_cd = hr_api.g_varchar2) then
376: p_rec.action_cd :=
377: pqh_wdt_shd.g_old_rec.action_cd;
378: End If;
379: If (p_rec.budget_unit1_percent = hr_api.g_number) then
380: p_rec.budget_unit1_percent :=
381: pqh_wdt_shd.g_old_rec.budget_unit1_percent;
377: pqh_wdt_shd.g_old_rec.action_cd;
378: End If;
379: If (p_rec.budget_unit1_percent = hr_api.g_number) then
380: p_rec.budget_unit1_percent :=
381: pqh_wdt_shd.g_old_rec.budget_unit1_percent;
382: End If;
383: If (p_rec.budget_unit1_value = hr_api.g_number) then
384: p_rec.budget_unit1_value :=
385: pqh_wdt_shd.g_old_rec.budget_unit1_value;
381: pqh_wdt_shd.g_old_rec.budget_unit1_percent;
382: End If;
383: If (p_rec.budget_unit1_value = hr_api.g_number) then
384: p_rec.budget_unit1_value :=
385: pqh_wdt_shd.g_old_rec.budget_unit1_value;
386: End If;
387: If (p_rec.budget_unit2_percent = hr_api.g_number) then
388: p_rec.budget_unit2_percent :=
389: pqh_wdt_shd.g_old_rec.budget_unit2_percent;
385: pqh_wdt_shd.g_old_rec.budget_unit1_value;
386: End If;
387: If (p_rec.budget_unit2_percent = hr_api.g_number) then
388: p_rec.budget_unit2_percent :=
389: pqh_wdt_shd.g_old_rec.budget_unit2_percent;
390: End If;
391: If (p_rec.budget_unit2_value = hr_api.g_number) then
392: p_rec.budget_unit2_value :=
393: pqh_wdt_shd.g_old_rec.budget_unit2_value;
389: pqh_wdt_shd.g_old_rec.budget_unit2_percent;
390: End If;
391: If (p_rec.budget_unit2_value = hr_api.g_number) then
392: p_rec.budget_unit2_value :=
393: pqh_wdt_shd.g_old_rec.budget_unit2_value;
394: End If;
395: If (p_rec.budget_unit3_percent = hr_api.g_number) then
396: p_rec.budget_unit3_percent :=
397: pqh_wdt_shd.g_old_rec.budget_unit3_percent;
393: pqh_wdt_shd.g_old_rec.budget_unit2_value;
394: End If;
395: If (p_rec.budget_unit3_percent = hr_api.g_number) then
396: p_rec.budget_unit3_percent :=
397: pqh_wdt_shd.g_old_rec.budget_unit3_percent;
398: End If;
399: If (p_rec.budget_unit3_value = hr_api.g_number) then
400: p_rec.budget_unit3_value :=
401: pqh_wdt_shd.g_old_rec.budget_unit3_value;
397: pqh_wdt_shd.g_old_rec.budget_unit3_percent;
398: End If;
399: If (p_rec.budget_unit3_value = hr_api.g_number) then
400: p_rec.budget_unit3_value :=
401: pqh_wdt_shd.g_old_rec.budget_unit3_value;
402: End If;
403: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
404: p_rec.budget_unit1_value_type_cd :=
405: pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd;
401: pqh_wdt_shd.g_old_rec.budget_unit3_value;
402: End If;
403: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
404: p_rec.budget_unit1_value_type_cd :=
405: pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd;
406: End If;
407: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
408: p_rec.budget_unit2_value_type_cd :=
409: pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd;
405: pqh_wdt_shd.g_old_rec.budget_unit1_value_type_cd;
406: End If;
407: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
408: p_rec.budget_unit2_value_type_cd :=
409: pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd;
410: End If;
411: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
412: p_rec.budget_unit3_value_type_cd :=
413: pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd;
409: pqh_wdt_shd.g_old_rec.budget_unit2_value_type_cd;
410: End If;
411: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
412: p_rec.budget_unit3_value_type_cd :=
413: pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd;
414: End If;
415: If (p_rec.status = hr_api.g_varchar2) then
416: p_rec.status :=
417: pqh_wdt_shd.g_old_rec.status;
413: pqh_wdt_shd.g_old_rec.budget_unit3_value_type_cd;
414: End If;
415: If (p_rec.status = hr_api.g_varchar2) then
416: p_rec.status :=
417: pqh_wdt_shd.g_old_rec.status;
418: End If;
419: If (p_rec.budget_unit1_available = hr_api.g_number) then
420: p_rec.budget_unit1_available :=
421: pqh_wdt_shd.g_old_rec.budget_unit1_available;
417: pqh_wdt_shd.g_old_rec.status;
418: End If;
419: If (p_rec.budget_unit1_available = hr_api.g_number) then
420: p_rec.budget_unit1_available :=
421: pqh_wdt_shd.g_old_rec.budget_unit1_available;
422: End If;
423: If (p_rec.budget_unit2_available = hr_api.g_number) then
424: p_rec.budget_unit2_available :=
425: pqh_wdt_shd.g_old_rec.budget_unit2_available;
421: pqh_wdt_shd.g_old_rec.budget_unit1_available;
422: End If;
423: If (p_rec.budget_unit2_available = hr_api.g_number) then
424: p_rec.budget_unit2_available :=
425: pqh_wdt_shd.g_old_rec.budget_unit2_available;
426: End If;
427: If (p_rec.budget_unit3_available = hr_api.g_number) then
428: p_rec.budget_unit3_available :=
429: pqh_wdt_shd.g_old_rec.budget_unit3_available;
425: pqh_wdt_shd.g_old_rec.budget_unit2_available;
426: End If;
427: If (p_rec.budget_unit3_available = hr_api.g_number) then
428: p_rec.budget_unit3_available :=
429: pqh_wdt_shd.g_old_rec.budget_unit3_available;
430: End If;
431: If (p_rec.old_unit1_value = hr_api.g_number) then
432: p_rec.old_unit1_value :=
433: pqh_wdt_shd.g_old_rec.old_unit1_value;
429: pqh_wdt_shd.g_old_rec.budget_unit3_available;
430: End If;
431: If (p_rec.old_unit1_value = hr_api.g_number) then
432: p_rec.old_unit1_value :=
433: pqh_wdt_shd.g_old_rec.old_unit1_value;
434: End If;
435: If (p_rec.old_unit2_value = hr_api.g_number) then
436: p_rec.old_unit2_value :=
437: pqh_wdt_shd.g_old_rec.old_unit2_value;
433: pqh_wdt_shd.g_old_rec.old_unit1_value;
434: End If;
435: If (p_rec.old_unit2_value = hr_api.g_number) then
436: p_rec.old_unit2_value :=
437: pqh_wdt_shd.g_old_rec.old_unit2_value;
438: End If;
439: If (p_rec.old_unit3_value = hr_api.g_number) then
440: p_rec.old_unit3_value :=
441: pqh_wdt_shd.g_old_rec.old_unit3_value;
437: pqh_wdt_shd.g_old_rec.old_unit2_value;
438: End If;
439: If (p_rec.old_unit3_value = hr_api.g_number) then
440: p_rec.old_unit3_value :=
441: pqh_wdt_shd.g_old_rec.old_unit3_value;
442: End If;
443: If (p_rec.defer_flag = hr_api.g_varchar2) then
444: p_rec.defer_flag :=
445: pqh_wdt_shd.g_old_rec.defer_flag;
441: pqh_wdt_shd.g_old_rec.old_unit3_value;
442: End If;
443: If (p_rec.defer_flag = hr_api.g_varchar2) then
444: p_rec.defer_flag :=
445: pqh_wdt_shd.g_old_rec.defer_flag;
446: End If;
447: If (p_rec.propagation_method = hr_api.g_varchar2) then
448: p_rec.propagation_method :=
449: pqh_wdt_shd.g_old_rec.propagation_method;
445: pqh_wdt_shd.g_old_rec.defer_flag;
446: End If;
447: If (p_rec.propagation_method = hr_api.g_varchar2) then
448: p_rec.propagation_method :=
449: pqh_wdt_shd.g_old_rec.propagation_method;
450: End If;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: --
458: -- ----------------------------------------------------------------------------
459: Procedure upd
460: (
461: p_effective_date in date,
462: p_rec in out nocopy pqh_wdt_shd.g_rec_type
463: ) is
464: --
465: l_proc varchar2(72) := g_package||'upd';
466: --
468: hr_utility.set_location('Entering:'||l_proc, 5);
469: --
470: -- We must lock the row which we need to update.
471: --
472: pqh_wdt_shd.lck
473: (
474: p_rec.worksheet_detail_id,
475: p_rec.object_version_number
476: );
536: p_defer_flag in varchar2 default hr_api.g_varchar2,
537: p_propagation_method in varchar2 default hr_api.g_varchar2
538: ) is
539: --
540: l_rec pqh_wdt_shd.g_rec_type;
541: l_proc varchar2(72) := g_package||'upd';
542: --
543: Begin
544: hr_utility.set_location('Entering:'||l_proc, 5);
546: -- Call conversion function to turn arguments into the
547: -- l_rec structure.
548: --
549: l_rec :=
550: pqh_wdt_shd.convert_args
551: (
552: p_worksheet_detail_id,
553: p_worksheet_id,
554: p_organization_id,