DBA Data[Home] [Help]

APPS.HR_TRN_UPD dependencies on HR_API

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

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

Line 124: p_creator_person_id in number default hr_api.g_number,

120: -- ----------------------------------------------------------------------------
121: Procedure upd
122: (
123: p_transaction_id in number,
124: p_creator_person_id in number default hr_api.g_number,
125: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
126: p_validate in boolean default false
127: );
128: --

Line 125: p_transaction_privilege in varchar2 default hr_api.g_varchar2,

121: Procedure upd
122: (
123: p_transaction_id in number,
124: p_creator_person_id in number default hr_api.g_number,
125: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
126: p_validate in boolean default false
127: );
128: --
129: -- Overloaded procedure to accomodate extra columns

Line 133: p_creator_person_id in number default hr_api.g_number,

129: -- Overloaded procedure to accomodate extra columns
130: Procedure upd
131: (
132: p_transaction_id in number,
133: p_creator_person_id in number default hr_api.g_number,
134: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
135: p_validate in boolean default false,
136: p_product_code in varchar2 default hr_api.g_varchar2,
137: p_url in varchar2 default hr_api.g_varchar2,

Line 134: p_transaction_privilege in varchar2 default hr_api.g_varchar2,

130: Procedure upd
131: (
132: p_transaction_id in number,
133: p_creator_person_id in number default hr_api.g_number,
134: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
135: p_validate in boolean default false,
136: p_product_code in varchar2 default hr_api.g_varchar2,
137: p_url in varchar2 default hr_api.g_varchar2,
138: p_status in varchar2,

Line 136: p_product_code in varchar2 default hr_api.g_varchar2,

132: p_transaction_id in number,
133: p_creator_person_id in number default hr_api.g_number,
134: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
135: p_validate in boolean default false,
136: p_product_code in varchar2 default hr_api.g_varchar2,
137: p_url in varchar2 default hr_api.g_varchar2,
138: p_status in varchar2,
139: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
140: p_section_display_name in varchar2 default hr_api.g_varchar2,

Line 137: p_url in varchar2 default hr_api.g_varchar2,

133: p_creator_person_id in number default hr_api.g_number,
134: p_transaction_privilege in varchar2 default hr_api.g_varchar2,
135: p_validate in boolean default false,
136: p_product_code in varchar2 default hr_api.g_varchar2,
137: p_url in varchar2 default hr_api.g_varchar2,
138: p_status in varchar2,
139: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
140: p_section_display_name in varchar2 default hr_api.g_varchar2,
141: p_function_id in number default hr_api.g_number,

Line 139: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns

135: p_validate in boolean default false,
136: p_product_code in varchar2 default hr_api.g_varchar2,
137: p_url in varchar2 default hr_api.g_varchar2,
138: p_status in varchar2,
139: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
140: p_section_display_name in varchar2 default hr_api.g_varchar2,
141: p_function_id in number default hr_api.g_number,
142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
143: p_transaction_ref_id in number default hr_api.g_number,

Line 140: p_section_display_name in varchar2 default hr_api.g_varchar2,

136: p_product_code in varchar2 default hr_api.g_varchar2,
137: p_url in varchar2 default hr_api.g_varchar2,
138: p_status in varchar2,
139: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
140: p_section_display_name in varchar2 default hr_api.g_varchar2,
141: p_function_id in number default hr_api.g_number,
142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
143: p_transaction_ref_id in number default hr_api.g_number,
144: p_transaction_type in varchar2 default hr_api.g_varchar2,

Line 141: p_function_id in number default hr_api.g_number,

137: p_url in varchar2 default hr_api.g_varchar2,
138: p_status in varchar2,
139: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
140: p_section_display_name in varchar2 default hr_api.g_varchar2,
141: p_function_id in number default hr_api.g_number,
142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
143: p_transaction_ref_id in number default hr_api.g_number,
144: p_transaction_type in varchar2 default hr_api.g_varchar2,
145: p_assignment_id in number default hr_api.g_number,

Line 142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,

138: p_status in varchar2,
139: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
140: p_section_display_name in varchar2 default hr_api.g_varchar2,
141: p_function_id in number default hr_api.g_number,
142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
143: p_transaction_ref_id in number default hr_api.g_number,
144: p_transaction_type in varchar2 default hr_api.g_varchar2,
145: p_assignment_id in number default hr_api.g_number,
146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,

Line 143: p_transaction_ref_id in number default hr_api.g_number,

139: p_transaction_state in varchar2 default hr_api.g_varchar2, --ns
140: p_section_display_name in varchar2 default hr_api.g_varchar2,
141: p_function_id in number default hr_api.g_number,
142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
143: p_transaction_ref_id in number default hr_api.g_number,
144: p_transaction_type in varchar2 default hr_api.g_varchar2,
145: p_assignment_id in number default hr_api.g_number,
146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
147: p_selected_person_id in number default hr_api.g_number,

Line 144: p_transaction_type in varchar2 default hr_api.g_varchar2,

140: p_section_display_name in varchar2 default hr_api.g_varchar2,
141: p_function_id in number default hr_api.g_number,
142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
143: p_transaction_ref_id in number default hr_api.g_number,
144: p_transaction_type in varchar2 default hr_api.g_varchar2,
145: p_assignment_id in number default hr_api.g_number,
146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
147: p_selected_person_id in number default hr_api.g_number,
148: p_item_type in varchar2 default hr_api.g_varchar2,

Line 145: p_assignment_id in number default hr_api.g_number,

141: p_function_id in number default hr_api.g_number,
142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
143: p_transaction_ref_id in number default hr_api.g_number,
144: p_transaction_type in varchar2 default hr_api.g_varchar2,
145: p_assignment_id in number default hr_api.g_number,
146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
147: p_selected_person_id in number default hr_api.g_number,
148: p_item_type in varchar2 default hr_api.g_varchar2,
149: p_item_key in varchar2 default hr_api.g_varchar2,

Line 146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,

142: p_transaction_ref_table in varchar2 default hr_api.g_varchar2,
143: p_transaction_ref_id in number default hr_api.g_number,
144: p_transaction_type in varchar2 default hr_api.g_varchar2,
145: p_assignment_id in number default hr_api.g_number,
146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
147: p_selected_person_id in number default hr_api.g_number,
148: p_item_type in varchar2 default hr_api.g_varchar2,
149: p_item_key in varchar2 default hr_api.g_varchar2,
150: p_transaction_effective_date in date default hr_api.g_date,

Line 147: p_selected_person_id in number default hr_api.g_number,

143: p_transaction_ref_id in number default hr_api.g_number,
144: p_transaction_type in varchar2 default hr_api.g_varchar2,
145: p_assignment_id in number default hr_api.g_number,
146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
147: p_selected_person_id in number default hr_api.g_number,
148: p_item_type in varchar2 default hr_api.g_varchar2,
149: p_item_key in varchar2 default hr_api.g_varchar2,
150: p_transaction_effective_date in date default hr_api.g_date,
151: p_process_name in varchar2 default hr_api.g_varchar2,

Line 148: p_item_type in varchar2 default hr_api.g_varchar2,

144: p_transaction_type in varchar2 default hr_api.g_varchar2,
145: p_assignment_id in number default hr_api.g_number,
146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
147: p_selected_person_id in number default hr_api.g_number,
148: p_item_type in varchar2 default hr_api.g_varchar2,
149: p_item_key in varchar2 default hr_api.g_varchar2,
150: p_transaction_effective_date in date default hr_api.g_date,
151: p_process_name in varchar2 default hr_api.g_varchar2,
152: p_plan_id in number default hr_api.g_number,

Line 149: p_item_key in varchar2 default hr_api.g_varchar2,

145: p_assignment_id in number default hr_api.g_number,
146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
147: p_selected_person_id in number default hr_api.g_number,
148: p_item_type in varchar2 default hr_api.g_varchar2,
149: p_item_key in varchar2 default hr_api.g_varchar2,
150: p_transaction_effective_date in date default hr_api.g_date,
151: p_process_name in varchar2 default hr_api.g_varchar2,
152: p_plan_id in number default hr_api.g_number,
153: p_rptg_grp_id in number default hr_api.g_number,

Line 150: p_transaction_effective_date in date default hr_api.g_date,

146: p_api_addtnl_info in varchar2 default hr_api.g_varchar2,
147: p_selected_person_id in number default hr_api.g_number,
148: p_item_type in varchar2 default hr_api.g_varchar2,
149: p_item_key in varchar2 default hr_api.g_varchar2,
150: p_transaction_effective_date in date default hr_api.g_date,
151: p_process_name in varchar2 default hr_api.g_varchar2,
152: p_plan_id in number default hr_api.g_number,
153: p_rptg_grp_id in number default hr_api.g_number,
154: p_effective_date_option in varchar2 default hr_api.g_varchar2,

Line 151: p_process_name in varchar2 default hr_api.g_varchar2,

147: p_selected_person_id in number default hr_api.g_number,
148: p_item_type in varchar2 default hr_api.g_varchar2,
149: p_item_key in varchar2 default hr_api.g_varchar2,
150: p_transaction_effective_date in date default hr_api.g_date,
151: p_process_name in varchar2 default hr_api.g_varchar2,
152: p_plan_id in number default hr_api.g_number,
153: p_rptg_grp_id in number default hr_api.g_number,
154: p_effective_date_option in varchar2 default hr_api.g_varchar2,
155: p_creator_role in varchar2 default hr_api.g_varchar2,

Line 152: p_plan_id in number default hr_api.g_number,

148: p_item_type in varchar2 default hr_api.g_varchar2,
149: p_item_key in varchar2 default hr_api.g_varchar2,
150: p_transaction_effective_date in date default hr_api.g_date,
151: p_process_name in varchar2 default hr_api.g_varchar2,
152: p_plan_id in number default hr_api.g_number,
153: p_rptg_grp_id in number default hr_api.g_number,
154: p_effective_date_option in varchar2 default hr_api.g_varchar2,
155: p_creator_role in varchar2 default hr_api.g_varchar2,
156: p_last_update_role in varchar2 default hr_api.g_varchar2,

Line 153: p_rptg_grp_id in number default hr_api.g_number,

149: p_item_key in varchar2 default hr_api.g_varchar2,
150: p_transaction_effective_date in date default hr_api.g_date,
151: p_process_name in varchar2 default hr_api.g_varchar2,
152: p_plan_id in number default hr_api.g_number,
153: p_rptg_grp_id in number default hr_api.g_number,
154: p_effective_date_option in varchar2 default hr_api.g_varchar2,
155: p_creator_role in varchar2 default hr_api.g_varchar2,
156: p_last_update_role in varchar2 default hr_api.g_varchar2,
157: p_parent_transaction_id in number default hr_api.g_number,

Line 154: p_effective_date_option in varchar2 default hr_api.g_varchar2,

150: p_transaction_effective_date in date default hr_api.g_date,
151: p_process_name in varchar2 default hr_api.g_varchar2,
152: p_plan_id in number default hr_api.g_number,
153: p_rptg_grp_id in number default hr_api.g_number,
154: p_effective_date_option in varchar2 default hr_api.g_varchar2,
155: p_creator_role in varchar2 default hr_api.g_varchar2,
156: p_last_update_role in varchar2 default hr_api.g_varchar2,
157: p_parent_transaction_id in number default hr_api.g_number,
158: p_relaunch_function in varchar2 default hr_api.g_varchar2,

Line 155: p_creator_role in varchar2 default hr_api.g_varchar2,

151: p_process_name in varchar2 default hr_api.g_varchar2,
152: p_plan_id in number default hr_api.g_number,
153: p_rptg_grp_id in number default hr_api.g_number,
154: p_effective_date_option in varchar2 default hr_api.g_varchar2,
155: p_creator_role in varchar2 default hr_api.g_varchar2,
156: p_last_update_role in varchar2 default hr_api.g_varchar2,
157: p_parent_transaction_id in number default hr_api.g_number,
158: p_relaunch_function in varchar2 default hr_api.g_varchar2,
159: p_transaction_group in varchar2 default hr_api.g_varchar2,

Line 156: p_last_update_role in varchar2 default hr_api.g_varchar2,

152: p_plan_id in number default hr_api.g_number,
153: p_rptg_grp_id in number default hr_api.g_number,
154: p_effective_date_option in varchar2 default hr_api.g_varchar2,
155: p_creator_role in varchar2 default hr_api.g_varchar2,
156: p_last_update_role in varchar2 default hr_api.g_varchar2,
157: p_parent_transaction_id in number default hr_api.g_number,
158: p_relaunch_function in varchar2 default hr_api.g_varchar2,
159: p_transaction_group in varchar2 default hr_api.g_varchar2,
160: p_transaction_identifier in varchar2 default hr_api.g_varchar2,

Line 157: p_parent_transaction_id in number default hr_api.g_number,

153: p_rptg_grp_id in number default hr_api.g_number,
154: p_effective_date_option in varchar2 default hr_api.g_varchar2,
155: p_creator_role in varchar2 default hr_api.g_varchar2,
156: p_last_update_role in varchar2 default hr_api.g_varchar2,
157: p_parent_transaction_id in number default hr_api.g_number,
158: p_relaunch_function in varchar2 default hr_api.g_varchar2,
159: p_transaction_group in varchar2 default hr_api.g_varchar2,
160: p_transaction_identifier in varchar2 default hr_api.g_varchar2,
161: p_transaction_document in clob default NULL

Line 158: p_relaunch_function in varchar2 default hr_api.g_varchar2,

154: p_effective_date_option in varchar2 default hr_api.g_varchar2,
155: p_creator_role in varchar2 default hr_api.g_varchar2,
156: p_last_update_role in varchar2 default hr_api.g_varchar2,
157: p_parent_transaction_id in number default hr_api.g_number,
158: p_relaunch_function in varchar2 default hr_api.g_varchar2,
159: p_transaction_group in varchar2 default hr_api.g_varchar2,
160: p_transaction_identifier in varchar2 default hr_api.g_varchar2,
161: p_transaction_document in clob default NULL
162: ) ;

Line 159: p_transaction_group in varchar2 default hr_api.g_varchar2,

155: p_creator_role in varchar2 default hr_api.g_varchar2,
156: p_last_update_role in varchar2 default hr_api.g_varchar2,
157: p_parent_transaction_id in number default hr_api.g_number,
158: p_relaunch_function in varchar2 default hr_api.g_varchar2,
159: p_transaction_group in varchar2 default hr_api.g_varchar2,
160: p_transaction_identifier in varchar2 default hr_api.g_varchar2,
161: p_transaction_document in clob default NULL
162: ) ;
163: --

Line 160: p_transaction_identifier in varchar2 default hr_api.g_varchar2,

156: p_last_update_role in varchar2 default hr_api.g_varchar2,
157: p_parent_transaction_id in number default hr_api.g_number,
158: p_relaunch_function in varchar2 default hr_api.g_varchar2,
159: p_transaction_group in varchar2 default hr_api.g_varchar2,
160: p_transaction_identifier in varchar2 default hr_api.g_varchar2,
161: p_transaction_document in clob default NULL
162: ) ;
163: --
164: -- p_plan_id, p_rptg_grp_id, p_effective_date_option added by sanej