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 542: l_datetrack_mode := hr_api.g_correction;

538: --
539: -- Since the current record has started today, we need to
540: -- correct the existing record.
541: --
542: l_datetrack_mode := hr_api.g_correction;
543: else
544: --
545: hr_utility.set_location(l_proc,90);
546: --

Line 549: l_datetrack_mode := hr_api.g_update;

545: hr_utility.set_location(l_proc,90);
546: --
547: -- End the existing record and create a new record.
548: --
549: l_datetrack_mode := hr_api.g_update;
550: end if;
551: --
552: -- Call update_status_type_apl_asg in the required date track mode.
553: --

Line 585: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2

581: procedure update_latest_offer_flag
582: ( P_VALIDATE IN boolean default false
583: ,P_EFFECTIVE_DATE IN date default null
584: ,P_OFFER_ID IN NUMBER
585: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
586: ,P_LATEST_OFFER IN VARCHAR2
587: ,P_CHANGE_REASON IN VARCHAR2 default null
588: ,P_STATUS_CHANGE_DATE IN date default null
589: ) is

Line 653: if p_offer_status <> hr_api.g_varchar2

649: --
650: -- Insert a new Offer History record with the change_reason only if
651: -- the Status has changed.
652: --
653: if p_offer_status <> hr_api.g_varchar2
654: and p_offer_status <> l_updated_offer_status
655: then
656: --
657: hr_utility.set_location(l_proc, 50);

Line 705: ,p_datetrack_mode => hr_api.g_delete

701: ,p_object_version_number => l_asg_object_version_number
702: ,p_effective_date => p_effective_date
703: ,p_validation_start_date => l_validation_start_date
704: ,p_validation_end_date => l_validation_end_date
705: ,p_datetrack_mode => hr_api.g_delete
706: ,p_validate => p_validate
707: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
708: );
709: --

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

749: l_org_now_no_manager_warning boolean;
750: l_validation_start_date date;
751: l_validation_end_date date;
752: l_effective_date date;
753: l_datetrack_mode varchar2(30) := hr_api.g_update;
754: --
755: -- Define cursors
756: --
757: cursor csr_assignment_ids is

Line 955: l_datetrack_mode := hr_api.g_correction;

951: --
952: -- Since the applicant assignment record is being modified multiple
953: -- times on the same day, the datetrack mode should be correction.
954: --
955: l_datetrack_mode := hr_api.g_correction;
956: --
957: end if;
958: --
959: hr_utility.set_location(l_proc,40);

Line 1090: raise hr_api.validate_enabled;

1086: --
1087: -- When in validation only mode raise the Validate_Enabled exception
1088: --
1089: if p_validate then
1090: raise hr_api.validate_enabled;
1091: end if;
1092: --
1093: hr_utility.set_location(' Leaving:'||l_proc, 60);
1094: --

Line 1096: when hr_api.validate_enabled then

1092: --
1093: hr_utility.set_location(' Leaving:'||l_proc, 60);
1094: --
1095: exception
1096: when hr_api.validate_enabled then
1097: --
1098: -- As the Validate_Enabled exception has been raised
1099: -- we must rollback to the savepoint
1100: --

Line 1317: raise hr_api.validate_enabled;

1313: --
1314: -- When in validation only mode raise the Validate_Enabled exception
1315: --
1316: if p_validate then
1317: raise hr_api.validate_enabled;
1318: end if;
1319: --
1320: hr_utility.set_location(' Leaving:'||l_proc, 60);
1321: --

Line 1323: when hr_api.validate_enabled then

1319: --
1320: hr_utility.set_location(' Leaving:'||l_proc, 60);
1321: --
1322: exception
1323: when hr_api.validate_enabled then
1324: --
1325: -- As the Validate_Enabled exception has been raised
1326: -- we must rollback to the savepoint
1327: --

Line 1450: l_transaction_id hr_api_transactions.transaction_id%TYPE;

1446: ,P_OFFER_ID IN number
1447: ) Is
1448: --
1449: l_proc varchar2(72) := g_package||'close_notifications';
1450: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1451: l_item_type hr_api_transactions.item_type%TYPE;
1452: l_item_key hr_api_transactions.item_key%TYPE;
1453: --
1454: cursor csr_get_txn_details is

Line 1451: l_item_type hr_api_transactions.item_type%TYPE;

1447: ) Is
1448: --
1449: l_proc varchar2(72) := g_package||'close_notifications';
1450: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1451: l_item_type hr_api_transactions.item_type%TYPE;
1452: l_item_key hr_api_transactions.item_key%TYPE;
1453: --
1454: cursor csr_get_txn_details is
1455: select transaction_id

Line 1452: l_item_key hr_api_transactions.item_key%TYPE;

1448: --
1449: l_proc varchar2(72) := g_package||'close_notifications';
1450: l_transaction_id hr_api_transactions.transaction_id%TYPE;
1451: l_item_type hr_api_transactions.item_type%TYPE;
1452: l_item_key hr_api_transactions.item_key%TYPE;
1453: --
1454: cursor csr_get_txn_details is
1455: select transaction_id
1456: ,item_type

Line 1458: from hr_api_transactions

1454: cursor csr_get_txn_details is
1455: select transaction_id
1456: ,item_type
1457: ,item_key
1458: from hr_api_transactions
1459: where transaction_ref_table='IRC_OFFERS'
1460: and transaction_ref_id = p_offer_id;
1461: --
1462: cursor csr_get_sfl_txn_details is

Line 1466: from hr_api_transactions hat,

1462: cursor csr_get_sfl_txn_details is
1463: select hat.transaction_id
1464: ,wn.MESSAGE_TYPE
1465: ,wn.item_key
1466: from hr_api_transactions hat,
1467: wf_notifications wn
1468: where hat.transaction_ref_table='IRC_OFFERS'
1469: and hat.STATUS='S'
1470: and wn.MESSAGE_TYPE='HRSFL'

Line 1757: when hr_api.cannot_find_prog_unit then

1753: , P_ATTRIBUTE29 => P_ATTRIBUTE29
1754: , P_ATTRIBUTE30 => P_ATTRIBUTE30
1755: );
1756: exception
1757: when hr_api.cannot_find_prog_unit then
1758: hr_api.cannot_find_prog_unit_error
1759: (p_module_name => 'create_offer'
1760: ,p_hook_type => 'BP'
1761: );

Line 1758: hr_api.cannot_find_prog_unit_error

1754: , P_ATTRIBUTE30 => P_ATTRIBUTE30
1755: );
1756: exception
1757: when hr_api.cannot_find_prog_unit then
1758: hr_api.cannot_find_prog_unit_error
1759: (p_module_name => 'create_offer'
1760: ,p_hook_type => 'BP'
1761: );
1762: end;

Line 1898: when hr_api.cannot_find_prog_unit then

1894: , P_OFFER_VERSION => l_offer_version
1895: , P_OBJECT_VERSION_NUMBER => l_object_version_number
1896: );
1897: exception
1898: when hr_api.cannot_find_prog_unit then
1899: hr_api.cannot_find_prog_unit_error
1900: (p_module_name => 'create_offer'
1901: ,p_hook_type => 'AP'
1902: );

Line 1899: hr_api.cannot_find_prog_unit_error

1895: , P_OBJECT_VERSION_NUMBER => l_object_version_number
1896: );
1897: exception
1898: when hr_api.cannot_find_prog_unit then
1899: hr_api.cannot_find_prog_unit_error
1900: (p_module_name => 'create_offer'
1901: ,p_hook_type => 'AP'
1902: );
1903: end;

Line 1908: raise hr_api.validate_enabled;

1904: --
1905: -- When in validation only mode raise the Validate_Enabled exception
1906: --
1907: if p_validate then
1908: raise hr_api.validate_enabled;
1909: end if;
1910: --
1911: -- Set all IN OUT and OUT parameters with out values
1912: --

Line 1919: when hr_api.validate_enabled then

1915: p_offer_version := l_offer_version;
1916: --
1917: hr_utility.set_location(' Leaving:'||l_proc, 70);
1918: exception
1919: when hr_api.validate_enabled then
1920: --
1921: -- As the Validate_Enabled exception has been raised
1922: -- we must rollback to the savepoint
1923: --

Line 1959: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2

