APPS.PQP_ANALYZED_ALIEN_DATA_API dependencies on HR_API

Line 86: when hr_api.cannot_find_prog_unit then

82: ,p_date_8233_signed => p_date_8233_signed
83: ,p_date_w4_signed => p_date_w4_signed
84: );
85: exception
86: when hr_api.cannot_find_prog_unit then
87: hr_api.cannot_find_prog_unit_error
88: (
89: p_module_name => 'CREATE_ANALYZED_ALIEN_DATA'
90: ,p_hook_type => 'BP'

Line 87: hr_api.cannot_find_prog_unit_error

83: ,p_date_w4_signed => p_date_w4_signed
84: );
85: exception
86: when hr_api.cannot_find_prog_unit then
87: hr_api.cannot_find_prog_unit_error
88: (
89: p_module_name => 'CREATE_ANALYZED_ALIEN_DATA'
90: ,p_hook_type => 'BP'
91: );

Line 153: when hr_api.cannot_find_prog_unit then

149: ,p_date_8233_signed => p_date_8233_signed
150: ,p_date_w4_signed => p_date_w4_signed
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'CREATE_ANALYZED_ALIEN_DATA'
156: ,p_hook_type => 'AP'
157: );

Line 154: hr_api.cannot_find_prog_unit_error

150: ,p_date_w4_signed => p_date_w4_signed
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'CREATE_ANALYZED_ALIEN_DATA'
156: ,p_hook_type => 'AP'
157: );
158: --

Line 168: raise hr_api.validate_enabled;

164: --
165: -- When in validation only mode raise the Validate_Enabled exception
166: --
167: if p_validate then
168: raise hr_api.validate_enabled;
169: end if;
170: --
171: -- Set all output arguments
172: --

Line 180: when hr_api.validate_enabled then

176: hr_utility.set_location(' Leaving:'||l_proc, 70);
177: --
178: exception
179: --
180: when hr_api.validate_enabled then
181: --
182: -- As the Validate_Enabled exception has been raised
183: -- we must rollback to the savepoint
184: --

Line 213: ,p_assignment_id in number default hr_api.g_number

