eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_CRITERIA_RATE_DEFN_API dependencies on HR_API

Line 20: ,p_language_code in varchar2 default hr_api.userenv_lang

16: ,p_business_group_id in number
17: ,p_criteria_rate_defn_id out nocopy number
18: ,p_short_name in varchar2 default null
19: ,p_name in varchar2
20: ,p_language_code in varchar2 default hr_api.userenv_lang
21: ,p_uom in varchar2
22: ,p_currency_code in varchar2 default null
23: ,p_reference_period_cd in varchar2 default null
24: ,p_define_max_rate_flag in varchar2 default null

Line 148: when hr_api.cannot_find_prog_unit then

144: ,p_attribute29 => p_attribute29
145: ,p_attribute30 => p_attribute30
146: );
147: exception
148: when hr_api.cannot_find_prog_unit then
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
151: ,p_hook_type => 'BP'
152: );

Line 149: hr_api.cannot_find_prog_unit_error

145: ,p_attribute30 => p_attribute30
146: );
147: exception
148: when hr_api.cannot_find_prog_unit then
149: hr_api.cannot_find_prog_unit_error
150: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
151: ,p_hook_type => 'BP'
152: );
153: end;

Line 279: when hr_api.cannot_find_prog_unit then

275: ,p_attribute29 => p_attribute29
276: ,p_attribute30 => p_attribute30
277: ,p_object_version_number => l_object_version_number );
278: exception
279: when hr_api.cannot_find_prog_unit then
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
282: ,p_hook_type => 'AP'
283: );

Line 280: hr_api.cannot_find_prog_unit_error

276: ,p_attribute30 => p_attribute30
277: ,p_object_version_number => l_object_version_number );
278: exception
279: when hr_api.cannot_find_prog_unit then
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
282: ,p_hook_type => 'AP'
283: );
284: end;

Line 289: raise hr_api.validate_enabled;

285: --
286: -- When in validation only mode raise the Validate_Enabled exception
287: --
288: if p_validate then
289: raise hr_api.validate_enabled;
290: end if;
291: --
292: -- Set all IN OUT and OUT parameters with out values
293: --

Line 299: when hr_api.validate_enabled then

295: p_object_version_number := l_object_version_number;
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 70);
298: exception
299: when hr_api.validate_enabled then
300: --
301: -- As the Validate_Enabled exception has been raised
302: -- we must rollback to the savepoint
303: --

Line 338: ,p_short_name in varchar2 default hr_api.g_varchar2

