DBA Data[Home] [Help]

APPS.HR_PHONE_SWI dependencies on HR_API

Line 52: ,p_validate in number default hr_api.g_false_num

48: ,p_attribute27 in varchar2 default null
49: ,p_attribute28 in varchar2 default null
50: ,p_attribute29 in varchar2 default null
51: ,p_attribute30 in varchar2 default null
52: ,p_validate in number default hr_api.g_false_num
53: ,p_effective_date in date
54: ,p_party_id in number default null
55: ,p_validity in varchar2 default null
56: ,p_return_status out nocopy varchar2

Line 87: hr_api.constant_to_boolean

83: --
84: -- Convert constant values to their corresponding boolean value
85: --
86: l_validate :=
87: hr_api.constant_to_boolean
88: (p_constant_value => p_validate);
89: --
90: -- Register Surrogate ID or user key values
91: --

Line 233: ,p_validate in number default hr_api.g_false_num

229: ,p_attribute27 in varchar2 default null
230: ,p_attribute28 in varchar2 default null
231: ,p_attribute29 in varchar2 default null
232: ,p_attribute30 in varchar2 default null
233: ,p_validate in number default hr_api.g_false_num
234: ,p_effective_date in date
235: ,p_party_id in number default null
236: ,p_validity in varchar2 default null
237: ,p_object_version_number out nocopy number

Line 267: hr_api.constant_to_boolean

263: --
264: -- Convert constant values to their corresponding boolean value
265: --
266: l_validate :=
267: hr_api.constant_to_boolean
268: (p_constant_value => p_validate);
269: --
270: -- Register Surrogate ID or user key values
271: --

