APPS.HR_ORGANIZATION_API dependencies on HR_API

Line 43: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

39: * @param p_name The name of the organization the process creates.
40: * @param p_date_from Date the organization takes effect.
41: * @param p_language_code Specifies to which language the translation values
42: * apply. You can set to the base or any installed language. The default value
43: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
44: * value.
45: * @param p_location_id Uniquely identifies the location of the organization.
46: * @param p_date_to Date the organization is no longer in effect.
47: * @param p_internal_external_flag Flag specifying if the organization is an

Line 116: ,p_language_code in varchar2 default hr_api.userenv_lang

112: ,p_effective_date in date
113: ,p_business_group_id in number
114: ,p_name in varchar2
115: ,p_date_from in date
116: ,p_language_code in varchar2 default hr_api.userenv_lang
117: ,p_location_id in number default null
118: ,p_date_to in date default null
119: ,p_internal_external_flag in varchar2 default null
120: ,p_internal_address_line in varchar2 default null

Line 173: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

169: --
170: PROCEDURE create_organization
171: ( p_validate IN BOOLEAN DEFAULT false
172: ,p_effective_date IN DATE
173: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
174: ,p_business_group_id IN NUMBER
175: ,p_date_from IN DATE
176: ,p_name IN VARCHAR2
177: ,p_location_id in number default null

Line 251: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

247: * applicable during the start to end active date range. This date does not
248: * determine when the changes take effect.
249: * @param p_language_code Specifies to which language the translation values
250: * apply. You can set to the base or any installed language. The default value
251: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
252: * value.
253: * @param p_business_group_id Uniquely identifies the business group associated
254: * with the organization the process creates.
255: * @param p_date_from Date the organization takes effect.

Line 320: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

316:
317: PROCEDURE create_organization
318: ( p_validate IN BOOLEAN DEFAULT false
319: ,p_effective_date IN DATE
320: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
321: ,p_business_group_id IN NUMBER
322: ,p_date_from IN DATE
323: ,p_name IN VARCHAR2
324: ,p_location_id in number default null

Line 401: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

397: * applicable during the start to end active date range. This date does not
398: * determine when the changes take effect.
399: * @param p_language_code Specifies to which language the translation values
400: * apply. You can set to the base or any installed language. The default value
401: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
402: * value.
403: * @param p_name Name of the organization (translated).
404: * @param p_organization_id Uniquely identifies the organization record to
405: * modify.

Line 499: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

495: --
496: PROCEDURE update_organization
497: ( p_validate IN BOOLEAN DEFAULT false
498: ,p_effective_date IN DATE
499: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
500: --
501: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_organization_id IN NUMBER
503: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number

Line 501: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

497: ( p_validate IN BOOLEAN DEFAULT false
498: ,p_effective_date IN DATE
499: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
500: --
501: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_organization_id IN NUMBER
503: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
505: -- Bug 3040119

Line 503: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number

499: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
500: --
501: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_organization_id IN NUMBER
503: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
505: -- Bug 3040119
506: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
507: ,p_date_from IN DATE DEFAULT hr_api.g_date

Line 504: ,p_location_id IN NUMBER DEFAULT hr_api.g_number

500: --
501: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_organization_id IN NUMBER
503: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
505: -- Bug 3040119
506: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
507: ,p_date_from IN DATE DEFAULT hr_api.g_date
508: ,p_date_to IN DATE DEFAULT hr_api.g_date

Line 506: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number

502: ,p_organization_id IN NUMBER
503: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
505: -- Bug 3040119
506: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
507: ,p_date_from IN DATE DEFAULT hr_api.g_date
508: ,p_date_to IN DATE DEFAULT hr_api.g_date
509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 507: ,p_date_from IN DATE DEFAULT hr_api.g_date

503: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
505: -- Bug 3040119
506: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
507: ,p_date_from IN DATE DEFAULT hr_api.g_date
508: ,p_date_to IN DATE DEFAULT hr_api.g_date
509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 508: ,p_date_to IN DATE DEFAULT hr_api.g_date

504: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
505: -- Bug 3040119
506: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
507: ,p_date_from IN DATE DEFAULT hr_api.g_date
508: ,p_date_to IN DATE DEFAULT hr_api.g_date
509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

505: -- Bug 3040119
506: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
507: ,p_date_from IN DATE DEFAULT hr_api.g_date
508: ,p_date_to IN DATE DEFAULT hr_api.g_date
509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2

506: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
507: ,p_date_from IN DATE DEFAULT hr_api.g_date
508: ,p_date_to IN DATE DEFAULT hr_api.g_date
509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

507: ,p_date_from IN DATE DEFAULT hr_api.g_date
508: ,p_date_to IN DATE DEFAULT hr_api.g_date
509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2

508: ,p_date_to IN DATE DEFAULT hr_api.g_date
509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

509: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

510: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

511: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

512: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

513: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

514: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

515: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

516: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

517: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

518: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

519: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

520: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

521: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

522: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

523: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

524: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

525: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

526: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: --Enhancement 4040086

Line 531: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

527: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: --Enhancement 4040086
535: --Begin of Add 10 additional segments

Line 532: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

528: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: --Enhancement 4040086
535: --Begin of Add 10 additional segments
536: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 533: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

529: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: --Enhancement 4040086
535: --Begin of Add 10 additional segments
536: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 536: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

532: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: --Enhancement 4040086
535: --Begin of Add 10 additional segments
536: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 537: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

533: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: --Enhancement 4040086
535: --Begin of Add 10 additional segments
536: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 538: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

534: --Enhancement 4040086
535: --Begin of Add 10 additional segments
536: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

535: --Begin of Add 10 additional segments
536: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

536: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

537: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

538: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: --End of Add 10 additional segments

Line 543: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

539: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: --End of Add 10 additional segments
547: -- Bug 3039046

Line 544: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

540: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: --End of Add 10 additional segments
547: -- Bug 3039046
548: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 545: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

541: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: --End of Add 10 additional segments
547: -- Bug 3039046
548: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 548: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

544: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: --End of Add 10 additional segments
547: -- Bug 3039046
548: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 549: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

545: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: --End of Add 10 additional segments
547: -- Bug 3039046
548: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 550: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

546: --End of Add 10 additional segments
547: -- Bug 3039046
548: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

547: -- Bug 3039046
548: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

548: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

549: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

550: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

551: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

552: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

553: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

554: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

555: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

556: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

557: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

558: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

559: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

560: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

561: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

562: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

563: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

564: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

565: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

566: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

567: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

568: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
576: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

569: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
576: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
577: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

570: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
576: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
577: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
578: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

571: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
576: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
577: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
578: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
579: --

Line 576: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

572: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
576: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
577: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
578: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
579: --
580: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 577: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

573: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
576: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
577: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
578: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
579: --
580: ,p_object_version_number IN OUT NOCOPY NUMBER
581: ,p_duplicate_org_warning OUT NOCOPY BOOLEAN

Line 578: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2

574: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
576: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
577: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
578: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
579: --
580: ,p_object_version_number IN OUT NOCOPY NUMBER
581: ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
582: );

Line 597: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

593:
594: PROCEDURE update_organization
595: ( p_validate IN BOOLEAN DEFAULT false
596: ,p_effective_date IN DATE
597: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
598: --
599: ,p_organization_id IN NUMBER
600: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
601: ,p_location_id IN NUMBER DEFAULT hr_api.g_number

Line 600: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number

596: ,p_effective_date IN DATE
597: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
598: --
599: ,p_organization_id IN NUMBER
600: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
601: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
602: -- Bug 3040119
603: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
604: ,p_date_from IN DATE DEFAULT hr_api.g_date

Line 601: ,p_location_id IN NUMBER DEFAULT hr_api.g_number

597: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
598: --
599: ,p_organization_id IN NUMBER
600: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
601: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
602: -- Bug 3040119
603: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
604: ,p_date_from IN DATE DEFAULT hr_api.g_date
605: ,p_date_to IN DATE DEFAULT hr_api.g_date

Line 603: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number

599: ,p_organization_id IN NUMBER
600: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
601: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
602: -- Bug 3040119
603: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
604: ,p_date_from IN DATE DEFAULT hr_api.g_date
605: ,p_date_to IN DATE DEFAULT hr_api.g_date
606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 604: ,p_date_from IN DATE DEFAULT hr_api.g_date

600: ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
601: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
602: -- Bug 3040119
603: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
604: ,p_date_from IN DATE DEFAULT hr_api.g_date
605: ,p_date_to IN DATE DEFAULT hr_api.g_date
606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 605: ,p_date_to IN DATE DEFAULT hr_api.g_date

601: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
602: -- Bug 3040119
603: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
604: ,p_date_from IN DATE DEFAULT hr_api.g_date
605: ,p_date_to IN DATE DEFAULT hr_api.g_date
606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

602: -- Bug 3040119
603: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
604: ,p_date_from IN DATE DEFAULT hr_api.g_date
605: ,p_date_to IN DATE DEFAULT hr_api.g_date
606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2

603: --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
604: ,p_date_from IN DATE DEFAULT hr_api.g_date
605: ,p_date_to IN DATE DEFAULT hr_api.g_date
606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

604: ,p_date_from IN DATE DEFAULT hr_api.g_date
605: ,p_date_to IN DATE DEFAULT hr_api.g_date
606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2

605: ,p_date_to IN DATE DEFAULT hr_api.g_date
606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

606: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

607: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

608: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

609: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

610: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

611: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

612: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

613: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

614: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

615: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

616: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

617: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

618: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

619: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

620: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
628: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

621: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
628: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
629: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

622: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
628: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
629: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
630: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

623: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
628: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
629: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
630: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
631: --Enhancement 4040086

Line 628: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

624: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
628: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
629: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
630: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
631: --Enhancement 4040086
632: --Begin of Add 10 additional segments

Line 629: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

625: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
628: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
629: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
630: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
631: --Enhancement 4040086
632: --Begin of Add 10 additional segments
633: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 630: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

626: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
628: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
629: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
630: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
631: --Enhancement 4040086
632: --Begin of Add 10 additional segments
633: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
634: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 633: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

629: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
630: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
631: --Enhancement 4040086
632: --Begin of Add 10 additional segments
633: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
634: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
635: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 634: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

630: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
631: --Enhancement 4040086
632: --Begin of Add 10 additional segments
633: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
634: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
635: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 635: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

631: --Enhancement 4040086
632: --Begin of Add 10 additional segments
633: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
634: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
635: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

632: --Begin of Add 10 additional segments
633: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
634: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
635: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

633: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
634: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
635: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

634: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
635: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

635: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
643: -- Bug 3039046

Line 640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

636: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
643: -- Bug 3039046
644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

637: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
643: -- Bug 3039046
644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

638: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
643: -- Bug 3039046
644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

640: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
643: -- Bug 3039046
644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

641: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
643: -- Bug 3039046
644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

642: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
643: -- Bug 3039046
644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

643: -- Bug 3039046
644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

644: ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

645: ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

646: ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

647: ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

648: ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

649: ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

650: ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

651: ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

652: ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

653: ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

654: ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

655: ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

656: ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

657: ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

658: ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

659: ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

660: ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

661: ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

662: ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

663: ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

664: ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

665: ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
673: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

666: ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
673: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
674: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

667: ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
673: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
674: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
675: --

Line 672: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

668: ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
673: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
674: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
675: --
676: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 673: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

669: ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
673: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
674: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
675: --
676: ,p_object_version_number IN OUT NOCOPY NUMBER
677: );

Line 674: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2

670: ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671: ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672: ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
673: ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
674: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
675: --
676: ,p_object_version_number IN OUT NOCOPY NUMBER
677: );
678: --

Line 1267: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1263: (p_validate IN BOOLEAN DEFAULT false
1264: ,p_effective_date IN DATE
1265: ,p_org_information_id IN NUMBER
1266: ,p_org_info_type_code IN VARCHAR2
1267: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1268: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1264: ,p_effective_date IN DATE
1265: ,p_org_information_id IN NUMBER
1266: ,p_org_info_type_code IN VARCHAR2
1267: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1269: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1265: ,p_org_information_id IN NUMBER
1266: ,p_org_info_type_code IN VARCHAR2
1267: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1266: ,p_org_info_type_code IN VARCHAR2
1267: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1267: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1268: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1269: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1270: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1271: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1272: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1273: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1274: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1275: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1276: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1277: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1278: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1279: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1280: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1281: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1282: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

1283: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1284: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1285: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1286: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1287: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1288: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1289: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1290: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1291: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1292: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1293: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1294: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1295: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1296: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1297: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1298: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1299: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1300: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1308: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 1305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1301: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1308: ,p_object_version_number IN OUT NOCOPY NUMBER
1309: );

Line 1306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1302: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1308: ,p_object_version_number IN OUT NOCOPY NUMBER
1309: );
1310: --

Line 1307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1303: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1306: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1307: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1308: ,p_object_version_number IN OUT NOCOPY NUMBER
1309: );
1310: --
1311: -- ----------------------------------------------------------------------------

