DBA Data[Home] [Help]

APPS.PER_ABV_SHD dependencies on PER_ABV_SHD

Line 1: Package Body per_abv_shd as

1: Package Body per_abv_shd as
2: /* $Header: peabvrhi.pkb 115.9 2002/12/03 14:36:09 raranjan noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 156: per_abv_shd.g_old_rec.assignment_budget_value_id and

152: --
153: l_fct_ret := false;
154: Else
155: If (p_assignment_budget_value_id =
156: per_abv_shd.g_old_rec.assignment_budget_value_id and
157: p_object_version_number = g_old_rec.object_version_number) Then
158: --
159: -- The g_old_rec is current therefore we must
160: -- set the returning function to true

Line 168: Fetch C_Sel1 Into per_abv_shd.g_old_rec;

164: --
165: -- Select the current row
166: --
167: Open C_Sel1;
168: Fetch C_Sel1 Into per_abv_shd.g_old_rec;
169: If C_Sel1%notfound Then
170: Close C_Sel1;
171: --
172: -- The primary key is invalid therefore we must error

Line 400: Fetch C_Sel1 Into per_abv_shd.g_old_rec;

396: --
397: -- We must select and lock the current row.
398: --
399: Open C_Sel1;
400: Fetch C_Sel1 Into per_abv_shd.g_old_rec;
401: If C_Sel1%notfound then
402: Close C_Sel1;
403: --
404: -- The primary key is invalid therefore we must error

Line 428: ,p_parent_key_value1 => per_abv_shd.g_old_rec.assignment_id

424: ,p_base_key_column => 'assignment_budget_value_id'
425: ,p_base_key_value => p_assignment_budget_value_id
426: ,p_parent_table_name1 => 'per_all_assignments_f'
427: ,p_parent_key_column1 => 'assignment_id'
428: ,p_parent_key_value1 => per_abv_shd.g_old_rec.assignment_id
429: ,p_enforce_foreign_locking => true
430: ,p_validation_start_date => l_validation_start_date
431: ,p_validation_end_date => l_validation_end_date
432: );

Line 508: end per_abv_shd;

504: Return(l_rec);
505: --
506: End convert_args;
507: --
508: end per_abv_shd;