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

APPS.IRC_OFFERS_API dependencies on HR_API

Line 327: raise hr_api.validate_enabled;

323: --
324: -- When in validation only mode raise the Validate_Enabled exception
325: --
326: if p_validate then
327: raise hr_api.validate_enabled;
328: end if;
329: --
330: p_offer_assignment_id := l_offer_assignment_id;
331: --

Line 335: when hr_api.validate_enabled then

331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 60);
333: --
334: exception
335: when hr_api.validate_enabled then
336: --
337: p_offer_assignment_id := null;
338: --
339: -- As the Validate_Enabled exception has been raised

Line 592: l_datetrack_mode := hr_api.g_correction;

588: --
589: -- Since the current record has started today, we need to
590: -- correct the existing record.
591: --
592: l_datetrack_mode := hr_api.g_correction;
593: else
594: --
595: hr_utility.set_location(l_proc,90);
596: --

Line 599: l_datetrack_mode := hr_api.g_update;

595: hr_utility.set_location(l_proc,90);
596: --
597: -- End the existing record and create a new record.
598: --
599: l_datetrack_mode := hr_api.g_update;
600: end if;
601: --
602: -- Call update_status_type_apl_asg in the required date track mode.
603: --

Line 654: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2

650: procedure update_latest_offer_flag
651: ( P_VALIDATE IN boolean default false
652: ,P_EFFECTIVE_DATE IN date default null
653: ,P_OFFER_ID IN NUMBER
654: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
655: ,P_LATEST_OFFER IN VARCHAR2
656: ,P_CHANGE_REASON IN VARCHAR2 default null
657: ,P_STATUS_CHANGE_DATE IN date default null
658: ) is

Line 722: if p_offer_status <> hr_api.g_varchar2

718: --
719: -- Insert a new Offer History record with the change_reason only if
720: -- the Status has changed.
721: --
722: if p_offer_status <> hr_api.g_varchar2
723: and p_offer_status <> l_updated_offer_status
724: then
725: --
726: hr_utility.set_location(l_proc, 50);

Line 774: ,p_datetrack_mode => hr_api.g_delete

770: ,p_object_version_number => l_asg_object_version_number
771: ,p_effective_date => p_effective_date
772: ,p_validation_start_date => l_validation_start_date
773: ,p_validation_end_date => l_validation_end_date
774: ,p_datetrack_mode => hr_api.g_delete
775: ,p_validate => p_validate
776: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
777: );
778: --

Line 822: l_datetrack_mode varchar2(30) := hr_api.g_update;

818: l_org_now_no_manager_warning boolean;
819: l_validation_start_date date;
820: l_validation_end_date date;
821: l_effective_date date;
822: l_datetrack_mode varchar2(30) := hr_api.g_update;
823: --
824: -- Define cursors
825: --
826: cursor csr_assignment_ids is

Line 1024: l_datetrack_mode := hr_api.g_correction;

1020: --
1021: -- Since the applicant assignment record is being modified multiple
1022: -- times on the same day, the datetrack mode should be correction.
1023: --
1024: l_datetrack_mode := hr_api.g_correction;
1025: --
1026: end if;
1027: --
1028: hr_utility.set_location(l_proc,40);

Line 1159: raise hr_api.validate_enabled;

1155: --
1156: -- When in validation only mode raise the Validate_Enabled exception
1157: --
1158: if p_validate then
1159: raise hr_api.validate_enabled;
1160: end if;
1161: --
1162: hr_utility.set_location(' Leaving:'||l_proc, 60);
1163: --

Line 1165: when hr_api.validate_enabled then

1161: --
1162: hr_utility.set_location(' Leaving:'||l_proc, 60);
1163: --
1164: exception
1165: when hr_api.validate_enabled then
1166: --
1167: -- As the Validate_Enabled exception has been raised
1168: -- we must rollback to the savepoint
1169: --

Line 1413: raise hr_api.validate_enabled;

1409: --
1410: -- When in validation only mode raise the Validate_Enabled exception
1411: --
1412: if p_validate then
1413: raise hr_api.validate_enabled;
1414: end if;
1415: --
1416: hr_utility.set_location(' Leaving:'||l_proc, 60);
1417: --

Line 1419: when hr_api.validate_enabled then

1415: --
1416: hr_utility.set_location(' Leaving:'||l_proc, 60);
1417: --
1418: exception
1419: when hr_api.validate_enabled then
1420: --
1421: -- As the Validate_Enabled exception has been raised
1422: -- we must rollback to the savepoint
1423: --

Line 1557: l_transaction_id hr_api_transactions.transaction_id%TYPE;

1553: ,P_OFFER_ID IN number
1554: ) Is
1555: --
1556: l_proc varchar2(72) := g_package||'close_notifications';
1557: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1558: l_item_type hr_api_transactions.item_type%TYPE;
1559: l_item_key hr_api_transactions.item_key%TYPE;
1560: --
1561: cursor csr_get_txn_details is

Line 1558: l_item_type hr_api_transactions.item_type%TYPE;

1554: ) Is
1555: --
1556: l_proc varchar2(72) := g_package||'close_notifications';
1557: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1558: l_item_type hr_api_transactions.item_type%TYPE;
1559: l_item_key hr_api_transactions.item_key%TYPE;
1560: --
1561: cursor csr_get_txn_details is
1562: select transaction_id

Line 1559: l_item_key hr_api_transactions.item_key%TYPE;

1555: --
1556: l_proc varchar2(72) := g_package||'close_notifications';
1557: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1558: l_item_type hr_api_transactions.item_type%TYPE;
1559: l_item_key hr_api_transactions.item_key%TYPE;
1560: --
1561: cursor csr_get_txn_details is
1562: select transaction_id
1563: ,item_type

Line 1565: from hr_api_transactions

1561: cursor csr_get_txn_details is
1562: select transaction_id
1563: ,item_type
1564: ,item_key
1565: from hr_api_transactions
1566: where transaction_ref_table='IRC_OFFERS'
1567: and transaction_ref_id = p_offer_id;
1568: --
1569: cursor csr_get_sfl_txn_details is

Line 1573: from hr_api_transactions hat,

1569: cursor csr_get_sfl_txn_details is
1570: select hat.transaction_id
1571: ,wn.MESSAGE_TYPE
1572: ,wn.item_key
1573: from hr_api_transactions hat,
1574: wf_notifications wn
1575: where hat.transaction_ref_table='IRC_OFFERS'
1576: and hat.STATUS='S'
1577: and wn.MESSAGE_TYPE='HRSFL'

Line 1884: when hr_api.cannot_find_prog_unit then

1880: , P_ATTRIBUTE29 => P_ATTRIBUTE29
1881: , P_ATTRIBUTE30 => P_ATTRIBUTE30
1882: );
1883: exception
1884: when hr_api.cannot_find_prog_unit then
1885: hr_api.cannot_find_prog_unit_error
1886: (p_module_name => 'create_offer'
1887: ,p_hook_type => 'BP'
1888: );

Line 1885: hr_api.cannot_find_prog_unit_error

1881: , P_ATTRIBUTE30 => P_ATTRIBUTE30
1882: );
1883: exception
1884: when hr_api.cannot_find_prog_unit then
1885: hr_api.cannot_find_prog_unit_error
1886: (p_module_name => 'create_offer'
1887: ,p_hook_type => 'BP'
1888: );
1889: end;

Line 2026: when hr_api.cannot_find_prog_unit then

2022: , P_OFFER_VERSION => l_offer_version
2023: , P_OBJECT_VERSION_NUMBER => l_object_version_number
2024: );
2025: exception
2026: when hr_api.cannot_find_prog_unit then
2027: hr_api.cannot_find_prog_unit_error
2028: (p_module_name => 'create_offer'
2029: ,p_hook_type => 'AP'
2030: );

Line 2027: hr_api.cannot_find_prog_unit_error

2023: , P_OBJECT_VERSION_NUMBER => l_object_version_number
2024: );
2025: exception
2026: when hr_api.cannot_find_prog_unit then
2027: hr_api.cannot_find_prog_unit_error
2028: (p_module_name => 'create_offer'
2029: ,p_hook_type => 'AP'
2030: );
2031: end;

