APPS.HR_OTT_SHD dependencies on HR_OTT_SHD

Line 1: PACKAGE BODY HR_OTT_SHD as

1: PACKAGE BODY HR_OTT_SHD as
2: /* $Header: hrottrhi.pkb 115.1 2004/04/05 07:21:14 menderby noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 71: = hr_ott_shd.g_old_rec.option_type_id and

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

Line 73: = hr_ott_shd.g_old_rec.language

69: Else
70: If (p_option_type_id
71: = hr_ott_shd.g_old_rec.option_type_id and
72: p_language
73: = hr_ott_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_ott_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_ott_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 142: Fetch C_Sel1 Into hr_ott_shd.g_old_rec;

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

Line 263: end hr_ott_shd;

259: Return(l_rec);
260: --
261: End convert_args;
262: --
263: end hr_ott_shd;