209: --
210: procedure update_analyzed_alien_data
211: (p_validate in boolean default false
212: ,p_analyzed_data_id in number
213: ,p_assignment_id in number default hr_api.g_number
214: ,p_data_source in varchar2 default hr_api.g_varchar2
215: ,p_tax_year in number default hr_api.g_number
216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
217: ,p_nra_to_ra_date in date default hr_api.g_date

Line 214: ,p_data_source in varchar2 default hr_api.g_varchar2

210: procedure update_analyzed_alien_data
211: (p_validate in boolean default false
212: ,p_analyzed_data_id in number
213: ,p_assignment_id in number default hr_api.g_number
214: ,p_data_source in varchar2 default hr_api.g_varchar2
215: ,p_tax_year in number default hr_api.g_number
216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
217: ,p_nra_to_ra_date in date default hr_api.g_date
218: ,p_target_departure_date in date default hr_api.g_date

Line 215: ,p_tax_year in number default hr_api.g_number

211: (p_validate in boolean default false
212: ,p_analyzed_data_id in number
213: ,p_assignment_id in number default hr_api.g_number
214: ,p_data_source in varchar2 default hr_api.g_varchar2
215: ,p_tax_year in number default hr_api.g_number
216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
217: ,p_nra_to_ra_date in date default hr_api.g_date
218: ,p_target_departure_date in date default hr_api.g_date
219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2

Line 216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2

212: ,p_analyzed_data_id in number
213: ,p_assignment_id in number default hr_api.g_number
214: ,p_data_source in varchar2 default hr_api.g_varchar2
215: ,p_tax_year in number default hr_api.g_number
216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
217: ,p_nra_to_ra_date in date default hr_api.g_date
218: ,p_target_departure_date in date default hr_api.g_date
219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
220: ,p_treaty_info_update_date in date default hr_api.g_date

Line 217: ,p_nra_to_ra_date in date default hr_api.g_date

213: ,p_assignment_id in number default hr_api.g_number
214: ,p_data_source in varchar2 default hr_api.g_varchar2
215: ,p_tax_year in number default hr_api.g_number
216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
217: ,p_nra_to_ra_date in date default hr_api.g_date
218: ,p_target_departure_date in date default hr_api.g_date
219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
220: ,p_treaty_info_update_date in date default hr_api.g_date
221: ,p_number_of_days_in_usa in number default hr_api.g_number

Line 218: ,p_target_departure_date in date default hr_api.g_date

214: ,p_data_source in varchar2 default hr_api.g_varchar2
215: ,p_tax_year in number default hr_api.g_number
216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
217: ,p_nra_to_ra_date in date default hr_api.g_date
218: ,p_target_departure_date in date default hr_api.g_date
219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
220: ,p_treaty_info_update_date in date default hr_api.g_date
221: ,p_number_of_days_in_usa in number default hr_api.g_number
222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2

Line 219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2

215: ,p_tax_year in number default hr_api.g_number
216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
217: ,p_nra_to_ra_date in date default hr_api.g_date
218: ,p_target_departure_date in date default hr_api.g_date
219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
220: ,p_treaty_info_update_date in date default hr_api.g_date
221: ,p_number_of_days_in_usa in number default hr_api.g_number
222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
223: ,p_ra_effective_date in date default hr_api.g_date

Line 220: ,p_treaty_info_update_date in date default hr_api.g_date

216: ,p_current_residency_status in varchar2 default hr_api.g_varchar2
217: ,p_nra_to_ra_date in date default hr_api.g_date
218: ,p_target_departure_date in date default hr_api.g_date
219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
220: ,p_treaty_info_update_date in date default hr_api.g_date
221: ,p_number_of_days_in_usa in number default hr_api.g_number
222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
223: ,p_ra_effective_date in date default hr_api.g_date
224: ,p_record_source in varchar2 default hr_api.g_varchar2

Line 221: ,p_number_of_days_in_usa in number default hr_api.g_number

217: ,p_nra_to_ra_date in date default hr_api.g_date
218: ,p_target_departure_date in date default hr_api.g_date
219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
220: ,p_treaty_info_update_date in date default hr_api.g_date
221: ,p_number_of_days_in_usa in number default hr_api.g_number
222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
223: ,p_ra_effective_date in date default hr_api.g_date
224: ,p_record_source in varchar2 default hr_api.g_varchar2
225: ,p_visa_type in varchar2 default hr_api.g_varchar2

Line 222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2

218: ,p_target_departure_date in date default hr_api.g_date
219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
220: ,p_treaty_info_update_date in date default hr_api.g_date
221: ,p_number_of_days_in_usa in number default hr_api.g_number
222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
223: ,p_ra_effective_date in date default hr_api.g_date
224: ,p_record_source in varchar2 default hr_api.g_varchar2
225: ,p_visa_type in varchar2 default hr_api.g_varchar2
226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2

Line 223: ,p_ra_effective_date in date default hr_api.g_date

219: ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
220: ,p_treaty_info_update_date in date default hr_api.g_date
221: ,p_number_of_days_in_usa in number default hr_api.g_number
222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
223: ,p_ra_effective_date in date default hr_api.g_date
224: ,p_record_source in varchar2 default hr_api.g_varchar2
225: ,p_visa_type in varchar2 default hr_api.g_varchar2
226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
227: ,p_primary_activity in varchar2 default hr_api.g_varchar2

Line 224: ,p_record_source in varchar2 default hr_api.g_varchar2

220: ,p_treaty_info_update_date in date default hr_api.g_date
221: ,p_number_of_days_in_usa in number default hr_api.g_number
222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
223: ,p_ra_effective_date in date default hr_api.g_date
224: ,p_record_source in varchar2 default hr_api.g_varchar2
225: ,p_visa_type in varchar2 default hr_api.g_varchar2
226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
227: ,p_primary_activity in varchar2 default hr_api.g_varchar2
228: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2

Line 225: ,p_visa_type in varchar2 default hr_api.g_varchar2

221: ,p_number_of_days_in_usa in number default hr_api.g_number
222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
223: ,p_ra_effective_date in date default hr_api.g_date
224: ,p_record_source in varchar2 default hr_api.g_varchar2
225: ,p_visa_type in varchar2 default hr_api.g_varchar2
226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
227: ,p_primary_activity in varchar2 default hr_api.g_varchar2
228: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
229: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2

Line 226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2

222: ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
223: ,p_ra_effective_date in date default hr_api.g_date
224: ,p_record_source in varchar2 default hr_api.g_varchar2
225: ,p_visa_type in varchar2 default hr_api.g_varchar2
226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
227: ,p_primary_activity in varchar2 default hr_api.g_varchar2
228: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
229: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
230: ,p_object_version_number in out nocopy number

Line 227: ,p_primary_activity in varchar2 default hr_api.g_varchar2

223: ,p_ra_effective_date in date default hr_api.g_date
224: ,p_record_source in varchar2 default hr_api.g_varchar2
225: ,p_visa_type in varchar2 default hr_api.g_varchar2
226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
227: ,p_primary_activity in varchar2 default hr_api.g_varchar2
228: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
229: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
230: ,p_object_version_number in out nocopy number
231: ,p_effective_date in date

Line 228: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2

224: ,p_record_source in varchar2 default hr_api.g_varchar2
225: ,p_visa_type in varchar2 default hr_api.g_varchar2
226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
227: ,p_primary_activity in varchar2 default hr_api.g_varchar2
228: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
229: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
230: ,p_object_version_number in out nocopy number
231: ,p_effective_date in date
232: ,p_date_8233_signed in date default hr_api.g_date

Line 229: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2

225: ,p_visa_type in varchar2 default hr_api.g_varchar2
226: ,p_j_sub_type in varchar2 default hr_api.g_varchar2
227: ,p_primary_activity in varchar2 default hr_api.g_varchar2
228: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
229: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
230: ,p_object_version_number in out nocopy number
231: ,p_effective_date in date
232: ,p_date_8233_signed in date default hr_api.g_date
233: ,p_date_w4_signed in date default hr_api.g_date

Line 232: ,p_date_8233_signed in date default hr_api.g_date

228: ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
229: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
230: ,p_object_version_number in out nocopy number
231: ,p_effective_date in date
232: ,p_date_8233_signed in date default hr_api.g_date
233: ,p_date_w4_signed in date default hr_api.g_date
234: ) is
235: --
236: -- Declare cursors and local variables

Line 233: ,p_date_w4_signed in date default hr_api.g_date

229: ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
230: ,p_object_version_number in out nocopy number
231: ,p_effective_date in date
232: ,p_date_8233_signed in date default hr_api.g_date
233: ,p_date_w4_signed in date default hr_api.g_date
234: ) is
235: --
236: -- Declare cursors and local variables
237: --

Line 285: when hr_api.cannot_find_prog_unit then

281: ,p_date_8233_signed => p_date_8233_signed
282: ,p_date_w4_signed => p_date_w4_signed
283: );
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'UPDATE_ANALYZED_ALIEN_DATA'
288: ,p_hook_type => 'BP'
289: );