Line 2036: raise hr_api.validate_enabled;

2032: --
2033: -- When in validation only mode raise the Validate_Enabled exception
2034: --
2035: if p_validate then
2036: raise hr_api.validate_enabled;
2037: end if;
2038: --
2039: -- Set all IN OUT and OUT parameters with out values
2040: --

Line 2047: when hr_api.validate_enabled then

2043: p_offer_version := l_offer_version;
2044: --
2045: hr_utility.set_location(' Leaving:'||l_proc, 70);
2046: exception
2047: when hr_api.validate_enabled then
2048: --
2049: -- As the Validate_Enabled exception has been raised
2050: -- we must rollback to the savepoint
2051: --

Line 2087: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2

2083: --
2084: procedure update_offer
2085: ( P_VALIDATE IN boolean default false
2086: ,P_EFFECTIVE_DATE IN date default null
2087: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
2088: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
2089: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date

Line 2088: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2

2084: procedure update_offer
2085: ( P_VALIDATE IN boolean default false
2086: ,P_EFFECTIVE_DATE IN date default null
2087: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
2088: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
2089: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date

Line 2089: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2

2085: ( P_VALIDATE IN boolean default false
2086: ,P_EFFECTIVE_DATE IN date default null
2087: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
2088: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
2089: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2

Line 2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number

2086: ,P_EFFECTIVE_DATE IN date default null
2087: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
2088: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
2089: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2

Line 2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date

2087: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
2088: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
2089: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date

Line 2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date

2088: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
2089: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

Line 2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2

2089: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

Line 2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2

2090: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number

Line 2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date

2091: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number

Line 2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

2092: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2

Line 2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

2093: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2

Line 2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number

2094: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number

2095: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

Line 2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2

2096: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

Line 2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2

2097: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

Line 2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

2098: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

Line 2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

2099: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

Line 2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

2100: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

Line 2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

2101: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

Line 2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

2102: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

Line 2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

2103: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2

Line 2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

2104: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

Line 2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

2105: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

Line 2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

2106: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

Line 2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2

2107: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

Line 2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

2108: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

Line 2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

2109: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

Line 2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

2110: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

Line 2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

2111: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

Line 2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

2112: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

Line 2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

2113: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

Line 2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

2114: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

Line 2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

2115: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

Line 2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

2116: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2

Line 2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

2117: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

Line 2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

2118: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

Line 2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

2119: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

Line 2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2

2120: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

Line 2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

2121: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

Line 2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

2122: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2130: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

Line 2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

2123: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2130: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2131: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

Line 2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

2124: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2130: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2131: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2132: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

Line 2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

2125: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2130: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2131: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2132: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
2133: ,P_CHANGE_REASON IN VARCHAR2 default null

Line 2130: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

2126: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2130: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2131: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2132: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
2133: ,P_CHANGE_REASON IN VARCHAR2 default null
2134: ,P_DECLINE_REASON IN VARCHAR2 default null

Line 2131: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

2127: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2130: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2131: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2132: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
2133: ,P_CHANGE_REASON IN VARCHAR2 default null
2134: ,P_DECLINE_REASON IN VARCHAR2 default null
2135: ,P_NOTE_TEXT IN VARCHAR2 default null

Line 2132: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

2128: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2129: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2130: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2131: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2132: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
2133: ,P_CHANGE_REASON IN VARCHAR2 default null
2134: ,P_DECLINE_REASON IN VARCHAR2 default null
2135: ,P_NOTE_TEXT IN VARCHAR2 default null
2136: ,P_STATUS_CHANGE_DATE IN DATE default null

Line 2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;

2151: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2152: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2153: l_prev_offer_status irc_offers.offer_status%TYPE;
2154: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2155: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2156: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2157: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2158: l_mutiple_fields_updated boolean;
2159: l_offer_version irc_offers.offer_version%TYPE;

Line 2316: if l_offer_status = hr_api.g_varchar2

2312: --
2313: end if;
2314: close csr_prev_offer_details;
2315: --
2316: if l_offer_status = hr_api.g_varchar2
2317: then
2318: --
2319: l_offer_status := l_prev_offer_status;
2320: --

Line 2387: if (( nvl(l_expiry_date,hr_api.g_date) <> nvl(l_prev_expiry_date,hr_api.g_date))

2383: -- 1) The offer duration has been Extended
2384: --
2385: -- Under all other circumstances, a new offer version should be created.
2386: --
2387: if (( nvl(l_expiry_date,hr_api.g_date) <> nvl(l_prev_expiry_date,hr_api.g_date))
2388: )
2389: then
2390: --
2391: irc_iof_bus.chk_multiple_fields_updated

Line 2563: if ( l_temp_offer_record.discretionary_job_title = hr_api.g_varchar2) then

2559: --
2560: -- Check if any of the variables have system default values,
2561: -- if so, set them to their previous values.
2562: --
2563: if ( l_temp_offer_record.discretionary_job_title = hr_api.g_varchar2) then
2564: l_temp_offer_record.discretionary_job_title := l_offer_record.discretionary_job_title;
2565: end if;
2566: if ( l_temp_offer_record.offer_extended_method = hr_api.g_varchar2) then
2567: l_temp_offer_record.offer_extended_method := l_offer_record.offer_extended_method;

Line 2566: if ( l_temp_offer_record.offer_extended_method = hr_api.g_varchar2) then

2562: --
2563: if ( l_temp_offer_record.discretionary_job_title = hr_api.g_varchar2) then
2564: l_temp_offer_record.discretionary_job_title := l_offer_record.discretionary_job_title;
2565: end if;
2566: if ( l_temp_offer_record.offer_extended_method = hr_api.g_varchar2) then
2567: l_temp_offer_record.offer_extended_method := l_offer_record.offer_extended_method;
2568: end if;
2569: if ( l_temp_offer_record.respondent_id = hr_api.g_number) then
2570: l_temp_offer_record.respondent_id := l_offer_record.respondent_id;

Line 2569: if ( l_temp_offer_record.respondent_id = hr_api.g_number) then

2565: end if;
2566: if ( l_temp_offer_record.offer_extended_method = hr_api.g_varchar2) then
2567: l_temp_offer_record.offer_extended_method := l_offer_record.offer_extended_method;
2568: end if;
2569: if ( l_temp_offer_record.respondent_id = hr_api.g_number) then
2570: l_temp_offer_record.respondent_id := l_offer_record.respondent_id;
2571: end if;
2572: if ( l_temp_offer_record.expiry_date = hr_api.g_date) then
2573: l_temp_offer_record.expiry_date := l_offer_record.expiry_date;

Line 2572: if ( l_temp_offer_record.expiry_date = hr_api.g_date) then

2568: end if;
2569: if ( l_temp_offer_record.respondent_id = hr_api.g_number) then
2570: l_temp_offer_record.respondent_id := l_offer_record.respondent_id;
2571: end if;
2572: if ( l_temp_offer_record.expiry_date = hr_api.g_date) then
2573: l_temp_offer_record.expiry_date := l_offer_record.expiry_date;
2574: end if;
2575: if ( l_temp_offer_record.proposed_start_date = hr_api.g_date) then
2576: l_temp_offer_record.proposed_start_date := l_offer_record.proposed_start_date;

Line 2575: if ( l_temp_offer_record.proposed_start_date = hr_api.g_date) then

2571: end if;
2572: if ( l_temp_offer_record.expiry_date = hr_api.g_date) then
2573: l_temp_offer_record.expiry_date := l_offer_record.expiry_date;
2574: end if;
2575: if ( l_temp_offer_record.proposed_start_date = hr_api.g_date) then
2576: l_temp_offer_record.proposed_start_date := l_offer_record.proposed_start_date;
2577: end if;
2578: if ( l_temp_offer_record.offer_letter_tracking_code = hr_api.g_varchar2) then
2579: l_temp_offer_record.offer_letter_tracking_code := l_offer_record.offer_letter_tracking_code;

Line 2578: if ( l_temp_offer_record.offer_letter_tracking_code = hr_api.g_varchar2) then

2574: end if;
2575: if ( l_temp_offer_record.proposed_start_date = hr_api.g_date) then
2576: l_temp_offer_record.proposed_start_date := l_offer_record.proposed_start_date;
2577: end if;
2578: if ( l_temp_offer_record.offer_letter_tracking_code = hr_api.g_varchar2) then
2579: l_temp_offer_record.offer_letter_tracking_code := l_offer_record.offer_letter_tracking_code;
2580: end if;
2581: if ( l_temp_offer_record.offer_postal_service = hr_api.g_varchar2) then
2582: l_temp_offer_record.offer_postal_service := l_offer_record.offer_postal_service;

Line 2581: if ( l_temp_offer_record.offer_postal_service = hr_api.g_varchar2) then

2577: end if;
2578: if ( l_temp_offer_record.offer_letter_tracking_code = hr_api.g_varchar2) then
2579: l_temp_offer_record.offer_letter_tracking_code := l_offer_record.offer_letter_tracking_code;
2580: end if;
2581: if ( l_temp_offer_record.offer_postal_service = hr_api.g_varchar2) then
2582: l_temp_offer_record.offer_postal_service := l_offer_record.offer_postal_service;
2583: end if;
2584: if ( l_temp_offer_record.offer_shipping_date = hr_api.g_date) then
2585: l_temp_offer_record.offer_shipping_date := l_offer_record.offer_shipping_date;

Line 2584: if ( l_temp_offer_record.offer_shipping_date = hr_api.g_date) then

2580: end if;
2581: if ( l_temp_offer_record.offer_postal_service = hr_api.g_varchar2) then
2582: l_temp_offer_record.offer_postal_service := l_offer_record.offer_postal_service;
2583: end if;
2584: if ( l_temp_offer_record.offer_shipping_date = hr_api.g_date) then
2585: l_temp_offer_record.offer_shipping_date := l_offer_record.offer_shipping_date;
2586: end if;
2587: if ( l_temp_offer_record.applicant_assignment_id = hr_api.g_number) then
2588: l_temp_offer_record.applicant_assignment_id := l_offer_record.applicant_assignment_id;

Line 2587: if ( l_temp_offer_record.applicant_assignment_id = hr_api.g_number) then

2583: end if;
2584: if ( l_temp_offer_record.offer_shipping_date = hr_api.g_date) then
2585: l_temp_offer_record.offer_shipping_date := l_offer_record.offer_shipping_date;
2586: end if;
2587: if ( l_temp_offer_record.applicant_assignment_id = hr_api.g_number) then
2588: l_temp_offer_record.applicant_assignment_id := l_offer_record.applicant_assignment_id;
2589: end if;
2590: if ( l_temp_offer_record.offer_assignment_id = hr_api.g_number) then
2591: l_temp_offer_record.offer_assignment_id := l_offer_record.offer_assignment_id;

Line 2590: if ( l_temp_offer_record.offer_assignment_id = hr_api.g_number) then

2586: end if;
2587: if ( l_temp_offer_record.applicant_assignment_id = hr_api.g_number) then
2588: l_temp_offer_record.applicant_assignment_id := l_offer_record.applicant_assignment_id;
2589: end if;
2590: if ( l_temp_offer_record.offer_assignment_id = hr_api.g_number) then
2591: l_temp_offer_record.offer_assignment_id := l_offer_record.offer_assignment_id;
2592: end if;
2593: if ( l_temp_offer_record.address_id = hr_api.g_number) then
2594: l_temp_offer_record.address_id := l_offer_record.address_id;

Line 2593: if ( l_temp_offer_record.address_id = hr_api.g_number) then

2589: end if;
2590: if ( l_temp_offer_record.offer_assignment_id = hr_api.g_number) then
2591: l_temp_offer_record.offer_assignment_id := l_offer_record.offer_assignment_id;
2592: end if;
2593: if ( l_temp_offer_record.address_id = hr_api.g_number) then
2594: l_temp_offer_record.address_id := l_offer_record.address_id;
2595: end if;
2596: if ( l_temp_offer_record.template_id = hr_api.g_number) then
2597: l_temp_offer_record.template_id := l_offer_record.template_id;

Line 2596: if ( l_temp_offer_record.template_id = hr_api.g_number) then

2592: end if;
2593: if ( l_temp_offer_record.address_id = hr_api.g_number) then
2594: l_temp_offer_record.address_id := l_offer_record.address_id;
2595: end if;
2596: if ( l_temp_offer_record.template_id = hr_api.g_number) then
2597: l_temp_offer_record.template_id := l_offer_record.template_id;
2598: end if;
2599: if ( l_temp_offer_record.offer_letter_file_type = hr_api.g_varchar2) then
2600: l_temp_offer_record.offer_letter_file_type := l_offer_record.offer_letter_file_type;

Line 2599: if ( l_temp_offer_record.offer_letter_file_type = hr_api.g_varchar2) then

2595: end if;
2596: if ( l_temp_offer_record.template_id = hr_api.g_number) then
2597: l_temp_offer_record.template_id := l_offer_record.template_id;
2598: end if;
2599: if ( l_temp_offer_record.offer_letter_file_type = hr_api.g_varchar2) then
2600: l_temp_offer_record.offer_letter_file_type := l_offer_record.offer_letter_file_type;
2601: end if;
2602: if ( l_temp_offer_record.offer_letter_file_name = hr_api.g_varchar2) then
2603: l_temp_offer_record.offer_letter_file_name := l_offer_record.offer_letter_file_name;

Line 2602: if ( l_temp_offer_record.offer_letter_file_name = hr_api.g_varchar2) then

2598: end if;
2599: if ( l_temp_offer_record.offer_letter_file_type = hr_api.g_varchar2) then
2600: l_temp_offer_record.offer_letter_file_type := l_offer_record.offer_letter_file_type;
2601: end if;
2602: if ( l_temp_offer_record.offer_letter_file_name = hr_api.g_varchar2) then
2603: l_temp_offer_record.offer_letter_file_name := l_offer_record.offer_letter_file_name;
2604: end if;
2605: if ( l_temp_offer_record.attribute_category = hr_api.g_varchar2) then
2606: l_temp_offer_record.attribute_category := l_offer_record.attribute_category;

Line 2605: if ( l_temp_offer_record.attribute_category = hr_api.g_varchar2) then

2601: end if;
2602: if ( l_temp_offer_record.offer_letter_file_name = hr_api.g_varchar2) then
2603: l_temp_offer_record.offer_letter_file_name := l_offer_record.offer_letter_file_name;
2604: end if;
2605: if ( l_temp_offer_record.attribute_category = hr_api.g_varchar2) then
2606: l_temp_offer_record.attribute_category := l_offer_record.attribute_category;
2607: end if;
2608: if ( l_temp_offer_record.attribute1 = hr_api.g_varchar2) then
2609: l_temp_offer_record.attribute1 := l_offer_record.attribute1;

Line 2608: if ( l_temp_offer_record.attribute1 = hr_api.g_varchar2) then

2604: end if;
2605: if ( l_temp_offer_record.attribute_category = hr_api.g_varchar2) then
2606: l_temp_offer_record.attribute_category := l_offer_record.attribute_category;
2607: end if;
2608: if ( l_temp_offer_record.attribute1 = hr_api.g_varchar2) then
2609: l_temp_offer_record.attribute1 := l_offer_record.attribute1;
2610: end if;
2611: if ( l_temp_offer_record.attribute2 = hr_api.g_varchar2) then
2612: l_temp_offer_record.attribute2 := l_offer_record.attribute2;

Line 2611: if ( l_temp_offer_record.attribute2 = hr_api.g_varchar2) then

2607: end if;
2608: if ( l_temp_offer_record.attribute1 = hr_api.g_varchar2) then
2609: l_temp_offer_record.attribute1 := l_offer_record.attribute1;
2610: end if;
2611: if ( l_temp_offer_record.attribute2 = hr_api.g_varchar2) then
2612: l_temp_offer_record.attribute2 := l_offer_record.attribute2;
2613: end if;
2614: if ( l_temp_offer_record.attribute3 = hr_api.g_varchar2) then
2615: l_temp_offer_record.attribute3 := l_offer_record.attribute3;

Line 2614: if ( l_temp_offer_record.attribute3 = hr_api.g_varchar2) then

2610: end if;
2611: if ( l_temp_offer_record.attribute2 = hr_api.g_varchar2) then
2612: l_temp_offer_record.attribute2 := l_offer_record.attribute2;
2613: end if;
2614: if ( l_temp_offer_record.attribute3 = hr_api.g_varchar2) then
2615: l_temp_offer_record.attribute3 := l_offer_record.attribute3;
2616: end if;
2617: if ( l_temp_offer_record.attribute4 = hr_api.g_varchar2) then
2618: l_temp_offer_record.attribute4 := l_offer_record.attribute4;

Line 2617: if ( l_temp_offer_record.attribute4 = hr_api.g_varchar2) then

2613: end if;
2614: if ( l_temp_offer_record.attribute3 = hr_api.g_varchar2) then
2615: l_temp_offer_record.attribute3 := l_offer_record.attribute3;
2616: end if;
2617: if ( l_temp_offer_record.attribute4 = hr_api.g_varchar2) then
2618: l_temp_offer_record.attribute4 := l_offer_record.attribute4;
2619: end if;
2620: if ( l_temp_offer_record.attribute5 = hr_api.g_varchar2) then
2621: l_temp_offer_record.attribute5 := l_offer_record.attribute5;

Line 2620: if ( l_temp_offer_record.attribute5 = hr_api.g_varchar2) then

2616: end if;
2617: if ( l_temp_offer_record.attribute4 = hr_api.g_varchar2) then
2618: l_temp_offer_record.attribute4 := l_offer_record.attribute4;
2619: end if;
2620: if ( l_temp_offer_record.attribute5 = hr_api.g_varchar2) then
2621: l_temp_offer_record.attribute5 := l_offer_record.attribute5;
2622: end if;
2623: if ( l_temp_offer_record.attribute6 = hr_api.g_varchar2) then
2624: l_temp_offer_record.attribute6 := l_offer_record.attribute6;

Line 2623: if ( l_temp_offer_record.attribute6 = hr_api.g_varchar2) then

2619: end if;
2620: if ( l_temp_offer_record.attribute5 = hr_api.g_varchar2) then
2621: l_temp_offer_record.attribute5 := l_offer_record.attribute5;
2622: end if;
2623: if ( l_temp_offer_record.attribute6 = hr_api.g_varchar2) then
2624: l_temp_offer_record.attribute6 := l_offer_record.attribute6;
2625: end if;
2626: if ( l_temp_offer_record.attribute7 = hr_api.g_varchar2) then
2627: l_temp_offer_record.attribute7 := l_offer_record.attribute7;

Line 2626: if ( l_temp_offer_record.attribute7 = hr_api.g_varchar2) then

2622: end if;
2623: if ( l_temp_offer_record.attribute6 = hr_api.g_varchar2) then
2624: l_temp_offer_record.attribute6 := l_offer_record.attribute6;
2625: end if;
2626: if ( l_temp_offer_record.attribute7 = hr_api.g_varchar2) then
2627: l_temp_offer_record.attribute7 := l_offer_record.attribute7;
2628: end if;
2629: if ( l_temp_offer_record.attribute8 = hr_api.g_varchar2) then
2630: l_temp_offer_record.attribute8 := l_offer_record.attribute8;

Line 2629: if ( l_temp_offer_record.attribute8 = hr_api.g_varchar2) then

2625: end if;
2626: if ( l_temp_offer_record.attribute7 = hr_api.g_varchar2) then
2627: l_temp_offer_record.attribute7 := l_offer_record.attribute7;
2628: end if;
2629: if ( l_temp_offer_record.attribute8 = hr_api.g_varchar2) then
2630: l_temp_offer_record.attribute8 := l_offer_record.attribute8;
2631: end if;
2632: if ( l_temp_offer_record.attribute9 = hr_api.g_varchar2) then
2633: l_temp_offer_record.attribute9 := l_offer_record.attribute9;

Line 2632: if ( l_temp_offer_record.attribute9 = hr_api.g_varchar2) then

2628: end if;
2629: if ( l_temp_offer_record.attribute8 = hr_api.g_varchar2) then
2630: l_temp_offer_record.attribute8 := l_offer_record.attribute8;
2631: end if;
2632: if ( l_temp_offer_record.attribute9 = hr_api.g_varchar2) then
2633: l_temp_offer_record.attribute9 := l_offer_record.attribute9;
2634: end if;
2635: if ( l_temp_offer_record.attribute10 = hr_api.g_varchar2) then
2636: l_temp_offer_record.attribute10 := l_offer_record.attribute10;

Line 2635: if ( l_temp_offer_record.attribute10 = hr_api.g_varchar2) then

2631: end if;
2632: if ( l_temp_offer_record.attribute9 = hr_api.g_varchar2) then
2633: l_temp_offer_record.attribute9 := l_offer_record.attribute9;
2634: end if;
2635: if ( l_temp_offer_record.attribute10 = hr_api.g_varchar2) then
2636: l_temp_offer_record.attribute10 := l_offer_record.attribute10;
2637: end if;
2638: if ( l_temp_offer_record.attribute11 = hr_api.g_varchar2) then
2639: l_temp_offer_record.attribute11 := l_offer_record.attribute11;

Line 2638: if ( l_temp_offer_record.attribute11 = hr_api.g_varchar2) then

2634: end if;
2635: if ( l_temp_offer_record.attribute10 = hr_api.g_varchar2) then
2636: l_temp_offer_record.attribute10 := l_offer_record.attribute10;
2637: end if;
2638: if ( l_temp_offer_record.attribute11 = hr_api.g_varchar2) then
2639: l_temp_offer_record.attribute11 := l_offer_record.attribute11;
2640: end if;
2641: if ( l_temp_offer_record.attribute12 = hr_api.g_varchar2) then
2642: l_temp_offer_record.attribute12 := l_offer_record.attribute12;

Line 2641: if ( l_temp_offer_record.attribute12 = hr_api.g_varchar2) then

2637: end if;
2638: if ( l_temp_offer_record.attribute11 = hr_api.g_varchar2) then
2639: l_temp_offer_record.attribute11 := l_offer_record.attribute11;
2640: end if;
2641: if ( l_temp_offer_record.attribute12 = hr_api.g_varchar2) then
2642: l_temp_offer_record.attribute12 := l_offer_record.attribute12;
2643: end if;
2644: if ( l_temp_offer_record.attribute13 = hr_api.g_varchar2) then
2645: l_temp_offer_record.attribute13 := l_offer_record.attribute13;

Line 2644: if ( l_temp_offer_record.attribute13 = hr_api.g_varchar2) then

2640: end if;
2641: if ( l_temp_offer_record.attribute12 = hr_api.g_varchar2) then
2642: l_temp_offer_record.attribute12 := l_offer_record.attribute12;
2643: end if;
2644: if ( l_temp_offer_record.attribute13 = hr_api.g_varchar2) then
2645: l_temp_offer_record.attribute13 := l_offer_record.attribute13;
2646: end if;
2647: if ( l_temp_offer_record.attribute14 = hr_api.g_varchar2) then
2648: l_temp_offer_record.attribute14 := l_offer_record.attribute14;

Line 2647: if ( l_temp_offer_record.attribute14 = hr_api.g_varchar2) then

2643: end if;
2644: if ( l_temp_offer_record.attribute13 = hr_api.g_varchar2) then
2645: l_temp_offer_record.attribute13 := l_offer_record.attribute13;
2646: end if;
2647: if ( l_temp_offer_record.attribute14 = hr_api.g_varchar2) then
2648: l_temp_offer_record.attribute14 := l_offer_record.attribute14;
2649: end if;
2650: if ( l_temp_offer_record.attribute15 = hr_api.g_varchar2) then
2651: l_temp_offer_record.attribute15 := l_offer_record.attribute15;

Line 2650: if ( l_temp_offer_record.attribute15 = hr_api.g_varchar2) then

2646: end if;
2647: if ( l_temp_offer_record.attribute14 = hr_api.g_varchar2) then
2648: l_temp_offer_record.attribute14 := l_offer_record.attribute14;
2649: end if;
2650: if ( l_temp_offer_record.attribute15 = hr_api.g_varchar2) then
2651: l_temp_offer_record.attribute15 := l_offer_record.attribute15;
2652: end if;
2653: if ( l_temp_offer_record.attribute16 = hr_api.g_varchar2) then
2654: l_temp_offer_record.attribute16 := l_offer_record.attribute16;

Line 2653: if ( l_temp_offer_record.attribute16 = hr_api.g_varchar2) then

2649: end if;
2650: if ( l_temp_offer_record.attribute15 = hr_api.g_varchar2) then
2651: l_temp_offer_record.attribute15 := l_offer_record.attribute15;
2652: end if;
2653: if ( l_temp_offer_record.attribute16 = hr_api.g_varchar2) then
2654: l_temp_offer_record.attribute16 := l_offer_record.attribute16;
2655: end if;
2656: if ( l_temp_offer_record.attribute17 = hr_api.g_varchar2) then
2657: l_temp_offer_record.attribute17 := l_offer_record.attribute17;

Line 2656: if ( l_temp_offer_record.attribute17 = hr_api.g_varchar2) then

2652: end if;
2653: if ( l_temp_offer_record.attribute16 = hr_api.g_varchar2) then
2654: l_temp_offer_record.attribute16 := l_offer_record.attribute16;
2655: end if;
2656: if ( l_temp_offer_record.attribute17 = hr_api.g_varchar2) then
2657: l_temp_offer_record.attribute17 := l_offer_record.attribute17;
2658: end if;
2659: if ( l_temp_offer_record.attribute18 = hr_api.g_varchar2) then
2660: l_temp_offer_record.attribute18 := l_offer_record.attribute18;

Line 2659: if ( l_temp_offer_record.attribute18 = hr_api.g_varchar2) then

2655: end if;
2656: if ( l_temp_offer_record.attribute17 = hr_api.g_varchar2) then
2657: l_temp_offer_record.attribute17 := l_offer_record.attribute17;
2658: end if;
2659: if ( l_temp_offer_record.attribute18 = hr_api.g_varchar2) then
2660: l_temp_offer_record.attribute18 := l_offer_record.attribute18;
2661: end if;
2662: if ( l_temp_offer_record.attribute19 = hr_api.g_varchar2) then
2663: l_temp_offer_record.attribute19 := l_offer_record.attribute19;

Line 2662: if ( l_temp_offer_record.attribute19 = hr_api.g_varchar2) then

2658: end if;
2659: if ( l_temp_offer_record.attribute18 = hr_api.g_varchar2) then
2660: l_temp_offer_record.attribute18 := l_offer_record.attribute18;
2661: end if;
2662: if ( l_temp_offer_record.attribute19 = hr_api.g_varchar2) then
2663: l_temp_offer_record.attribute19 := l_offer_record.attribute19;
2664: end if;
2665: if ( l_temp_offer_record.attribute20 = hr_api.g_varchar2) then
2666: l_temp_offer_record.attribute20 := l_offer_record.attribute20;

Line 2665: if ( l_temp_offer_record.attribute20 = hr_api.g_varchar2) then

2661: end if;
2662: if ( l_temp_offer_record.attribute19 = hr_api.g_varchar2) then
2663: l_temp_offer_record.attribute19 := l_offer_record.attribute19;
2664: end if;
2665: if ( l_temp_offer_record.attribute20 = hr_api.g_varchar2) then
2666: l_temp_offer_record.attribute20 := l_offer_record.attribute20;
2667: end if;
2668: if ( l_temp_offer_record.attribute21 = hr_api.g_varchar2) then
2669: l_temp_offer_record.attribute21 := l_offer_record.attribute21;

Line 2668: if ( l_temp_offer_record.attribute21 = hr_api.g_varchar2) then

2664: end if;
2665: if ( l_temp_offer_record.attribute20 = hr_api.g_varchar2) then
2666: l_temp_offer_record.attribute20 := l_offer_record.attribute20;
2667: end if;
2668: if ( l_temp_offer_record.attribute21 = hr_api.g_varchar2) then
2669: l_temp_offer_record.attribute21 := l_offer_record.attribute21;
2670: end if;
2671: if ( l_temp_offer_record.attribute22 = hr_api.g_varchar2) then
2672: l_temp_offer_record.attribute22 := l_offer_record.attribute22;

Line 2671: if ( l_temp_offer_record.attribute22 = hr_api.g_varchar2) then

2667: end if;
2668: if ( l_temp_offer_record.attribute21 = hr_api.g_varchar2) then
2669: l_temp_offer_record.attribute21 := l_offer_record.attribute21;
2670: end if;
2671: if ( l_temp_offer_record.attribute22 = hr_api.g_varchar2) then
2672: l_temp_offer_record.attribute22 := l_offer_record.attribute22;
2673: end if;
2674: if ( l_temp_offer_record.attribute23 = hr_api.g_varchar2) then
2675: l_temp_offer_record.attribute23 := l_offer_record.attribute23;

Line 2674: if ( l_temp_offer_record.attribute23 = hr_api.g_varchar2) then

2670: end if;
2671: if ( l_temp_offer_record.attribute22 = hr_api.g_varchar2) then
2672: l_temp_offer_record.attribute22 := l_offer_record.attribute22;
2673: end if;
2674: if ( l_temp_offer_record.attribute23 = hr_api.g_varchar2) then
2675: l_temp_offer_record.attribute23 := l_offer_record.attribute23;
2676: end if;
2677: if ( l_temp_offer_record.attribute24 = hr_api.g_varchar2) then
2678: l_temp_offer_record.attribute24 := l_offer_record.attribute24;

Line 2677: if ( l_temp_offer_record.attribute24 = hr_api.g_varchar2) then

2673: end if;
2674: if ( l_temp_offer_record.attribute23 = hr_api.g_varchar2) then
2675: l_temp_offer_record.attribute23 := l_offer_record.attribute23;
2676: end if;
2677: if ( l_temp_offer_record.attribute24 = hr_api.g_varchar2) then
2678: l_temp_offer_record.attribute24 := l_offer_record.attribute24;
2679: end if;
2680: if ( l_temp_offer_record.attribute25 = hr_api.g_varchar2) then
2681: l_temp_offer_record.attribute25 := l_offer_record.attribute25;

Line 2680: if ( l_temp_offer_record.attribute25 = hr_api.g_varchar2) then

2676: end if;
2677: if ( l_temp_offer_record.attribute24 = hr_api.g_varchar2) then
2678: l_temp_offer_record.attribute24 := l_offer_record.attribute24;
2679: end if;
2680: if ( l_temp_offer_record.attribute25 = hr_api.g_varchar2) then
2681: l_temp_offer_record.attribute25 := l_offer_record.attribute25;
2682: end if;
2683: if ( l_temp_offer_record.attribute26 = hr_api.g_varchar2) then
2684: l_temp_offer_record.attribute26 := l_offer_record.attribute26;

Line 2683: if ( l_temp_offer_record.attribute26 = hr_api.g_varchar2) then

2679: end if;
2680: if ( l_temp_offer_record.attribute25 = hr_api.g_varchar2) then
2681: l_temp_offer_record.attribute25 := l_offer_record.attribute25;
2682: end if;
2683: if ( l_temp_offer_record.attribute26 = hr_api.g_varchar2) then
2684: l_temp_offer_record.attribute26 := l_offer_record.attribute26;
2685: end if;
2686: if ( l_temp_offer_record.attribute27 = hr_api.g_varchar2) then
2687: l_temp_offer_record.attribute27 := l_offer_record.attribute27;

Line 2686: if ( l_temp_offer_record.attribute27 = hr_api.g_varchar2) then

2682: end if;
2683: if ( l_temp_offer_record.attribute26 = hr_api.g_varchar2) then
2684: l_temp_offer_record.attribute26 := l_offer_record.attribute26;
2685: end if;
2686: if ( l_temp_offer_record.attribute27 = hr_api.g_varchar2) then
2687: l_temp_offer_record.attribute27 := l_offer_record.attribute27;
2688: end if;
2689: if ( l_temp_offer_record.attribute28 = hr_api.g_varchar2) then
2690: l_temp_offer_record.attribute28 := l_offer_record.attribute28;

Line 2689: if ( l_temp_offer_record.attribute28 = hr_api.g_varchar2) then

2685: end if;
2686: if ( l_temp_offer_record.attribute27 = hr_api.g_varchar2) then
2687: l_temp_offer_record.attribute27 := l_offer_record.attribute27;
2688: end if;
2689: if ( l_temp_offer_record.attribute28 = hr_api.g_varchar2) then
2690: l_temp_offer_record.attribute28 := l_offer_record.attribute28;
2691: end if;
2692: if ( l_temp_offer_record.attribute29 = hr_api.g_varchar2) then
2693: l_temp_offer_record.attribute29 := l_offer_record.attribute29;

Line 2692: if ( l_temp_offer_record.attribute29 = hr_api.g_varchar2) then

2688: end if;
2689: if ( l_temp_offer_record.attribute28 = hr_api.g_varchar2) then
2690: l_temp_offer_record.attribute28 := l_offer_record.attribute28;
2691: end if;
2692: if ( l_temp_offer_record.attribute29 = hr_api.g_varchar2) then
2693: l_temp_offer_record.attribute29 := l_offer_record.attribute29;
2694: end if;
2695: if ( l_temp_offer_record.attribute30 = hr_api.g_varchar2) then
2696: l_temp_offer_record.attribute30 := l_offer_record.attribute30;

Line 2695: if ( l_temp_offer_record.attribute30 = hr_api.g_varchar2) then

2691: end if;
2692: if ( l_temp_offer_record.attribute29 = hr_api.g_varchar2) then
2693: l_temp_offer_record.attribute29 := l_offer_record.attribute29;
2694: end if;
2695: if ( l_temp_offer_record.attribute30 = hr_api.g_varchar2) then
2696: l_temp_offer_record.attribute30 := l_offer_record.attribute30;
2697: end if;
2698: --
2699: -- Create a new offer assignment copied from prev offer assignment.

Line 2827: when hr_api.cannot_find_prog_unit then

2823: , P_ATTRIBUTE30 => P_ATTRIBUTE30
2824: , P_OBJECT_VERSION_NUMBER => p_object_version_number
2825: );
2826: exception
2827: when hr_api.cannot_find_prog_unit then
2828: hr_api.cannot_find_prog_unit_error
2829: (p_module_name => 'update_offer'
2830: ,p_hook_type => 'BP'
2831: );

Line 2828: hr_api.cannot_find_prog_unit_error

2824: , P_OBJECT_VERSION_NUMBER => p_object_version_number
2825: );
2826: exception
2827: when hr_api.cannot_find_prog_unit then
2828: hr_api.cannot_find_prog_unit_error
2829: (p_module_name => 'update_offer'
2830: ,p_hook_type => 'BP'
2831: );
2832: end;

Line 3134: (nvl(l_expiry_date,hr_api.g_date) <> nvl(l_prev_expiry_date,hr_api.g_date))

3130: -- 3) The offer status change reason has changed.
3131: --
3132: if (l_offer_status <> l_prev_offer_status) OR
3133: (l_offer_status = 'EXTENDED' AND
3134: (nvl(l_expiry_date,hr_api.g_date) <> nvl(l_prev_expiry_date,hr_api.g_date))
3135: ) OR
3136: (l_prev_offer_change_reason <> p_change_reason)
3137: then
3138: --

