DBA Data[Home] [Help]

APPS.HR_AU_PERSON_API dependencies on HR_API

Line 43: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number

39: ,p_effective_date IN DATE
40: ,p_datetrack_update_mode IN VARCHAR2
41: ,p_person_id IN NUMBER
42: ,p_object_version_number IN OUT NOCOPY NUMBER
43: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
44: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date

Line 44: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

40: ,p_datetrack_update_mode IN VARCHAR2
41: ,p_person_id IN NUMBER
42: ,p_object_version_number IN OUT NOCOPY NUMBER
43: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
44: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date

Line 45: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

41: ,p_person_id IN NUMBER
42: ,p_object_version_number IN OUT NOCOPY NUMBER
43: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
44: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2

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

42: ,p_object_version_number IN OUT NOCOPY NUMBER
43: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
44: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_employee_number IN OUT NOCOPY VARCHAR2

Line 47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date

43: ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
44: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_employee_number IN OUT NOCOPY VARCHAR2
51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date

44: ,p_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
45: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_employee_number IN OUT NOCOPY VARCHAR2
51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2

45: ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
46: ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_employee_number IN OUT NOCOPY VARCHAR2
51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2

47: ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_employee_number IN OUT NOCOPY VARCHAR2
51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

48: ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_employee_number IN OUT NOCOPY VARCHAR2
51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2

49: ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
50: ,p_employee_number IN OUT NOCOPY VARCHAR2
51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

50: ,p_employee_number IN OUT NOCOPY VARCHAR2
51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2

51: ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2

52: ,p_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2

53: ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

54: ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number

Line 59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

55: ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2

56: ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2

57: ,p_national_identifier IN VARCHAR2 DEFAULT hr_api.g_varchar2
58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number

58: ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2

59: ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

60: ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

61: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

62: ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

63: ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

64: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

65: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

66: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

67: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

68: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

69: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

70: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

71: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

72: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

73: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

74: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

75: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

76: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

77: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

78: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

79: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

80: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2

81: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2

82: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2

83: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2

84: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2

85: ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2

86: ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2

87: ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2

88: ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date

Line 93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2

89: ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2

90: ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date

Line 95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2

91: ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date

92: ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

93: ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date

94: ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number

Line 99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2

95: ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date

Line 100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2

96: ,p_date_of_death IN DATE DEFAULT hr_api.g_date
97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2

97: ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number

98: ,p_background_date_check IN DATE DEFAULT hr_api.g_date
99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date

99: ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date

Line 104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2

100: ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2

101: ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2

102: ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date

103: ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2

104: ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date

Line 109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2

105: ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2

106: ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2

107: ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date

108: ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date

Line 113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2

109: ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2

110: ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

111: ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date

112: ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2

113: ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2

114: ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
122: ,p_benefit_group_id in number default hr_api.g_number

Line 119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2

115: ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
122: ,p_benefit_group_id in number default hr_api.g_number
123: ,p_receipt_of_death_cert_date in date default hr_api.g_date

Line 120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2

116: ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
122: ,p_benefit_group_id in number default hr_api.g_number
123: ,p_receipt_of_death_cert_date in date default hr_api.g_date
124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2

Line 121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2

117: ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
122: ,p_benefit_group_id in number default hr_api.g_number
123: ,p_receipt_of_death_cert_date in date default hr_api.g_date
124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2
125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 122: ,p_benefit_group_id in number default hr_api.g_number

118: ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
122: ,p_benefit_group_id in number default hr_api.g_number
123: ,p_receipt_of_death_cert_date in date default hr_api.g_date
124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2
125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 123: ,p_receipt_of_death_cert_date in date default hr_api.g_date

119: ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
122: ,p_benefit_group_id in number default hr_api.g_number
123: ,p_receipt_of_death_cert_date in date default hr_api.g_date
124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2
125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
127: ,p_dpdnt_adoption_date in date default hr_api.g_date

Line 124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2

120: ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
122: ,p_benefit_group_id in number default hr_api.g_number
123: ,p_receipt_of_death_cert_date in date default hr_api.g_date
124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2
125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
127: ,p_dpdnt_adoption_date in date default hr_api.g_date
128: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

121: ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
122: ,p_benefit_group_id in number default hr_api.g_number
123: ,p_receipt_of_death_cert_date in date default hr_api.g_date
124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2
125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
127: ,p_dpdnt_adoption_date in date default hr_api.g_date
128: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
129: ,p_original_date_of_hire in date default hr_api.g_date

Line 126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

122: ,p_benefit_group_id in number default hr_api.g_number
123: ,p_receipt_of_death_cert_date in date default hr_api.g_date
124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2
125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
127: ,p_dpdnt_adoption_date in date default hr_api.g_date
128: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
129: ,p_original_date_of_hire in date default hr_api.g_date
130: ,p_adjusted_svc_date in date default hr_api.g_date

Line 127: ,p_dpdnt_adoption_date in date default hr_api.g_date

123: ,p_receipt_of_death_cert_date in date default hr_api.g_date
124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2
125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
127: ,p_dpdnt_adoption_date in date default hr_api.g_date
128: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
129: ,p_original_date_of_hire in date default hr_api.g_date
130: ,p_adjusted_svc_date in date default hr_api.g_date
131: ,p_effective_start_date OUT NOCOPY DATE

Line 128: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

124: ,p_coord_ben_med_pln_no in VARCHAR2 default hr_api.g_varchar2
125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
127: ,p_dpdnt_adoption_date in date default hr_api.g_date
128: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
129: ,p_original_date_of_hire in date default hr_api.g_date
130: ,p_adjusted_svc_date in date default hr_api.g_date
131: ,p_effective_start_date OUT NOCOPY DATE
132: ,p_effective_end_date OUT NOCOPY DATE

Line 129: ,p_original_date_of_hire in date default hr_api.g_date

125: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
127: ,p_dpdnt_adoption_date in date default hr_api.g_date
128: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
129: ,p_original_date_of_hire in date default hr_api.g_date
130: ,p_adjusted_svc_date in date default hr_api.g_date
131: ,p_effective_start_date OUT NOCOPY DATE
132: ,p_effective_end_date OUT NOCOPY DATE
133: ,p_full_name OUT NOCOPY VARCHAR2

Line 130: ,p_adjusted_svc_date in date default hr_api.g_date

126: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
127: ,p_dpdnt_adoption_date in date default hr_api.g_date
128: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
129: ,p_original_date_of_hire in date default hr_api.g_date
130: ,p_adjusted_svc_date in date default hr_api.g_date
131: ,p_effective_start_date OUT NOCOPY DATE
132: ,p_effective_end_date OUT NOCOPY DATE
133: ,p_full_name OUT NOCOPY VARCHAR2
134: ,p_comment_id OUT NOCOPY NUMBER