APPS.PER_CAI_SHD dependencies on PER_CAI_SHD

Line 1: Package Body per_cai_shd as

1: Package Body per_cai_shd as
2: /* $Header: pecairhi.pkb 115.1 2002/12/04 05:50:07 raranjan noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 70: = per_cai_shd.g_old_rec.cagr_api_id and

66: --
67: l_fct_ret := false;
68: Else
69: If (p_cagr_api_id
70: = per_cai_shd.g_old_rec.cagr_api_id and
71: p_object_version_number
72: = per_cai_shd.g_old_rec.object_version_number
73: ) Then
74: --

Line 72: = per_cai_shd.g_old_rec.object_version_number

68: Else
69: If (p_cagr_api_id
70: = per_cai_shd.g_old_rec.cagr_api_id and
71: p_object_version_number
72: = per_cai_shd.g_old_rec.object_version_number
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_cai_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_cai_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 95: <> per_cai_shd.g_old_rec.object_version_number) Then

91: fnd_message.raise_error;
92: End If;
93: Close C_Sel1;
94: If (p_object_version_number
95: <> per_cai_shd.g_old_rec.object_version_number) Then
96: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
97: fnd_message.raise_error;
98: End If;
99: l_fct_ret := true;

Line 138: Fetch C_Sel1 Into per_cai_shd.g_old_rec;

134: ,p_argument_value => p_cagr_api_id
135: );
136: --
137: Open C_Sel1;
138: Fetch C_Sel1 Into per_cai_shd.g_old_rec;
139: If C_Sel1%notfound then
140: Close C_Sel1;
141: --
142: -- The primary key is invalid therefore we must error

Line 149: <> per_cai_shd.g_old_rec.object_version_number) Then

145: fnd_message.raise_error;
146: End If;
147: Close C_Sel1;
148: If (p_object_version_number
149: <> per_cai_shd.g_old_rec.object_version_number) Then
150: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
151: fnd_message.raise_error;
152: End If;
153: --

Line 197: end per_cai_shd;

193: Return(l_rec);
194: --
195: End convert_args;
196: --
197: end per_cai_shd;