334: (p_validate in boolean default false
335: ,p_effective_date in date
336: ,p_business_group_id in number
337: ,p_criteria_rate_defn_id in number
338: ,p_short_name in varchar2 default hr_api.g_varchar2
339: ,p_name in varchar2
340: ,p_language_code in varchar2 default hr_api.userenv_lang
341: ,p_uom in varchar2
342: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 340: ,p_language_code in varchar2 default hr_api.userenv_lang

336: ,p_business_group_id in number
337: ,p_criteria_rate_defn_id in number
338: ,p_short_name in varchar2 default hr_api.g_varchar2
339: ,p_name in varchar2
340: ,p_language_code in varchar2 default hr_api.userenv_lang
341: ,p_uom in varchar2
342: ,p_currency_code in varchar2 default hr_api.g_varchar2
343: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
344: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2

Line 342: ,p_currency_code in varchar2 default hr_api.g_varchar2

338: ,p_short_name in varchar2 default hr_api.g_varchar2
339: ,p_name in varchar2
340: ,p_language_code in varchar2 default hr_api.userenv_lang
341: ,p_uom in varchar2
342: ,p_currency_code in varchar2 default hr_api.g_varchar2
343: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
344: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
345: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
346: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2

Line 343: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2

339: ,p_name in varchar2
340: ,p_language_code in varchar2 default hr_api.userenv_lang
341: ,p_uom in varchar2
342: ,p_currency_code in varchar2 default hr_api.g_varchar2
343: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
344: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
345: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
346: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
347: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2

Line 344: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2

340: ,p_language_code in varchar2 default hr_api.userenv_lang
341: ,p_uom in varchar2
342: ,p_currency_code in varchar2 default hr_api.g_varchar2
343: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
344: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
345: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
346: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
347: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
348: ,p_rate_calc_cd in varchar2

Line 345: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2

341: ,p_uom in varchar2
342: ,p_currency_code in varchar2 default hr_api.g_varchar2
343: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
344: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
345: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
346: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
347: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
348: ,p_rate_calc_cd in varchar2
349: ,p_rate_calc_rule in number default hr_api.g_number

Line 346: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2

342: ,p_currency_code in varchar2 default hr_api.g_varchar2
343: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
344: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
345: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
346: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
347: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
348: ,p_rate_calc_cd in varchar2
349: ,p_rate_calc_rule in number default hr_api.g_number
350: ,p_preferential_rate_cd in varchar2

Line 347: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2

343: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
344: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
345: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
346: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
347: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
348: ,p_rate_calc_cd in varchar2
349: ,p_rate_calc_rule in number default hr_api.g_number
350: ,p_preferential_rate_cd in varchar2
351: ,p_preferential_rate_rule in number default hr_api.g_number

Line 349: ,p_rate_calc_rule in number default hr_api.g_number

345: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
346: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
347: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
348: ,p_rate_calc_cd in varchar2
349: ,p_rate_calc_rule in number default hr_api.g_number
350: ,p_preferential_rate_cd in varchar2
351: ,p_preferential_rate_rule in number default hr_api.g_number
352: ,p_rounding_cd in varchar2
353: ,p_rounding_rule in number default hr_api.g_number

Line 351: ,p_preferential_rate_rule in number default hr_api.g_number

347: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
348: ,p_rate_calc_cd in varchar2
349: ,p_rate_calc_rule in number default hr_api.g_number
350: ,p_preferential_rate_cd in varchar2
351: ,p_preferential_rate_rule in number default hr_api.g_number
352: ,p_rounding_cd in varchar2
353: ,p_rounding_rule in number default hr_api.g_number
354: ,p_legislation_code in varchar2 default hr_api.g_varchar2
355: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 353: ,p_rounding_rule in number default hr_api.g_number

349: ,p_rate_calc_rule in number default hr_api.g_number
350: ,p_preferential_rate_cd in varchar2
351: ,p_preferential_rate_rule in number default hr_api.g_number
352: ,p_rounding_cd in varchar2
353: ,p_rounding_rule in number default hr_api.g_number
354: ,p_legislation_code in varchar2 default hr_api.g_varchar2
355: ,p_attribute_category in varchar2 default hr_api.g_varchar2
356: ,p_attribute1 in varchar2 default hr_api.g_varchar2
357: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 354: ,p_legislation_code in varchar2 default hr_api.g_varchar2

350: ,p_preferential_rate_cd in varchar2
351: ,p_preferential_rate_rule in number default hr_api.g_number
352: ,p_rounding_cd in varchar2
353: ,p_rounding_rule in number default hr_api.g_number
354: ,p_legislation_code in varchar2 default hr_api.g_varchar2
355: ,p_attribute_category in varchar2 default hr_api.g_varchar2
356: ,p_attribute1 in varchar2 default hr_api.g_varchar2
357: ,p_attribute2 in varchar2 default hr_api.g_varchar2
358: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 355: ,p_attribute_category in varchar2 default hr_api.g_varchar2

351: ,p_preferential_rate_rule in number default hr_api.g_number
352: ,p_rounding_cd in varchar2
353: ,p_rounding_rule in number default hr_api.g_number
354: ,p_legislation_code in varchar2 default hr_api.g_varchar2
355: ,p_attribute_category in varchar2 default hr_api.g_varchar2
356: ,p_attribute1 in varchar2 default hr_api.g_varchar2
357: ,p_attribute2 in varchar2 default hr_api.g_varchar2
358: ,p_attribute3 in varchar2 default hr_api.g_varchar2
359: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 356: ,p_attribute1 in varchar2 default hr_api.g_varchar2

352: ,p_rounding_cd in varchar2
353: ,p_rounding_rule in number default hr_api.g_number
354: ,p_legislation_code in varchar2 default hr_api.g_varchar2
355: ,p_attribute_category in varchar2 default hr_api.g_varchar2
356: ,p_attribute1 in varchar2 default hr_api.g_varchar2
357: ,p_attribute2 in varchar2 default hr_api.g_varchar2
358: ,p_attribute3 in varchar2 default hr_api.g_varchar2
359: ,p_attribute4 in varchar2 default hr_api.g_varchar2
360: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 357: ,p_attribute2 in varchar2 default hr_api.g_varchar2

353: ,p_rounding_rule in number default hr_api.g_number
354: ,p_legislation_code in varchar2 default hr_api.g_varchar2
355: ,p_attribute_category in varchar2 default hr_api.g_varchar2
356: ,p_attribute1 in varchar2 default hr_api.g_varchar2
357: ,p_attribute2 in varchar2 default hr_api.g_varchar2
358: ,p_attribute3 in varchar2 default hr_api.g_varchar2
359: ,p_attribute4 in varchar2 default hr_api.g_varchar2
360: ,p_attribute5 in varchar2 default hr_api.g_varchar2
361: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 358: ,p_attribute3 in varchar2 default hr_api.g_varchar2

354: ,p_legislation_code in varchar2 default hr_api.g_varchar2
355: ,p_attribute_category in varchar2 default hr_api.g_varchar2
356: ,p_attribute1 in varchar2 default hr_api.g_varchar2
357: ,p_attribute2 in varchar2 default hr_api.g_varchar2
358: ,p_attribute3 in varchar2 default hr_api.g_varchar2
359: ,p_attribute4 in varchar2 default hr_api.g_varchar2
360: ,p_attribute5 in varchar2 default hr_api.g_varchar2
361: ,p_attribute6 in varchar2 default hr_api.g_varchar2
362: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 359: ,p_attribute4 in varchar2 default hr_api.g_varchar2

355: ,p_attribute_category in varchar2 default hr_api.g_varchar2
356: ,p_attribute1 in varchar2 default hr_api.g_varchar2
357: ,p_attribute2 in varchar2 default hr_api.g_varchar2
358: ,p_attribute3 in varchar2 default hr_api.g_varchar2
359: ,p_attribute4 in varchar2 default hr_api.g_varchar2
360: ,p_attribute5 in varchar2 default hr_api.g_varchar2
361: ,p_attribute6 in varchar2 default hr_api.g_varchar2
362: ,p_attribute7 in varchar2 default hr_api.g_varchar2
363: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 360: ,p_attribute5 in varchar2 default hr_api.g_varchar2

356: ,p_attribute1 in varchar2 default hr_api.g_varchar2
357: ,p_attribute2 in varchar2 default hr_api.g_varchar2
358: ,p_attribute3 in varchar2 default hr_api.g_varchar2
359: ,p_attribute4 in varchar2 default hr_api.g_varchar2
360: ,p_attribute5 in varchar2 default hr_api.g_varchar2
361: ,p_attribute6 in varchar2 default hr_api.g_varchar2
362: ,p_attribute7 in varchar2 default hr_api.g_varchar2
363: ,p_attribute8 in varchar2 default hr_api.g_varchar2
364: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 361: ,p_attribute6 in varchar2 default hr_api.g_varchar2

357: ,p_attribute2 in varchar2 default hr_api.g_varchar2
358: ,p_attribute3 in varchar2 default hr_api.g_varchar2
359: ,p_attribute4 in varchar2 default hr_api.g_varchar2
360: ,p_attribute5 in varchar2 default hr_api.g_varchar2
361: ,p_attribute6 in varchar2 default hr_api.g_varchar2
362: ,p_attribute7 in varchar2 default hr_api.g_varchar2
363: ,p_attribute8 in varchar2 default hr_api.g_varchar2
364: ,p_attribute9 in varchar2 default hr_api.g_varchar2
365: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 362: ,p_attribute7 in varchar2 default hr_api.g_varchar2

358: ,p_attribute3 in varchar2 default hr_api.g_varchar2
359: ,p_attribute4 in varchar2 default hr_api.g_varchar2
360: ,p_attribute5 in varchar2 default hr_api.g_varchar2
361: ,p_attribute6 in varchar2 default hr_api.g_varchar2
362: ,p_attribute7 in varchar2 default hr_api.g_varchar2
363: ,p_attribute8 in varchar2 default hr_api.g_varchar2
364: ,p_attribute9 in varchar2 default hr_api.g_varchar2
365: ,p_attribute10 in varchar2 default hr_api.g_varchar2
366: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 363: ,p_attribute8 in varchar2 default hr_api.g_varchar2

359: ,p_attribute4 in varchar2 default hr_api.g_varchar2
360: ,p_attribute5 in varchar2 default hr_api.g_varchar2
361: ,p_attribute6 in varchar2 default hr_api.g_varchar2
362: ,p_attribute7 in varchar2 default hr_api.g_varchar2
363: ,p_attribute8 in varchar2 default hr_api.g_varchar2
364: ,p_attribute9 in varchar2 default hr_api.g_varchar2
365: ,p_attribute10 in varchar2 default hr_api.g_varchar2
366: ,p_attribute11 in varchar2 default hr_api.g_varchar2
367: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 364: ,p_attribute9 in varchar2 default hr_api.g_varchar2

360: ,p_attribute5 in varchar2 default hr_api.g_varchar2
361: ,p_attribute6 in varchar2 default hr_api.g_varchar2
362: ,p_attribute7 in varchar2 default hr_api.g_varchar2
363: ,p_attribute8 in varchar2 default hr_api.g_varchar2
364: ,p_attribute9 in varchar2 default hr_api.g_varchar2
365: ,p_attribute10 in varchar2 default hr_api.g_varchar2
366: ,p_attribute11 in varchar2 default hr_api.g_varchar2
367: ,p_attribute12 in varchar2 default hr_api.g_varchar2
368: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 365: ,p_attribute10 in varchar2 default hr_api.g_varchar2

361: ,p_attribute6 in varchar2 default hr_api.g_varchar2
362: ,p_attribute7 in varchar2 default hr_api.g_varchar2
363: ,p_attribute8 in varchar2 default hr_api.g_varchar2
364: ,p_attribute9 in varchar2 default hr_api.g_varchar2
365: ,p_attribute10 in varchar2 default hr_api.g_varchar2
366: ,p_attribute11 in varchar2 default hr_api.g_varchar2
367: ,p_attribute12 in varchar2 default hr_api.g_varchar2
368: ,p_attribute13 in varchar2 default hr_api.g_varchar2
369: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 366: ,p_attribute11 in varchar2 default hr_api.g_varchar2

362: ,p_attribute7 in varchar2 default hr_api.g_varchar2
363: ,p_attribute8 in varchar2 default hr_api.g_varchar2
364: ,p_attribute9 in varchar2 default hr_api.g_varchar2
365: ,p_attribute10 in varchar2 default hr_api.g_varchar2
366: ,p_attribute11 in varchar2 default hr_api.g_varchar2
367: ,p_attribute12 in varchar2 default hr_api.g_varchar2
368: ,p_attribute13 in varchar2 default hr_api.g_varchar2
369: ,p_attribute14 in varchar2 default hr_api.g_varchar2
370: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 367: ,p_attribute12 in varchar2 default hr_api.g_varchar2

363: ,p_attribute8 in varchar2 default hr_api.g_varchar2
364: ,p_attribute9 in varchar2 default hr_api.g_varchar2
365: ,p_attribute10 in varchar2 default hr_api.g_varchar2
366: ,p_attribute11 in varchar2 default hr_api.g_varchar2
367: ,p_attribute12 in varchar2 default hr_api.g_varchar2
368: ,p_attribute13 in varchar2 default hr_api.g_varchar2
369: ,p_attribute14 in varchar2 default hr_api.g_varchar2
370: ,p_attribute15 in varchar2 default hr_api.g_varchar2
371: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 368: ,p_attribute13 in varchar2 default hr_api.g_varchar2

364: ,p_attribute9 in varchar2 default hr_api.g_varchar2
365: ,p_attribute10 in varchar2 default hr_api.g_varchar2
366: ,p_attribute11 in varchar2 default hr_api.g_varchar2
367: ,p_attribute12 in varchar2 default hr_api.g_varchar2
368: ,p_attribute13 in varchar2 default hr_api.g_varchar2
369: ,p_attribute14 in varchar2 default hr_api.g_varchar2
370: ,p_attribute15 in varchar2 default hr_api.g_varchar2
371: ,p_attribute16 in varchar2 default hr_api.g_varchar2
372: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 369: ,p_attribute14 in varchar2 default hr_api.g_varchar2

365: ,p_attribute10 in varchar2 default hr_api.g_varchar2
366: ,p_attribute11 in varchar2 default hr_api.g_varchar2
367: ,p_attribute12 in varchar2 default hr_api.g_varchar2
368: ,p_attribute13 in varchar2 default hr_api.g_varchar2
369: ,p_attribute14 in varchar2 default hr_api.g_varchar2
370: ,p_attribute15 in varchar2 default hr_api.g_varchar2
371: ,p_attribute16 in varchar2 default hr_api.g_varchar2
372: ,p_attribute17 in varchar2 default hr_api.g_varchar2
373: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 370: ,p_attribute15 in varchar2 default hr_api.g_varchar2

366: ,p_attribute11 in varchar2 default hr_api.g_varchar2
367: ,p_attribute12 in varchar2 default hr_api.g_varchar2
368: ,p_attribute13 in varchar2 default hr_api.g_varchar2
369: ,p_attribute14 in varchar2 default hr_api.g_varchar2
370: ,p_attribute15 in varchar2 default hr_api.g_varchar2
371: ,p_attribute16 in varchar2 default hr_api.g_varchar2
372: ,p_attribute17 in varchar2 default hr_api.g_varchar2
373: ,p_attribute18 in varchar2 default hr_api.g_varchar2
374: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 371: ,p_attribute16 in varchar2 default hr_api.g_varchar2

367: ,p_attribute12 in varchar2 default hr_api.g_varchar2
368: ,p_attribute13 in varchar2 default hr_api.g_varchar2
369: ,p_attribute14 in varchar2 default hr_api.g_varchar2
370: ,p_attribute15 in varchar2 default hr_api.g_varchar2
371: ,p_attribute16 in varchar2 default hr_api.g_varchar2
372: ,p_attribute17 in varchar2 default hr_api.g_varchar2
373: ,p_attribute18 in varchar2 default hr_api.g_varchar2
374: ,p_attribute19 in varchar2 default hr_api.g_varchar2
375: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 372: ,p_attribute17 in varchar2 default hr_api.g_varchar2

368: ,p_attribute13 in varchar2 default hr_api.g_varchar2
369: ,p_attribute14 in varchar2 default hr_api.g_varchar2
370: ,p_attribute15 in varchar2 default hr_api.g_varchar2
371: ,p_attribute16 in varchar2 default hr_api.g_varchar2
372: ,p_attribute17 in varchar2 default hr_api.g_varchar2
373: ,p_attribute18 in varchar2 default hr_api.g_varchar2
374: ,p_attribute19 in varchar2 default hr_api.g_varchar2
375: ,p_attribute20 in varchar2 default hr_api.g_varchar2
376: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 373: ,p_attribute18 in varchar2 default hr_api.g_varchar2

369: ,p_attribute14 in varchar2 default hr_api.g_varchar2
370: ,p_attribute15 in varchar2 default hr_api.g_varchar2
371: ,p_attribute16 in varchar2 default hr_api.g_varchar2
372: ,p_attribute17 in varchar2 default hr_api.g_varchar2
373: ,p_attribute18 in varchar2 default hr_api.g_varchar2
374: ,p_attribute19 in varchar2 default hr_api.g_varchar2
375: ,p_attribute20 in varchar2 default hr_api.g_varchar2
376: ,p_attribute21 in varchar2 default hr_api.g_varchar2
377: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 374: ,p_attribute19 in varchar2 default hr_api.g_varchar2

370: ,p_attribute15 in varchar2 default hr_api.g_varchar2
371: ,p_attribute16 in varchar2 default hr_api.g_varchar2
372: ,p_attribute17 in varchar2 default hr_api.g_varchar2
373: ,p_attribute18 in varchar2 default hr_api.g_varchar2
374: ,p_attribute19 in varchar2 default hr_api.g_varchar2
375: ,p_attribute20 in varchar2 default hr_api.g_varchar2
376: ,p_attribute21 in varchar2 default hr_api.g_varchar2
377: ,p_attribute22 in varchar2 default hr_api.g_varchar2
378: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 375: ,p_attribute20 in varchar2 default hr_api.g_varchar2

371: ,p_attribute16 in varchar2 default hr_api.g_varchar2
372: ,p_attribute17 in varchar2 default hr_api.g_varchar2
373: ,p_attribute18 in varchar2 default hr_api.g_varchar2
374: ,p_attribute19 in varchar2 default hr_api.g_varchar2
375: ,p_attribute20 in varchar2 default hr_api.g_varchar2
376: ,p_attribute21 in varchar2 default hr_api.g_varchar2
377: ,p_attribute22 in varchar2 default hr_api.g_varchar2
378: ,p_attribute23 in varchar2 default hr_api.g_varchar2
379: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 376: ,p_attribute21 in varchar2 default hr_api.g_varchar2

372: ,p_attribute17 in varchar2 default hr_api.g_varchar2
373: ,p_attribute18 in varchar2 default hr_api.g_varchar2
374: ,p_attribute19 in varchar2 default hr_api.g_varchar2
375: ,p_attribute20 in varchar2 default hr_api.g_varchar2
376: ,p_attribute21 in varchar2 default hr_api.g_varchar2
377: ,p_attribute22 in varchar2 default hr_api.g_varchar2
378: ,p_attribute23 in varchar2 default hr_api.g_varchar2
379: ,p_attribute24 in varchar2 default hr_api.g_varchar2
380: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 377: ,p_attribute22 in varchar2 default hr_api.g_varchar2

373: ,p_attribute18 in varchar2 default hr_api.g_varchar2
374: ,p_attribute19 in varchar2 default hr_api.g_varchar2
375: ,p_attribute20 in varchar2 default hr_api.g_varchar2
376: ,p_attribute21 in varchar2 default hr_api.g_varchar2
377: ,p_attribute22 in varchar2 default hr_api.g_varchar2
378: ,p_attribute23 in varchar2 default hr_api.g_varchar2
379: ,p_attribute24 in varchar2 default hr_api.g_varchar2
380: ,p_attribute25 in varchar2 default hr_api.g_varchar2
381: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 378: ,p_attribute23 in varchar2 default hr_api.g_varchar2

374: ,p_attribute19 in varchar2 default hr_api.g_varchar2
375: ,p_attribute20 in varchar2 default hr_api.g_varchar2
376: ,p_attribute21 in varchar2 default hr_api.g_varchar2
377: ,p_attribute22 in varchar2 default hr_api.g_varchar2
378: ,p_attribute23 in varchar2 default hr_api.g_varchar2
379: ,p_attribute24 in varchar2 default hr_api.g_varchar2
380: ,p_attribute25 in varchar2 default hr_api.g_varchar2
381: ,p_attribute26 in varchar2 default hr_api.g_varchar2
382: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 379: ,p_attribute24 in varchar2 default hr_api.g_varchar2

375: ,p_attribute20 in varchar2 default hr_api.g_varchar2
376: ,p_attribute21 in varchar2 default hr_api.g_varchar2
377: ,p_attribute22 in varchar2 default hr_api.g_varchar2
378: ,p_attribute23 in varchar2 default hr_api.g_varchar2
379: ,p_attribute24 in varchar2 default hr_api.g_varchar2
380: ,p_attribute25 in varchar2 default hr_api.g_varchar2
381: ,p_attribute26 in varchar2 default hr_api.g_varchar2
382: ,p_attribute27 in varchar2 default hr_api.g_varchar2
383: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 380: ,p_attribute25 in varchar2 default hr_api.g_varchar2

376: ,p_attribute21 in varchar2 default hr_api.g_varchar2
377: ,p_attribute22 in varchar2 default hr_api.g_varchar2
378: ,p_attribute23 in varchar2 default hr_api.g_varchar2
379: ,p_attribute24 in varchar2 default hr_api.g_varchar2
380: ,p_attribute25 in varchar2 default hr_api.g_varchar2
381: ,p_attribute26 in varchar2 default hr_api.g_varchar2
382: ,p_attribute27 in varchar2 default hr_api.g_varchar2
383: ,p_attribute28 in varchar2 default hr_api.g_varchar2
384: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 381: ,p_attribute26 in varchar2 default hr_api.g_varchar2

377: ,p_attribute22 in varchar2 default hr_api.g_varchar2
378: ,p_attribute23 in varchar2 default hr_api.g_varchar2
379: ,p_attribute24 in varchar2 default hr_api.g_varchar2
380: ,p_attribute25 in varchar2 default hr_api.g_varchar2
381: ,p_attribute26 in varchar2 default hr_api.g_varchar2
382: ,p_attribute27 in varchar2 default hr_api.g_varchar2
383: ,p_attribute28 in varchar2 default hr_api.g_varchar2
384: ,p_attribute29 in varchar2 default hr_api.g_varchar2
385: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 382: ,p_attribute27 in varchar2 default hr_api.g_varchar2

378: ,p_attribute23 in varchar2 default hr_api.g_varchar2
379: ,p_attribute24 in varchar2 default hr_api.g_varchar2
380: ,p_attribute25 in varchar2 default hr_api.g_varchar2
381: ,p_attribute26 in varchar2 default hr_api.g_varchar2
382: ,p_attribute27 in varchar2 default hr_api.g_varchar2
383: ,p_attribute28 in varchar2 default hr_api.g_varchar2
384: ,p_attribute29 in varchar2 default hr_api.g_varchar2
385: ,p_attribute30 in varchar2 default hr_api.g_varchar2
386: ,p_object_version_number in out nocopy number

Line 383: ,p_attribute28 in varchar2 default hr_api.g_varchar2

379: ,p_attribute24 in varchar2 default hr_api.g_varchar2
380: ,p_attribute25 in varchar2 default hr_api.g_varchar2
381: ,p_attribute26 in varchar2 default hr_api.g_varchar2
382: ,p_attribute27 in varchar2 default hr_api.g_varchar2
383: ,p_attribute28 in varchar2 default hr_api.g_varchar2
384: ,p_attribute29 in varchar2 default hr_api.g_varchar2
385: ,p_attribute30 in varchar2 default hr_api.g_varchar2
386: ,p_object_version_number in out nocopy number
387: ) is