Line 376: (p_validate in number default hr_api.g_false_num

372: -- ----------------------------------------------------------------------------
373: -- |-----------------------------< delete_phone >-----------------------------|
374: -- ----------------------------------------------------------------------------
375: PROCEDURE delete_phone
376: (p_validate in number default hr_api.g_false_num
377: ,p_phone_id in number
378: ,p_object_version_number in number
379: ,p_return_status out nocopy varchar2
380: ) is

Line 406: hr_api.constant_to_boolean

402: --
403: -- Convert constant values to their corresponding boolean value
404: --
405: l_validate :=
406: hr_api.constant_to_boolean
407: (p_constant_value => p_validate);
408: --
409: -- Register Surrogate ID or user key values
410: --

Line 471: ,p_date_from in date default hr_api.g_date

467: -- |-----------------------------< update_phone >-----------------------------|
468: -- ----------------------------------------------------------------------------
469: PROCEDURE update_phone
470: (p_phone_id in number
471: ,p_date_from in date default hr_api.g_date
472: ,p_date_to in date default hr_api.g_date
473: ,p_phone_type in varchar2 default hr_api.g_varchar2
474: ,p_phone_number in varchar2 default hr_api.g_varchar2
475: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 472: ,p_date_to in date default hr_api.g_date

468: -- ----------------------------------------------------------------------------
469: PROCEDURE update_phone
470: (p_phone_id in number
471: ,p_date_from in date default hr_api.g_date
472: ,p_date_to in date default hr_api.g_date
473: ,p_phone_type in varchar2 default hr_api.g_varchar2
474: ,p_phone_number in varchar2 default hr_api.g_varchar2
475: ,p_attribute_category in varchar2 default hr_api.g_varchar2
476: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 473: ,p_phone_type in varchar2 default hr_api.g_varchar2

469: PROCEDURE update_phone
470: (p_phone_id in number
471: ,p_date_from in date default hr_api.g_date
472: ,p_date_to in date default hr_api.g_date
473: ,p_phone_type in varchar2 default hr_api.g_varchar2
474: ,p_phone_number in varchar2 default hr_api.g_varchar2
475: ,p_attribute_category in varchar2 default hr_api.g_varchar2
476: ,p_attribute1 in varchar2 default hr_api.g_varchar2
477: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 474: ,p_phone_number in varchar2 default hr_api.g_varchar2

470: (p_phone_id in number
471: ,p_date_from in date default hr_api.g_date
472: ,p_date_to in date default hr_api.g_date
473: ,p_phone_type in varchar2 default hr_api.g_varchar2
474: ,p_phone_number in varchar2 default hr_api.g_varchar2
475: ,p_attribute_category in varchar2 default hr_api.g_varchar2
476: ,p_attribute1 in varchar2 default hr_api.g_varchar2
477: ,p_attribute2 in varchar2 default hr_api.g_varchar2
478: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 475: ,p_attribute_category in varchar2 default hr_api.g_varchar2

471: ,p_date_from in date default hr_api.g_date
472: ,p_date_to in date default hr_api.g_date
473: ,p_phone_type in varchar2 default hr_api.g_varchar2
474: ,p_phone_number in varchar2 default hr_api.g_varchar2
475: ,p_attribute_category in varchar2 default hr_api.g_varchar2
476: ,p_attribute1 in varchar2 default hr_api.g_varchar2
477: ,p_attribute2 in varchar2 default hr_api.g_varchar2
478: ,p_attribute3 in varchar2 default hr_api.g_varchar2
479: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 476: ,p_attribute1 in varchar2 default hr_api.g_varchar2

472: ,p_date_to in date default hr_api.g_date
473: ,p_phone_type in varchar2 default hr_api.g_varchar2
474: ,p_phone_number in varchar2 default hr_api.g_varchar2
475: ,p_attribute_category in varchar2 default hr_api.g_varchar2
476: ,p_attribute1 in varchar2 default hr_api.g_varchar2
477: ,p_attribute2 in varchar2 default hr_api.g_varchar2
478: ,p_attribute3 in varchar2 default hr_api.g_varchar2
479: ,p_attribute4 in varchar2 default hr_api.g_varchar2
480: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 477: ,p_attribute2 in varchar2 default hr_api.g_varchar2

473: ,p_phone_type in varchar2 default hr_api.g_varchar2
474: ,p_phone_number in varchar2 default hr_api.g_varchar2
475: ,p_attribute_category in varchar2 default hr_api.g_varchar2
476: ,p_attribute1 in varchar2 default hr_api.g_varchar2
477: ,p_attribute2 in varchar2 default hr_api.g_varchar2
478: ,p_attribute3 in varchar2 default hr_api.g_varchar2
479: ,p_attribute4 in varchar2 default hr_api.g_varchar2
480: ,p_attribute5 in varchar2 default hr_api.g_varchar2
481: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 478: ,p_attribute3 in varchar2 default hr_api.g_varchar2

474: ,p_phone_number in varchar2 default hr_api.g_varchar2
475: ,p_attribute_category in varchar2 default hr_api.g_varchar2
476: ,p_attribute1 in varchar2 default hr_api.g_varchar2
477: ,p_attribute2 in varchar2 default hr_api.g_varchar2
478: ,p_attribute3 in varchar2 default hr_api.g_varchar2
479: ,p_attribute4 in varchar2 default hr_api.g_varchar2
480: ,p_attribute5 in varchar2 default hr_api.g_varchar2
481: ,p_attribute6 in varchar2 default hr_api.g_varchar2
482: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 479: ,p_attribute4 in varchar2 default hr_api.g_varchar2

475: ,p_attribute_category in varchar2 default hr_api.g_varchar2
476: ,p_attribute1 in varchar2 default hr_api.g_varchar2
477: ,p_attribute2 in varchar2 default hr_api.g_varchar2
478: ,p_attribute3 in varchar2 default hr_api.g_varchar2
479: ,p_attribute4 in varchar2 default hr_api.g_varchar2
480: ,p_attribute5 in varchar2 default hr_api.g_varchar2
481: ,p_attribute6 in varchar2 default hr_api.g_varchar2
482: ,p_attribute7 in varchar2 default hr_api.g_varchar2
483: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 480: ,p_attribute5 in varchar2 default hr_api.g_varchar2

476: ,p_attribute1 in varchar2 default hr_api.g_varchar2
477: ,p_attribute2 in varchar2 default hr_api.g_varchar2
478: ,p_attribute3 in varchar2 default hr_api.g_varchar2
479: ,p_attribute4 in varchar2 default hr_api.g_varchar2
480: ,p_attribute5 in varchar2 default hr_api.g_varchar2
481: ,p_attribute6 in varchar2 default hr_api.g_varchar2
482: ,p_attribute7 in varchar2 default hr_api.g_varchar2
483: ,p_attribute8 in varchar2 default hr_api.g_varchar2
484: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 481: ,p_attribute6 in varchar2 default hr_api.g_varchar2

477: ,p_attribute2 in varchar2 default hr_api.g_varchar2
478: ,p_attribute3 in varchar2 default hr_api.g_varchar2
479: ,p_attribute4 in varchar2 default hr_api.g_varchar2
480: ,p_attribute5 in varchar2 default hr_api.g_varchar2
481: ,p_attribute6 in varchar2 default hr_api.g_varchar2
482: ,p_attribute7 in varchar2 default hr_api.g_varchar2
483: ,p_attribute8 in varchar2 default hr_api.g_varchar2
484: ,p_attribute9 in varchar2 default hr_api.g_varchar2
485: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 482: ,p_attribute7 in varchar2 default hr_api.g_varchar2

478: ,p_attribute3 in varchar2 default hr_api.g_varchar2
479: ,p_attribute4 in varchar2 default hr_api.g_varchar2
480: ,p_attribute5 in varchar2 default hr_api.g_varchar2
481: ,p_attribute6 in varchar2 default hr_api.g_varchar2
482: ,p_attribute7 in varchar2 default hr_api.g_varchar2
483: ,p_attribute8 in varchar2 default hr_api.g_varchar2
484: ,p_attribute9 in varchar2 default hr_api.g_varchar2
485: ,p_attribute10 in varchar2 default hr_api.g_varchar2
486: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 483: ,p_attribute8 in varchar2 default hr_api.g_varchar2

479: ,p_attribute4 in varchar2 default hr_api.g_varchar2
480: ,p_attribute5 in varchar2 default hr_api.g_varchar2
481: ,p_attribute6 in varchar2 default hr_api.g_varchar2
482: ,p_attribute7 in varchar2 default hr_api.g_varchar2
483: ,p_attribute8 in varchar2 default hr_api.g_varchar2
484: ,p_attribute9 in varchar2 default hr_api.g_varchar2
485: ,p_attribute10 in varchar2 default hr_api.g_varchar2
486: ,p_attribute11 in varchar2 default hr_api.g_varchar2
487: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 484: ,p_attribute9 in varchar2 default hr_api.g_varchar2

480: ,p_attribute5 in varchar2 default hr_api.g_varchar2
481: ,p_attribute6 in varchar2 default hr_api.g_varchar2
482: ,p_attribute7 in varchar2 default hr_api.g_varchar2
483: ,p_attribute8 in varchar2 default hr_api.g_varchar2
484: ,p_attribute9 in varchar2 default hr_api.g_varchar2
485: ,p_attribute10 in varchar2 default hr_api.g_varchar2
486: ,p_attribute11 in varchar2 default hr_api.g_varchar2
487: ,p_attribute12 in varchar2 default hr_api.g_varchar2
488: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 485: ,p_attribute10 in varchar2 default hr_api.g_varchar2

481: ,p_attribute6 in varchar2 default hr_api.g_varchar2
482: ,p_attribute7 in varchar2 default hr_api.g_varchar2
483: ,p_attribute8 in varchar2 default hr_api.g_varchar2
484: ,p_attribute9 in varchar2 default hr_api.g_varchar2
485: ,p_attribute10 in varchar2 default hr_api.g_varchar2
486: ,p_attribute11 in varchar2 default hr_api.g_varchar2
487: ,p_attribute12 in varchar2 default hr_api.g_varchar2
488: ,p_attribute13 in varchar2 default hr_api.g_varchar2
489: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 486: ,p_attribute11 in varchar2 default hr_api.g_varchar2

482: ,p_attribute7 in varchar2 default hr_api.g_varchar2
483: ,p_attribute8 in varchar2 default hr_api.g_varchar2
484: ,p_attribute9 in varchar2 default hr_api.g_varchar2
485: ,p_attribute10 in varchar2 default hr_api.g_varchar2
486: ,p_attribute11 in varchar2 default hr_api.g_varchar2
487: ,p_attribute12 in varchar2 default hr_api.g_varchar2
488: ,p_attribute13 in varchar2 default hr_api.g_varchar2
489: ,p_attribute14 in varchar2 default hr_api.g_varchar2
490: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 487: ,p_attribute12 in varchar2 default hr_api.g_varchar2

483: ,p_attribute8 in varchar2 default hr_api.g_varchar2
484: ,p_attribute9 in varchar2 default hr_api.g_varchar2
485: ,p_attribute10 in varchar2 default hr_api.g_varchar2
486: ,p_attribute11 in varchar2 default hr_api.g_varchar2
487: ,p_attribute12 in varchar2 default hr_api.g_varchar2
488: ,p_attribute13 in varchar2 default hr_api.g_varchar2
489: ,p_attribute14 in varchar2 default hr_api.g_varchar2
490: ,p_attribute15 in varchar2 default hr_api.g_varchar2
491: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 488: ,p_attribute13 in varchar2 default hr_api.g_varchar2

484: ,p_attribute9 in varchar2 default hr_api.g_varchar2
485: ,p_attribute10 in varchar2 default hr_api.g_varchar2
486: ,p_attribute11 in varchar2 default hr_api.g_varchar2
487: ,p_attribute12 in varchar2 default hr_api.g_varchar2
488: ,p_attribute13 in varchar2 default hr_api.g_varchar2
489: ,p_attribute14 in varchar2 default hr_api.g_varchar2
490: ,p_attribute15 in varchar2 default hr_api.g_varchar2
491: ,p_attribute16 in varchar2 default hr_api.g_varchar2
492: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 489: ,p_attribute14 in varchar2 default hr_api.g_varchar2

485: ,p_attribute10 in varchar2 default hr_api.g_varchar2
486: ,p_attribute11 in varchar2 default hr_api.g_varchar2
487: ,p_attribute12 in varchar2 default hr_api.g_varchar2
488: ,p_attribute13 in varchar2 default hr_api.g_varchar2
489: ,p_attribute14 in varchar2 default hr_api.g_varchar2
490: ,p_attribute15 in varchar2 default hr_api.g_varchar2
491: ,p_attribute16 in varchar2 default hr_api.g_varchar2
492: ,p_attribute17 in varchar2 default hr_api.g_varchar2
493: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 490: ,p_attribute15 in varchar2 default hr_api.g_varchar2

486: ,p_attribute11 in varchar2 default hr_api.g_varchar2
487: ,p_attribute12 in varchar2 default hr_api.g_varchar2
488: ,p_attribute13 in varchar2 default hr_api.g_varchar2
489: ,p_attribute14 in varchar2 default hr_api.g_varchar2
490: ,p_attribute15 in varchar2 default hr_api.g_varchar2
491: ,p_attribute16 in varchar2 default hr_api.g_varchar2
492: ,p_attribute17 in varchar2 default hr_api.g_varchar2
493: ,p_attribute18 in varchar2 default hr_api.g_varchar2
494: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 491: ,p_attribute16 in varchar2 default hr_api.g_varchar2

487: ,p_attribute12 in varchar2 default hr_api.g_varchar2
488: ,p_attribute13 in varchar2 default hr_api.g_varchar2
489: ,p_attribute14 in varchar2 default hr_api.g_varchar2
490: ,p_attribute15 in varchar2 default hr_api.g_varchar2
491: ,p_attribute16 in varchar2 default hr_api.g_varchar2
492: ,p_attribute17 in varchar2 default hr_api.g_varchar2
493: ,p_attribute18 in varchar2 default hr_api.g_varchar2
494: ,p_attribute19 in varchar2 default hr_api.g_varchar2
495: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 492: ,p_attribute17 in varchar2 default hr_api.g_varchar2

488: ,p_attribute13 in varchar2 default hr_api.g_varchar2
489: ,p_attribute14 in varchar2 default hr_api.g_varchar2
490: ,p_attribute15 in varchar2 default hr_api.g_varchar2
491: ,p_attribute16 in varchar2 default hr_api.g_varchar2
492: ,p_attribute17 in varchar2 default hr_api.g_varchar2
493: ,p_attribute18 in varchar2 default hr_api.g_varchar2
494: ,p_attribute19 in varchar2 default hr_api.g_varchar2
495: ,p_attribute20 in varchar2 default hr_api.g_varchar2
496: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 493: ,p_attribute18 in varchar2 default hr_api.g_varchar2

489: ,p_attribute14 in varchar2 default hr_api.g_varchar2
490: ,p_attribute15 in varchar2 default hr_api.g_varchar2
491: ,p_attribute16 in varchar2 default hr_api.g_varchar2
492: ,p_attribute17 in varchar2 default hr_api.g_varchar2
493: ,p_attribute18 in varchar2 default hr_api.g_varchar2
494: ,p_attribute19 in varchar2 default hr_api.g_varchar2
495: ,p_attribute20 in varchar2 default hr_api.g_varchar2
496: ,p_attribute21 in varchar2 default hr_api.g_varchar2
497: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 494: ,p_attribute19 in varchar2 default hr_api.g_varchar2

490: ,p_attribute15 in varchar2 default hr_api.g_varchar2
491: ,p_attribute16 in varchar2 default hr_api.g_varchar2
492: ,p_attribute17 in varchar2 default hr_api.g_varchar2
493: ,p_attribute18 in varchar2 default hr_api.g_varchar2
494: ,p_attribute19 in varchar2 default hr_api.g_varchar2
495: ,p_attribute20 in varchar2 default hr_api.g_varchar2
496: ,p_attribute21 in varchar2 default hr_api.g_varchar2
497: ,p_attribute22 in varchar2 default hr_api.g_varchar2
498: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 495: ,p_attribute20 in varchar2 default hr_api.g_varchar2

491: ,p_attribute16 in varchar2 default hr_api.g_varchar2
492: ,p_attribute17 in varchar2 default hr_api.g_varchar2
493: ,p_attribute18 in varchar2 default hr_api.g_varchar2
494: ,p_attribute19 in varchar2 default hr_api.g_varchar2
495: ,p_attribute20 in varchar2 default hr_api.g_varchar2
496: ,p_attribute21 in varchar2 default hr_api.g_varchar2
497: ,p_attribute22 in varchar2 default hr_api.g_varchar2
498: ,p_attribute23 in varchar2 default hr_api.g_varchar2
499: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 496: ,p_attribute21 in varchar2 default hr_api.g_varchar2

492: ,p_attribute17 in varchar2 default hr_api.g_varchar2
493: ,p_attribute18 in varchar2 default hr_api.g_varchar2
494: ,p_attribute19 in varchar2 default hr_api.g_varchar2
495: ,p_attribute20 in varchar2 default hr_api.g_varchar2
496: ,p_attribute21 in varchar2 default hr_api.g_varchar2
497: ,p_attribute22 in varchar2 default hr_api.g_varchar2
498: ,p_attribute23 in varchar2 default hr_api.g_varchar2
499: ,p_attribute24 in varchar2 default hr_api.g_varchar2
500: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 497: ,p_attribute22 in varchar2 default hr_api.g_varchar2

493: ,p_attribute18 in varchar2 default hr_api.g_varchar2
494: ,p_attribute19 in varchar2 default hr_api.g_varchar2
495: ,p_attribute20 in varchar2 default hr_api.g_varchar2
496: ,p_attribute21 in varchar2 default hr_api.g_varchar2
497: ,p_attribute22 in varchar2 default hr_api.g_varchar2
498: ,p_attribute23 in varchar2 default hr_api.g_varchar2
499: ,p_attribute24 in varchar2 default hr_api.g_varchar2
500: ,p_attribute25 in varchar2 default hr_api.g_varchar2
501: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 498: ,p_attribute23 in varchar2 default hr_api.g_varchar2

494: ,p_attribute19 in varchar2 default hr_api.g_varchar2
495: ,p_attribute20 in varchar2 default hr_api.g_varchar2
496: ,p_attribute21 in varchar2 default hr_api.g_varchar2
497: ,p_attribute22 in varchar2 default hr_api.g_varchar2
498: ,p_attribute23 in varchar2 default hr_api.g_varchar2
499: ,p_attribute24 in varchar2 default hr_api.g_varchar2
500: ,p_attribute25 in varchar2 default hr_api.g_varchar2
501: ,p_attribute26 in varchar2 default hr_api.g_varchar2
502: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 499: ,p_attribute24 in varchar2 default hr_api.g_varchar2

495: ,p_attribute20 in varchar2 default hr_api.g_varchar2
496: ,p_attribute21 in varchar2 default hr_api.g_varchar2
497: ,p_attribute22 in varchar2 default hr_api.g_varchar2
498: ,p_attribute23 in varchar2 default hr_api.g_varchar2
499: ,p_attribute24 in varchar2 default hr_api.g_varchar2
500: ,p_attribute25 in varchar2 default hr_api.g_varchar2
501: ,p_attribute26 in varchar2 default hr_api.g_varchar2
502: ,p_attribute27 in varchar2 default hr_api.g_varchar2
503: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 500: ,p_attribute25 in varchar2 default hr_api.g_varchar2

496: ,p_attribute21 in varchar2 default hr_api.g_varchar2
497: ,p_attribute22 in varchar2 default hr_api.g_varchar2
498: ,p_attribute23 in varchar2 default hr_api.g_varchar2
499: ,p_attribute24 in varchar2 default hr_api.g_varchar2
500: ,p_attribute25 in varchar2 default hr_api.g_varchar2
501: ,p_attribute26 in varchar2 default hr_api.g_varchar2
502: ,p_attribute27 in varchar2 default hr_api.g_varchar2
503: ,p_attribute28 in varchar2 default hr_api.g_varchar2
504: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 501: ,p_attribute26 in varchar2 default hr_api.g_varchar2

497: ,p_attribute22 in varchar2 default hr_api.g_varchar2
498: ,p_attribute23 in varchar2 default hr_api.g_varchar2
499: ,p_attribute24 in varchar2 default hr_api.g_varchar2
500: ,p_attribute25 in varchar2 default hr_api.g_varchar2
501: ,p_attribute26 in varchar2 default hr_api.g_varchar2
502: ,p_attribute27 in varchar2 default hr_api.g_varchar2
503: ,p_attribute28 in varchar2 default hr_api.g_varchar2
504: ,p_attribute29 in varchar2 default hr_api.g_varchar2
505: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 502: ,p_attribute27 in varchar2 default hr_api.g_varchar2

498: ,p_attribute23 in varchar2 default hr_api.g_varchar2
499: ,p_attribute24 in varchar2 default hr_api.g_varchar2
500: ,p_attribute25 in varchar2 default hr_api.g_varchar2
501: ,p_attribute26 in varchar2 default hr_api.g_varchar2
502: ,p_attribute27 in varchar2 default hr_api.g_varchar2
503: ,p_attribute28 in varchar2 default hr_api.g_varchar2
504: ,p_attribute29 in varchar2 default hr_api.g_varchar2
505: ,p_attribute30 in varchar2 default hr_api.g_varchar2
506: ,p_object_version_number in out nocopy number

Line 503: ,p_attribute28 in varchar2 default hr_api.g_varchar2

499: ,p_attribute24 in varchar2 default hr_api.g_varchar2
500: ,p_attribute25 in varchar2 default hr_api.g_varchar2
501: ,p_attribute26 in varchar2 default hr_api.g_varchar2
502: ,p_attribute27 in varchar2 default hr_api.g_varchar2
503: ,p_attribute28 in varchar2 default hr_api.g_varchar2
504: ,p_attribute29 in varchar2 default hr_api.g_varchar2
505: ,p_attribute30 in varchar2 default hr_api.g_varchar2
506: ,p_object_version_number in out nocopy number
507: ,p_validate in number default hr_api.g_false_num

Line 504: ,p_attribute29 in varchar2 default hr_api.g_varchar2

500: ,p_attribute25 in varchar2 default hr_api.g_varchar2
501: ,p_attribute26 in varchar2 default hr_api.g_varchar2
502: ,p_attribute27 in varchar2 default hr_api.g_varchar2
503: ,p_attribute28 in varchar2 default hr_api.g_varchar2
504: ,p_attribute29 in varchar2 default hr_api.g_varchar2
505: ,p_attribute30 in varchar2 default hr_api.g_varchar2
506: ,p_object_version_number in out nocopy number
507: ,p_validate in number default hr_api.g_false_num
508: ,p_effective_date in date

Line 505: ,p_attribute30 in varchar2 default hr_api.g_varchar2

501: ,p_attribute26 in varchar2 default hr_api.g_varchar2
502: ,p_attribute27 in varchar2 default hr_api.g_varchar2
503: ,p_attribute28 in varchar2 default hr_api.g_varchar2
504: ,p_attribute29 in varchar2 default hr_api.g_varchar2
505: ,p_attribute30 in varchar2 default hr_api.g_varchar2
506: ,p_object_version_number in out nocopy number
507: ,p_validate in number default hr_api.g_false_num
508: ,p_effective_date in date
509: ,p_party_id in number default hr_api.g_number

Line 507: ,p_validate in number default hr_api.g_false_num

503: ,p_attribute28 in varchar2 default hr_api.g_varchar2
504: ,p_attribute29 in varchar2 default hr_api.g_varchar2
505: ,p_attribute30 in varchar2 default hr_api.g_varchar2
506: ,p_object_version_number in out nocopy number
507: ,p_validate in number default hr_api.g_false_num
508: ,p_effective_date in date
509: ,p_party_id in number default hr_api.g_number
510: ,p_validity in varchar2 default hr_api.g_varchar2
511: ,p_return_status out nocopy varchar2

Line 509: ,p_party_id in number default hr_api.g_number

505: ,p_attribute30 in varchar2 default hr_api.g_varchar2
506: ,p_object_version_number in out nocopy number
507: ,p_validate in number default hr_api.g_false_num
508: ,p_effective_date in date
509: ,p_party_id in number default hr_api.g_number
510: ,p_validity in varchar2 default hr_api.g_varchar2
511: ,p_return_status out nocopy varchar2
512: ) is
513: --

Line 510: ,p_validity in varchar2 default hr_api.g_varchar2

506: ,p_object_version_number in out nocopy number
507: ,p_validate in number default hr_api.g_false_num
508: ,p_effective_date in date
509: ,p_party_id in number default hr_api.g_number
510: ,p_validity in varchar2 default hr_api.g_varchar2
511: ,p_return_status out nocopy varchar2
512: ) is
513: --
514: -- Variables for API Boolean parameters

Line 540: hr_api.constant_to_boolean

536: --
537: -- Convert constant values to their corresponding boolean value
538: --
539: l_validate :=
540: hr_api.constant_to_boolean
541: (p_constant_value => p_validate);
542: --
543: -- Register Surrogate ID or user key values
544: --