99: Procedure upd
100: (
101: p_effective_date in date,
102: p_worksheet_id in number,
103: p_budget_id in number default hr_api.g_number,
104: p_worksheet_name in varchar2 default hr_api.g_varchar2,
105: p_version_number in number default hr_api.g_number,
106: p_action_date in date default hr_api.g_date,
107: p_date_from in date default hr_api.g_date,
100: (
101: p_effective_date in date,
102: p_worksheet_id in number,
103: p_budget_id in number default hr_api.g_number,
104: p_worksheet_name in varchar2 default hr_api.g_varchar2,
105: p_version_number in number default hr_api.g_number,
106: p_action_date in date default hr_api.g_date,
107: p_date_from in date default hr_api.g_date,
108: p_date_to in date default hr_api.g_date,
101: p_effective_date in date,
102: p_worksheet_id in number,
103: p_budget_id in number default hr_api.g_number,
104: p_worksheet_name in varchar2 default hr_api.g_varchar2,
105: p_version_number in number default hr_api.g_number,
106: p_action_date in date default hr_api.g_date,
107: p_date_from in date default hr_api.g_date,
108: p_date_to in date default hr_api.g_date,
109: p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2,
102: p_worksheet_id in number,
103: p_budget_id in number default hr_api.g_number,
104: p_worksheet_name in varchar2 default hr_api.g_varchar2,
105: p_version_number in number default hr_api.g_number,
106: p_action_date in date default hr_api.g_date,
107: p_date_from in date default hr_api.g_date,
108: p_date_to in date default hr_api.g_date,
109: p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2,
110: p_transaction_status in varchar2 default hr_api.g_varchar2,
103: p_budget_id in number default hr_api.g_number,
104: p_worksheet_name in varchar2 default hr_api.g_varchar2,
105: p_version_number in number default hr_api.g_number,
106: p_action_date in date default hr_api.g_date,
107: p_date_from in date default hr_api.g_date,
108: p_date_to in date default hr_api.g_date,
109: p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2,
110: p_transaction_status in varchar2 default hr_api.g_varchar2,
111: p_object_version_number in out nocopy number,
104: p_worksheet_name in varchar2 default hr_api.g_varchar2,
105: p_version_number in number default hr_api.g_number,
106: p_action_date in date default hr_api.g_date,
107: p_date_from in date default hr_api.g_date,
108: p_date_to in date default hr_api.g_date,
109: p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2,
110: p_transaction_status in varchar2 default hr_api.g_varchar2,
111: p_object_version_number in out nocopy number,
112: p_budget_version_id in number default hr_api.g_number,
105: p_version_number in number default hr_api.g_number,
106: p_action_date in date default hr_api.g_date,
107: p_date_from in date default hr_api.g_date,
108: p_date_to in date default hr_api.g_date,
109: p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2,
110: p_transaction_status in varchar2 default hr_api.g_varchar2,
111: p_object_version_number in out nocopy number,
112: p_budget_version_id in number default hr_api.g_number,
113: p_propagation_method in varchar2 default hr_api.g_varchar2,
106: p_action_date in date default hr_api.g_date,
107: p_date_from in date default hr_api.g_date,
108: p_date_to in date default hr_api.g_date,
109: p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2,
110: p_transaction_status in varchar2 default hr_api.g_varchar2,
111: p_object_version_number in out nocopy number,
112: p_budget_version_id in number default hr_api.g_number,
113: p_propagation_method in varchar2 default hr_api.g_varchar2,
114: p_wf_transaction_category_id in number default hr_api.g_number
108: p_date_to in date default hr_api.g_date,
109: p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2,
110: p_transaction_status in varchar2 default hr_api.g_varchar2,
111: p_object_version_number in out nocopy number,
112: p_budget_version_id in number default hr_api.g_number,
113: p_propagation_method in varchar2 default hr_api.g_varchar2,
114: p_wf_transaction_category_id in number default hr_api.g_number
115: );
116: --
109: p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2,
110: p_transaction_status in varchar2 default hr_api.g_varchar2,
111: p_object_version_number in out nocopy number,
112: p_budget_version_id in number default hr_api.g_number,
113: p_propagation_method in varchar2 default hr_api.g_varchar2,
114: p_wf_transaction_category_id in number default hr_api.g_number
115: );
116: --
117: end pqh_wks_upd;
110: p_transaction_status in varchar2 default hr_api.g_varchar2,
111: p_object_version_number in out nocopy number,
112: p_budget_version_id in number default hr_api.g_number,
113: p_propagation_method in varchar2 default hr_api.g_varchar2,
114: p_wf_transaction_category_id in number default hr_api.g_number
115: );
116: --
117: end pqh_wks_upd;