Line 3147: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))

3143: if not
3144: (
3145: (
3146: (
3147: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3148: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))
3149: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3150: )
3151: or (

Line 3148: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))

3144: (
3145: (
3146: (
3147: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3148: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))
3149: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3150: )
3151: or (
3152: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))

Line 3149: and p_offer_letter_tracking_code <> hr_api.g_varchar2

3145: (
3146: (
3147: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3148: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))
3149: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3150: )
3151: or (
3152: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3153: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))

Line 3152: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))

3148: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))
3149: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3150: )
3151: or (
3152: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3153: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))
3154: and p_offer_postal_service <> hr_api.g_varchar2
3155: )
3156: or (

Line 3153: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))

3149: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3150: )
3151: or (
3152: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3153: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))
3154: and p_offer_postal_service <> hr_api.g_varchar2
3155: )
3156: or (
3157: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))

Line 3154: and p_offer_postal_service <> hr_api.g_varchar2

3150: )
3151: or (
3152: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3153: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))
3154: and p_offer_postal_service <> hr_api.g_varchar2
3155: )
3156: or (
3157: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3158: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))

Line 3157: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))

3153: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))
3154: and p_offer_postal_service <> hr_api.g_varchar2
3155: )
3156: or (
3157: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3158: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))
3159: and l_offer_shipping_date <> hr_api.g_date
3160: )
3161: )