Line 286: hr_api.cannot_find_prog_unit_error

282: ,p_date_w4_signed => p_date_w4_signed
283: );
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'UPDATE_ANALYZED_ALIEN_DATA'
288: ,p_hook_type => 'BP'
289: );
290: --

Line 351: when hr_api.cannot_find_prog_unit then

347: ,p_date_8233_signed => p_date_8233_signed
348: ,p_date_w4_signed => p_date_w4_signed
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'UPDATE_ANALYZED_ALIEN_DATA'
354: ,p_hook_type => 'AP'
355: );

Line 352: hr_api.cannot_find_prog_unit_error

348: ,p_date_w4_signed => p_date_w4_signed
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'UPDATE_ANALYZED_ALIEN_DATA'
354: ,p_hook_type => 'AP'
355: );
356: --

Line 366: raise hr_api.validate_enabled;

362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then
366: raise hr_api.validate_enabled;
367: end if;
368: --
369: -- Set all output arguments
370: --

Line 377: when hr_api.validate_enabled then

373: hr_utility.set_location(' Leaving:'||l_proc, 70);
374: --
375: exception
376: --
377: when hr_api.validate_enabled then
378: --
379: -- As the Validate_Enabled exception has been raised
380: -- we must rollback to the savepoint
381: --

Line 440: when hr_api.cannot_find_prog_unit then

436: ,p_object_version_number => p_object_version_number
437: ,p_effective_date => trunc(p_effective_date)
438: );
439: exception
440: when hr_api.cannot_find_prog_unit then
441: hr_api.cannot_find_prog_unit_error
442: (p_module_name => 'DELETE_ANALYZED_ALIEN_DATA'
443: ,p_hook_type => 'BP'
444: );

Line 441: hr_api.cannot_find_prog_unit_error

437: ,p_effective_date => trunc(p_effective_date)
438: );
439: exception
440: when hr_api.cannot_find_prog_unit then
441: hr_api.cannot_find_prog_unit_error
442: (p_module_name => 'DELETE_ANALYZED_ALIEN_DATA'
443: ,p_hook_type => 'BP'
444: );
445: --

Line 468: when hr_api.cannot_find_prog_unit then

464: ,p_object_version_number => l_object_version_number
465: ,p_effective_date => trunc(p_effective_date)
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'DELETE_ANALYZED_ALIEN_DATA'
471: ,p_hook_type => 'AP'
472: );

Line 469: hr_api.cannot_find_prog_unit_error

465: ,p_effective_date => trunc(p_effective_date)
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'DELETE_ANALYZED_ALIEN_DATA'
471: ,p_hook_type => 'AP'
472: );
473: --

Line 483: raise hr_api.validate_enabled;

479: --
480: -- When in validation only mode raise the Validate_Enabled exception
481: --
482: if p_validate then
483: raise hr_api.validate_enabled;
484: end if;
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 70);
487: --

Line 490: when hr_api.validate_enabled then

486: hr_utility.set_location(' Leaving:'||l_proc, 70);
487: --
488: exception
489: --
490: when hr_api.validate_enabled then
491: --
492: -- As the Validate_Enabled exception has been raised
493: -- we must rollback to the savepoint
494: --