APPS.PQH_FR_EMP_STAT_SIT_UTILITY dependencies on HR_API

Line 10: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

6: -- This procedure is the self-service wrapper procedure to the following
7: -- API: pqh_fr_emp_stat_situation_api.create_emp_stat_situation
8: -- ---------------------------------------------------------------------------
9: PROCEDURE create_emp_stat_situation
10: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
11: ,p_effective_date IN DATE
12: ,p_statutory_situation_id IN NUMBER
13: ,p_person_id IN NUMBER
14: ,p_provisional_start_date IN DATE

Line 68: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

64: -- This procedure is the self-service wrapper procedure to the following
65: -- API: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
66: -- ---------------------------------------------------------------------------
67: PROCEDURE update_emp_stat_situation
68: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
69: ,p_effective_date IN DATE
70: ,p_emp_stat_situation_id IN NUMBER
71: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
72: ,p_person_id IN NUMBER DEFAULT HR_API.g_number

Line 71: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number

67: PROCEDURE update_emp_stat_situation
68: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
69: ,p_effective_date IN DATE
70: ,p_emp_stat_situation_id IN NUMBER
71: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
72: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
73: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date

Line 72: ,p_person_id IN NUMBER DEFAULT HR_API.g_number

68: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
69: ,p_effective_date IN DATE
70: ,p_emp_stat_situation_id IN NUMBER
71: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
72: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
73: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date

Line 73: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date

69: ,p_effective_date IN DATE
70: ,p_emp_stat_situation_id IN NUMBER
71: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
72: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
73: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date

70: ,p_emp_stat_situation_id IN NUMBER
71: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
72: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
73: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date

71: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
72: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
73: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number

Line 76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date

72: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
73: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2

73: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number

Line 78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2

74: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number

75: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number

Line 80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2

76: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number

Line 81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number

77: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2

78: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number

79: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number

80: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2

81: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2

82: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2

83: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2

84: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2

85: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2

86: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2

87: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2

88: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2

89: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2

90: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2

91: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2

92: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2

93: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2

94: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2

95: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2

96: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2

97: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2

98: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2

99: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2

100: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2

101: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2

102: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2

103: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2

104: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2

105: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2

106: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
114: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2

107: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
114: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2

108: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
114: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
116: ,p_object_version_number IN OUT nocopy NUMBER

Line 113: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2

109: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
114: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
116: ,p_object_version_number IN OUT nocopy NUMBER
117: ,p_return_status OUT nocopy VARCHAR2

Line 114: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2

110: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
114: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
116: ,p_object_version_number IN OUT nocopy NUMBER
117: ,p_return_status OUT nocopy VARCHAR2
118: );

Line 115: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2

111: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
113: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
114: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
115: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
116: ,p_object_version_number IN OUT nocopy NUMBER
117: ,p_return_status OUT nocopy VARCHAR2
118: );
119: --

Line 126: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

122: -- This procedure is the self-service wrapper procedure to the following
123: -- API: pqh_fr_emp_stat_situation_api.reinstate_emp_stat_situation
124: -- ---------------------------------------------------------------------------
125: PROCEDURE reinstate_emp_stat_situation
126: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
127: ,p_person_id IN NUMBER
128: ,p_emp_stat_situation_id IN NUMBER
129: ,p_reinstate_date IN DATE
130: ,p_comments IN VARCHAR2

Line 141: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

137: -- This procedure is the self-service wrapper procedure to the following
138: -- API: pqh_fr_emp_stat_situation_api.renew_emp_stat_situation
139: -- ---------------------------------------------------------------------------
140: PROCEDURE renew_emp_stat_situation
141: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
142: ,p_emp_stat_situation_id IN OUT nocopy NUMBER
143: ,p_renew_stat_situation_id IN NUMBER
144: ,p_renewal_duration IN NUMBER
145: ,p_duration_units IN VARCHAR2

Line 158: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

154: -- This procedure is the self-service wrapper procedure to the following
155: -- API: pqh_fr_emp_stat_situation_api.delete_emp_stat_situation
156: -- ---------------------------------------------------------------------------
157: PROCEDURE delete_emp_stat_situation
158: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
159: ,p_emp_stat_situation_id IN NUMBER
160: ,p_object_version_number IN NUMBER
161: ,p_return_status OUT nocopy VARCHAR2
162: );