Line 3158: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))

3154: and p_offer_postal_service <> hr_api.g_varchar2
3155: )
3156: or (
3157: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3158: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))
3159: and l_offer_shipping_date <> hr_api.g_date
3160: )
3161: )
3162: and

Line 3159: and l_offer_shipping_date <> hr_api.g_date

3155: )
3156: or (
3157: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3158: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))
3159: and l_offer_shipping_date <> hr_api.g_date
3160: )
3161: )
3162: and
3163: (l_expiry_date = hr_api.g_date)

Line 3163: (l_expiry_date = hr_api.g_date)

3159: and l_offer_shipping_date <> hr_api.g_date
3160: )
3161: )
3162: and
3163: (l_expiry_date = hr_api.g_date)
3164: )
3165: then
3166: --
3167: hr_utility.set_location(l_proc,140);

Line 3203: if trunc(l_effective_end_date) = hr_api.g_eot then

3199: then
3200: --
3201: hr_utility.set_location(l_proc,142);
3202: --
3203: if trunc(l_effective_end_date) = hr_api.g_eot then
3204: --
3205: hr_utility.set_location('Delete the offer assignment ',143);
3206: per_asg_del.del
3207: (

Line 3216: ,p_datetrack_mode => hr_api.g_delete

3212: ,p_object_version_number => l_asg_object_version_number
3213: ,p_effective_date => l_effective_date
3214: ,p_validation_start_date => l_validation_start_date
3215: ,p_validation_end_date => l_validation_end_date
3216: ,p_datetrack_mode => hr_api.g_delete
3217: ,p_validate => p_validate
3218: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
3219: );
3220: hr_utility.set_location('After deleting the offer assignment ',144);

