APPS.SSP_STP_SHD dependencies on SSP_STOPPAGES

Line 36: If (p_constraint_name = 'SSP_STOPPAGES_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'SSP_STOPPAGES_FK1') Then
37: fnd_message.set_name ('SSP', 'SSP_35069_STOPPAGES_FK1');
38: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK2') Then
39: fnd_message.set_name ('SSP', 'SSP_35070_STOPPAGES_FK2');
40: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK3') Then

Line 38: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK2') Then

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'SSP_STOPPAGES_FK1') Then
37: fnd_message.set_name ('SSP', 'SSP_35069_STOPPAGES_FK1');
38: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK2') Then
39: fnd_message.set_name ('SSP', 'SSP_35070_STOPPAGES_FK2');
40: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK3') Then
41: fnd_message.set_name ('SSP', 'SSP_35071_STOPPAGES_FK3');
42: ElsIf (p_constraint_name = 'SSP_STOPPAGES_PK') Then

Line 40: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK3') Then

36: If (p_constraint_name = 'SSP_STOPPAGES_FK1') Then
37: fnd_message.set_name ('SSP', 'SSP_35069_STOPPAGES_FK1');
38: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK2') Then
39: fnd_message.set_name ('SSP', 'SSP_35070_STOPPAGES_FK2');
40: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK3') Then
41: fnd_message.set_name ('SSP', 'SSP_35071_STOPPAGES_FK3');
42: ElsIf (p_constraint_name = 'SSP_STOPPAGES_PK') Then
43: fnd_message.set_name ('SSP', 'SSP_35072_STOPPAGES_PK');
44: ElsIf (p_constraint_name = 'SSP_STP_ARC_ABS_MAT') Then

Line 42: ElsIf (p_constraint_name = 'SSP_STOPPAGES_PK') Then

38: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK2') Then
39: fnd_message.set_name ('SSP', 'SSP_35070_STOPPAGES_FK2');
40: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK3') Then
41: fnd_message.set_name ('SSP', 'SSP_35071_STOPPAGES_FK3');
42: ElsIf (p_constraint_name = 'SSP_STOPPAGES_PK') Then
43: fnd_message.set_name ('SSP', 'SSP_35072_STOPPAGES_PK');
44: ElsIf (p_constraint_name = 'SSP_STP_ARC_ABS_MAT') Then
45: fnd_message.set_name ('SSP', 'SSP_35073_STP_ARC_ABS_MAT');
46: ElsIf (p_constraint_name = 'SSP_STP_SMP_STOPPAGE_DATES') Then

Line 85: from ssp_stoppages

81: override_stoppage,
82: employee_notified,
83: withhold_from,
84: withhold_to
85: from ssp_stoppages
86: where stoppage_id = p_stoppage_id;
87: --
88: l_proc varchar2(72) := g_package||'api_updating';
89: l_fct_ret boolean;

Line 164: from ssp_stoppages

160: override_stoppage,
161: employee_notified,
162: withhold_from,
163: withhold_to
164: from ssp_stoppages
165: where stoppage_id = p_stoppage_id
166: for update nowait;
167: --
168: l_proc varchar2(72) := g_package||'lck';

Line 207: hr_utility.set_message_token('TABLE_NAME', 'ssp_stoppages');

203: -- The object is locked therefore we need to supply a meaningful
204: -- error message.
205: --
206: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
207: hr_utility.set_message_token('TABLE_NAME', 'ssp_stoppages');
208: hr_utility.raise_error;
209: End lck;
210: --
211: -- ----------------------------------------------------------------------------