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 120.0.12010000.2 2009/05/27 06:36:51 brsinha ship $ */
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 401: Fetch C_Sel1 Into per_abv_shd.g_old_rec;

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

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

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

Line 509: end per_abv_shd;

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