DBA Data[Home] [Help]

APPS.PER_QTT_SHD dependencies on PER_QTT_SHD

Line 1: Package Body per_qtt_shd as

1: Package Body per_qtt_shd as
2: /* $Header: peqttrhi.pkb 115.2 2003/05/13 06:22:26 fsheikh noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 70: = per_qtt_shd.g_old_rec.qualification_type_id and

66: --
67: l_fct_ret := false;
68: Else
69: If (p_qualification_type_id
70: = per_qtt_shd.g_old_rec.qualification_type_id and
71: p_language
72: = per_qtt_shd.g_old_rec.language
73: ) Then
74: --

Line 72: = per_qtt_shd.g_old_rec.language

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

Line 84: Fetch C_Sel1 Into per_qtt_shd.g_old_rec;

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

Line 141: Fetch C_Sel1 Into per_qtt_shd.g_old_rec;

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

Line 262: end per_qtt_shd;

258: Return(l_rec);
259: --
260: End convert_args;
261: --
262: end per_qtt_shd;