1955: --
1956: procedure update_offer
1957: ( P_VALIDATE IN boolean default false
1958: ,P_EFFECTIVE_DATE IN date default null
1959: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
1960: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
1961: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date

Line 1960: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2

1956: procedure update_offer
1957: ( P_VALIDATE IN boolean default false
1958: ,P_EFFECTIVE_DATE IN date default null
1959: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
1960: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
1961: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date

Line 1961: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2

1957: ( P_VALIDATE IN boolean default false
1958: ,P_EFFECTIVE_DATE IN date default null
1959: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
1960: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
1961: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2

Line 1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number

1958: ,P_EFFECTIVE_DATE IN date default null
1959: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
1960: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
1961: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2

Line 1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date

1959: ,P_OFFER_STATUS IN VARCHAR2 default hr_api.g_varchar2
1960: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
1961: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date

Line 1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date

1960: ,P_DISCRETIONARY_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
1961: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

Line 1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2

1961: ,P_OFFER_EXTENDED_METHOD IN VARCHAR2 default hr_api.g_varchar2
1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

Line 1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2

1962: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number

Line 1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date

1963: ,P_EXPIRY_DATE IN DATE default hr_api.g_date
1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number

Line 1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

1964: ,P_PROPOSED_START_DATE IN DATE default hr_api.g_date
1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2

Line 1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

1965: ,P_OFFER_LETTER_TRACKING_CODE IN VARCHAR2 default hr_api.g_varchar2
1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2

Line 1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number

1966: ,P_OFFER_POSTAL_SERVICE IN VARCHAR2 default hr_api.g_varchar2
1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number

1967: ,P_OFFER_SHIPPING_DATE IN DATE default hr_api.g_date
1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

Line 1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2

1968: ,P_APPLICANT_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

Line 1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2

1969: ,P_OFFER_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

Line 1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

1970: ,P_ADDRESS_ID IN NUMBER default hr_api.g_number
1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

Line 1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

1971: ,P_TEMPLATE_ID IN NUMBER default hr_api.g_number
1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

Line 1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

1972: ,P_OFFER_LETTER_FILE_TYPE IN VARCHAR2 default hr_api.g_varchar2
1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

Line 1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

1973: ,P_OFFER_LETTER_FILE_NAME IN VARCHAR2 default hr_api.g_varchar2
1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

Line 1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

1974: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

Line 1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

1975: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2

Line 1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

1976: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

Line 1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

1977: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

Line 1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

1978: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

Line 1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2

1979: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

Line 1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

1980: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

Line 1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

1981: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

Line 1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

1982: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

Line 1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

1983: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

Line 1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

1984: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

Line 1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

1985: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

Line 1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

1986: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

Line 1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

1987: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

Line 1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

1988: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2

Line 1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

1989: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

Line 1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

1990: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

Line 1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

1991: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

Line 1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2

1992: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

Line 1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

1993: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

Line 1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

1994: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2002: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

Line 1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

1995: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2002: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2003: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

Line 2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

1996: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2002: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2003: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2004: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

Line 2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

1997: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2002: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2003: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2004: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
2005: ,P_CHANGE_REASON IN VARCHAR2 default null

Line 2002: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

1998: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2002: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2003: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2004: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
2005: ,P_CHANGE_REASON IN VARCHAR2 default null
2006: ,P_DECLINE_REASON IN VARCHAR2 default null

Line 2003: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

1999: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2002: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2003: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2004: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
2005: ,P_CHANGE_REASON IN VARCHAR2 default null
2006: ,P_DECLINE_REASON IN VARCHAR2 default null
2007: ,P_NOTE_TEXT IN VARCHAR2 default null

Line 2004: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

2000: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
2001: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
2002: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
2003: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
2004: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
2005: ,P_CHANGE_REASON IN VARCHAR2 default null
2006: ,P_DECLINE_REASON IN VARCHAR2 default null
2007: ,P_NOTE_TEXT IN VARCHAR2 default null
2008: ,P_STATUS_CHANGE_DATE IN DATE default null

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

2023: l_offer_shipping_date irc_offers.offer_shipping_date%TYPE;
2024: l_offer_status_history_id irc_offer_status_history.offer_status_history_id%TYPE;
2025: l_prev_offer_status irc_offers.offer_status%TYPE;
2026: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2027: l_latest_offer irc_offers.latest_offer%TYPE := hr_api.g_varchar2;
2028: l_osh_object_version_number irc_offer_status_history.object_version_number%TYPE;
2029: l_status_change_date irc_offer_status_history.status_change_date%TYPE;
2030: l_mutiple_fields_updated boolean;
2031: l_offer_version irc_offers.offer_version%TYPE;

Line 2176: if l_offer_status = hr_api.g_varchar2

2172: --
2173: end if;
2174: close csr_prev_offer_details;
2175: --
2176: if l_offer_status = hr_api.g_varchar2
2177: then
2178: --
2179: l_offer_status := l_prev_offer_status;
2180: --

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

2243: -- 1) The offer duration has been Extended
2244: --
2245: -- Under all other circumstances, a new offer version should be created.
2246: --
2247: if (( nvl(l_expiry_date,hr_api.g_date) <> nvl(l_prev_expiry_date,hr_api.g_date))
2248: )
2249: then
2250: --
2251: irc_iof_bus.chk_multiple_fields_updated

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

2419: --
2420: -- Check if any of the variables have system default values,
2421: -- if so, set them to their previous values.
2422: --
2423: if ( l_temp_offer_record.discretionary_job_title = hr_api.g_varchar2) then
2424: l_temp_offer_record.discretionary_job_title := l_offer_record.discretionary_job_title;
2425: end if;
2426: if ( l_temp_offer_record.offer_extended_method = hr_api.g_varchar2) then
2427: l_temp_offer_record.offer_extended_method := l_offer_record.offer_extended_method;

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

2422: --
2423: if ( l_temp_offer_record.discretionary_job_title = hr_api.g_varchar2) then
2424: l_temp_offer_record.discretionary_job_title := l_offer_record.discretionary_job_title;
2425: end if;
2426: if ( l_temp_offer_record.offer_extended_method = hr_api.g_varchar2) then
2427: l_temp_offer_record.offer_extended_method := l_offer_record.offer_extended_method;
2428: end if;
2429: if ( l_temp_offer_record.respondent_id = hr_api.g_number) then
2430: l_temp_offer_record.respondent_id := l_offer_record.respondent_id;

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

2425: end if;
2426: if ( l_temp_offer_record.offer_extended_method = hr_api.g_varchar2) then
2427: l_temp_offer_record.offer_extended_method := l_offer_record.offer_extended_method;
2428: end if;
2429: if ( l_temp_offer_record.respondent_id = hr_api.g_number) then
2430: l_temp_offer_record.respondent_id := l_offer_record.respondent_id;
2431: end if;
2432: if ( l_temp_offer_record.expiry_date = hr_api.g_date) then
2433: l_temp_offer_record.expiry_date := l_offer_record.expiry_date;

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

2428: end if;
2429: if ( l_temp_offer_record.respondent_id = hr_api.g_number) then
2430: l_temp_offer_record.respondent_id := l_offer_record.respondent_id;
2431: end if;
2432: if ( l_temp_offer_record.expiry_date = hr_api.g_date) then
2433: l_temp_offer_record.expiry_date := l_offer_record.expiry_date;
2434: end if;
2435: if ( l_temp_offer_record.proposed_start_date = hr_api.g_date) then
2436: l_temp_offer_record.proposed_start_date := l_offer_record.proposed_start_date;

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

2431: end if;
2432: if ( l_temp_offer_record.expiry_date = hr_api.g_date) then
2433: l_temp_offer_record.expiry_date := l_offer_record.expiry_date;
2434: end if;
2435: if ( l_temp_offer_record.proposed_start_date = hr_api.g_date) then
2436: l_temp_offer_record.proposed_start_date := l_offer_record.proposed_start_date;
2437: end if;
2438: if ( l_temp_offer_record.offer_letter_tracking_code = hr_api.g_varchar2) then
2439: l_temp_offer_record.offer_letter_tracking_code := l_offer_record.offer_letter_tracking_code;

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

2434: end if;
2435: if ( l_temp_offer_record.proposed_start_date = hr_api.g_date) then
2436: l_temp_offer_record.proposed_start_date := l_offer_record.proposed_start_date;
2437: end if;
2438: if ( l_temp_offer_record.offer_letter_tracking_code = hr_api.g_varchar2) then
2439: l_temp_offer_record.offer_letter_tracking_code := l_offer_record.offer_letter_tracking_code;
2440: end if;
2441: if ( l_temp_offer_record.offer_postal_service = hr_api.g_varchar2) then
2442: l_temp_offer_record.offer_postal_service := l_offer_record.offer_postal_service;

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

2437: end if;
2438: if ( l_temp_offer_record.offer_letter_tracking_code = hr_api.g_varchar2) then
2439: l_temp_offer_record.offer_letter_tracking_code := l_offer_record.offer_letter_tracking_code;
2440: end if;
2441: if ( l_temp_offer_record.offer_postal_service = hr_api.g_varchar2) then
2442: l_temp_offer_record.offer_postal_service := l_offer_record.offer_postal_service;
2443: end if;
2444: if ( l_temp_offer_record.offer_shipping_date = hr_api.g_date) then
2445: l_temp_offer_record.offer_shipping_date := l_offer_record.offer_shipping_date;

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

2440: end if;
2441: if ( l_temp_offer_record.offer_postal_service = hr_api.g_varchar2) then
2442: l_temp_offer_record.offer_postal_service := l_offer_record.offer_postal_service;
2443: end if;
2444: if ( l_temp_offer_record.offer_shipping_date = hr_api.g_date) then
2445: l_temp_offer_record.offer_shipping_date := l_offer_record.offer_shipping_date;
2446: end if;
2447: if ( l_temp_offer_record.applicant_assignment_id = hr_api.g_number) then
2448: l_temp_offer_record.applicant_assignment_id := l_offer_record.applicant_assignment_id;

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

2443: end if;
2444: if ( l_temp_offer_record.offer_shipping_date = hr_api.g_date) then
2445: l_temp_offer_record.offer_shipping_date := l_offer_record.offer_shipping_date;
2446: end if;
2447: if ( l_temp_offer_record.applicant_assignment_id = hr_api.g_number) then
2448: l_temp_offer_record.applicant_assignment_id := l_offer_record.applicant_assignment_id;
2449: end if;
2450: if ( l_temp_offer_record.offer_assignment_id = hr_api.g_number) then
2451: l_temp_offer_record.offer_assignment_id := l_offer_record.offer_assignment_id;

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

2446: end if;
2447: if ( l_temp_offer_record.applicant_assignment_id = hr_api.g_number) then
2448: l_temp_offer_record.applicant_assignment_id := l_offer_record.applicant_assignment_id;
2449: end if;
2450: if ( l_temp_offer_record.offer_assignment_id = hr_api.g_number) then
2451: l_temp_offer_record.offer_assignment_id := l_offer_record.offer_assignment_id;
2452: end if;
2453: if ( l_temp_offer_record.address_id = hr_api.g_number) then
2454: l_temp_offer_record.address_id := l_offer_record.address_id;

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

2449: end if;
2450: if ( l_temp_offer_record.offer_assignment_id = hr_api.g_number) then
2451: l_temp_offer_record.offer_assignment_id := l_offer_record.offer_assignment_id;
2452: end if;
2453: if ( l_temp_offer_record.address_id = hr_api.g_number) then
2454: l_temp_offer_record.address_id := l_offer_record.address_id;
2455: end if;
2456: if ( l_temp_offer_record.template_id = hr_api.g_number) then
2457: l_temp_offer_record.template_id := l_offer_record.template_id;

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

2452: end if;
2453: if ( l_temp_offer_record.address_id = hr_api.g_number) then
2454: l_temp_offer_record.address_id := l_offer_record.address_id;
2455: end if;
2456: if ( l_temp_offer_record.template_id = hr_api.g_number) then
2457: l_temp_offer_record.template_id := l_offer_record.template_id;
2458: end if;
2459: if ( l_temp_offer_record.offer_letter_file_type = hr_api.g_varchar2) then
2460: l_temp_offer_record.offer_letter_file_type := l_offer_record.offer_letter_file_type;

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

2455: end if;
2456: if ( l_temp_offer_record.template_id = hr_api.g_number) then
2457: l_temp_offer_record.template_id := l_offer_record.template_id;
2458: end if;
2459: if ( l_temp_offer_record.offer_letter_file_type = hr_api.g_varchar2) then
2460: l_temp_offer_record.offer_letter_file_type := l_offer_record.offer_letter_file_type;
2461: end if;
2462: if ( l_temp_offer_record.offer_letter_file_name = hr_api.g_varchar2) then
2463: l_temp_offer_record.offer_letter_file_name := l_offer_record.offer_letter_file_name;

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

2458: end if;
2459: if ( l_temp_offer_record.offer_letter_file_type = hr_api.g_varchar2) then
2460: l_temp_offer_record.offer_letter_file_type := l_offer_record.offer_letter_file_type;
2461: end if;
2462: if ( l_temp_offer_record.offer_letter_file_name = hr_api.g_varchar2) then
2463: l_temp_offer_record.offer_letter_file_name := l_offer_record.offer_letter_file_name;
2464: end if;
2465: if ( l_temp_offer_record.attribute_category = hr_api.g_varchar2) then
2466: l_temp_offer_record.attribute_category := l_offer_record.attribute_category;

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

2461: end if;
2462: if ( l_temp_offer_record.offer_letter_file_name = hr_api.g_varchar2) then
2463: l_temp_offer_record.offer_letter_file_name := l_offer_record.offer_letter_file_name;
2464: end if;
2465: if ( l_temp_offer_record.attribute_category = hr_api.g_varchar2) then
2466: l_temp_offer_record.attribute_category := l_offer_record.attribute_category;
2467: end if;
2468: if ( l_temp_offer_record.attribute1 = hr_api.g_varchar2) then
2469: l_temp_offer_record.attribute1 := l_offer_record.attribute1;

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

2464: end if;
2465: if ( l_temp_offer_record.attribute_category = hr_api.g_varchar2) then
2466: l_temp_offer_record.attribute_category := l_offer_record.attribute_category;
2467: end if;
2468: if ( l_temp_offer_record.attribute1 = hr_api.g_varchar2) then
2469: l_temp_offer_record.attribute1 := l_offer_record.attribute1;
2470: end if;
2471: if ( l_temp_offer_record.attribute2 = hr_api.g_varchar2) then
2472: l_temp_offer_record.attribute2 := l_offer_record.attribute2;

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

2467: end if;
2468: if ( l_temp_offer_record.attribute1 = hr_api.g_varchar2) then
2469: l_temp_offer_record.attribute1 := l_offer_record.attribute1;
2470: end if;
2471: if ( l_temp_offer_record.attribute2 = hr_api.g_varchar2) then
2472: l_temp_offer_record.attribute2 := l_offer_record.attribute2;
2473: end if;
2474: if ( l_temp_offer_record.attribute3 = hr_api.g_varchar2) then
2475: l_temp_offer_record.attribute3 := l_offer_record.attribute3;

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

2470: end if;
2471: if ( l_temp_offer_record.attribute2 = hr_api.g_varchar2) then
2472: l_temp_offer_record.attribute2 := l_offer_record.attribute2;
2473: end if;
2474: if ( l_temp_offer_record.attribute3 = hr_api.g_varchar2) then
2475: l_temp_offer_record.attribute3 := l_offer_record.attribute3;
2476: end if;
2477: if ( l_temp_offer_record.attribute4 = hr_api.g_varchar2) then
2478: l_temp_offer_record.attribute4 := l_offer_record.attribute4;

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

2473: end if;
2474: if ( l_temp_offer_record.attribute3 = hr_api.g_varchar2) then
2475: l_temp_offer_record.attribute3 := l_offer_record.attribute3;
2476: end if;
2477: if ( l_temp_offer_record.attribute4 = hr_api.g_varchar2) then
2478: l_temp_offer_record.attribute4 := l_offer_record.attribute4;
2479: end if;
2480: if ( l_temp_offer_record.attribute5 = hr_api.g_varchar2) then
2481: l_temp_offer_record.attribute5 := l_offer_record.attribute5;

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

2476: end if;
2477: if ( l_temp_offer_record.attribute4 = hr_api.g_varchar2) then
2478: l_temp_offer_record.attribute4 := l_offer_record.attribute4;
2479: end if;
2480: if ( l_temp_offer_record.attribute5 = hr_api.g_varchar2) then
2481: l_temp_offer_record.attribute5 := l_offer_record.attribute5;
2482: end if;
2483: if ( l_temp_offer_record.attribute6 = hr_api.g_varchar2) then
2484: l_temp_offer_record.attribute6 := l_offer_record.attribute6;

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

2479: end if;
2480: if ( l_temp_offer_record.attribute5 = hr_api.g_varchar2) then
2481: l_temp_offer_record.attribute5 := l_offer_record.attribute5;
2482: end if;
2483: if ( l_temp_offer_record.attribute6 = hr_api.g_varchar2) then
2484: l_temp_offer_record.attribute6 := l_offer_record.attribute6;
2485: end if;
2486: if ( l_temp_offer_record.attribute7 = hr_api.g_varchar2) then
2487: l_temp_offer_record.attribute7 := l_offer_record.attribute7;

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

2482: end if;
2483: if ( l_temp_offer_record.attribute6 = hr_api.g_varchar2) then
2484: l_temp_offer_record.attribute6 := l_offer_record.attribute6;
2485: end if;
2486: if ( l_temp_offer_record.attribute7 = hr_api.g_varchar2) then
2487: l_temp_offer_record.attribute7 := l_offer_record.attribute7;
2488: end if;
2489: if ( l_temp_offer_record.attribute8 = hr_api.g_varchar2) then
2490: l_temp_offer_record.attribute8 := l_offer_record.attribute8;

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

2485: end if;
2486: if ( l_temp_offer_record.attribute7 = hr_api.g_varchar2) then
2487: l_temp_offer_record.attribute7 := l_offer_record.attribute7;
2488: end if;
2489: if ( l_temp_offer_record.attribute8 = hr_api.g_varchar2) then
2490: l_temp_offer_record.attribute8 := l_offer_record.attribute8;
2491: end if;
2492: if ( l_temp_offer_record.attribute9 = hr_api.g_varchar2) then
2493: l_temp_offer_record.attribute9 := l_offer_record.attribute9;

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

2488: end if;
2489: if ( l_temp_offer_record.attribute8 = hr_api.g_varchar2) then
2490: l_temp_offer_record.attribute8 := l_offer_record.attribute8;
2491: end if;
2492: if ( l_temp_offer_record.attribute9 = hr_api.g_varchar2) then
2493: l_temp_offer_record.attribute9 := l_offer_record.attribute9;
2494: end if;
2495: if ( l_temp_offer_record.attribute10 = hr_api.g_varchar2) then
2496: l_temp_offer_record.attribute10 := l_offer_record.attribute10;

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

2491: end if;
2492: if ( l_temp_offer_record.attribute9 = hr_api.g_varchar2) then
2493: l_temp_offer_record.attribute9 := l_offer_record.attribute9;
2494: end if;
2495: if ( l_temp_offer_record.attribute10 = hr_api.g_varchar2) then
2496: l_temp_offer_record.attribute10 := l_offer_record.attribute10;
2497: end if;
2498: if ( l_temp_offer_record.attribute11 = hr_api.g_varchar2) then
2499: l_temp_offer_record.attribute11 := l_offer_record.attribute11;

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

2494: end if;
2495: if ( l_temp_offer_record.attribute10 = hr_api.g_varchar2) then
2496: l_temp_offer_record.attribute10 := l_offer_record.attribute10;
2497: end if;
2498: if ( l_temp_offer_record.attribute11 = hr_api.g_varchar2) then
2499: l_temp_offer_record.attribute11 := l_offer_record.attribute11;
2500: end if;
2501: if ( l_temp_offer_record.attribute12 = hr_api.g_varchar2) then
2502: l_temp_offer_record.attribute12 := l_offer_record.attribute12;

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

2497: end if;
2498: if ( l_temp_offer_record.attribute11 = hr_api.g_varchar2) then
2499: l_temp_offer_record.attribute11 := l_offer_record.attribute11;
2500: end if;
2501: if ( l_temp_offer_record.attribute12 = hr_api.g_varchar2) then
2502: l_temp_offer_record.attribute12 := l_offer_record.attribute12;
2503: end if;
2504: if ( l_temp_offer_record.attribute13 = hr_api.g_varchar2) then
2505: l_temp_offer_record.attribute13 := l_offer_record.attribute13;

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

2500: end if;
2501: if ( l_temp_offer_record.attribute12 = hr_api.g_varchar2) then
2502: l_temp_offer_record.attribute12 := l_offer_record.attribute12;
2503: end if;
2504: if ( l_temp_offer_record.attribute13 = hr_api.g_varchar2) then
2505: l_temp_offer_record.attribute13 := l_offer_record.attribute13;
2506: end if;
2507: if ( l_temp_offer_record.attribute14 = hr_api.g_varchar2) then
2508: l_temp_offer_record.attribute14 := l_offer_record.attribute14;

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

2503: end if;
2504: if ( l_temp_offer_record.attribute13 = hr_api.g_varchar2) then
2505: l_temp_offer_record.attribute13 := l_offer_record.attribute13;
2506: end if;
2507: if ( l_temp_offer_record.attribute14 = hr_api.g_varchar2) then
2508: l_temp_offer_record.attribute14 := l_offer_record.attribute14;
2509: end if;
2510: if ( l_temp_offer_record.attribute15 = hr_api.g_varchar2) then
2511: l_temp_offer_record.attribute15 := l_offer_record.attribute15;

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

2506: end if;
2507: if ( l_temp_offer_record.attribute14 = hr_api.g_varchar2) then
2508: l_temp_offer_record.attribute14 := l_offer_record.attribute14;
2509: end if;
2510: if ( l_temp_offer_record.attribute15 = hr_api.g_varchar2) then
2511: l_temp_offer_record.attribute15 := l_offer_record.attribute15;
2512: end if;
2513: if ( l_temp_offer_record.attribute16 = hr_api.g_varchar2) then
2514: l_temp_offer_record.attribute16 := l_offer_record.attribute16;

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

2509: end if;
2510: if ( l_temp_offer_record.attribute15 = hr_api.g_varchar2) then
2511: l_temp_offer_record.attribute15 := l_offer_record.attribute15;
2512: end if;
2513: if ( l_temp_offer_record.attribute16 = hr_api.g_varchar2) then
2514: l_temp_offer_record.attribute16 := l_offer_record.attribute16;
2515: end if;
2516: if ( l_temp_offer_record.attribute17 = hr_api.g_varchar2) then
2517: l_temp_offer_record.attribute17 := l_offer_record.attribute17;

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

2512: end if;
2513: if ( l_temp_offer_record.attribute16 = hr_api.g_varchar2) then
2514: l_temp_offer_record.attribute16 := l_offer_record.attribute16;
2515: end if;
2516: if ( l_temp_offer_record.attribute17 = hr_api.g_varchar2) then
2517: l_temp_offer_record.attribute17 := l_offer_record.attribute17;
2518: end if;
2519: if ( l_temp_offer_record.attribute18 = hr_api.g_varchar2) then
2520: l_temp_offer_record.attribute18 := l_offer_record.attribute18;

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

2515: end if;
2516: if ( l_temp_offer_record.attribute17 = hr_api.g_varchar2) then
2517: l_temp_offer_record.attribute17 := l_offer_record.attribute17;
2518: end if;
2519: if ( l_temp_offer_record.attribute18 = hr_api.g_varchar2) then
2520: l_temp_offer_record.attribute18 := l_offer_record.attribute18;
2521: end if;
2522: if ( l_temp_offer_record.attribute19 = hr_api.g_varchar2) then
2523: l_temp_offer_record.attribute19 := l_offer_record.attribute19;

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

2518: end if;
2519: if ( l_temp_offer_record.attribute18 = hr_api.g_varchar2) then
2520: l_temp_offer_record.attribute18 := l_offer_record.attribute18;
2521: end if;
2522: if ( l_temp_offer_record.attribute19 = hr_api.g_varchar2) then
2523: l_temp_offer_record.attribute19 := l_offer_record.attribute19;
2524: end if;
2525: if ( l_temp_offer_record.attribute20 = hr_api.g_varchar2) then
2526: l_temp_offer_record.attribute20 := l_offer_record.attribute20;

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

2521: end if;
2522: if ( l_temp_offer_record.attribute19 = hr_api.g_varchar2) then
2523: l_temp_offer_record.attribute19 := l_offer_record.attribute19;
2524: end if;
2525: if ( l_temp_offer_record.attribute20 = hr_api.g_varchar2) then
2526: l_temp_offer_record.attribute20 := l_offer_record.attribute20;
2527: end if;
2528: if ( l_temp_offer_record.attribute21 = hr_api.g_varchar2) then
2529: l_temp_offer_record.attribute21 := l_offer_record.attribute21;

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

2524: end if;
2525: if ( l_temp_offer_record.attribute20 = hr_api.g_varchar2) then
2526: l_temp_offer_record.attribute20 := l_offer_record.attribute20;
2527: end if;
2528: if ( l_temp_offer_record.attribute21 = hr_api.g_varchar2) then
2529: l_temp_offer_record.attribute21 := l_offer_record.attribute21;
2530: end if;
2531: if ( l_temp_offer_record.attribute22 = hr_api.g_varchar2) then
2532: l_temp_offer_record.attribute22 := l_offer_record.attribute22;

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

2527: end if;
2528: if ( l_temp_offer_record.attribute21 = hr_api.g_varchar2) then
2529: l_temp_offer_record.attribute21 := l_offer_record.attribute21;
2530: end if;
2531: if ( l_temp_offer_record.attribute22 = hr_api.g_varchar2) then
2532: l_temp_offer_record.attribute22 := l_offer_record.attribute22;
2533: end if;
2534: if ( l_temp_offer_record.attribute23 = hr_api.g_varchar2) then
2535: l_temp_offer_record.attribute23 := l_offer_record.attribute23;

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

2530: end if;
2531: if ( l_temp_offer_record.attribute22 = hr_api.g_varchar2) then
2532: l_temp_offer_record.attribute22 := l_offer_record.attribute22;
2533: end if;
2534: if ( l_temp_offer_record.attribute23 = hr_api.g_varchar2) then
2535: l_temp_offer_record.attribute23 := l_offer_record.attribute23;
2536: end if;
2537: if ( l_temp_offer_record.attribute24 = hr_api.g_varchar2) then
2538: l_temp_offer_record.attribute24 := l_offer_record.attribute24;

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

2533: end if;
2534: if ( l_temp_offer_record.attribute23 = hr_api.g_varchar2) then
2535: l_temp_offer_record.attribute23 := l_offer_record.attribute23;
2536: end if;
2537: if ( l_temp_offer_record.attribute24 = hr_api.g_varchar2) then
2538: l_temp_offer_record.attribute24 := l_offer_record.attribute24;
2539: end if;
2540: if ( l_temp_offer_record.attribute25 = hr_api.g_varchar2) then
2541: l_temp_offer_record.attribute25 := l_offer_record.attribute25;

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

2536: end if;
2537: if ( l_temp_offer_record.attribute24 = hr_api.g_varchar2) then
2538: l_temp_offer_record.attribute24 := l_offer_record.attribute24;
2539: end if;
2540: if ( l_temp_offer_record.attribute25 = hr_api.g_varchar2) then
2541: l_temp_offer_record.attribute25 := l_offer_record.attribute25;
2542: end if;
2543: if ( l_temp_offer_record.attribute26 = hr_api.g_varchar2) then
2544: l_temp_offer_record.attribute26 := l_offer_record.attribute26;

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

2539: end if;
2540: if ( l_temp_offer_record.attribute25 = hr_api.g_varchar2) then
2541: l_temp_offer_record.attribute25 := l_offer_record.attribute25;
2542: end if;
2543: if ( l_temp_offer_record.attribute26 = hr_api.g_varchar2) then
2544: l_temp_offer_record.attribute26 := l_offer_record.attribute26;
2545: end if;
2546: if ( l_temp_offer_record.attribute27 = hr_api.g_varchar2) then
2547: l_temp_offer_record.attribute27 := l_offer_record.attribute27;

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

2542: end if;
2543: if ( l_temp_offer_record.attribute26 = hr_api.g_varchar2) then
2544: l_temp_offer_record.attribute26 := l_offer_record.attribute26;
2545: end if;
2546: if ( l_temp_offer_record.attribute27 = hr_api.g_varchar2) then
2547: l_temp_offer_record.attribute27 := l_offer_record.attribute27;
2548: end if;
2549: if ( l_temp_offer_record.attribute28 = hr_api.g_varchar2) then
2550: l_temp_offer_record.attribute28 := l_offer_record.attribute28;

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

2545: end if;
2546: if ( l_temp_offer_record.attribute27 = hr_api.g_varchar2) then
2547: l_temp_offer_record.attribute27 := l_offer_record.attribute27;
2548: end if;
2549: if ( l_temp_offer_record.attribute28 = hr_api.g_varchar2) then
2550: l_temp_offer_record.attribute28 := l_offer_record.attribute28;
2551: end if;
2552: if ( l_temp_offer_record.attribute29 = hr_api.g_varchar2) then
2553: l_temp_offer_record.attribute29 := l_offer_record.attribute29;

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

2548: end if;
2549: if ( l_temp_offer_record.attribute28 = hr_api.g_varchar2) then
2550: l_temp_offer_record.attribute28 := l_offer_record.attribute28;
2551: end if;
2552: if ( l_temp_offer_record.attribute29 = hr_api.g_varchar2) then
2553: l_temp_offer_record.attribute29 := l_offer_record.attribute29;
2554: end if;
2555: if ( l_temp_offer_record.attribute30 = hr_api.g_varchar2) then
2556: l_temp_offer_record.attribute30 := l_offer_record.attribute30;

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

2551: end if;
2552: if ( l_temp_offer_record.attribute29 = hr_api.g_varchar2) then
2553: l_temp_offer_record.attribute29 := l_offer_record.attribute29;
2554: end if;
2555: if ( l_temp_offer_record.attribute30 = hr_api.g_varchar2) then
2556: l_temp_offer_record.attribute30 := l_offer_record.attribute30;
2557: end if;
2558: --
2559: -- Create a new offer assignment copied from prev offer assignment.

Line 2687: when hr_api.cannot_find_prog_unit then

2683: , P_ATTRIBUTE30 => P_ATTRIBUTE30
2684: , P_OBJECT_VERSION_NUMBER => p_object_version_number
2685: );
2686: exception
2687: when hr_api.cannot_find_prog_unit then
2688: hr_api.cannot_find_prog_unit_error
2689: (p_module_name => 'update_offer'
2690: ,p_hook_type => 'BP'
2691: );

Line 2688: hr_api.cannot_find_prog_unit_error

2684: , P_OBJECT_VERSION_NUMBER => p_object_version_number
2685: );
2686: exception
2687: when hr_api.cannot_find_prog_unit then
2688: hr_api.cannot_find_prog_unit_error
2689: (p_module_name => 'update_offer'
2690: ,p_hook_type => 'BP'
2691: );
2692: end;

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

