APPS.PAY_PGR_SHD dependencies on PAY_PGR_SHD

Line 1: Package Body pay_pgr_shd as

1: Package Body pay_pgr_shd as
2: /* $Header: pypgrrhi.pkb 120.6.12020000.2 2013/01/17 09:39:34 sclakkar ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 111: pay_pgr_shd.g_old_rec.grade_rule_id and

107: --
108: l_fct_ret := false;
109: Else
110: If (p_grade_rule_id =
111: pay_pgr_shd.g_old_rec.grade_rule_id and
112: p_object_version_number =
113: pay_pgr_shd.g_old_rec.object_version_number
114: ) Then
115: --

Line 113: pay_pgr_shd.g_old_rec.object_version_number

109: Else
110: If (p_grade_rule_id =
111: pay_pgr_shd.g_old_rec.grade_rule_id and
112: p_object_version_number =
113: pay_pgr_shd.g_old_rec.object_version_number
114: ) Then
115: --
116: -- The g_old_rec is current therefore we must
117: -- set the returning function to true

Line 125: Fetch C_Sel1 Into pay_pgr_shd.g_old_rec;

121: --
122: -- Select the current row
123: --
124: Open C_Sel1;
125: Fetch C_Sel1 Into pay_pgr_shd.g_old_rec;
126: If C_Sel1%notfound Then
127: Close C_Sel1;
128: --
129: -- The primary key is invalid therefore we must error

Line 136: <> pay_pgr_shd.g_old_rec.object_version_number) Then

132: fnd_message.raise_error;
133: End If;
134: Close C_Sel1;
135: If (p_object_version_number
136: <> pay_pgr_shd.g_old_rec.object_version_number) Then
137: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
138: fnd_message.raise_error;
139: End If;
140: l_fct_ret := true;

Line 243: pay_pgr_shd.g_api_dml := true; -- Set the api dml status

239: ,p_base_key_value => p_base_key_value
240: );
241: --
242: hr_utility.set_location(l_proc, 10);
243: pay_pgr_shd.g_api_dml := true; -- Set the api dml status
244: --
245: -- Update the specified datetrack row setting the effective
246: -- end date to the specified new effective end date.
247: --

Line 255: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status

251: where t.grade_rule_id = p_base_key_value
252: and p_effective_date
253: between t.effective_start_date and t.effective_end_date;
254: --
255: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
256: p_object_version_number := l_object_version_number;
257: hr_utility.set_location(' Leaving:'||l_proc, 15);
258: --
259: Exception

Line 261: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status

257: hr_utility.set_location(' Leaving:'||l_proc, 15);
258: --
259: Exception
260: When Others Then
261: pay_pgr_shd.g_api_dml := false; -- Unset the api dml status
262: Raise;
263: --
264: End upd_effective_end_date;
265: --

Line 348: Fetch C_Sel1 Into pay_pgr_shd.g_old_rec;

344: --
345: -- We must select and lock the current row.
346: --
347: Open C_Sel1;
348: Fetch C_Sel1 Into pay_pgr_shd.g_old_rec;
349: If C_Sel1%notfound then
350: Close C_Sel1;
351: --
352: -- The primary key is invalid therefore we must error

Line 359: <> pay_pgr_shd.g_old_rec.object_version_number) Then

355: fnd_message.raise_error;
356: End If;
357: Close C_Sel1;
358: If (p_object_version_number
359: <> pay_pgr_shd.g_old_rec.object_version_number) Then
360: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
361: fnd_message.raise_error;
362: End If;
363: --

Line 368: IF pay_pgr_shd.g_old_rec.rate_type = 'A' THEN

364: --
365: -- Validate the datetrack mode mode getting the validation start
366: -- and end dates for the specified datetrack operation.
367: --
368: IF pay_pgr_shd.g_old_rec.rate_type = 'A' THEN
369: --
370: hr_utility.set_location(l_proc, 20);
371: --
372: dt_api.validate_dt_mode

Line 380: ,p_parent_key_value1 => pay_pgr_shd.g_old_rec.grade_or_spinal_point_id

376: ,p_base_key_column => 'grade_rule_id'
377: ,p_base_key_value => p_grade_rule_id
378: ,p_parent_table_name1 => 'per_all_assignments_f'
379: ,p_parent_key_column1 => 'assignment_id'
380: ,p_parent_key_value1 => pay_pgr_shd.g_old_rec.grade_or_spinal_point_id
381: ,p_enforce_foreign_locking => true
382: ,p_validation_start_date => l_validation_start_date
383: ,p_validation_end_date => l_validation_end_date);
384: --

Line 490: end pay_pgr_shd;

486: Return(l_rec);
487: --
488: End convert_args;
489: --
490: end pay_pgr_shd;