eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_LIV_SHD dependencies on PAY_LIV_SHD

Line 1: Package Body pay_liv_shd as

1: Package Body pay_liv_shd as
2: /* $Header: pylivrhi.pkb 120.1 2005/07/12 05:24:42 alogue noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 104: pay_liv_shd.g_old_rec.link_input_value_id and

100: --
101: l_fct_ret := false;
102: Else
103: If (p_link_input_value_id =
104: pay_liv_shd.g_old_rec.link_input_value_id and
105: p_object_version_number =
106: pay_liv_shd.g_old_rec.object_version_number
107: ) Then
108: --

Line 106: pay_liv_shd.g_old_rec.object_version_number

102: Else
103: If (p_link_input_value_id =
104: pay_liv_shd.g_old_rec.link_input_value_id and
105: p_object_version_number =
106: pay_liv_shd.g_old_rec.object_version_number
107: ) Then
108: --
109: -- The g_old_rec is current therefore we must
110: -- set the returning function to true

Line 118: Fetch C_Sel1 Into pay_liv_shd.g_old_rec;

114: --
115: -- Select the current row
116: --
117: Open C_Sel1;
118: Fetch C_Sel1 Into pay_liv_shd.g_old_rec;
119: If C_Sel1%notfound Then
120: Close C_Sel1;
121: --
122: -- The primary key is invalid therefore we must error

Line 129: <> pay_liv_shd.g_old_rec.object_version_number) Then

125: fnd_message.raise_error;
126: End If;
127: Close C_Sel1;
128: If (p_object_version_number
129: <> pay_liv_shd.g_old_rec.object_version_number) Then
130: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
131: fnd_message.raise_error;
132: End If;
133: l_fct_ret := true;

Line 265: pay_liv_shd.g_api_dml := true; -- Set the api dml status

261: ,p_base_key_value => p_base_key_value
262: );
263: --
264: hr_utility.set_location(l_proc, 10);
265: pay_liv_shd.g_api_dml := true; -- Set the api dml status
266: --
267: -- Update the specified datetrack row setting the effective
268: -- end date to the specified new effective end date.
269: --

Line 277: pay_liv_shd.g_api_dml := false; -- Unset the api dml status

273: where t.link_input_value_id = p_base_key_value
274: and p_effective_date
275: between t.effective_start_date and t.effective_end_date;
276: --
277: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
278: p_object_version_number := l_object_version_number;
279: hr_utility.set_location(' Leaving:'||l_proc, 15);
280: --
281: Exception

Line 283: pay_liv_shd.g_api_dml := false; -- Unset the api dml status

279: hr_utility.set_location(' Leaving:'||l_proc, 15);
280: --
281: Exception
282: When Others Then
283: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
284: Raise;
285: --
286: End upd_effective_end_date;
287: --

Line 361: Fetch C_Sel1 Into pay_liv_shd.g_old_rec;

357: --
358: -- We must select and lock the current row.
359: --
360: Open C_Sel1;
361: Fetch C_Sel1 Into pay_liv_shd.g_old_rec;
362: If C_Sel1%notfound then
363: Close C_Sel1;
364: --
365: -- The primary key is invalid therefore we must error

Line 372: <> pay_liv_shd.g_old_rec.object_version_number) Then

368: fnd_message.raise_error;
369: End If;
370: Close C_Sel1;
371: If (p_object_version_number
372: <> pay_liv_shd.g_old_rec.object_version_number) Then
373: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
374: fnd_message.raise_error;
375: End If;
376: --

Line 389: ,p_parent_key_value1 => pay_liv_shd.g_old_rec.input_value_id

385: ,p_base_key_column => 'link_input_value_id'
386: ,p_base_key_value => p_link_input_value_id
387: ,p_parent_table_name1 => 'pay_input_values_f'
388: ,p_parent_key_column1 => 'input_value_id'
389: ,p_parent_key_value1 => pay_liv_shd.g_old_rec.input_value_id
390: ,p_parent_table_name2 => 'pay_element_links_f'
391: ,p_parent_key_column2 => 'element_link_id'
392: ,p_parent_key_value2 => pay_liv_shd.g_old_rec.element_link_id
393: ,p_enforce_foreign_locking => true

Line 392: ,p_parent_key_value2 => pay_liv_shd.g_old_rec.element_link_id

388: ,p_parent_key_column1 => 'input_value_id'
389: ,p_parent_key_value1 => pay_liv_shd.g_old_rec.input_value_id
390: ,p_parent_table_name2 => 'pay_element_links_f'
391: ,p_parent_key_column2 => 'element_link_id'
392: ,p_parent_key_value2 => pay_liv_shd.g_old_rec.element_link_id
393: ,p_enforce_foreign_locking => true
394: ,p_validation_start_date => l_validation_start_date
395: ,p_validation_end_date => l_validation_end_date
396: );

Line 471: end pay_liv_shd;

467: Return(l_rec);
468: --
469: End convert_args;
470: --
471: end pay_liv_shd;