2989: -- 3) The offer status change reason has changed.
2990: --
2991: if (l_offer_status <> l_prev_offer_status) OR
2992: (l_offer_status = 'EXTENDED' AND
2993: (nvl(l_expiry_date,hr_api.g_date) <> nvl(l_prev_expiry_date,hr_api.g_date))
2994: ) OR
2995: (l_prev_offer_change_reason <> p_change_reason)
2996: then
2997: --

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

3002: if not
3003: (
3004: (
3005: (
3006: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3007: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))
3008: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3009: )
3010: or (

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

3003: (
3004: (
3005: (
3006: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3007: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))
3008: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3009: )
3010: or (
3011: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))

Line 3008: and p_offer_letter_tracking_code <> hr_api.g_varchar2

3004: (
3005: (
3006: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3007: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))
3008: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3009: )
3010: or (
3011: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3012: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))

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

3007: and (nvl(p_offer_letter_tracking_code,hr_api.g_varchar2) <> nvl(l_offer_letter_tracking_code,hr_api.g_varchar2))
3008: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3009: )
3010: or (
3011: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3012: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))
3013: and p_offer_postal_service <> hr_api.g_varchar2
3014: )
3015: or (

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

3008: and p_offer_letter_tracking_code <> hr_api.g_varchar2
3009: )
3010: or (
3011: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3012: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))
3013: and p_offer_postal_service <> hr_api.g_varchar2
3014: )
3015: or (
3016: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))