Line 3343: when hr_api.cannot_find_prog_unit then

3339: , P_ATTRIBUTE30 => P_ATTRIBUTE30
3340: , P_OBJECT_VERSION_NUMBER => p_object_version_number
3341: );
3342: exception
3343: when hr_api.cannot_find_prog_unit then
3344: hr_api.cannot_find_prog_unit_error
3345: (p_module_name => 'update_offer'
3346: ,p_hook_type => 'AP'
3347: );

Line 3344: hr_api.cannot_find_prog_unit_error

3340: , P_OBJECT_VERSION_NUMBER => p_object_version_number
3341: );
3342: exception
3343: when hr_api.cannot_find_prog_unit then
3344: hr_api.cannot_find_prog_unit_error
3345: (p_module_name => 'update_offer'
3346: ,p_hook_type => 'AP'
3347: );
3348: end;

Line 3353: raise hr_api.validate_enabled;

3349: --
3350: -- When in validation only mode raise the Validate_Enabled exception
3351: --
3352: if p_validate then
3353: raise hr_api.validate_enabled;
3354: end if;
3355: --
3356: end if; -- l_create_new_version
3357: --

Line 3369: when hr_api.validate_enabled then

3365: --
3366: hr_utility.set_location(' Leaving:'||l_proc, 145);
3367: --
3368: exception
3369: when hr_api.validate_enabled then
3370: --
3371: -- Reset IN OUT parameters and set OUT parameters
3372: -- (Any key or derived arguments must be set to null
3373: -- when validation only mode is being used.)

