DBA Data[Home] [Help]

APPS.GHR_PRH_UPD dependencies on HR_API

Line 51: -- by raising and handling the exception hr_api.validate_enabled. We use

47: -- default is false. The validation is controlled by a savepoint and
48: -- rollback mechanism. The savepoint is issued at the beginning of the
49: -- process and is rollbacked at the end of the process
50: -- when all the processing has been completed. The rollback is controlled
51: -- by raising and handling the exception hr_api.validate_enabled. We use
52: -- the exception because, by raising the exception with the
53: -- process, we can exit successfully without having any of the 'OUT'
54: -- parameters being set.
55: --

Line 125: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,

121: -- ----------------------------------------------------------------------------
122: Procedure upd
123: (
124: p_pa_routing_history_id in number,
125: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
126: p_initiator_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_requester_flag in varchar2 default hr_api.g_varchar2,

Line 126: p_initiator_flag in varchar2 default hr_api.g_varchar2,

122: Procedure upd
123: (
124: p_pa_routing_history_id in number,
125: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
126: p_initiator_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_requester_flag in varchar2 default hr_api.g_varchar2,
130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,

Line 127: p_approver_flag in varchar2 default hr_api.g_varchar2,

123: (
124: p_pa_routing_history_id in number,
125: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
126: p_initiator_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_requester_flag in varchar2 default hr_api.g_varchar2,
130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,

Line 128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,

124: p_pa_routing_history_id in number,
125: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
126: p_initiator_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_requester_flag in varchar2 default hr_api.g_varchar2,
130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
132: p_approved_flag in varchar2 default hr_api.g_varchar2,

Line 129: p_requester_flag in varchar2 default hr_api.g_varchar2,

125: p_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
126: p_initiator_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_requester_flag in varchar2 default hr_api.g_varchar2,
130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
132: p_approved_flag in varchar2 default hr_api.g_varchar2,
133: p_user_name in varchar2 default hr_api.g_varchar2,

Line 130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,

126: p_initiator_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_requester_flag in varchar2 default hr_api.g_varchar2,
130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
132: p_approved_flag in varchar2 default hr_api.g_varchar2,
133: p_user_name in varchar2 default hr_api.g_varchar2,
134: p_user_name_employee_id in number default hr_api.g_number,

Line 131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,

127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_requester_flag in varchar2 default hr_api.g_varchar2,
130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
132: p_approved_flag in varchar2 default hr_api.g_varchar2,
133: p_user_name in varchar2 default hr_api.g_varchar2,
134: p_user_name_employee_id in number default hr_api.g_number,
135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,

Line 132: p_approved_flag in varchar2 default hr_api.g_varchar2,

128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_requester_flag in varchar2 default hr_api.g_varchar2,
130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
132: p_approved_flag in varchar2 default hr_api.g_varchar2,
133: p_user_name in varchar2 default hr_api.g_varchar2,
134: p_user_name_employee_id in number default hr_api.g_number,
135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,

Line 133: p_user_name in varchar2 default hr_api.g_varchar2,

129: p_requester_flag in varchar2 default hr_api.g_varchar2,
130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
132: p_approved_flag in varchar2 default hr_api.g_varchar2,
133: p_user_name in varchar2 default hr_api.g_varchar2,
134: p_user_name_employee_id in number default hr_api.g_number,
135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,

Line 134: p_user_name_employee_id in number default hr_api.g_number,

130: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
132: p_approved_flag in varchar2 default hr_api.g_varchar2,
133: p_user_name in varchar2 default hr_api.g_varchar2,
134: p_user_name_employee_id in number default hr_api.g_number,
135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
138: p_notepad in varchar2 default hr_api.g_varchar2,

Line 135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,

131: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
132: p_approved_flag in varchar2 default hr_api.g_varchar2,
133: p_user_name in varchar2 default hr_api.g_varchar2,
134: p_user_name_employee_id in number default hr_api.g_number,
135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
138: p_notepad in varchar2 default hr_api.g_varchar2,
139: p_action_taken in varchar2 default hr_api.g_varchar2,

Line 136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,

132: p_approved_flag in varchar2 default hr_api.g_varchar2,
133: p_user_name in varchar2 default hr_api.g_varchar2,
134: p_user_name_employee_id in number default hr_api.g_number,
135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
138: p_notepad in varchar2 default hr_api.g_varchar2,
139: p_action_taken in varchar2 default hr_api.g_varchar2,
140: p_groupbox_id in number default hr_api.g_number,

Line 137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,

133: p_user_name in varchar2 default hr_api.g_varchar2,
134: p_user_name_employee_id in number default hr_api.g_number,
135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
138: p_notepad in varchar2 default hr_api.g_varchar2,
139: p_action_taken in varchar2 default hr_api.g_varchar2,
140: p_groupbox_id in number default hr_api.g_number,
141: p_noa_family_code in varchar2 default hr_api.g_varchar2,

Line 138: p_notepad in varchar2 default hr_api.g_varchar2,

134: p_user_name_employee_id in number default hr_api.g_number,
135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
138: p_notepad in varchar2 default hr_api.g_varchar2,
139: p_action_taken in varchar2 default hr_api.g_varchar2,
140: p_groupbox_id in number default hr_api.g_number,
141: p_noa_family_code in varchar2 default hr_api.g_varchar2,
142: p_nature_of_action_id in number default hr_api.g_number,

Line 139: p_action_taken in varchar2 default hr_api.g_varchar2,

135: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
138: p_notepad in varchar2 default hr_api.g_varchar2,
139: p_action_taken in varchar2 default hr_api.g_varchar2,
140: p_groupbox_id in number default hr_api.g_number,
141: p_noa_family_code in varchar2 default hr_api.g_varchar2,
142: p_nature_of_action_id in number default hr_api.g_number,
143: p_second_nature_of_action_id in number default hr_api.g_number,

Line 140: p_groupbox_id in number default hr_api.g_number,

136: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
138: p_notepad in varchar2 default hr_api.g_varchar2,
139: p_action_taken in varchar2 default hr_api.g_varchar2,
140: p_groupbox_id in number default hr_api.g_number,
141: p_noa_family_code in varchar2 default hr_api.g_varchar2,
142: p_nature_of_action_id in number default hr_api.g_number,
143: p_second_nature_of_action_id in number default hr_api.g_number,
144: p_approval_status in varchar2 default hr_api.g_varchar2,

Line 141: p_noa_family_code in varchar2 default hr_api.g_varchar2,

137: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
138: p_notepad in varchar2 default hr_api.g_varchar2,
139: p_action_taken in varchar2 default hr_api.g_varchar2,
140: p_groupbox_id in number default hr_api.g_number,
141: p_noa_family_code in varchar2 default hr_api.g_varchar2,
142: p_nature_of_action_id in number default hr_api.g_number,
143: p_second_nature_of_action_id in number default hr_api.g_number,
144: p_approval_status in varchar2 default hr_api.g_varchar2,
145: p_date_notification_sent in date default hr_api.g_date,

Line 142: p_nature_of_action_id in number default hr_api.g_number,

138: p_notepad in varchar2 default hr_api.g_varchar2,
139: p_action_taken in varchar2 default hr_api.g_varchar2,
140: p_groupbox_id in number default hr_api.g_number,
141: p_noa_family_code in varchar2 default hr_api.g_varchar2,
142: p_nature_of_action_id in number default hr_api.g_number,
143: p_second_nature_of_action_id in number default hr_api.g_number,
144: p_approval_status in varchar2 default hr_api.g_varchar2,
145: p_date_notification_sent in date default hr_api.g_date,
146: p_object_version_number in out NOCOPY number,

Line 143: p_second_nature_of_action_id in number default hr_api.g_number,

139: p_action_taken in varchar2 default hr_api.g_varchar2,
140: p_groupbox_id in number default hr_api.g_number,
141: p_noa_family_code in varchar2 default hr_api.g_varchar2,
142: p_nature_of_action_id in number default hr_api.g_number,
143: p_second_nature_of_action_id in number default hr_api.g_number,
144: p_approval_status in varchar2 default hr_api.g_varchar2,
145: p_date_notification_sent in date default hr_api.g_date,
146: p_object_version_number in out NOCOPY number,
147: p_validate in boolean default false

Line 144: p_approval_status in varchar2 default hr_api.g_varchar2,

140: p_groupbox_id in number default hr_api.g_number,
141: p_noa_family_code in varchar2 default hr_api.g_varchar2,
142: p_nature_of_action_id in number default hr_api.g_number,
143: p_second_nature_of_action_id in number default hr_api.g_number,
144: p_approval_status in varchar2 default hr_api.g_varchar2,
145: p_date_notification_sent in date default hr_api.g_date,
146: p_object_version_number in out NOCOPY number,
147: p_validate in boolean default false
148: );

Line 145: p_date_notification_sent in date default hr_api.g_date,

141: p_noa_family_code in varchar2 default hr_api.g_varchar2,
142: p_nature_of_action_id in number default hr_api.g_number,
143: p_second_nature_of_action_id in number default hr_api.g_number,
144: p_approval_status in varchar2 default hr_api.g_varchar2,
145: p_date_notification_sent in date default hr_api.g_date,
146: p_object_version_number in out NOCOPY number,
147: p_validate in boolean default false
148: );
149: --