DBA Data[Home] [Help]

APPS.SSP_MAT_UPD dependencies on HR_API

Line 50: -- by raising and handling the exception hr_api.validate_enabled. We use

46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- process and is rollbacked at the end of the process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: --

Line 125: p_due_date in date default hr_api.g_date,

121: Procedure upd
122: (
123: p_maternity_id in number,
124: p_object_version_number in out nocopy number,
125: p_due_date in date default hr_api.g_date,
126: p_start_date_SMA in date default hr_api.g_date,
127: p_notification_of_birth_date in date default hr_api.g_date,
128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
129: p_stated_return_date in date default hr_api.g_date,

Line 126: p_start_date_SMA in date default hr_api.g_date,

122: (
123: p_maternity_id in number,
124: p_object_version_number in out nocopy number,
125: p_due_date in date default hr_api.g_date,
126: p_start_date_SMA in date default hr_api.g_date,
127: p_notification_of_birth_date in date default hr_api.g_date,
128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
129: p_stated_return_date in date default hr_api.g_date,
130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,

Line 127: p_notification_of_birth_date in date default hr_api.g_date,

123: p_maternity_id in number,
124: p_object_version_number in out nocopy number,
125: p_due_date in date default hr_api.g_date,
126: p_start_date_SMA in date default hr_api.g_date,
127: p_notification_of_birth_date in date default hr_api.g_date,
128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
129: p_stated_return_date in date default hr_api.g_date,
130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
131: p_start_date_with_new_employer in date default hr_api.g_date,

Line 128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,

124: p_object_version_number in out nocopy number,
125: p_due_date in date default hr_api.g_date,
126: p_start_date_SMA in date default hr_api.g_date,
127: p_notification_of_birth_date in date default hr_api.g_date,
128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
129: p_stated_return_date in date default hr_api.g_date,
130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
131: p_start_date_with_new_employer in date default hr_api.g_date,
132: p_smp_must_be_paid_by_date in date default hr_api.g_date,

Line 129: p_stated_return_date in date default hr_api.g_date,

125: p_due_date in date default hr_api.g_date,
126: p_start_date_SMA in date default hr_api.g_date,
127: p_notification_of_birth_date in date default hr_api.g_date,
128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
129: p_stated_return_date in date default hr_api.g_date,
130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
131: p_start_date_with_new_employer in date default hr_api.g_date,
132: p_smp_must_be_paid_by_date in date default hr_api.g_date,
133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,

Line 130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,

126: p_start_date_SMA in date default hr_api.g_date,
127: p_notification_of_birth_date in date default hr_api.g_date,
128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
129: p_stated_return_date in date default hr_api.g_date,
130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
131: p_start_date_with_new_employer in date default hr_api.g_date,
132: p_smp_must_be_paid_by_date in date default hr_api.g_date,
133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,

Line 131: p_start_date_with_new_employer in date default hr_api.g_date,

127: p_notification_of_birth_date in date default hr_api.g_date,
128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
129: p_stated_return_date in date default hr_api.g_date,
130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
131: p_start_date_with_new_employer in date default hr_api.g_date,
132: p_smp_must_be_paid_by_date in date default hr_api.g_date,
133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
135: p_actual_birth_date in date default hr_api.g_date,

Line 132: p_smp_must_be_paid_by_date in date default hr_api.g_date,

128: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
129: p_stated_return_date in date default hr_api.g_date,
130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
131: p_start_date_with_new_employer in date default hr_api.g_date,
132: p_smp_must_be_paid_by_date in date default hr_api.g_date,
133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
135: p_actual_birth_date in date default hr_api.g_date,
136: p_mpp_start_date in date default hr_api.g_date,

Line 133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,

129: p_stated_return_date in date default hr_api.g_date,
130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
131: p_start_date_with_new_employer in date default hr_api.g_date,
132: p_smp_must_be_paid_by_date in date default hr_api.g_date,
133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
135: p_actual_birth_date in date default hr_api.g_date,
136: p_mpp_start_date in date default hr_api.g_date,
137: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,

130: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
131: p_start_date_with_new_employer in date default hr_api.g_date,
132: p_smp_must_be_paid_by_date in date default hr_api.g_date,
133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
135: p_actual_birth_date in date default hr_api.g_date,
136: p_mpp_start_date in date default hr_api.g_date,
137: p_attribute_category in varchar2 default hr_api.g_varchar2,
138: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 135: p_actual_birth_date in date default hr_api.g_date,

131: p_start_date_with_new_employer in date default hr_api.g_date,
132: p_smp_must_be_paid_by_date in date default hr_api.g_date,
133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
135: p_actual_birth_date in date default hr_api.g_date,
136: p_mpp_start_date in date default hr_api.g_date,
137: p_attribute_category in varchar2 default hr_api.g_varchar2,
138: p_attribute1 in varchar2 default hr_api.g_varchar2,
139: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 136: p_mpp_start_date in date default hr_api.g_date,

132: p_smp_must_be_paid_by_date in date default hr_api.g_date,
133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
135: p_actual_birth_date in date default hr_api.g_date,
136: p_mpp_start_date in date default hr_api.g_date,
137: p_attribute_category in varchar2 default hr_api.g_varchar2,
138: p_attribute1 in varchar2 default hr_api.g_varchar2,
139: p_attribute2 in varchar2 default hr_api.g_varchar2,
140: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 137: p_attribute_category in varchar2 default hr_api.g_varchar2,

133: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
135: p_actual_birth_date in date default hr_api.g_date,
136: p_mpp_start_date in date default hr_api.g_date,
137: p_attribute_category in varchar2 default hr_api.g_varchar2,
138: p_attribute1 in varchar2 default hr_api.g_varchar2,
139: p_attribute2 in varchar2 default hr_api.g_varchar2,
140: p_attribute3 in varchar2 default hr_api.g_varchar2,
141: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 138: p_attribute1 in varchar2 default hr_api.g_varchar2,

134: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
135: p_actual_birth_date in date default hr_api.g_date,
136: p_mpp_start_date in date default hr_api.g_date,
137: p_attribute_category in varchar2 default hr_api.g_varchar2,
138: p_attribute1 in varchar2 default hr_api.g_varchar2,
139: p_attribute2 in varchar2 default hr_api.g_varchar2,
140: p_attribute3 in varchar2 default hr_api.g_varchar2,
141: p_attribute4 in varchar2 default hr_api.g_varchar2,
142: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 139: p_attribute2 in varchar2 default hr_api.g_varchar2,

135: p_actual_birth_date in date default hr_api.g_date,
136: p_mpp_start_date in date default hr_api.g_date,
137: p_attribute_category in varchar2 default hr_api.g_varchar2,
138: p_attribute1 in varchar2 default hr_api.g_varchar2,
139: p_attribute2 in varchar2 default hr_api.g_varchar2,
140: p_attribute3 in varchar2 default hr_api.g_varchar2,
141: p_attribute4 in varchar2 default hr_api.g_varchar2,
142: p_attribute5 in varchar2 default hr_api.g_varchar2,
143: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 140: p_attribute3 in varchar2 default hr_api.g_varchar2,

136: p_mpp_start_date in date default hr_api.g_date,
137: p_attribute_category in varchar2 default hr_api.g_varchar2,
138: p_attribute1 in varchar2 default hr_api.g_varchar2,
139: p_attribute2 in varchar2 default hr_api.g_varchar2,
140: p_attribute3 in varchar2 default hr_api.g_varchar2,
141: p_attribute4 in varchar2 default hr_api.g_varchar2,
142: p_attribute5 in varchar2 default hr_api.g_varchar2,
143: p_attribute6 in varchar2 default hr_api.g_varchar2,
144: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 141: p_attribute4 in varchar2 default hr_api.g_varchar2,

137: p_attribute_category in varchar2 default hr_api.g_varchar2,
138: p_attribute1 in varchar2 default hr_api.g_varchar2,
139: p_attribute2 in varchar2 default hr_api.g_varchar2,
140: p_attribute3 in varchar2 default hr_api.g_varchar2,
141: p_attribute4 in varchar2 default hr_api.g_varchar2,
142: p_attribute5 in varchar2 default hr_api.g_varchar2,
143: p_attribute6 in varchar2 default hr_api.g_varchar2,
144: p_attribute7 in varchar2 default hr_api.g_varchar2,
145: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 142: p_attribute5 in varchar2 default hr_api.g_varchar2,

138: p_attribute1 in varchar2 default hr_api.g_varchar2,
139: p_attribute2 in varchar2 default hr_api.g_varchar2,
140: p_attribute3 in varchar2 default hr_api.g_varchar2,
141: p_attribute4 in varchar2 default hr_api.g_varchar2,
142: p_attribute5 in varchar2 default hr_api.g_varchar2,
143: p_attribute6 in varchar2 default hr_api.g_varchar2,
144: p_attribute7 in varchar2 default hr_api.g_varchar2,
145: p_attribute8 in varchar2 default hr_api.g_varchar2,
146: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 143: p_attribute6 in varchar2 default hr_api.g_varchar2,

139: p_attribute2 in varchar2 default hr_api.g_varchar2,
140: p_attribute3 in varchar2 default hr_api.g_varchar2,
141: p_attribute4 in varchar2 default hr_api.g_varchar2,
142: p_attribute5 in varchar2 default hr_api.g_varchar2,
143: p_attribute6 in varchar2 default hr_api.g_varchar2,
144: p_attribute7 in varchar2 default hr_api.g_varchar2,
145: p_attribute8 in varchar2 default hr_api.g_varchar2,
146: p_attribute9 in varchar2 default hr_api.g_varchar2,
147: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 144: p_attribute7 in varchar2 default hr_api.g_varchar2,

140: p_attribute3 in varchar2 default hr_api.g_varchar2,
141: p_attribute4 in varchar2 default hr_api.g_varchar2,
142: p_attribute5 in varchar2 default hr_api.g_varchar2,
143: p_attribute6 in varchar2 default hr_api.g_varchar2,
144: p_attribute7 in varchar2 default hr_api.g_varchar2,
145: p_attribute8 in varchar2 default hr_api.g_varchar2,
146: p_attribute9 in varchar2 default hr_api.g_varchar2,
147: p_attribute10 in varchar2 default hr_api.g_varchar2,
148: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 145: p_attribute8 in varchar2 default hr_api.g_varchar2,

141: p_attribute4 in varchar2 default hr_api.g_varchar2,
142: p_attribute5 in varchar2 default hr_api.g_varchar2,
143: p_attribute6 in varchar2 default hr_api.g_varchar2,
144: p_attribute7 in varchar2 default hr_api.g_varchar2,
145: p_attribute8 in varchar2 default hr_api.g_varchar2,
146: p_attribute9 in varchar2 default hr_api.g_varchar2,
147: p_attribute10 in varchar2 default hr_api.g_varchar2,
148: p_attribute11 in varchar2 default hr_api.g_varchar2,
149: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 146: p_attribute9 in varchar2 default hr_api.g_varchar2,

142: p_attribute5 in varchar2 default hr_api.g_varchar2,
143: p_attribute6 in varchar2 default hr_api.g_varchar2,
144: p_attribute7 in varchar2 default hr_api.g_varchar2,
145: p_attribute8 in varchar2 default hr_api.g_varchar2,
146: p_attribute9 in varchar2 default hr_api.g_varchar2,
147: p_attribute10 in varchar2 default hr_api.g_varchar2,
148: p_attribute11 in varchar2 default hr_api.g_varchar2,
149: p_attribute12 in varchar2 default hr_api.g_varchar2,
150: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 147: p_attribute10 in varchar2 default hr_api.g_varchar2,

143: p_attribute6 in varchar2 default hr_api.g_varchar2,
144: p_attribute7 in varchar2 default hr_api.g_varchar2,
145: p_attribute8 in varchar2 default hr_api.g_varchar2,
146: p_attribute9 in varchar2 default hr_api.g_varchar2,
147: p_attribute10 in varchar2 default hr_api.g_varchar2,
148: p_attribute11 in varchar2 default hr_api.g_varchar2,
149: p_attribute12 in varchar2 default hr_api.g_varchar2,
150: p_attribute13 in varchar2 default hr_api.g_varchar2,
151: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 148: p_attribute11 in varchar2 default hr_api.g_varchar2,

144: p_attribute7 in varchar2 default hr_api.g_varchar2,
145: p_attribute8 in varchar2 default hr_api.g_varchar2,
146: p_attribute9 in varchar2 default hr_api.g_varchar2,
147: p_attribute10 in varchar2 default hr_api.g_varchar2,
148: p_attribute11 in varchar2 default hr_api.g_varchar2,
149: p_attribute12 in varchar2 default hr_api.g_varchar2,
150: p_attribute13 in varchar2 default hr_api.g_varchar2,
151: p_attribute14 in varchar2 default hr_api.g_varchar2,
152: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 149: p_attribute12 in varchar2 default hr_api.g_varchar2,

145: p_attribute8 in varchar2 default hr_api.g_varchar2,
146: p_attribute9 in varchar2 default hr_api.g_varchar2,
147: p_attribute10 in varchar2 default hr_api.g_varchar2,
148: p_attribute11 in varchar2 default hr_api.g_varchar2,
149: p_attribute12 in varchar2 default hr_api.g_varchar2,
150: p_attribute13 in varchar2 default hr_api.g_varchar2,
151: p_attribute14 in varchar2 default hr_api.g_varchar2,
152: p_attribute15 in varchar2 default hr_api.g_varchar2,
153: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 150: p_attribute13 in varchar2 default hr_api.g_varchar2,

146: p_attribute9 in varchar2 default hr_api.g_varchar2,
147: p_attribute10 in varchar2 default hr_api.g_varchar2,
148: p_attribute11 in varchar2 default hr_api.g_varchar2,
149: p_attribute12 in varchar2 default hr_api.g_varchar2,
150: p_attribute13 in varchar2 default hr_api.g_varchar2,
151: p_attribute14 in varchar2 default hr_api.g_varchar2,
152: p_attribute15 in varchar2 default hr_api.g_varchar2,
153: p_attribute16 in varchar2 default hr_api.g_varchar2,
154: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 151: p_attribute14 in varchar2 default hr_api.g_varchar2,

147: p_attribute10 in varchar2 default hr_api.g_varchar2,
148: p_attribute11 in varchar2 default hr_api.g_varchar2,
149: p_attribute12 in varchar2 default hr_api.g_varchar2,
150: p_attribute13 in varchar2 default hr_api.g_varchar2,
151: p_attribute14 in varchar2 default hr_api.g_varchar2,
152: p_attribute15 in varchar2 default hr_api.g_varchar2,
153: p_attribute16 in varchar2 default hr_api.g_varchar2,
154: p_attribute17 in varchar2 default hr_api.g_varchar2,
155: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 152: p_attribute15 in varchar2 default hr_api.g_varchar2,

148: p_attribute11 in varchar2 default hr_api.g_varchar2,
149: p_attribute12 in varchar2 default hr_api.g_varchar2,
150: p_attribute13 in varchar2 default hr_api.g_varchar2,
151: p_attribute14 in varchar2 default hr_api.g_varchar2,
152: p_attribute15 in varchar2 default hr_api.g_varchar2,
153: p_attribute16 in varchar2 default hr_api.g_varchar2,
154: p_attribute17 in varchar2 default hr_api.g_varchar2,
155: p_attribute18 in varchar2 default hr_api.g_varchar2,
156: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 153: p_attribute16 in varchar2 default hr_api.g_varchar2,

149: p_attribute12 in varchar2 default hr_api.g_varchar2,
150: p_attribute13 in varchar2 default hr_api.g_varchar2,
151: p_attribute14 in varchar2 default hr_api.g_varchar2,
152: p_attribute15 in varchar2 default hr_api.g_varchar2,
153: p_attribute16 in varchar2 default hr_api.g_varchar2,
154: p_attribute17 in varchar2 default hr_api.g_varchar2,
155: p_attribute18 in varchar2 default hr_api.g_varchar2,
156: p_attribute19 in varchar2 default hr_api.g_varchar2,
157: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 154: p_attribute17 in varchar2 default hr_api.g_varchar2,

150: p_attribute13 in varchar2 default hr_api.g_varchar2,
151: p_attribute14 in varchar2 default hr_api.g_varchar2,
152: p_attribute15 in varchar2 default hr_api.g_varchar2,
153: p_attribute16 in varchar2 default hr_api.g_varchar2,
154: p_attribute17 in varchar2 default hr_api.g_varchar2,
155: p_attribute18 in varchar2 default hr_api.g_varchar2,
156: p_attribute19 in varchar2 default hr_api.g_varchar2,
157: p_attribute20 in varchar2 default hr_api.g_varchar2,
158: p_LEAVE_TYPE in VARCHAR2 default 'MA',

Line 155: p_attribute18 in varchar2 default hr_api.g_varchar2,

151: p_attribute14 in varchar2 default hr_api.g_varchar2,
152: p_attribute15 in varchar2 default hr_api.g_varchar2,
153: p_attribute16 in varchar2 default hr_api.g_varchar2,
154: p_attribute17 in varchar2 default hr_api.g_varchar2,
155: p_attribute18 in varchar2 default hr_api.g_varchar2,
156: p_attribute19 in varchar2 default hr_api.g_varchar2,
157: p_attribute20 in varchar2 default hr_api.g_varchar2,
158: p_LEAVE_TYPE in VARCHAR2 default 'MA',
159: p_MATCHING_DATE in DATE default hr_api.g_date,

Line 156: p_attribute19 in varchar2 default hr_api.g_varchar2,

152: p_attribute15 in varchar2 default hr_api.g_varchar2,
153: p_attribute16 in varchar2 default hr_api.g_varchar2,
154: p_attribute17 in varchar2 default hr_api.g_varchar2,
155: p_attribute18 in varchar2 default hr_api.g_varchar2,
156: p_attribute19 in varchar2 default hr_api.g_varchar2,
157: p_attribute20 in varchar2 default hr_api.g_varchar2,
158: p_LEAVE_TYPE in VARCHAR2 default 'MA',
159: p_MATCHING_DATE in DATE default hr_api.g_date,
160: p_PLACEMENT_DATE in DATE default hr_api.g_date,

Line 157: p_attribute20 in varchar2 default hr_api.g_varchar2,

153: p_attribute16 in varchar2 default hr_api.g_varchar2,
154: p_attribute17 in varchar2 default hr_api.g_varchar2,
155: p_attribute18 in varchar2 default hr_api.g_varchar2,
156: p_attribute19 in varchar2 default hr_api.g_varchar2,
157: p_attribute20 in varchar2 default hr_api.g_varchar2,
158: p_LEAVE_TYPE in VARCHAR2 default 'MA',
159: p_MATCHING_DATE in DATE default hr_api.g_date,
160: p_PLACEMENT_DATE in DATE default hr_api.g_date,
161: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,

Line 159: p_MATCHING_DATE in DATE default hr_api.g_date,

155: p_attribute18 in varchar2 default hr_api.g_varchar2,
156: p_attribute19 in varchar2 default hr_api.g_varchar2,
157: p_attribute20 in varchar2 default hr_api.g_varchar2,
158: p_LEAVE_TYPE in VARCHAR2 default 'MA',
159: p_MATCHING_DATE in DATE default hr_api.g_date,
160: p_PLACEMENT_DATE in DATE default hr_api.g_date,
161: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
162: p_validate in boolean default false,
163: p_mat_information_category in varchar2 default hr_api.g_varchar2,

Line 160: p_PLACEMENT_DATE in DATE default hr_api.g_date,

156: p_attribute19 in varchar2 default hr_api.g_varchar2,
157: p_attribute20 in varchar2 default hr_api.g_varchar2,
158: p_LEAVE_TYPE in VARCHAR2 default 'MA',
159: p_MATCHING_DATE in DATE default hr_api.g_date,
160: p_PLACEMENT_DATE in DATE default hr_api.g_date,
161: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
162: p_validate in boolean default false,
163: p_mat_information_category in varchar2 default hr_api.g_varchar2,
164: p_mat_information1 in varchar2 default hr_api.g_varchar2,

Line 161: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,

157: p_attribute20 in varchar2 default hr_api.g_varchar2,
158: p_LEAVE_TYPE in VARCHAR2 default 'MA',
159: p_MATCHING_DATE in DATE default hr_api.g_date,
160: p_PLACEMENT_DATE in DATE default hr_api.g_date,
161: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
162: p_validate in boolean default false,
163: p_mat_information_category in varchar2 default hr_api.g_varchar2,
164: p_mat_information1 in varchar2 default hr_api.g_varchar2,
165: p_mat_information2 in varchar2 default hr_api.g_varchar2,

Line 163: p_mat_information_category in varchar2 default hr_api.g_varchar2,

159: p_MATCHING_DATE in DATE default hr_api.g_date,
160: p_PLACEMENT_DATE in DATE default hr_api.g_date,
161: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
162: p_validate in boolean default false,
163: p_mat_information_category in varchar2 default hr_api.g_varchar2,
164: p_mat_information1 in varchar2 default hr_api.g_varchar2,
165: p_mat_information2 in varchar2 default hr_api.g_varchar2,
166: p_mat_information3 in varchar2 default hr_api.g_varchar2,
167: p_mat_information4 in varchar2 default hr_api.g_varchar2,

Line 164: p_mat_information1 in varchar2 default hr_api.g_varchar2,

160: p_PLACEMENT_DATE in DATE default hr_api.g_date,
161: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
162: p_validate in boolean default false,
163: p_mat_information_category in varchar2 default hr_api.g_varchar2,
164: p_mat_information1 in varchar2 default hr_api.g_varchar2,
165: p_mat_information2 in varchar2 default hr_api.g_varchar2,
166: p_mat_information3 in varchar2 default hr_api.g_varchar2,
167: p_mat_information4 in varchar2 default hr_api.g_varchar2,
168: p_mat_information5 in varchar2 default hr_api.g_varchar2,

Line 165: p_mat_information2 in varchar2 default hr_api.g_varchar2,

161: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
162: p_validate in boolean default false,
163: p_mat_information_category in varchar2 default hr_api.g_varchar2,
164: p_mat_information1 in varchar2 default hr_api.g_varchar2,
165: p_mat_information2 in varchar2 default hr_api.g_varchar2,
166: p_mat_information3 in varchar2 default hr_api.g_varchar2,
167: p_mat_information4 in varchar2 default hr_api.g_varchar2,
168: p_mat_information5 in varchar2 default hr_api.g_varchar2,
169: p_mat_information6 in varchar2 default hr_api.g_varchar2,

Line 166: p_mat_information3 in varchar2 default hr_api.g_varchar2,

162: p_validate in boolean default false,
163: p_mat_information_category in varchar2 default hr_api.g_varchar2,
164: p_mat_information1 in varchar2 default hr_api.g_varchar2,
165: p_mat_information2 in varchar2 default hr_api.g_varchar2,
166: p_mat_information3 in varchar2 default hr_api.g_varchar2,
167: p_mat_information4 in varchar2 default hr_api.g_varchar2,
168: p_mat_information5 in varchar2 default hr_api.g_varchar2,
169: p_mat_information6 in varchar2 default hr_api.g_varchar2,
170: p_mat_information7 in varchar2 default hr_api.g_varchar2,

Line 167: p_mat_information4 in varchar2 default hr_api.g_varchar2,

163: p_mat_information_category in varchar2 default hr_api.g_varchar2,
164: p_mat_information1 in varchar2 default hr_api.g_varchar2,
165: p_mat_information2 in varchar2 default hr_api.g_varchar2,
166: p_mat_information3 in varchar2 default hr_api.g_varchar2,
167: p_mat_information4 in varchar2 default hr_api.g_varchar2,
168: p_mat_information5 in varchar2 default hr_api.g_varchar2,
169: p_mat_information6 in varchar2 default hr_api.g_varchar2,
170: p_mat_information7 in varchar2 default hr_api.g_varchar2,
171: p_mat_information8 in varchar2 default hr_api.g_varchar2,

Line 168: p_mat_information5 in varchar2 default hr_api.g_varchar2,

164: p_mat_information1 in varchar2 default hr_api.g_varchar2,
165: p_mat_information2 in varchar2 default hr_api.g_varchar2,
166: p_mat_information3 in varchar2 default hr_api.g_varchar2,
167: p_mat_information4 in varchar2 default hr_api.g_varchar2,
168: p_mat_information5 in varchar2 default hr_api.g_varchar2,
169: p_mat_information6 in varchar2 default hr_api.g_varchar2,
170: p_mat_information7 in varchar2 default hr_api.g_varchar2,
171: p_mat_information8 in varchar2 default hr_api.g_varchar2,
172: p_mat_information9 in varchar2 default hr_api.g_varchar2,

Line 169: p_mat_information6 in varchar2 default hr_api.g_varchar2,

165: p_mat_information2 in varchar2 default hr_api.g_varchar2,
166: p_mat_information3 in varchar2 default hr_api.g_varchar2,
167: p_mat_information4 in varchar2 default hr_api.g_varchar2,
168: p_mat_information5 in varchar2 default hr_api.g_varchar2,
169: p_mat_information6 in varchar2 default hr_api.g_varchar2,
170: p_mat_information7 in varchar2 default hr_api.g_varchar2,
171: p_mat_information8 in varchar2 default hr_api.g_varchar2,
172: p_mat_information9 in varchar2 default hr_api.g_varchar2,
173: p_mat_information10 in varchar2 default hr_api.g_varchar2,

Line 170: p_mat_information7 in varchar2 default hr_api.g_varchar2,

166: p_mat_information3 in varchar2 default hr_api.g_varchar2,
167: p_mat_information4 in varchar2 default hr_api.g_varchar2,
168: p_mat_information5 in varchar2 default hr_api.g_varchar2,
169: p_mat_information6 in varchar2 default hr_api.g_varchar2,
170: p_mat_information7 in varchar2 default hr_api.g_varchar2,
171: p_mat_information8 in varchar2 default hr_api.g_varchar2,
172: p_mat_information9 in varchar2 default hr_api.g_varchar2,
173: p_mat_information10 in varchar2 default hr_api.g_varchar2,
174: p_mat_information11 in varchar2 default hr_api.g_varchar2,

Line 171: p_mat_information8 in varchar2 default hr_api.g_varchar2,

167: p_mat_information4 in varchar2 default hr_api.g_varchar2,
168: p_mat_information5 in varchar2 default hr_api.g_varchar2,
169: p_mat_information6 in varchar2 default hr_api.g_varchar2,
170: p_mat_information7 in varchar2 default hr_api.g_varchar2,
171: p_mat_information8 in varchar2 default hr_api.g_varchar2,
172: p_mat_information9 in varchar2 default hr_api.g_varchar2,
173: p_mat_information10 in varchar2 default hr_api.g_varchar2,
174: p_mat_information11 in varchar2 default hr_api.g_varchar2,
175: p_mat_information12 in varchar2 default hr_api.g_varchar2,

Line 172: p_mat_information9 in varchar2 default hr_api.g_varchar2,

168: p_mat_information5 in varchar2 default hr_api.g_varchar2,
169: p_mat_information6 in varchar2 default hr_api.g_varchar2,
170: p_mat_information7 in varchar2 default hr_api.g_varchar2,
171: p_mat_information8 in varchar2 default hr_api.g_varchar2,
172: p_mat_information9 in varchar2 default hr_api.g_varchar2,
173: p_mat_information10 in varchar2 default hr_api.g_varchar2,
174: p_mat_information11 in varchar2 default hr_api.g_varchar2,
175: p_mat_information12 in varchar2 default hr_api.g_varchar2,
176: p_mat_information13 in varchar2 default hr_api.g_varchar2,

Line 173: p_mat_information10 in varchar2 default hr_api.g_varchar2,

169: p_mat_information6 in varchar2 default hr_api.g_varchar2,
170: p_mat_information7 in varchar2 default hr_api.g_varchar2,
171: p_mat_information8 in varchar2 default hr_api.g_varchar2,
172: p_mat_information9 in varchar2 default hr_api.g_varchar2,
173: p_mat_information10 in varchar2 default hr_api.g_varchar2,
174: p_mat_information11 in varchar2 default hr_api.g_varchar2,
175: p_mat_information12 in varchar2 default hr_api.g_varchar2,
176: p_mat_information13 in varchar2 default hr_api.g_varchar2,
177: p_mat_information14 in varchar2 default hr_api.g_varchar2,

Line 174: p_mat_information11 in varchar2 default hr_api.g_varchar2,

170: p_mat_information7 in varchar2 default hr_api.g_varchar2,
171: p_mat_information8 in varchar2 default hr_api.g_varchar2,
172: p_mat_information9 in varchar2 default hr_api.g_varchar2,
173: p_mat_information10 in varchar2 default hr_api.g_varchar2,
174: p_mat_information11 in varchar2 default hr_api.g_varchar2,
175: p_mat_information12 in varchar2 default hr_api.g_varchar2,
176: p_mat_information13 in varchar2 default hr_api.g_varchar2,
177: p_mat_information14 in varchar2 default hr_api.g_varchar2,
178: p_mat_information15 in varchar2 default hr_api.g_varchar2,

Line 175: p_mat_information12 in varchar2 default hr_api.g_varchar2,

171: p_mat_information8 in varchar2 default hr_api.g_varchar2,
172: p_mat_information9 in varchar2 default hr_api.g_varchar2,
173: p_mat_information10 in varchar2 default hr_api.g_varchar2,
174: p_mat_information11 in varchar2 default hr_api.g_varchar2,
175: p_mat_information12 in varchar2 default hr_api.g_varchar2,
176: p_mat_information13 in varchar2 default hr_api.g_varchar2,
177: p_mat_information14 in varchar2 default hr_api.g_varchar2,
178: p_mat_information15 in varchar2 default hr_api.g_varchar2,
179: p_mat_information16 in varchar2 default hr_api.g_varchar2,

Line 176: p_mat_information13 in varchar2 default hr_api.g_varchar2,

172: p_mat_information9 in varchar2 default hr_api.g_varchar2,
173: p_mat_information10 in varchar2 default hr_api.g_varchar2,
174: p_mat_information11 in varchar2 default hr_api.g_varchar2,
175: p_mat_information12 in varchar2 default hr_api.g_varchar2,
176: p_mat_information13 in varchar2 default hr_api.g_varchar2,
177: p_mat_information14 in varchar2 default hr_api.g_varchar2,
178: p_mat_information15 in varchar2 default hr_api.g_varchar2,
179: p_mat_information16 in varchar2 default hr_api.g_varchar2,
180: p_mat_information17 in varchar2 default hr_api.g_varchar2,

Line 177: p_mat_information14 in varchar2 default hr_api.g_varchar2,

173: p_mat_information10 in varchar2 default hr_api.g_varchar2,
174: p_mat_information11 in varchar2 default hr_api.g_varchar2,
175: p_mat_information12 in varchar2 default hr_api.g_varchar2,
176: p_mat_information13 in varchar2 default hr_api.g_varchar2,
177: p_mat_information14 in varchar2 default hr_api.g_varchar2,
178: p_mat_information15 in varchar2 default hr_api.g_varchar2,
179: p_mat_information16 in varchar2 default hr_api.g_varchar2,
180: p_mat_information17 in varchar2 default hr_api.g_varchar2,
181: p_mat_information18 in varchar2 default hr_api.g_varchar2,

Line 178: p_mat_information15 in varchar2 default hr_api.g_varchar2,

174: p_mat_information11 in varchar2 default hr_api.g_varchar2,
175: p_mat_information12 in varchar2 default hr_api.g_varchar2,
176: p_mat_information13 in varchar2 default hr_api.g_varchar2,
177: p_mat_information14 in varchar2 default hr_api.g_varchar2,
178: p_mat_information15 in varchar2 default hr_api.g_varchar2,
179: p_mat_information16 in varchar2 default hr_api.g_varchar2,
180: p_mat_information17 in varchar2 default hr_api.g_varchar2,
181: p_mat_information18 in varchar2 default hr_api.g_varchar2,
182: p_mat_information19 in varchar2 default hr_api.g_varchar2,

Line 179: p_mat_information16 in varchar2 default hr_api.g_varchar2,

175: p_mat_information12 in varchar2 default hr_api.g_varchar2,
176: p_mat_information13 in varchar2 default hr_api.g_varchar2,
177: p_mat_information14 in varchar2 default hr_api.g_varchar2,
178: p_mat_information15 in varchar2 default hr_api.g_varchar2,
179: p_mat_information16 in varchar2 default hr_api.g_varchar2,
180: p_mat_information17 in varchar2 default hr_api.g_varchar2,
181: p_mat_information18 in varchar2 default hr_api.g_varchar2,
182: p_mat_information19 in varchar2 default hr_api.g_varchar2,
183: p_mat_information20 in varchar2 default hr_api.g_varchar2,

Line 180: p_mat_information17 in varchar2 default hr_api.g_varchar2,

176: p_mat_information13 in varchar2 default hr_api.g_varchar2,
177: p_mat_information14 in varchar2 default hr_api.g_varchar2,
178: p_mat_information15 in varchar2 default hr_api.g_varchar2,
179: p_mat_information16 in varchar2 default hr_api.g_varchar2,
180: p_mat_information17 in varchar2 default hr_api.g_varchar2,
181: p_mat_information18 in varchar2 default hr_api.g_varchar2,
182: p_mat_information19 in varchar2 default hr_api.g_varchar2,
183: p_mat_information20 in varchar2 default hr_api.g_varchar2,
184: p_mat_information21 in varchar2 default hr_api.g_varchar2,

Line 181: p_mat_information18 in varchar2 default hr_api.g_varchar2,

177: p_mat_information14 in varchar2 default hr_api.g_varchar2,
178: p_mat_information15 in varchar2 default hr_api.g_varchar2,
179: p_mat_information16 in varchar2 default hr_api.g_varchar2,
180: p_mat_information17 in varchar2 default hr_api.g_varchar2,
181: p_mat_information18 in varchar2 default hr_api.g_varchar2,
182: p_mat_information19 in varchar2 default hr_api.g_varchar2,
183: p_mat_information20 in varchar2 default hr_api.g_varchar2,
184: p_mat_information21 in varchar2 default hr_api.g_varchar2,
185: p_mat_information22 in varchar2 default hr_api.g_varchar2,

Line 182: p_mat_information19 in varchar2 default hr_api.g_varchar2,

178: p_mat_information15 in varchar2 default hr_api.g_varchar2,
179: p_mat_information16 in varchar2 default hr_api.g_varchar2,
180: p_mat_information17 in varchar2 default hr_api.g_varchar2,
181: p_mat_information18 in varchar2 default hr_api.g_varchar2,
182: p_mat_information19 in varchar2 default hr_api.g_varchar2,
183: p_mat_information20 in varchar2 default hr_api.g_varchar2,
184: p_mat_information21 in varchar2 default hr_api.g_varchar2,
185: p_mat_information22 in varchar2 default hr_api.g_varchar2,
186: p_mat_information23 in varchar2 default hr_api.g_varchar2,

Line 183: p_mat_information20 in varchar2 default hr_api.g_varchar2,

179: p_mat_information16 in varchar2 default hr_api.g_varchar2,
180: p_mat_information17 in varchar2 default hr_api.g_varchar2,
181: p_mat_information18 in varchar2 default hr_api.g_varchar2,
182: p_mat_information19 in varchar2 default hr_api.g_varchar2,
183: p_mat_information20 in varchar2 default hr_api.g_varchar2,
184: p_mat_information21 in varchar2 default hr_api.g_varchar2,
185: p_mat_information22 in varchar2 default hr_api.g_varchar2,
186: p_mat_information23 in varchar2 default hr_api.g_varchar2,
187: p_mat_information24 in varchar2 default hr_api.g_varchar2,

Line 184: p_mat_information21 in varchar2 default hr_api.g_varchar2,

180: p_mat_information17 in varchar2 default hr_api.g_varchar2,
181: p_mat_information18 in varchar2 default hr_api.g_varchar2,
182: p_mat_information19 in varchar2 default hr_api.g_varchar2,
183: p_mat_information20 in varchar2 default hr_api.g_varchar2,
184: p_mat_information21 in varchar2 default hr_api.g_varchar2,
185: p_mat_information22 in varchar2 default hr_api.g_varchar2,
186: p_mat_information23 in varchar2 default hr_api.g_varchar2,
187: p_mat_information24 in varchar2 default hr_api.g_varchar2,
188: p_mat_information25 in varchar2 default hr_api.g_varchar2,

Line 185: p_mat_information22 in varchar2 default hr_api.g_varchar2,

181: p_mat_information18 in varchar2 default hr_api.g_varchar2,
182: p_mat_information19 in varchar2 default hr_api.g_varchar2,
183: p_mat_information20 in varchar2 default hr_api.g_varchar2,
184: p_mat_information21 in varchar2 default hr_api.g_varchar2,
185: p_mat_information22 in varchar2 default hr_api.g_varchar2,
186: p_mat_information23 in varchar2 default hr_api.g_varchar2,
187: p_mat_information24 in varchar2 default hr_api.g_varchar2,
188: p_mat_information25 in varchar2 default hr_api.g_varchar2,
189: p_mat_information26 in varchar2 default hr_api.g_varchar2,

Line 186: p_mat_information23 in varchar2 default hr_api.g_varchar2,

182: p_mat_information19 in varchar2 default hr_api.g_varchar2,
183: p_mat_information20 in varchar2 default hr_api.g_varchar2,
184: p_mat_information21 in varchar2 default hr_api.g_varchar2,
185: p_mat_information22 in varchar2 default hr_api.g_varchar2,
186: p_mat_information23 in varchar2 default hr_api.g_varchar2,
187: p_mat_information24 in varchar2 default hr_api.g_varchar2,
188: p_mat_information25 in varchar2 default hr_api.g_varchar2,
189: p_mat_information26 in varchar2 default hr_api.g_varchar2,
190: p_mat_information27 in varchar2 default hr_api.g_varchar2,

Line 187: p_mat_information24 in varchar2 default hr_api.g_varchar2,

183: p_mat_information20 in varchar2 default hr_api.g_varchar2,
184: p_mat_information21 in varchar2 default hr_api.g_varchar2,
185: p_mat_information22 in varchar2 default hr_api.g_varchar2,
186: p_mat_information23 in varchar2 default hr_api.g_varchar2,
187: p_mat_information24 in varchar2 default hr_api.g_varchar2,
188: p_mat_information25 in varchar2 default hr_api.g_varchar2,
189: p_mat_information26 in varchar2 default hr_api.g_varchar2,
190: p_mat_information27 in varchar2 default hr_api.g_varchar2,
191: p_mat_information28 in varchar2 default hr_api.g_varchar2,

Line 188: p_mat_information25 in varchar2 default hr_api.g_varchar2,

184: p_mat_information21 in varchar2 default hr_api.g_varchar2,
185: p_mat_information22 in varchar2 default hr_api.g_varchar2,
186: p_mat_information23 in varchar2 default hr_api.g_varchar2,
187: p_mat_information24 in varchar2 default hr_api.g_varchar2,
188: p_mat_information25 in varchar2 default hr_api.g_varchar2,
189: p_mat_information26 in varchar2 default hr_api.g_varchar2,
190: p_mat_information27 in varchar2 default hr_api.g_varchar2,
191: p_mat_information28 in varchar2 default hr_api.g_varchar2,
192: p_mat_information29 in varchar2 default hr_api.g_varchar2,

Line 189: p_mat_information26 in varchar2 default hr_api.g_varchar2,

185: p_mat_information22 in varchar2 default hr_api.g_varchar2,
186: p_mat_information23 in varchar2 default hr_api.g_varchar2,
187: p_mat_information24 in varchar2 default hr_api.g_varchar2,
188: p_mat_information25 in varchar2 default hr_api.g_varchar2,
189: p_mat_information26 in varchar2 default hr_api.g_varchar2,
190: p_mat_information27 in varchar2 default hr_api.g_varchar2,
191: p_mat_information28 in varchar2 default hr_api.g_varchar2,
192: p_mat_information29 in varchar2 default hr_api.g_varchar2,
193: p_mat_information30 in varchar2 default hr_api.g_varchar2,

Line 190: p_mat_information27 in varchar2 default hr_api.g_varchar2,

186: p_mat_information23 in varchar2 default hr_api.g_varchar2,
187: p_mat_information24 in varchar2 default hr_api.g_varchar2,
188: p_mat_information25 in varchar2 default hr_api.g_varchar2,
189: p_mat_information26 in varchar2 default hr_api.g_varchar2,
190: p_mat_information27 in varchar2 default hr_api.g_varchar2,
191: p_mat_information28 in varchar2 default hr_api.g_varchar2,
192: p_mat_information29 in varchar2 default hr_api.g_varchar2,
193: p_mat_information30 in varchar2 default hr_api.g_varchar2,
194: p_partner_stat_pay_start_date in date default hr_api.g_date,

Line 191: p_mat_information28 in varchar2 default hr_api.g_varchar2,

187: p_mat_information24 in varchar2 default hr_api.g_varchar2,
188: p_mat_information25 in varchar2 default hr_api.g_varchar2,
189: p_mat_information26 in varchar2 default hr_api.g_varchar2,
190: p_mat_information27 in varchar2 default hr_api.g_varchar2,
191: p_mat_information28 in varchar2 default hr_api.g_varchar2,
192: p_mat_information29 in varchar2 default hr_api.g_varchar2,
193: p_mat_information30 in varchar2 default hr_api.g_varchar2,
194: p_partner_stat_pay_start_date in date default hr_api.g_date,
195: p_partner_return_to_work in date default hr_api.g_date,

Line 192: p_mat_information29 in varchar2 default hr_api.g_varchar2,

188: p_mat_information25 in varchar2 default hr_api.g_varchar2,
189: p_mat_information26 in varchar2 default hr_api.g_varchar2,
190: p_mat_information27 in varchar2 default hr_api.g_varchar2,
191: p_mat_information28 in varchar2 default hr_api.g_varchar2,
192: p_mat_information29 in varchar2 default hr_api.g_varchar2,
193: p_mat_information30 in varchar2 default hr_api.g_varchar2,
194: p_partner_stat_pay_start_date in date default hr_api.g_date,
195: p_partner_return_to_work in date default hr_api.g_date,
196: p_partner_death_date in date default hr_api.g_date

Line 193: p_mat_information30 in varchar2 default hr_api.g_varchar2,

189: p_mat_information26 in varchar2 default hr_api.g_varchar2,
190: p_mat_information27 in varchar2 default hr_api.g_varchar2,
191: p_mat_information28 in varchar2 default hr_api.g_varchar2,
192: p_mat_information29 in varchar2 default hr_api.g_varchar2,
193: p_mat_information30 in varchar2 default hr_api.g_varchar2,
194: p_partner_stat_pay_start_date in date default hr_api.g_date,
195: p_partner_return_to_work in date default hr_api.g_date,
196: p_partner_death_date in date default hr_api.g_date
197: );

Line 194: p_partner_stat_pay_start_date in date default hr_api.g_date,

190: p_mat_information27 in varchar2 default hr_api.g_varchar2,
191: p_mat_information28 in varchar2 default hr_api.g_varchar2,
192: p_mat_information29 in varchar2 default hr_api.g_varchar2,
193: p_mat_information30 in varchar2 default hr_api.g_varchar2,
194: p_partner_stat_pay_start_date in date default hr_api.g_date,
195: p_partner_return_to_work in date default hr_api.g_date,
196: p_partner_death_date in date default hr_api.g_date
197: );
198: --

Line 195: p_partner_return_to_work in date default hr_api.g_date,

191: p_mat_information28 in varchar2 default hr_api.g_varchar2,
192: p_mat_information29 in varchar2 default hr_api.g_varchar2,
193: p_mat_information30 in varchar2 default hr_api.g_varchar2,
194: p_partner_stat_pay_start_date in date default hr_api.g_date,
195: p_partner_return_to_work in date default hr_api.g_date,
196: p_partner_death_date in date default hr_api.g_date
197: );
198: --
199: end ssp_mat_upd;

Line 196: p_partner_death_date in date default hr_api.g_date

192: p_mat_information29 in varchar2 default hr_api.g_varchar2,
193: p_mat_information30 in varchar2 default hr_api.g_varchar2,
194: p_partner_stat_pay_start_date in date default hr_api.g_date,
195: p_partner_return_to_work in date default hr_api.g_date,
196: p_partner_death_date in date default hr_api.g_date
197: );
198: --
199: end ssp_mat_upd;