Line 384: ,p_attribute29 in varchar2 default hr_api.g_varchar2

380: ,p_attribute25 in varchar2 default hr_api.g_varchar2
381: ,p_attribute26 in varchar2 default hr_api.g_varchar2
382: ,p_attribute27 in varchar2 default hr_api.g_varchar2
383: ,p_attribute28 in varchar2 default hr_api.g_varchar2
384: ,p_attribute29 in varchar2 default hr_api.g_varchar2
385: ,p_attribute30 in varchar2 default hr_api.g_varchar2
386: ,p_object_version_number in out nocopy number
387: ) is
388: --

Line 385: ,p_attribute30 in varchar2 default hr_api.g_varchar2

381: ,p_attribute26 in varchar2 default hr_api.g_varchar2
382: ,p_attribute27 in varchar2 default hr_api.g_varchar2
383: ,p_attribute28 in varchar2 default hr_api.g_varchar2
384: ,p_attribute29 in varchar2 default hr_api.g_varchar2
385: ,p_attribute30 in varchar2 default hr_api.g_varchar2
386: ,p_object_version_number in out nocopy number
387: ) is
388: --
389: -- Declare cursors and local variables

Line 469: when hr_api.cannot_find_prog_unit then

465: ,p_attribute30 => p_attribute30
466: ,p_object_version_number => p_object_version_number
467: );
468: exception
469: when hr_api.cannot_find_prog_unit then
470: hr_api.cannot_find_prog_unit_error
471: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
472: ,p_hook_type => 'BP'
473: );

