APPS.SSP_ERN_SHD dependencies on SSP_EARNINGS_CALCULATIONS

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 1);
35: --
36: If (p_constraint_name = 'SSP_EARNINGS_CALCULATIONS_PK') Then
37: fnd_message.set_name('SSP', 'SSP_35043_INVALID_PRIMARY_KEY');
38: ElsIf (p_constraint_name = 'SSP_EARNINGS_CALCULATIONS_UK1') Then
39: fnd_message.set_name('SSP', 'SSP_35053_ERN_INV_UK1');
40: Else

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

34: hr_utility.set_location('Entering:'||l_proc, 1);
35: --
36: If (p_constraint_name = 'SSP_EARNINGS_CALCULATIONS_PK') Then
37: fnd_message.set_name('SSP', 'SSP_35043_INVALID_PRIMARY_KEY');
38: ElsIf (p_constraint_name = 'SSP_EARNINGS_CALCULATIONS_UK1') Then
39: fnd_message.set_name('SSP', 'SSP_35053_ERN_INV_UK1');
40: Else
41: fnd_message.set_name('PAY','HR_7877_API_INVALID_CONSTRAINT');
42: fnd_message.set_token ('PROCEDURE',l_proc);

Line 69: from ssp_earnings_calculations

65: effective_date,
66: average_earnings_amount,
67: user_entered,
68: payment_periods
69: from ssp_earnings_calculations
70: where earnings_calculations_id = p_earnings_calculations_id;
71: --
72: l_proc varchar2(72) := g_package||'api_updating';
73: l_fct_ret boolean;

Line 152: from ssp_earnings_calculations

148: effective_date,
149: average_earnings_amount,
150: user_entered,
151: payment_periods
152: from ssp_earnings_calculations
153: where earnings_calculations_id = p_earnings_calculations_id
154: for update nowait;
155: --
156: l_proc varchar2(72) := g_package||'lck';

Line 202: fnd_message.set_token ('TABLE_NAME','ssp_earnings_calculations');

198: --
199: -- The object is locked so supply a meaningful error message.
200: --
201: fnd_message.set_name('PAY','HR_7165_OBJECT_LOCKED');
202: fnd_message.set_token ('TABLE_NAME','ssp_earnings_calculations');
203: fnd_message.raise_error;
204: End lck;
205: --
206: -- ----------------------------------------------------------------------------