APPS.PAY_FRR_SHD dependencies on PAY_FRR_SHD

Line 1: Package Body pay_frr_shd as

1: Package Body pay_frr_shd as
2: /* $Header: pyfrrrhi.pkb 120.3.12020000.2 2012/07/06 14:00:07 asnell ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 101: pay_frr_shd.g_old_rec.formula_result_rule_id and

97: --
98: l_fct_ret := false;
99: Else
100: If (p_formula_result_rule_id =
101: pay_frr_shd.g_old_rec.formula_result_rule_id and
102: p_object_version_number =
103: pay_frr_shd.g_old_rec.object_version_number
104: ) Then
105: --

Line 103: pay_frr_shd.g_old_rec.object_version_number

99: Else
100: If (p_formula_result_rule_id =
101: pay_frr_shd.g_old_rec.formula_result_rule_id and
102: p_object_version_number =
103: pay_frr_shd.g_old_rec.object_version_number
104: ) Then
105: --
106: -- The g_old_rec is current therefore we must
107: -- set the returning function to true

Line 115: Fetch C_Sel1 Into pay_frr_shd.g_old_rec;

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

Line 126: <> pay_frr_shd.g_old_rec.object_version_number) Then

122: fnd_message.raise_error;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number
126: <> pay_frr_shd.g_old_rec.object_version_number) Then
127: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
128: fnd_message.raise_error;
129: End If;
130: l_fct_ret := true;

Line 233: pay_frr_shd.g_api_dml := true; -- Set the api dml status

229: ,p_base_key_value => p_base_key_value
230: );
231: --
232: hr_utility.set_location(l_proc, 10);
233: pay_frr_shd.g_api_dml := true; -- Set the api dml status
234: --
235: -- Update the specified datetrack row setting the effective
236: -- end date to the specified new effective end date.
237: --

Line 245: pay_frr_shd.g_api_dml := false; -- Unset the api dml status

241: where t.formula_result_rule_id = p_base_key_value
242: and p_effective_date
243: between t.effective_start_date and t.effective_end_date;
244: --
245: pay_frr_shd.g_api_dml := false; -- Unset the api dml status
246: p_object_version_number := l_object_version_number;
247: hr_utility.set_location(' Leaving:'||l_proc, 15);
248: --
249: Exception

Line 251: pay_frr_shd.g_api_dml := false; -- Unset the api dml status

247: hr_utility.set_location(' Leaving:'||l_proc, 15);
248: --
249: Exception
250: When Others Then
251: pay_frr_shd.g_api_dml := false; -- Unset the api dml status
252: Raise;
253: --
254: End upd_effective_end_date;
255: --

Line 331: Fetch C_Sel1 Into pay_frr_shd.g_old_rec;

327: --
328: -- We must select and lock the current row.
329: --
330: Open C_Sel1;
331: Fetch C_Sel1 Into pay_frr_shd.g_old_rec;
332: If C_Sel1%notfound then
333: Close C_Sel1;
334: --
335: -- The primary key is invalid therefore we must error

Line 342: <> pay_frr_shd.g_old_rec.object_version_number) Then

338: fnd_message.raise_error;
339: End If;
340: Close C_Sel1;
341: If (p_object_version_number
342: <> pay_frr_shd.g_old_rec.object_version_number) Then
343: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
344: fnd_message.raise_error;
345: End If;
346: --

Line 439: end pay_frr_shd;

435: Return(l_rec);
436: --
437: End convert_args;
438: --
439: end pay_frr_shd;