Line 470: hr_api.cannot_find_prog_unit_error

466: ,p_object_version_number => p_object_version_number
467: );
468: exception
469: when hr_api.cannot_find_prog_unit then
470: hr_api.cannot_find_prog_unit_error
471: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
472: ,p_hook_type => 'BP'
473: );
474: end;

Line 600: when hr_api.cannot_find_prog_unit then

596: ,p_attribute29 => p_attribute29
597: ,p_attribute30 => p_attribute30
598: ,p_object_version_number => l_object_version_number );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
603: ,p_hook_type => 'AP'
604: );

Line 601: hr_api.cannot_find_prog_unit_error

597: ,p_attribute30 => p_attribute30
598: ,p_object_version_number => l_object_version_number );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
603: ,p_hook_type => 'AP'
604: );
605: end;

Line 610: raise hr_api.validate_enabled;

606: --
607: -- When in validation only mode raise the Validate_Enabled exception
608: --
609: if p_validate then
610: raise hr_api.validate_enabled;
611: end if;
612: --
613: -- Set all IN OUT and OUT parameters with out values
614: --

Line 619: when hr_api.validate_enabled then

615: p_object_version_number := l_object_version_number;
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 70);
618: exception
619: when hr_api.validate_enabled then
620: --
621: -- As the Validate_Enabled exception has been raised
622: -- we must rollback to the savepoint
623: --

