APPS.PAY_UCI_SHD dependencies on PAY_UCI_SHD

Line 1: Package Body pay_uci_shd as

1: Package Body pay_uci_shd as
2: /* $Header: pyucirhi.pkb 115.0 2003/09/23 07:31 tvankayl noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 92: pay_uci_shd.g_old_rec.user_column_instance_id and

88: --
89: l_fct_ret := false;
90: Else
91: If (p_user_column_instance_id =
92: pay_uci_shd.g_old_rec.user_column_instance_id and
93: p_object_version_number =
94: pay_uci_shd.g_old_rec.object_version_number
95: ) Then
96: --

Line 94: pay_uci_shd.g_old_rec.object_version_number

90: Else
91: If (p_user_column_instance_id =
92: pay_uci_shd.g_old_rec.user_column_instance_id and
93: p_object_version_number =
94: pay_uci_shd.g_old_rec.object_version_number
95: ) Then
96: --
97: -- The g_old_rec is current therefore we must
98: -- set the returning function to true

Line 106: Fetch C_Sel1 Into pay_uci_shd.g_old_rec;

102: --
103: -- Select the current row
104: --
105: Open C_Sel1;
106: Fetch C_Sel1 Into pay_uci_shd.g_old_rec;
107: If C_Sel1%notfound Then
108: Close C_Sel1;
109: --
110: -- The primary key is invalid therefore we must error

Line 117: <> pay_uci_shd.g_old_rec.object_version_number) Then

113: fnd_message.raise_error;
114: End If;
115: Close C_Sel1;
116: If (p_object_version_number
117: <> pay_uci_shd.g_old_rec.object_version_number) Then
118: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
119: fnd_message.raise_error;
120: End If;
121: l_fct_ret := true;

Line 247: pay_uci_shd.g_api_dml := true; -- Set the api dml status

243: ,p_base_key_value => p_base_key_value
244: );
245: --
246: hr_utility.set_location(l_proc, 10);
247: pay_uci_shd.g_api_dml := true; -- Set the api dml status
248: --
249: -- Update the specified datetrack row setting the effective
250: -- end date to the specified new effective end date.
251: --

Line 259: pay_uci_shd.g_api_dml := false; -- Unset the api dml status

255: where t.user_column_instance_id = p_base_key_value
256: and p_effective_date
257: between t.effective_start_date and t.effective_end_date;
258: --
259: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
260: p_object_version_number := l_object_version_number;
261: hr_utility.set_location(' Leaving:'||l_proc, 15);
262: --
263: Exception

Line 265: pay_uci_shd.g_api_dml := false; -- Unset the api dml status

261: hr_utility.set_location(' Leaving:'||l_proc, 15);
262: --
263: Exception
264: When Others Then
265: pay_uci_shd.g_api_dml := false; -- Unset the api dml status
266: Raise;
267: --
268: End upd_effective_end_date;
269: --

Line 341: Fetch C_Sel1 Into pay_uci_shd.g_old_rec;

337: --
338: -- We must select and lock the current row.
339: --
340: Open C_Sel1;
341: Fetch C_Sel1 Into pay_uci_shd.g_old_rec;
342: If C_Sel1%notfound then
343: Close C_Sel1;
344: --
345: -- The primary key is invalid therefore we must error

Line 352: <> pay_uci_shd.g_old_rec.object_version_number) Then

348: fnd_message.raise_error;
349: End If;
350: Close C_Sel1;
351: If (p_object_version_number
352: <> pay_uci_shd.g_old_rec.object_version_number) Then
353: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
354: fnd_message.raise_error;
355: End If;
356: --

Line 369: ,p_parent_key_value1 => pay_uci_shd.g_old_rec.user_row_id

365: ,p_base_key_column => 'user_column_instance_id'
366: ,p_base_key_value => p_user_column_instance_id
367: ,p_parent_table_name1 => 'pay_user_rows_f'
368: ,p_parent_key_column1 => 'user_row_id'
369: ,p_parent_key_value1 => pay_uci_shd.g_old_rec.user_row_id
370: ,p_enforce_foreign_locking => true
371: ,p_validation_start_date => l_validation_start_date
372: ,p_validation_end_date => l_validation_end_date
373: );

Line 444: end pay_uci_shd;

440: Return(l_rec);
441: --
442: End convert_args;
443: --
444: end pay_uci_shd;