Line 1414: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1410: ,p_effective_date IN DATE
1411: ,p_organization_id IN NUMBER
1412: ,p_org_information_id IN NUMBER
1413: ,p_org_info_type_code IN VARCHAR2
1414: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1415: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1416: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1415: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1411: ,p_organization_id IN NUMBER
1412: ,p_org_information_id IN NUMBER
1413: ,p_org_info_type_code IN VARCHAR2
1414: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1415: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1416: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1416: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1412: ,p_org_information_id IN NUMBER
1413: ,p_org_info_type_code IN VARCHAR2
1414: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1415: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1416: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1413: ,p_org_info_type_code IN VARCHAR2
1414: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1415: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1416: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1414: ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1415: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1416: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1415: ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1416: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1416: ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1417: ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1418: ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1419: ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1420: ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1421: ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1422: ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1423: ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1424: ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1425: ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1426: ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1427: ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1428: ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1429: ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

1430: ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1431: ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1432: ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1433: ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1434: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1435: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1436: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1437: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1438: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1439: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1440: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1441: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1442: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1443: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1444: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1445: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1446: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1447: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 1452: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1448: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_object_version_number IN OUT NOCOPY NUMBER
1456: ,p_warning OUT NOCOPY BOOLEAN);

Line 1453: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1449: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_object_version_number IN OUT NOCOPY NUMBER
1456: ,p_warning OUT NOCOPY BOOLEAN);
1457: --