Line 3013: and p_offer_postal_service <> hr_api.g_varchar2

3009: )
3010: or (
3011: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3012: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))
3013: and p_offer_postal_service <> hr_api.g_varchar2
3014: )
3015: or (
3016: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3017: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))

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

3012: and (nvl(p_offer_postal_service,hr_api.g_varchar2) <> nvl(l_offer_postal_service,hr_api.g_varchar2))
3013: and p_offer_postal_service <> hr_api.g_varchar2
3014: )
3015: or (
3016: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3017: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))
3018: and l_offer_shipping_date <> hr_api.g_date
3019: )
3020: )

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

3013: and p_offer_postal_service <> hr_api.g_varchar2
3014: )
3015: or (
3016: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3017: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))
3018: and l_offer_shipping_date <> hr_api.g_date
3019: )
3020: )
3021: and

Line 3018: and l_offer_shipping_date <> hr_api.g_date

3014: )
3015: or (
3016: ((l_offer_status = 'EXTENDED') or (l_offer_status = hr_api.g_varchar2))
3017: and (nvl(l_offer_shipping_date,hr_api.g_date) <> nvl(l_prev_offer_shipping_date,hr_api.g_date))
3018: and l_offer_shipping_date <> hr_api.g_date
3019: )
3020: )
3021: and
3022: (l_expiry_date = hr_api.g_date)