Line 3500: when hr_api.cannot_find_prog_unit then

3496: P_OBJECT_VERSION_NUMBER
3497: ,P_OFFER_ID
3498: );
3499: exception
3500: when hr_api.cannot_find_prog_unit then
3501: hr_api.cannot_find_prog_unit_error
3502: (p_module_name => 'delete_offer'
3503: ,p_hook_type => 'BP'
3504: );

Line 3501: hr_api.cannot_find_prog_unit_error

3497: ,P_OFFER_ID
3498: );
3499: exception
3500: when hr_api.cannot_find_prog_unit then
3501: hr_api.cannot_find_prog_unit_error
3502: (p_module_name => 'delete_offer'
3503: ,p_hook_type => 'BP'
3504: );
3505: end;

Line 3555: ,p_datetrack_mode => hr_api.g_zap

3551: ,p_object_version_number => l_asg_object_version_number
3552: ,p_effective_date => l_effective_date
3553: ,p_validation_start_date => l_validation_start_date
3554: ,p_validation_end_date => l_validation_end_date
3555: ,p_datetrack_mode => hr_api.g_zap
3556: ,p_validate => p_validate
3557: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
3558: );
3559: --

Line 3611: when hr_api.cannot_find_prog_unit then

3607: P_OBJECT_VERSION_NUMBER
3608: ,P_OFFER_ID
3609: );
3610: exception
3611: when hr_api.cannot_find_prog_unit then
3612: hr_api.cannot_find_prog_unit_error
3613: (p_module_name => 'delete_offer'
3614: ,p_hook_type => 'AP'
3615: );