Line 1454: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1450: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_object_version_number IN OUT NOCOPY NUMBER
1456: ,p_warning OUT NOCOPY BOOLEAN);
1457: --
1458: -- ----------------------------------------------------------------------------

Line 1536: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

1532: * applicable during the start to end active date range. This date does not
1533: * determine when the changes take effect.
1534: * @param p_language_code Specifies to which language the translation values
1535: * apply. You can set to the base or any installed language. The default value
1536: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
1537: * value.
1538: * @param p_date_from Date the organization takes effect.
1539: * @param p_name The business group name (translated).
1540: * @param p_type The organization type associated with the organization the

Line 1584: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

1580: --
1581: PROCEDURE create_business_group
1582: ( p_validate IN BOOLEAN DEFAULT false
1583: ,p_effective_date IN DATE
1584: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1585: --
1586: ,p_date_from IN DATE
1587: ,p_name IN VARCHAR2
1588: ,p_type IN VARCHAR2

Line 1642: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

1638: * applicable during the start to end active date range. This date does not
1639: * determine when the changes take effect.
1640: * @param p_language_code Specifies to which language the translation values
1641: * apply. You can set to the base or any installed language. The default value
1642: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
1643: * value.
1644: * @param p_business_group_id Uniquely identifies the business group associated
1645: * with the operating unit the process creates.
1646: * @param p_date_from Date the operating unit takes effect.

Line 1678: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

1674:
1675: PROCEDURE create_operating_unit
1676: ( p_validate IN BOOLEAN DEFAULT false
1677: ,p_effective_date IN DATE
1678: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1679: --
1680: ,p_business_group_id IN NUMBER
1681: ,p_date_from IN DATE
1682: ,p_name IN VARCHAR2

Line 1751: * value of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG')

1747: * applicable during the start to end active date range and used for
1748: * date_track validation.
1749: * @param p_language_code Specifies to which language the translation
1750: * values apply. You can set to the base or any installed language. The default
1751: * value of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG')
1752: * function value.
1753: * @param p_date_from Date the operating unit takes effect.
1754: * @param p_name The name of the operating unit.
1755: * @param p_type The organization type associated with the operating unit the

Line 1787: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

1783: (
1784: p_validate IN BOOLEAN DEFAULT false
1785: ,p_organization_id IN NUMBER
1786: ,p_effective_date IN DATE
1787: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1788: ,p_date_from IN DATE DEFAULT hr_api.g_date
1789: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1788: ,p_date_from IN DATE DEFAULT hr_api.g_date

1784: p_validate IN BOOLEAN DEFAULT false
1785: ,p_organization_id IN NUMBER
1786: ,p_effective_date IN DATE
1787: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1788: ,p_date_from IN DATE DEFAULT hr_api.g_date
1789: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number

Line 1789: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

1785: ,p_organization_id IN NUMBER
1786: ,p_effective_date IN DATE
1787: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1788: ,p_date_from IN DATE DEFAULT hr_api.g_date
1789: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

1786: ,p_effective_date IN DATE
1787: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1788: ,p_date_from IN DATE DEFAULT hr_api.g_date
1789: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1794: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

1787: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1788: ,p_date_from IN DATE DEFAULT hr_api.g_date
1789: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1794: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1795: -- Added p_short_code for bug 4526439

Line 1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number

1788: ,p_date_from IN DATE DEFAULT hr_api.g_date
1789: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1794: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1795: -- Added p_short_code for bug 4526439
1796: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2

1789: ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1794: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1795: -- Added p_short_code for bug 4526439
1796: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1797: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1794: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

1790: ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791: ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1794: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1795: -- Added p_short_code for bug 4526439
1796: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1797: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1798: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 1796: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

1792: ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1794: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1795: -- Added p_short_code for bug 4526439
1796: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1797: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1798: ,p_object_version_number IN OUT NOCOPY NUMBER
1799: ,p_update_prim_ledger_warning OUT NOCOPY BOOLEAN
1800: ,p_duplicate_org_warning OUT NOCOPY BOOLEAN

Line 1797: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2

1793: ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1794: ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1795: -- Added p_short_code for bug 4526439
1796: ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1797: ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1798: ,p_object_version_number IN OUT NOCOPY NUMBER
1799: ,p_update_prim_ledger_warning OUT NOCOPY BOOLEAN
1800: ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
1801: );

Line 1838: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

1834: * applicable during the start to end active date range. This date does not
1835: * determine when the changes take effect.
1836: * @param p_language_code Specifies to which language the translation values
1837: * apply. You can set to the base or any installed language. The default value
1838: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
1839: * value.
1840: * @param p_business_group_id Uniquely identifies the business group associated
1841: * with the legal entity the process creates.
1842: * @param p_date_from Date the legal entity takes effect.

Line 1870: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

1866:
1867: PROCEDURE create_legal_entity
1868: ( p_validate IN BOOLEAN DEFAULT false
1869: ,p_effective_date IN DATE
1870: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1871: --
1872: ,p_business_group_id IN NUMBER
1873: ,p_date_from IN DATE
1874: ,p_name IN VARCHAR2

Line 2075: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

2071: * applicable during the start to end active date range. This date does not
2072: * determine when the changes take effect.
2073: * @param p_language_code Specifies to which language the translation values
2074: * apply. You can set to the base or any installed language. The default value
2075: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
2076: * value.
2077: * @param p_organization_id Uniquely identifies the organization whose name the
2078: * process translates.
2079: * @param p_name The organization name (translated)

Line 2092: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

2088: --
2089: PROCEDURE trans_org_name
2090: ( p_validate IN BOOLEAN DEFAULT false
2091: ,p_effective_date IN DATE
2092: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
2093: --
2094: ,p_organization_id IN NUMBER
2095: ,p_name IN VARCHAR2
2096: );

Line 2194: ,p_language_code IN VARCHAR2 DEFAULT HR_API.userenv_lang

2190: -- This API creates a default or not usable Operating Unit.
2191: PROCEDURE create_not_usable_ou_internal
2192: (p_validate IN BOOLEAN DEFAULT FALSE
2193: ,p_effective_date IN DATE
2194: ,p_language_code IN VARCHAR2 DEFAULT HR_API.userenv_lang
2195: ,p_business_group_id IN NUMBER
2196: ,p_date_from IN DATE
2197: ,p_name IN VARCHAR2
2198: ,p_type IN VARCHAR2