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 165: from ssp_maternities

161: mat_information27,
162: mat_information28,
163: mat_information29,
164: mat_information30
165: from ssp_maternities
166: where maternity_id = p_maternity_id;
167: --
168: l_proc varchar2(72) := g_package||'api_updating';
169: l_fct_ret boolean;

Line 305: from ssp_maternities

301: mat_information27,
302: mat_information28,
303: mat_information29,
304: mat_information30
305: from ssp_maternities
306: where maternity_id = p_maternity_id
307: for update nowait;
308: --
309: l_proc varchar2(72) := g_package||'lck';

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

344: -- The object is locked therefore we need to supply a meaningful
345: -- error message.
346: --
347: fnd_message.set_name ('PAY', 'HR_7165_OBJECT_LOCKED');
348: fnd_message.set_token('TABLE_NAME', 'ssp_maternities');
349: fnd_message.raise_error;
350: End lck;
351: --
352: -- ----------------------------------------------------------------------------