Line 3022: (l_expiry_date = hr_api.g_date)

3018: and l_offer_shipping_date <> hr_api.g_date
3019: )
3020: )
3021: and
3022: (l_expiry_date = hr_api.g_date)
3023: )
3024: then
3025: --
3026: hr_utility.set_location(l_proc,140);

Line 3072: ,p_datetrack_mode => hr_api.g_delete

3068: ,p_object_version_number => l_asg_object_version_number
3069: ,p_effective_date => l_effective_date
3070: ,p_validation_start_date => l_validation_start_date
3071: ,p_validation_end_date => l_validation_end_date
3072: ,p_datetrack_mode => hr_api.g_delete
3073: ,p_validate => p_validate
3074: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
3075: );
3076: --

Line 3192: when hr_api.cannot_find_prog_unit then

3188: , P_ATTRIBUTE30 => P_ATTRIBUTE30
3189: , P_OBJECT_VERSION_NUMBER => p_object_version_number
3190: );
3191: exception
3192: when hr_api.cannot_find_prog_unit then
3193: hr_api.cannot_find_prog_unit_error
3194: (p_module_name => 'update_offer'
3195: ,p_hook_type => 'AP'
3196: );

Line 3193: hr_api.cannot_find_prog_unit_error

3189: , P_OBJECT_VERSION_NUMBER => p_object_version_number
3190: );
3191: exception
3192: when hr_api.cannot_find_prog_unit then
3193: hr_api.cannot_find_prog_unit_error
3194: (p_module_name => 'update_offer'
3195: ,p_hook_type => 'AP'
3196: );
3197: end;

