DBA Data[Home] [Help]

APPS.HR_HTL_SHD dependencies on HR_HTL_SHD

Line 1: Package Body hr_htl_shd as

1: Package Body hr_htl_shd as
2: /* $Header: hrhtlrhi.pkb 115.1 2004/04/05 07:20:54 menderby noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 71: = hr_htl_shd.g_old_rec.hierarchy_id and

67: --
68: l_fct_ret := false;
69: Else
70: If (p_hierarchy_id
71: = hr_htl_shd.g_old_rec.hierarchy_id and
72: p_language
73: = hr_htl_shd.g_old_rec.language
74: ) Then
75: --

Line 73: = hr_htl_shd.g_old_rec.language

69: Else
70: If (p_hierarchy_id
71: = hr_htl_shd.g_old_rec.hierarchy_id and
72: p_language
73: = hr_htl_shd.g_old_rec.language
74: ) Then
75: --
76: -- The g_old_rec is current therefore we must
77: -- set the returning function to true

Line 85: Fetch C_Sel1 Into hr_htl_shd.g_old_rec;

81: --
82: -- Select the current row into g_old_rec
83: --
84: Open C_Sel1;
85: Fetch C_Sel1 Into hr_htl_shd.g_old_rec;
86: If C_Sel1%notfound Then
87: Close C_Sel1;
88: --
89: -- The primary key is invalid therefore we must error

Line 143: Fetch C_Sel1 Into hr_htl_shd.g_old_rec;

139: ,p_argument_value => p_language
140: );
141: --
142: Open C_Sel1;
143: Fetch C_Sel1 Into hr_htl_shd.g_old_rec;
144: If C_Sel1%notfound then
145: Close C_Sel1;
146: --
147: -- The primary key is invalid therefore we must error

Line 278: end hr_htl_shd;

274: Return(l_rec);
275: --
276: End convert_args;
277: --
278: end hr_htl_shd;