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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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: --
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
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
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: );