Line 3202: raise hr_api.validate_enabled;

3198: --
3199: -- When in validation only mode raise the Validate_Enabled exception
3200: --
3201: if p_validate then
3202: raise hr_api.validate_enabled;
3203: end if;
3204: --
3205: end if; -- l_create_new_version
3206: --

Line 3218: when hr_api.validate_enabled then

3214: --
3215: hr_utility.set_location(' Leaving:'||l_proc, 145);
3216: --
3217: exception
3218: when hr_api.validate_enabled then
3219: --
3220: -- Reset IN OUT parameters and set OUT parameters
3221: -- (Any key or derived arguments must be set to null
3222: -- when validation only mode is being used.)

Line 3349: when hr_api.cannot_find_prog_unit then

3345: P_OBJECT_VERSION_NUMBER
3346: ,P_OFFER_ID
3347: );
3348: exception
3349: when hr_api.cannot_find_prog_unit then
3350: hr_api.cannot_find_prog_unit_error
3351: (p_module_name => 'delete_offer'
3352: ,p_hook_type => 'BP'
3353: );

Line 3350: hr_api.cannot_find_prog_unit_error

3346: ,P_OFFER_ID
3347: );
3348: exception
3349: when hr_api.cannot_find_prog_unit then
3350: hr_api.cannot_find_prog_unit_error
3351: (p_module_name => 'delete_offer'
3352: ,p_hook_type => 'BP'
3353: );
3354: end;

Line 3404: ,p_datetrack_mode => hr_api.g_zap

3400: ,p_object_version_number => l_asg_object_version_number
3401: ,p_effective_date => l_effective_date
3402: ,p_validation_start_date => l_validation_start_date
3403: ,p_validation_end_date => l_validation_end_date
3404: ,p_datetrack_mode => hr_api.g_zap
3405: ,p_validate => p_validate
3406: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
3407: );
3408: --

Line 3460: when hr_api.cannot_find_prog_unit then

3456: P_OBJECT_VERSION_NUMBER
3457: ,P_OFFER_ID
3458: );
3459: exception
3460: when hr_api.cannot_find_prog_unit then
3461: hr_api.cannot_find_prog_unit_error
3462: (p_module_name => 'delete_offer'
3463: ,p_hook_type => 'AP'
3464: );

Line 3461: hr_api.cannot_find_prog_unit_error

3457: ,P_OFFER_ID
3458: );
3459: exception
3460: when hr_api.cannot_find_prog_unit then
3461: hr_api.cannot_find_prog_unit_error
3462: (p_module_name => 'delete_offer'
3463: ,p_hook_type => 'AP'
3464: );
3465: end;

Line 3470: raise hr_api.validate_enabled;

3466: --
3467: -- When in validation only mode raise the Validate_Enabled exception
3468: --
3469: if p_validate then
3470: raise hr_api.validate_enabled;
3471: end if;
3472: --
3473: -- Set all output arguments
3474: --

Line 3478: when hr_api.validate_enabled then

3474: --
3475: --
3476: hr_utility.set_location(' Leaving:'||l_proc, 50);
3477: exception
3478: when hr_api.validate_enabled then
3479: --
3480: -- As the Validate_Enabled exception has been raised
3481: -- we must rollback to the savepoint
3482: --

Line 3722: raise hr_api.validate_enabled;

3718: --
3719: -- When in validation only mode raise the Validate_Enabled exception
3720: --
3721: if p_validate then
3722: raise hr_api.validate_enabled;
3723: end if;
3724: --
3725: hr_utility.set_location(' Leaving:'||l_proc, 100);
3726: exception

Line 3727: when hr_api.validate_enabled then

3723: end if;
3724: --
3725: hr_utility.set_location(' Leaving:'||l_proc, 100);
3726: exception
3727: when hr_api.validate_enabled then
3728: --
3729: -- As the Validate_Enabled exception has been raised
3730: -- we must rollback to the savepoint
3731: --

Line 3754: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number