Line 3612: hr_api.cannot_find_prog_unit_error

3608: ,P_OFFER_ID
3609: );
3610: exception
3611: when hr_api.cannot_find_prog_unit then
3612: hr_api.cannot_find_prog_unit_error
3613: (p_module_name => 'delete_offer'
3614: ,p_hook_type => 'AP'
3615: );
3616: end;

Line 3621: raise hr_api.validate_enabled;

3617: --
3618: -- When in validation only mode raise the Validate_Enabled exception
3619: --
3620: if p_validate then
3621: raise hr_api.validate_enabled;
3622: end if;
3623: --
3624: -- Set all output arguments
3625: --

Line 3629: when hr_api.validate_enabled then

3625: --
3626: --
3627: hr_utility.set_location(' Leaving:'||l_proc, 50);
3628: exception
3629: when hr_api.validate_enabled then
3630: --
3631: -- As the Validate_Enabled exception has been raised
3632: -- we must rollback to the savepoint
3633: --

Line 3957: raise hr_api.validate_enabled;

3953: --
3954: -- When in validation only mode raise the Validate_Enabled exception
3955: --
3956: if p_validate then
3957: raise hr_api.validate_enabled;
3958: end if;
3959: --
3960: hr_utility.set_location(' Leaving:'||l_proc, 100);
3961: exception

Line 3962: when hr_api.validate_enabled then

3958: end if;
3959: --
3960: hr_utility.set_location(' Leaving:'||l_proc, 100);
3961: exception
3962: when hr_api.validate_enabled then
3963: --
3964: -- As the Validate_Enabled exception has been raised
3965: -- we must rollback to the savepoint
3966: --

Line 3989: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number

