APPS.PAY_IVL_SHD dependencies on PAY_IVL_SHD

Line 1: Package Body pay_ivl_shd as

1: Package Body pay_ivl_shd as
2: /* $Header: pyivlrhi.pkb 120.0 2005/05/29 06:04:43 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pay_ivl_shd.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_ivl_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< return_api_dml_status >-------------------------|
12: -- ----------------------------------------------------------------------------

Line 129: pay_ivl_shd.g_old_rec.input_value_id and

125: --
126: l_fct_ret := false;
127: Else
128: If (p_input_value_id =
129: pay_ivl_shd.g_old_rec.input_value_id and
130: p_object_version_number =
131: pay_ivl_shd.g_old_rec.object_version_number
132: ) Then
133: --

Line 131: pay_ivl_shd.g_old_rec.object_version_number

127: Else
128: If (p_input_value_id =
129: pay_ivl_shd.g_old_rec.input_value_id and
130: p_object_version_number =
131: pay_ivl_shd.g_old_rec.object_version_number
132: ) Then
133: --
134: -- The g_old_rec is current therefore we must
135: -- set the returning function to true

Line 143: Fetch C_Sel1 Into pay_ivl_shd.g_old_rec;

139: --
140: -- Select the current row
141: --
142: Open C_Sel1;
143: Fetch C_Sel1 Into pay_ivl_shd.g_old_rec;
144: If C_Sel1%notfound Then
145: Close C_Sel1;
146: --
147: -- The primary key is invalid therefore we must error

Line 154: <> pay_ivl_shd.g_old_rec.object_version_number) Then

150: fnd_message.raise_error;
151: End If;
152: Close C_Sel1;
153: If (p_object_version_number
154: <> pay_ivl_shd.g_old_rec.object_version_number) Then
155: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
156: fnd_message.raise_error;
157: End If;
158: l_fct_ret := true;

Line 284: pay_ivl_shd.g_api_dml := true; -- Set the api dml status

280: ,p_base_key_value => p_base_key_value
281: );
282: --
283: hr_utility.set_location(l_proc, 10);
284: pay_ivl_shd.g_api_dml := true; -- Set the api dml status
285: --
286: -- Update the specified datetrack row setting the effective
287: -- end date to the specified new effective end date.
288: --

Line 296: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status

292: where t.input_value_id = p_base_key_value
293: and p_effective_date
294: between t.effective_start_date and t.effective_end_date;
295: --
296: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
297: p_object_version_number := l_object_version_number;
298: hr_utility.set_location(' Leaving:'||l_proc, 15);
299: --
300: Exception

Line 302: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status

298: hr_utility.set_location(' Leaving:'||l_proc, 15);
299: --
300: Exception
301: When Others Then
302: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
303: Raise;
304: --
305: End upd_effective_end_date;
306: --

Line 390: Fetch C_Sel1 Into pay_ivl_shd.g_old_rec;

386: --
387: -- We must select and lock the current row.
388: --
389: Open C_Sel1;
390: Fetch C_Sel1 Into pay_ivl_shd.g_old_rec;
391: If C_Sel1%notfound then
392: Close C_Sel1;
393: --
394: -- The primary key is invalid therefore we must error

Line 401: <> pay_ivl_shd.g_old_rec.object_version_number) Then

397: fnd_message.raise_error;
398: End If;
399: Close C_Sel1;
400: If (p_object_version_number
401: <> pay_ivl_shd.g_old_rec.object_version_number) Then
402: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
403: fnd_message.raise_error;
404: End If;
405: --

Line 418: ,p_parent_key_value1 => pay_ivl_shd.g_old_rec.element_type_id

414: ,p_base_key_column => 'input_value_id'
415: ,p_base_key_value => p_input_value_id
416: ,p_parent_table_name1 => 'pay_element_types_f'
417: ,p_parent_key_column1 => 'element_type_id'
418: ,p_parent_key_value1 => pay_ivl_shd.g_old_rec.element_type_id
419: ,p_child_table_name1 => 'ben_acty_base_rt_f'
420: ,p_child_key_column1 => 'acty_base_rt_id'
421: ,p_child_alt_base_key_column1 => 'input_value_id'
422: ,p_child_table_name2 => 'pay_link_input_values_f'

Line 523: end pay_ivl_shd;

519: Return(l_rec);
520: --
521: End convert_args;
522: --
523: end pay_ivl_shd;