DBA Data[Home] [Help]

APPS.HR_HK_PERSON_API dependencies on HR_API

Line 16: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number

12: ,p_effective_date IN DATE
13: ,p_datetrack_update_mode IN VARCHAR2
14: ,p_person_id IN NUMBER
15: ,p_object_version_number IN OUT NOCOPY NUMBER
16: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
17: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
19: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date

Line 17: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

13: ,p_datetrack_update_mode IN VARCHAR2
14: ,p_person_id IN NUMBER
15: ,p_object_version_number IN OUT NOCOPY NUMBER
16: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
17: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
19: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date

Line 18: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

14: ,p_person_id IN NUMBER
15: ,p_object_version_number IN OUT NOCOPY NUMBER
16: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
17: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
19: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 19: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2

15: ,p_object_version_number IN OUT NOCOPY NUMBER
16: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
17: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
19: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
23: ,p_employee_number IN OUT NOCOPY VARCHAR2

Line 20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date

16: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
17: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
19: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
23: ,p_employee_number IN OUT NOCOPY VARCHAR2
24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date

17: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
18: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
19: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
23: ,p_employee_number IN OUT NOCOPY VARCHAR2
24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2

18: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
19: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
23: ,p_employee_number IN OUT NOCOPY VARCHAR2
24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2

20: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
23: ,p_employee_number IN OUT NOCOPY VARCHAR2
24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

21: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
23: ,p_employee_number IN OUT NOCOPY VARCHAR2
24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2

22: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
23: ,p_employee_number IN OUT NOCOPY VARCHAR2
24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

23: ,p_employee_number IN OUT NOCOPY VARCHAR2
24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2

24: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2

25: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

26: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

27: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number

Line 32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

28: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2

29: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2

30: ,p_hkid_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number

31: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2

32: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

33: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

34: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

35: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

36: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

37: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

38: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

39: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

40: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

41: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

42: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

43: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

44: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

45: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

46: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

47: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

48: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

49: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

50: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

51: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

52: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

53: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

54: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

55: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

56: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

57: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

58: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

59: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

60: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

61: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

62: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

63: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

64: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2

65: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

66: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2

67: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

68: ,p_passport_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

69: ,p_country_of_issue IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date

Line 74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

70: ,p_work_permit_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2

71: ,p_work_permit_expiry_date IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date

Line 76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

72: ,p_chinese_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date

73: ,p_hk_full_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

74: ,p_previous_employer_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date

75: ,p_previous_employer_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number

Line 80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

76: ,p_employee_tax_file_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date

Line 81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2

77: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2

78: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number

79: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date

80: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date

Line 85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2

81: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2

82: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2

83: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date

84: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2

85: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date

Line 90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

86: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2

87: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2

88: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date

89: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date

Line 94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2

90: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2

91: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

92: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date

93: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

94: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

95: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
103: ,p_benefit_group_id in number default hr_api.g_number

Line 100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2

96: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
103: ,p_benefit_group_id in number default hr_api.g_number
104: ,p_receipt_of_death_cert_date in date default hr_api.g_date

Line 101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2

97: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
103: ,p_benefit_group_id in number default hr_api.g_number
104: ,p_receipt_of_death_cert_date in date default hr_api.g_date
105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2

Line 102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2

98: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
103: ,p_benefit_group_id in number default hr_api.g_number
104: ,p_receipt_of_death_cert_date in date default hr_api.g_date
105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 103: ,p_benefit_group_id in number default hr_api.g_number

99: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
103: ,p_benefit_group_id in number default hr_api.g_number
104: ,p_receipt_of_death_cert_date in date default hr_api.g_date
105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 104: ,p_receipt_of_death_cert_date in date default hr_api.g_date

100: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
103: ,p_benefit_group_id in number default hr_api.g_number
104: ,p_receipt_of_death_cert_date in date default hr_api.g_date
105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
108: ,p_dpdnt_adoption_date in date default hr_api.g_date

Line 105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2

101: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
103: ,p_benefit_group_id in number default hr_api.g_number
104: ,p_receipt_of_death_cert_date in date default hr_api.g_date
105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
108: ,p_dpdnt_adoption_date in date default hr_api.g_date
109: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

102: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
103: ,p_benefit_group_id in number default hr_api.g_number
104: ,p_receipt_of_death_cert_date in date default hr_api.g_date
105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
108: ,p_dpdnt_adoption_date in date default hr_api.g_date
109: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
110: ,p_original_date_of_hire in date default hr_api.g_date

Line 107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

103: ,p_benefit_group_id in number default hr_api.g_number
104: ,p_receipt_of_death_cert_date in date default hr_api.g_date
105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
108: ,p_dpdnt_adoption_date in date default hr_api.g_date
109: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
110: ,p_original_date_of_hire in date default hr_api.g_date
111: ,p_adjusted_svc_date in date default hr_api.g_date

Line 108: ,p_dpdnt_adoption_date in date default hr_api.g_date

104: ,p_receipt_of_death_cert_date in date default hr_api.g_date
105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
108: ,p_dpdnt_adoption_date in date default hr_api.g_date
109: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
110: ,p_original_date_of_hire in date default hr_api.g_date
111: ,p_adjusted_svc_date in date default hr_api.g_date
112: ,p_effective_start_date OUT NOCOPY DATE

Line 109: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

105: ,p_coord_ben_med_pln_no in VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
108: ,p_dpdnt_adoption_date in date default hr_api.g_date
109: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
110: ,p_original_date_of_hire in date default hr_api.g_date
111: ,p_adjusted_svc_date in date default hr_api.g_date
112: ,p_effective_start_date OUT NOCOPY DATE
113: ,p_effective_end_date OUT NOCOPY DATE

Line 110: ,p_original_date_of_hire in date default hr_api.g_date

106: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
108: ,p_dpdnt_adoption_date in date default hr_api.g_date
109: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
110: ,p_original_date_of_hire in date default hr_api.g_date
111: ,p_adjusted_svc_date in date default hr_api.g_date
112: ,p_effective_start_date OUT NOCOPY DATE
113: ,p_effective_end_date OUT NOCOPY DATE
114: ,p_full_name OUT NOCOPY VARCHAR2

Line 111: ,p_adjusted_svc_date in date default hr_api.g_date

107: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
108: ,p_dpdnt_adoption_date in date default hr_api.g_date
109: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
110: ,p_original_date_of_hire in date default hr_api.g_date
111: ,p_adjusted_svc_date in date default hr_api.g_date
112: ,p_effective_start_date OUT NOCOPY DATE
113: ,p_effective_end_date OUT NOCOPY DATE
114: ,p_full_name OUT NOCOPY VARCHAR2
115: ,p_comment_id OUT NOCOPY NUMBER