3750: procedure hold_offer
3751: ( P_VALIDATE IN boolean default false
3752: ,P_EFFECTIVE_DATE IN date default null
3753: ,P_OFFER_ID IN NUMBER
3754: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
3755: ,P_CHANGE_REASON IN VARCHAR2 default null
3756: ,P_STATUS_CHANGE_DATE IN date default null
3757: ,P_NOTE_TEXT IN VARCHAR2 default null
3758: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER

Line 3797: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number

3793: procedure release_offer
3794: ( P_VALIDATE IN boolean default false
3795: ,P_EFFECTIVE_DATE IN date default null
3796: ,P_OFFER_ID IN NUMBER
3797: ,P_RESPONDENT_ID IN NUMBER default hr_api.g_number
3798: ,P_CHANGE_REASON IN VARCHAR2 default null
3799: ,P_STATUS_CHANGE_DATE IN date default null
3800: ,P_NOTE_TEXT IN VARCHAR2 default null
3801: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER

Line 4275: raise hr_api.validate_enabled;

4271: --
4272: -- When in validation only mode raise the Validate_Enabled exception
4273: --
4274: if p_validate then
4275: raise hr_api.validate_enabled;
4276: end if;
4277: --
4278: -- Assign all the OUT and IN OUT Variables
4279: --

Line 4293: when hr_api.validate_enabled then

4289: --
4290: hr_utility.set_location(' Leaving:'||l_proc, 60);
4291: --
4292: exception
4293: when hr_api.validate_enabled then
4294: --
4295: p_assignment_id := null;
4296: p_effective_start_date := null;
4297: p_effective_end_date := null;

Line 4337: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number

4333: ,P_EFFECTIVE_START_DATE OUT NOCOPY DATE
4334: ,P_EFFECTIVE_END_DATE OUT NOCOPY DATE
4335: ,P_BUSINESS_GROUP_ID OUT NOCOPY NUMBER
4336:
4337: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4338: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4339: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4340: ,P_JOB_ID IN NUMBER default hr_api.g_number
4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number

Line 4338: ,P_GRADE_ID IN NUMBER default hr_api.g_number

4334: ,P_EFFECTIVE_END_DATE OUT NOCOPY DATE
4335: ,P_BUSINESS_GROUP_ID OUT NOCOPY NUMBER
4336:
4337: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4338: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4339: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4340: ,P_JOB_ID IN NUMBER default hr_api.g_number
4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number

Line 4339: ,P_POSITION_ID IN NUMBER default hr_api.g_number

4335: ,P_BUSINESS_GROUP_ID OUT NOCOPY NUMBER
4336:
4337: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4338: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4339: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4340: ,P_JOB_ID IN NUMBER default hr_api.g_number
4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number

Line 4340: ,P_JOB_ID IN NUMBER default hr_api.g_number

4336:
4337: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4338: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4339: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4340: ,P_JOB_ID IN NUMBER default hr_api.g_number
4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number

Line 4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number

4337: ,P_RECRUITER_ID IN NUMBER default hr_api.g_number
4338: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4339: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4340: ,P_JOB_ID IN NUMBER default hr_api.g_number
4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number

Line 4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number

4338: ,P_GRADE_ID IN NUMBER default hr_api.g_number
4339: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4340: ,P_JOB_ID IN NUMBER default hr_api.g_number
4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number

Line 4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number

4339: ,P_POSITION_ID IN NUMBER default hr_api.g_number
4340: ,P_JOB_ID IN NUMBER default hr_api.g_number
4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number

Line 4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number

4340: ,P_JOB_ID IN NUMBER default hr_api.g_number
4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number

Line 4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number

4341: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER default hr_api.g_number
4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4349:

Line 4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number

4342: ,P_PAYROLL_ID IN NUMBER default hr_api.g_number
4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4349:
4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number

Line 4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number

4343: ,P_LOCATION_ID IN NUMBER default hr_api.g_number
4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4349:
4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number

Line 4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number

4344: ,P_PERSON_REFERRED_BY_ID IN NUMBER default hr_api.g_number
4345: ,P_SUPERVISOR_ID IN NUMBER default hr_api.g_number
4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4349:
4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number

Line 4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number

4346: ,P_SPECIAL_CEILING_STEP_ID IN NUMBER default hr_api.g_number
4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4349:
4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number

Line 4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number

4347: ,P_RECRUITMENT_ACTIVITY_ID IN NUMBER default hr_api.g_number
4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4349:
4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2

Line 4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number

4348: ,P_SOURCE_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4349:
4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2

Line 4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number

4349:
4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number

Line 4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number

4350: ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2

Line 4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2

4351: ,P_PEOPLE_GROUP_ID IN NUMBER default hr_api.g_number
4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4359: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2

Line 4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2

4352: ,P_SOFT_CODING_KEYFLEX_ID IN NUMBER default hr_api.g_number
4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4359: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4360: ,P_COMMENT_ID OUT NOCOPY NUMBER

Line 4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number

4353: ,P_VACANCY_ID IN NUMBER default hr_api.g_number
4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4359: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4360: ,P_COMMENT_ID OUT NOCOPY NUMBER
4361: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2

Line 4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2

4354: ,P_PAY_BASIS_ID IN NUMBER default hr_api.g_number
4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4359: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4360: ,P_COMMENT_ID OUT NOCOPY NUMBER
4361: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4362: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date

Line 4359: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2

4355: ,P_ASSIGNMENT_TYPE IN VARCHAR2 default hr_api.g_varchar2
4356: ,P_PRIMARY_FLAG IN VARCHAR2 default hr_api.g_varchar2
4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4359: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4360: ,P_COMMENT_ID OUT NOCOPY NUMBER
4361: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4362: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4363:

Line 4361: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2

4357: ,P_APPLICATION_ID IN NUMBER default hr_api.g_number
4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4359: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4360: ,P_COMMENT_ID OUT NOCOPY NUMBER
4361: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4362: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4363:
4364: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 4362: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date

4358: ,P_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4359: ,P_CHANGE_REASON IN VARCHAR2 default hr_api.g_varchar2
4360: ,P_COMMENT_ID OUT NOCOPY NUMBER
4361: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4362: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4363:
4364: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

Line 4364: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number

4360: ,P_COMMENT_ID OUT NOCOPY NUMBER
4361: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4362: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4363:
4364: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2

Line 4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

4361: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
4362: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4363:
4364: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number

Line 4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

4362: ,P_DATE_PROBATION_END IN DATE default hr_api.g_date
4363:
4364: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number

Line 4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2

4363:
4364: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

Line 4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2

4364: ,P_DEFAULT_CODE_COMB_ID IN NUMBER default hr_api.g_number
4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number

Line 4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number

4365: ,P_EMPLOYMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number

Line 4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number

4366: ,P_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2

Line 4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

4367: ,P_INTERNAL_ADDRESS_LINE IN VARCHAR2 default hr_api.g_varchar2
4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number

Line 4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number

4368: ,P_MANAGER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

Line 4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number

4369: ,P_NORMAL_HOURS IN NUMBER default hr_api.g_number
4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number

Line 4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2

4370: ,P_PERF_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4378:

Line 4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number

4371: ,P_PERF_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4378:
4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2

Line 4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2

4372: ,P_PERIOD_OF_SERVICE_ID IN NUMBER default hr_api.g_number
4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4378:
4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2

Line 4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number

4373: ,P_PROBATION_PERIOD IN NUMBER default hr_api.g_number
4374: ,P_PROBATION_UNIT IN VARCHAR2 default hr_api.g_varchar2
4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4378:
4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2

Line 4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2

4375: ,P_SAL_REVIEW_PERIOD IN NUMBER default hr_api.g_number
4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4378:
4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2

Line 4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2

4376: ,P_SAL_REVIEW_PERIOD_FREQUENCY IN VARCHAR2 default hr_api.g_varchar2
4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4378:
4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2

Line 4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2

4377: ,P_SET_OF_BOOKS_ID IN NUMBER default hr_api.g_number
4378:
4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number

Line 4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2

4378:
4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number

Line 4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2

4379: ,P_SOURCE_TYPE IN VARCHAR2 default hr_api.g_varchar2
4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number

Line 4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2

4380: ,P_TIME_NORMAL_FINISH IN VARCHAR2 default hr_api.g_varchar2
4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date

Line 4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number

4381: ,P_TIME_NORMAL_START IN VARCHAR2 default hr_api.g_varchar2
4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number

4382: ,P_BARGAINING_UNIT_CODE IN VARCHAR2 default hr_api.g_varchar2
4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

Line 4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number

4383: ,P_LABOUR_UNION_MEMBER_FLAG IN VARCHAR2 default hr_api.g_varchar2
4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

Line 4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date

4384: ,P_HOURLY_SALARIED_CODE IN VARCHAR2 default hr_api.g_varchar2
4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

Line 4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

4385: ,P_REQUEST_ID IN NUMBER default hr_api.g_number
4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

Line 4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

4386: ,P_PROGRAM_APPLICATION_ID IN NUMBER default hr_api.g_number
4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

Line 4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

4387: ,P_PROGRAM_ID IN NUMBER default hr_api.g_number
4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4395:

Line 4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

4388: ,P_PROGRAM_UPDATE_DATE IN DATE default hr_api.g_date
4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4395:
4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

Line 4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

4389: ,P_ASS_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4395:
4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

Line 4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

4390: ,P_ASS_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
4391: ,P_ASS_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4395:
4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

Line 4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

4392: ,P_ASS_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4395:
4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

Line 4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

4393: ,P_ASS_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4395:
4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

Line 4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

4394: ,P_ASS_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
4395:
4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

Line 4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2

4395:
4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

Line 4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

4396: ,P_ASS_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

Line 4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

4397: ,P_ASS_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

Line 4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

4398: ,P_ASS_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

Line 4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

4399: ,P_ASS_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

Line 4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

4400: ,P_ASS_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

Line 4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

4401: ,P_ASS_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4409:

Line 4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

4402: ,P_ASS_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4409:
4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

Line 4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

4403: ,P_ASS_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4409:
4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

Line 4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

4404: ,P_ASS_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
4405: ,P_ASS_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4409:
4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

Line 4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

4406: ,P_ASS_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4409:
4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

Line 4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

4407: ,P_ASS_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4409:
4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

Line 4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

4408: ,P_ASS_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
4409:
4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

Line 4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2

4409:
4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

Line 4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

4410: ,P_ASS_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

Line 4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

4411: ,P_ASS_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

Line 4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

4412: ,P_ASS_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

Line 4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

4413: ,P_ASS_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

Line 4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

4414: ,P_ASS_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2

Line 4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

4415: ,P_ASS_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number

Line 4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

4416: ,P_ASS_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number

Line 4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

4417: ,P_ASS_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number

Line 4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2

4418: ,P_ASS_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number

Line 4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number

4419: ,P_ASS_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number

Line 4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number

4420: ,P_ASS_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4428: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER

Line 4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number

4421: ,P_ASS_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4428: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number

Line 4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number

4422: ,P_TITLE IN VARCHAR2 default hr_api.g_varchar2
4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4428: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2

Line 4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number

4423: ,P_CONTRACT_ID IN NUMBER default hr_api.g_number
4424: ,P_ESTABLISHMENT_ID IN NUMBER default hr_api.g_number
4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4428: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number

4425: ,P_COLLECTIVE_AGREEMENT_ID IN NUMBER default hr_api.g_number
4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4428: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2

Line 4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2

4426: ,P_CAGR_GRADE_DEF_ID IN NUMBER default hr_api.g_number
4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4428: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number

Line 4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

4427: ,P_CAGR_ID_FLEX_NUM IN NUMBER default hr_api.g_number
4428: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date

Line 4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2

4428: ,P_ASG_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number

Line 4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2

4429: ,P_NOTICE_PERIOD IN NUMBER default hr_api.g_number
4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2

Line 4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number

4430: ,P_NOTICE_PERIOD_UOM IN VARCHAR2 default hr_api.g_varchar2
4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2

Line 4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date

4431: ,P_EMPLOYEE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number

4432: ,P_WORK_AT_HOME IN VARCHAR2 default hr_api.g_varchar2
4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2

Line 4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2

4433: ,P_JOB_POST_SOURCE_NAME IN VARCHAR2 default hr_api.g_varchar2
4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number

Line 4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2

4434: ,P_POSTING_CONTENT_ID IN NUMBER default hr_api.g_number
4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number

Line 4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

4435: ,P_PLACEMENT_DATE_START IN DATE default hr_api.g_date
4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

Line 4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2

4436: ,P_VENDOR_ID IN NUMBER default hr_api.g_number
4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number

Line 4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number

4437: ,P_VENDOR_EMPLOYEE_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4445: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number

Line 4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number

4438: ,P_VENDOR_ASSIGNMENT_NUMBER IN VARCHAR2 default hr_api.g_varchar2
4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4445: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4446: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number

Line 4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number

4439: ,P_ASSIGNMENT_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4445: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4446: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4447: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date

Line 4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number

4440: ,P_PROJECT_TITLE IN VARCHAR2 default hr_api.g_varchar2
4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4445: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4446: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4447: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
4448: ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN

Line 4445: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number

4441: ,P_APPLICANT_RANK IN NUMBER default hr_api.g_number
4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4445: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4446: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4447: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
4448: ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN
4449: ,P_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN

Line 4446: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number

4442: ,P_GRADE_LADDER_PGM_ID IN NUMBER default hr_api.g_number
4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4445: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4446: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4447: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
4448: ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN
4449: ,P_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN
4450: ,P_HOURLY_SALARIED_WARNING OUT NOCOPY BOOLEAN

Line 4447: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date

4443: ,P_SUPERVISOR_ASSIGNMENT_ID IN NUMBER default hr_api.g_number
4444: ,P_VENDOR_SITE_ID IN NUMBER default hr_api.g_number
4445: ,P_PO_HEADER_ID IN NUMBER default hr_api.g_number
4446: ,P_PO_LINE_ID IN NUMBER default hr_api.g_number
4447: ,P_PROJECTED_ASSIGNMENT_END IN DATE default hr_api.g_date
4448: ,P_PAYROLL_ID_UPDATED OUT NOCOPY BOOLEAN
4449: ,P_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN
4450: ,P_HOURLY_SALARIED_WARNING OUT NOCOPY BOOLEAN
4451: ,P_NO_MANAGERS_WARNING OUT NOCOPY BOOLEAN

Line 4456: ,P_DATETRACK_MODE IN VARCHAR2 default hr_api.g_update

4452: ,P_ORG_NOW_NO_MANAGER_WARNING OUT NOCOPY BOOLEAN
4453: ,P_VALIDATION_START_DATE OUT NOCOPY DATE
4454: ,P_VALIDATION_END_DATE OUT NOCOPY DATE
4455: ,P_EFFECTIVE_DATE IN DATE default null
4456: ,P_DATETRACK_MODE IN VARCHAR2 default hr_api.g_update
4457: ,P_VALIDATE IN BOOLEAN default false
4458: ,P_OFFER_ID IN OUT NOCOPY NUMBER
4459: ,P_OFFER_STATUS IN VARCHAR2 default null
4460: ) Is

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

4480:
4481: l_prev_offer_status irc_offers.offer_status%TYPE;
4482: l_iof_object_version_number irc_offers.object_version_number%TYPE;
4483: l_offer_version irc_offers.offer_version%TYPE;
4484: l_datetrack_mode varchar2(30) := hr_api.g_update;
4485: --
4486: cursor csr_prev_offer_details is
4487: select offer_status
4488: ,offer_assignment_id

Line 4602: l_datetrack_mode := hr_api.g_correction;

4598: --
4599: -- Since the current record has started today, we need to
4600: -- correct the existing record.
4601: --
4602: l_datetrack_mode := hr_api.g_correction;
4603: else
4604: --
4605: -- End the existing record and create a new record.
4606: --

Line 4607: l_datetrack_mode := hr_api.g_update;

4603: else
4604: --
4605: -- End the existing record and create a new record.
4606: --
4607: l_datetrack_mode := hr_api.g_update;
4608: --
4609: end if;
4610: --
4611: if l_prev_offer_status = 'HOLD'

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

4726: );
4727: --
4728: -- Since a new offer assignment record has been created, we will
4729: -- be updating the assignment_record again on the same day of creation.
4730: -- We hence need to set the date track mode to 'hr_api.g_correction'
4731: --
4732: l_datetrack_mode := hr_api.g_correction;
4733: --
4734: end if; -- l_create_new_version