3985: procedure hold_offer
3986: ( P_VALIDATE IN boolean default false
3987: ,P_EFFECTIVE_DATE IN date default null
3988: ,P_OFFER_ID IN NUMBER
3989: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
3990: ,P_CHANGE_REASON IN VARCHAR2 default null
3991: ,P_STATUS_CHANGE_DATE IN date default null
3992: ,P_NOTE_TEXT IN VARCHAR2 default null
3993: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER

Line 4032: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number

4028: procedure release_offer
4029: ( P_VALIDATE IN boolean default false
4030: ,P_EFFECTIVE_DATE IN date default null
4031: ,P_OFFER_ID IN NUMBER
4032: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
4033: ,P_CHANGE_REASON IN VARCHAR2 default null
4034: ,P_STATUS_CHANGE_DATE IN date default null
4035: ,P_NOTE_TEXT IN VARCHAR2 default null
4036: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER

Line 4518: raise hr_api.validate_enabled;

4514: --
4515: -- When in validation only mode raise the Validate_Enabled exception
4516: --
4517: if p_validate then
4518: raise hr_api.validate_enabled;
4519: end if;
4520: --
4521: -- Assign all the OUT and IN OUT Variables
4522: --

Line 4536: when hr_api.validate_enabled then

4532: --
4533: hr_utility.set_location(' Leaving:'||l_proc, 60);
4534: --
4535: exception
4536: when hr_api.validate_enabled then
4537: --
4538: p_assignment_id := null;
4539: p_effective_start_date := null;
4540: p_effective_end_date := null;

Line 4580: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number

4576: ,P_EFFECTIVE_START_DATE OUT NOCOPY DATE
4577: ,P_EFFECTIVE_END_DATE OUT NOCOPY DATE
4578: ,P_BUSINESS_GROUP_ID OUT NOCOPY NUMBER
4579:
4580: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4581: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4582: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4583: ,P_JOB_ID IN NUMBER default hr_api.g_number
4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number

Line 4581: ,P_GRADE_ID IN NUMBER default hr_api.g_number

4577: ,P_EFFECTIVE_END_DATE OUT NOCOPY DATE
4578: ,P_BUSINESS_GROUP_ID OUT NOCOPY NUMBER
4579:
4580: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4581: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4582: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4583: ,P_JOB_ID IN NUMBER default hr_api.g_number
4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number

Line 4582: ,P_POSITION_ID IN NUMBER default hr_api.g_number

4578: ,P_BUSINESS_GROUP_ID OUT NOCOPY NUMBER
4579:
4580: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4581: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4582: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4583: ,P_JOB_ID IN NUMBER default hr_api.g_number
4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number

Line 4583: ,P_JOB_ID IN NUMBER default hr_api.g_number

4579:
4580: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4581: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4582: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4583: ,P_JOB_ID IN NUMBER default hr_api.g_number
4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number

Line 4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number

4580: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4581: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4582: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4583: ,P_JOB_ID IN NUMBER default hr_api.g_number
4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number

Line 4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number

4581: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4582: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4583: ,P_JOB_ID IN NUMBER default hr_api.g_number
4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number

Line 4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number

4582: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4583: ,P_JOB_ID IN NUMBER default hr_api.g_number
4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number

Line 4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number

4583: ,P_JOB_ID IN NUMBER default hr_api.g_number
4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number

Line 4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number

4584: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4592:

Line 4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number

4585: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4592:
4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number

Line 4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number

4586: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4592:
4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number

Line 4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number

4587: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4588: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4592:
4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number

Line 4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number

4589: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4592:
4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number

Line 4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number

4590: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4592:
4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2

Line 4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number

4591: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4592:
4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2

Line 4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number

4592:
4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number

Line 4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number

4593: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2

Line 4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2

4594: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4602: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2

Line 4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2

4595: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4602: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4603: ,P_COMMENT_ID OUT NOCOPY NUMBER

Line 4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number

4596: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4602: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4603: ,P_COMMENT_ID OUT NOCOPY NUMBER
4604: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2

Line 4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2

4597: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4602: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4603: ,P_COMMENT_ID OUT NOCOPY NUMBER
4604: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4605: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date

Line 4602: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2

4598: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4599: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4602: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4603: ,P_COMMENT_ID OUT NOCOPY NUMBER
4604: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4605: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4606:

Line 4604: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2

4600: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4602: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4603: ,P_COMMENT_ID OUT NOCOPY NUMBER
4604: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4605: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4606:
4607: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 4605: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date

4601: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4602: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4603: ,P_COMMENT_ID OUT NOCOPY NUMBER
4604: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4605: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4606:
4607: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

Line 4607: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number

4603: ,P_COMMENT_ID OUT NOCOPY NUMBER
4604: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4605: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4606:
4607: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2

Line 4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

4604: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4605: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4606:
4607: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number

Line 4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

4605: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4606:
4607: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number

Line 4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2

4606:
4607: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

Line 4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2

4607: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number

Line 4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number

4608: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number

Line 4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number

4609: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2

Line 4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

4610: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number

Line 4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number

4611: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

Line 4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number

4612: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number

Line 4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2

4613: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4621:

Line 4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number

4614: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4621:
4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2

Line 4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

4615: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4621:
4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2

Line 4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number

4616: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4617: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4621:
4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2

Line 4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2

4618: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4621:
4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2

Line 4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2

4619: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4621:
4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2

Line 4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2

4620: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4621:
4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number

Line 4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2

4621:
4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number

Line 4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2

4622: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number

Line 4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2

4623: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date

Line 4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number

4624: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number

4625: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

Line 4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number

4626: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

Line 4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date

4627: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

Line 4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

4628: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

Line 4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

4629: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

Line 4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

4630: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4638:

Line 4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

4631: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4638:
4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

Line 4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

4632: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4638:
4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

Line 4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

4633: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4634: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4638:
4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

Line 4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

4635: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4638:
4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

Line 4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

4636: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4638:
4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

Line 4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

4637: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4638:
4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

Line 4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2

4638:
4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

Line 4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

4639: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

Line 4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

4640: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

Line 4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

4641: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

Line 4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

4642: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

Line 4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

4643: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

Line 4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

4644: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4652:

Line 4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

4645: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4652:
4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

Line 4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

4646: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4652:
4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

Line 4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

4647: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4648: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4652:
4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

Line 4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

4649: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4652:
4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

Line 4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

4650: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4652:
4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

Line 4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

4651: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4652:
4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

Line 4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2

4652:
4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

Line 4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

4653: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

Line 4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

4654: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

Line 4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

4655: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

Line 4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

4656: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

Line 4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

4657: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2

Line 4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

4658: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number

Line 4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

4659: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number

Line 4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

4660: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number

Line 4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2

4661: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number

Line 4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number

4662: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number

Line 4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number

4663: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4671: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER

Line 4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number

4664: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4671: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number

Line 4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number

4665: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4671: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2

Line 4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number

4666: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4667: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4671: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number

4668: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4671: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2

Line 4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2

4669: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4671: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number

Line 4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

4670: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4671: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date

Line 4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2

4671: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number

Line 4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2

4672: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2

Line 4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number

4673: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2

Line 4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date

4674: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number

4675: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2

Line 4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2

4676: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number

Line 4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2

4677: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number

Line 4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

4678: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

Line 4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2

4679: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number

Line 4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number

4680: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4688: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number

Line 4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number

4681: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4688: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4689: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number

Line 4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

4682: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4688: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4689: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4690: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date

Line 4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number

4683: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4688: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4689: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4690: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
4691: ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN

Line 4688: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number

4684: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4688: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4689: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4690: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
4691: ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN
4692: ,P_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN

Line 4689: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number

4685: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4688: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4689: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4690: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
4691: ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN
4692: ,P_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN
4693: ,P_HOURLY_SALARIED_WARNING OUT NOCOPY BOOLEAN

Line 4690: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date

4686: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4687: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4688: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4689: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4690: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
4691: ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN
4692: ,P_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN
4693: ,P_HOURLY_SALARIED_WARNING OUT NOCOPY BOOLEAN
4694: ,P_NO_MANAGERS_WARNING OUT NOCOPY BOOLEAN

Line 4699: ,P_DATETRACK_MODE IN VARCHAR2 default hr_api.g_update

4695: ,P_ORG_NOW_NO_MANAGER_WARNING OUT NOCOPY BOOLEAN
4696: ,P_VALIDATION_START_DATE OUT NOCOPY DATE
4697: ,P_VALIDATION_END_DATE OUT NOCOPY DATE
4698: ,P_EFFECTIVE_DATE IN DATE default null
4699: ,P_DATETRACK_MODE IN VARCHAR2 default hr_api.g_update
4700: ,P_VALIDATE IN BOOLEAN default false
4701: ,P_OFFER_ID IN OUT NOCOPY NUMBER
4702: ,P_OFFER_STATUS IN VARCHAR2 default null
4703: ) Is

Line 4727: l_datetrack_mode varchar2(30) := hr_api.g_update;

4723:
4724: l_prev_offer_status irc_offers.offer_status%TYPE;
4725: l_iof_object_version_number irc_offers.object_version_number%TYPE;
4726: l_offer_version irc_offers.offer_version%TYPE;
4727: l_datetrack_mode varchar2(30) := hr_api.g_update;
4728: --
4729: cursor csr_prev_offer_details is
4730: select offer_status
4731: ,offer_assignment_id

Line 4845: l_datetrack_mode := hr_api.g_correction;

4841: --
4842: -- Since the current record has started today, we need to
4843: -- correct the existing record.
4844: --
4845: l_datetrack_mode := hr_api.g_correction;
4846: else
4847: --
4848: -- End the existing record and create a new record.
4849: --

Line 4850: l_datetrack_mode := hr_api.g_update;

4846: else
4847: --
4848: -- End the existing record and create a new record.
4849: --
4850: l_datetrack_mode := hr_api.g_update;
4851: --
4852: end if;
4853: --
4854: if l_prev_offer_status = 'HOLD'

Line 4973: -- We hence need to set the date track mode to 'hr_api.g_correction'

4969: );
4970: --
4971: -- Since a new offer assignment record has been created, we will
4972: -- be updating the assignment_record again on the same day of creation.
4973: -- We hence need to set the date track mode to 'hr_api.g_correction'
4974: --
4975: l_datetrack_mode := hr_api.g_correction;
4976: --
4977: end if; -- l_create_new_version

Line 4975: l_datetrack_mode := hr_api.g_correction;

4971: -- Since a new offer assignment record has been created, we will
4972: -- be updating the assignment_record again on the same day of creation.
4973: -- We hence need to set the date track mode to 'hr_api.g_correction'
4974: --
4975: l_datetrack_mode := hr_api.g_correction;
4976: --
4977: end if; -- l_create_new_version
4978: --
4979: hr_utility.set_location(l_proc, 60);

Line 5116: raise hr_api.validate_enabled;

5112: --
5113: -- When in validation only mode raise the Validate_Enabled exception
5114: --
5115: if p_validate then
5116: raise hr_api.validate_enabled;
5117: end if;
5118: --
5119: -- Set all IN OUT and OUT parameters with out values
5120: --

Line 5139: when hr_api.validate_enabled then

5135:
5136: hr_utility.set_location(' Leaving:'||l_proc, 145);
5137: --
5138: exception
5139: when hr_api.validate_enabled then
5140: --
5141: -- As the Validate_Enabled exception has been raised
5142: -- we must rollback to the savepoint
5143: --

Line 5254: raise hr_api.validate_enabled;

5250: --
5251: -- When in validation only mode raise the Validate_Enabled exception
5252: --
5253: if p_validate then
5254: raise hr_api.validate_enabled;
5255: end if;
5256: --
5257: hr_utility.set_location(' Leaving:'||l_proc, 40);
5258: --

Line 5260: when hr_api.validate_enabled then

5256: --
5257: hr_utility.set_location(' Leaving:'||l_proc, 40);
5258: --
5259: exception
5260: when hr_api.validate_enabled then
5261: --
5262: -- As the Validate_Enabled exception has been raised
5263: -- we must rollback to the savepoint
5264: --

Line 5315: raise hr_api.validate_enabled;

5311: --
5312: -- When in validation only mode raise the Validate_Enabled exception
5313: --
5314: if p_validate then
5315: raise hr_api.validate_enabled;
5316: end if;
5317: --
5318: hr_utility.set_location(' Leaving:'||l_proc, 40);
5319: exception

Line 5320: when hr_api.validate_enabled then

5316: end if;
5317: --
5318: hr_utility.set_location(' Leaving:'||l_proc, 40);
5319: exception
5320: when hr_api.validate_enabled then
5321: --
5322: -- As the Validate_Enabled exception has been raised
5323: -- we must rollback to the savepoint
5324: --