Line 694: when hr_api.cannot_find_prog_unit then

690: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
691: ,p_object_version_number => l_object_version_number
692: );
693: exception
694: when hr_api.cannot_find_prog_unit then
695: hr_api.cannot_find_prog_unit_error
696: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
697: ,p_hook_type => 'BP'
698: );

Line 695: hr_api.cannot_find_prog_unit_error

691: ,p_object_version_number => l_object_version_number
692: );
693: exception
694: when hr_api.cannot_find_prog_unit then
695: hr_api.cannot_find_prog_unit_error
696: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
697: ,p_hook_type => 'BP'
698: );
699: end;

Line 726: when hr_api.cannot_find_prog_unit then

722: (p_effective_date => l_effective_date
723: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
724: ,p_object_version_number => l_object_version_number );
725: exception
726: when hr_api.cannot_find_prog_unit then
727: hr_api.cannot_find_prog_unit_error
728: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
729: ,p_hook_type => 'AP'
730: );

Line 727: hr_api.cannot_find_prog_unit_error

723: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
724: ,p_object_version_number => l_object_version_number );
725: exception
726: when hr_api.cannot_find_prog_unit then
727: hr_api.cannot_find_prog_unit_error
728: (p_module_name => 'PQH_CRITERIA_RATE_DEFN_API'
729: ,p_hook_type => 'AP'
730: );
731: end;

Line 736: raise hr_api.validate_enabled;

732: --
733: -- When in validation only mode raise the Validate_Enabled exception
734: --
735: if p_validate then
736: raise hr_api.validate_enabled;
737: end if;
738: --
739: -- Set all IN OUT and OUT parameters with out values
740: --

Line 744: when hr_api.validate_enabled then

740: --
741: --
742: hr_utility.set_location(' Leaving:'||l_proc, 70);
743: exception
744: when hr_api.validate_enabled then
745: --
746: -- As the Validate_Enabled exception has been raised
747: -- we must rollback to the savepoint
748: --