APPS.OTA_LME_SHD dependencies on OTA_LME_SHD

Line 1: Package Body ota_lme_shd as

1: Package Body ota_lme_shd as
2: /* $Header: otlmerhi.pkb 120.0.12010000.2 2009/05/14 08:48:52 pekasi ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 108: = ota_lme_shd.g_old_rec.lp_member_enrollment_id and

104: --
105: l_fct_ret := false;
106: Else
107: If (p_lp_member_enrollment_id
108: = ota_lme_shd.g_old_rec.lp_member_enrollment_id and
109: p_object_version_number
110: = ota_lme_shd.g_old_rec.object_version_number
111: ) Then
112: --

Line 110: = ota_lme_shd.g_old_rec.object_version_number

106: Else
107: If (p_lp_member_enrollment_id
108: = ota_lme_shd.g_old_rec.lp_member_enrollment_id and
109: p_object_version_number
110: = ota_lme_shd.g_old_rec.object_version_number
111: ) Then
112: --
113: -- The g_old_rec is current therefore we must
114: -- set the returning function to true

Line 122: Fetch C_Sel1 Into ota_lme_shd.g_old_rec;

118: --
119: -- Select the current row into g_old_rec
120: --
121: Open C_Sel1;
122: Fetch C_Sel1 Into ota_lme_shd.g_old_rec;
123: If C_Sel1%notfound Then
124: Close C_Sel1;
125: --
126: -- The primary key is invalid therefore we must error

Line 133: <> ota_lme_shd.g_old_rec.object_version_number) Then

129: fnd_message.raise_error;
130: End If;
131: Close C_Sel1;
132: If (p_object_version_number
133: <> ota_lme_shd.g_old_rec.object_version_number) Then
134: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
135: fnd_message.raise_error;
136: End If;
137: l_fct_ret := true;

Line 220: Fetch C_Sel1 Into ota_lme_shd.g_old_rec;

216: ,p_argument_value => p_object_version_number
217: );
218: --
219: Open C_Sel1;
220: Fetch C_Sel1 Into ota_lme_shd.g_old_rec;
221: If C_Sel1%notfound then
222: Close C_Sel1;
223: --
224: -- The primary key is invalid therefore we must error

Line 231: <> ota_lme_shd.g_old_rec.object_version_number) Then

227: fnd_message.raise_error;
228: End If;
229: Close C_Sel1;
230: If (p_object_version_number
231: <> ota_lme_shd.g_old_rec.object_version_number) Then
232: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
233: fnd_message.raise_error;
234: End If;
235: --

Line 355: end ota_lme_shd;

351: Return(l_rec);
352: --
353: End convert_args;
354: --
355: end ota_lme_shd;