APPS.SSP_MAT_SHD dependencies on SSP_MATERNITIES

Line 54: ElsIf (p_constraint_name = 'SSP_MATERNITIES_PK') Then

50: --
51: ElsIf (p_constraint_name = 'SSP_MAT_UNFIT_TO_RETURN_DATE') Then
52: fnd_message.set_name ('SSP', 'SSP_35058_UNFIT_TO_RETURN');
53: --
54: ElsIf (p_constraint_name = 'SSP_MATERNITIES_PK') Then
55: fnd_message.set_name ('SSP', 'SSP_35041_DUP_MATERNITY_PK');
56: --
57: ElsIf (p_constraint_name = 'SSP_MATERNITIES_UK1') Then
58: fnd_message.set_name ('SSP', 'SSP_35009_DUP_DUE_DATE');

Line 57: ElsIf (p_constraint_name = 'SSP_MATERNITIES_UK1') Then

53: --
54: ElsIf (p_constraint_name = 'SSP_MATERNITIES_PK') Then
55: fnd_message.set_name ('SSP', 'SSP_35041_DUP_MATERNITY_PK');
56: --
57: ElsIf (p_constraint_name = 'SSP_MATERNITIES_UK1') Then
58: fnd_message.set_name ('SSP', 'SSP_35009_DUP_DUE_DATE');
59: --
60: ElsIf (p_constraint_name = 'SSP_MAT_MPP_START_BIRTH_DATE') Then
61: fnd_message.set_name ('SSP', 'SSP_35055_MPP_SUN_FOLLW_BIRTH');

Line 66: ElsIf (p_constraint_name = 'SSP_MATERNITIES_FK1') Then

62: --
63: ElsIf (p_constraint_name = 'SSP_MAT_NOTIFICATION_OF_BIRTH') Then
64: fnd_message.set_name ('SSP', 'SSP_35059_NOTIF_OF_BIRTH');
65: --
66: ElsIf (p_constraint_name = 'SSP_MATERNITIES_FK1') Then
67: fnd_message.set_name('SSP', 'SSP_35057_BAD_PERSON_ID');
68: --
69: Else
70: fnd_message.set_name ('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 168: from ssp_maternities

164: mat_information30,
165: partner_stat_pay_start_date,
166: partner_return_to_work,
167: partner_death_date
168: from ssp_maternities
169: where maternity_id = p_maternity_id;
170: --
171: l_proc varchar2(72) := g_package||'api_updating';
172: l_fct_ret boolean;

Line 311: from ssp_maternities

307: mat_information30,
308: partner_stat_pay_start_date,
309: partner_return_to_work,
310: partner_death_date
311: from ssp_maternities
312: where maternity_id = p_maternity_id
313: for update nowait;
314: --
315: l_proc varchar2(72) := g_package||'lck';

Line 354: fnd_message.set_token('TABLE_NAME', 'ssp_maternities');

350: -- The object is locked therefore we need to supply a meaningful
351: -- error message.
352: --
353: fnd_message.set_name ('PAY', 'HR_7165_OBJECT_LOCKED');
354: fnd_message.set_token('TABLE_NAME', 'ssp_maternities');
355: fnd_message.raise_error;
356: End lck;
357: --
358: -- ----------------------------------------------------------------------------