Line 4732: l_datetrack_mode := hr_api.g_correction;

4728: -- Since a new offer assignment record has been created, we will
4729: -- be updating the assignment_record again on the same day of creation.
4730: -- We hence need to set the date track mode to 'hr_api.g_correction'
4731: --
4732: l_datetrack_mode := hr_api.g_correction;
4733: --
4734: end if; -- l_create_new_version
4735: --
4736: hr_utility.set_location(l_proc, 60);

Line 4873: raise hr_api.validate_enabled;

4869: --
4870: -- When in validation only mode raise the Validate_Enabled exception
4871: --
4872: if p_validate then
4873: raise hr_api.validate_enabled;
4874: end if;
4875: --
4876: -- Set all IN OUT and OUT parameters with out values
4877: --

Line 4896: when hr_api.validate_enabled then

4892:
4893: hr_utility.set_location(' Leaving:'||l_proc, 145);
4894: --
4895: exception
4896: when hr_api.validate_enabled then
4897: --
4898: -- As the Validate_Enabled exception has been raised
4899: -- we must rollback to the savepoint
4900: --

Line 5011: raise hr_api.validate_enabled;

5007: --
5008: -- When in validation only mode raise the Validate_Enabled exception
5009: --
5010: if p_validate then
5011: raise hr_api.validate_enabled;
5012: end if;
5013: --
5014: hr_utility.set_location(' Leaving:'||l_proc, 40);
5015: --

Line 5017: when hr_api.validate_enabled then

5013: --
5014: hr_utility.set_location(' Leaving:'||l_proc, 40);
5015: --
5016: exception
5017: when hr_api.validate_enabled then
5018: --
5019: -- As the Validate_Enabled exception has been raised
5020: -- we must rollback to the savepoint
5021: --

Line 5072: raise hr_api.validate_enabled;

5068: --
5069: -- When in validation only mode raise the Validate_Enabled exception
5070: --
5071: if p_validate then
5072: raise hr_api.validate_enabled;
5073: end if;
5074: --
5075: hr_utility.set_location(' Leaving:'||l_proc, 40);
5076: exception

Line 5077: when hr_api.validate_enabled then

5073: end if;
5074: --
5075: hr_utility.set_location(' Leaving:'||l_proc, 40);
5076: exception
5077: when hr_api.validate_enabled then
5078: --
5079: -- As the Validate_Enabled exception has been raised
5080: -- we must rollback to the savepoint
5081: --