APPS.OTA_TPS_SHD dependencies on OTA_TPS_SHD

Line 1: Package Body ota_tps_shd as

1: Package Body ota_tps_shd as
2: /* $Header: ottpsrhi.pkb 120.2 2005/12/14 15:17:58 asud noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 131: = ota_tps_shd.g_old_rec.training_plan_id and

127: --
128: l_fct_ret := false;
129: Else
130: If (p_training_plan_id
131: = ota_tps_shd.g_old_rec.training_plan_id and
132: p_object_version_number
133: = ota_tps_shd.g_old_rec.object_version_number
134: ) Then
135: --

Line 133: = ota_tps_shd.g_old_rec.object_version_number

129: Else
130: If (p_training_plan_id
131: = ota_tps_shd.g_old_rec.training_plan_id and
132: p_object_version_number
133: = ota_tps_shd.g_old_rec.object_version_number
134: ) Then
135: --
136: -- The g_old_rec is current therefore we must
137: -- set the returning function to true

Line 145: Fetch C_Sel1 Into ota_tps_shd.g_old_rec;

141: --
142: -- Select the current row into g_old_rec
143: --
144: Open C_Sel1;
145: Fetch C_Sel1 Into ota_tps_shd.g_old_rec;
146: If C_Sel1%notfound Then
147: Close C_Sel1;
148: --
149: -- The primary key is invalid therefore we must error

Line 156: <> ota_tps_shd.g_old_rec.object_version_number) Then

152: fnd_message.raise_error;
153: End If;
154: Close C_Sel1;
155: If (p_object_version_number
156: <> ota_tps_shd.g_old_rec.object_version_number) Then
157: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
158: fnd_message.raise_error;
159: End If;
160: l_fct_ret := true;

Line 243: Fetch C_Sel1 Into ota_tps_shd.g_old_rec;

239: ,p_argument_value => p_training_plan_id
240: );
241: --
242: Open C_Sel1;
243: Fetch C_Sel1 Into ota_tps_shd.g_old_rec;
244: If C_Sel1%notfound then
245: Close C_Sel1;
246: --
247: -- The primary key is invalid therefore we must error

Line 254: <> ota_tps_shd.g_old_rec.object_version_number) Then

250: fnd_message.raise_error;
251: End If;
252: Close C_Sel1;
253: If (p_object_version_number
254: <> ota_tps_shd.g_old_rec.object_version_number) Then
255: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
256: fnd_message.raise_error;
257: End If;
258: --

Line 391: end ota_tps_shd;

387: Return(l_rec);
388: --
389: End convert_args;
390: --
391: end ota_tps_shd;