APPS.PER_OSE_SHD dependencies on PER_OSE_SHD

Line 1: Package Body per_ose_shd as

1: Package Body per_ose_shd as
2: /* $Header: peoserhi.pkb 120.2.12000000.1 2007/01/22 00:38:55 appldev ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 113: = per_ose_shd.g_old_rec.org_structure_element_id and

109: --
110: l_fct_ret := false;
111: Else
112: If (p_org_structure_element_id
113: = per_ose_shd.g_old_rec.org_structure_element_id and
114: p_object_version_number
115: = per_ose_shd.g_old_rec.object_version_number
116: ) Then
117: --

Line 115: = per_ose_shd.g_old_rec.object_version_number

111: Else
112: If (p_org_structure_element_id
113: = per_ose_shd.g_old_rec.org_structure_element_id and
114: p_object_version_number
115: = per_ose_shd.g_old_rec.object_version_number
116: ) Then
117: --
118: -- The g_old_rec is current therefore we must
119: -- set the returning function to true

Line 127: Fetch C_Sel1 Into per_ose_shd.g_old_rec;

123: --
124: -- Select the current row into g_old_rec
125: --
126: Open C_Sel1;
127: Fetch C_Sel1 Into per_ose_shd.g_old_rec;
128: If C_Sel1%notfound Then
129: Close C_Sel1;
130: --
131: -- The primary key is invalid therefore we must error

Line 138: <> per_ose_shd.g_old_rec.object_version_number) Then

134: fnd_message.raise_error;
135: End If;
136: Close C_Sel1;
137: If (p_object_version_number
138: <> per_ose_shd.g_old_rec.object_version_number) Then
139: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
140: fnd_message.raise_error;
141: End If;
142: l_fct_ret := true;

Line 188: Fetch C_Sel1 Into per_ose_shd.g_old_rec;

184: ,p_argument_value => p_org_structure_element_id
185: );
186: --
187: Open C_Sel1;
188: Fetch C_Sel1 Into per_ose_shd.g_old_rec;
189: If C_Sel1%notfound then
190: Close C_Sel1;
191: --
192: -- The primary key is invalid therefore we must error

Line 199: <> per_ose_shd.g_old_rec.object_version_number) Then

195: fnd_message.raise_error;
196: End If;
197: Close C_Sel1;
198: If (p_object_version_number
199: <> per_ose_shd.g_old_rec.object_version_number) Then
200: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
201: fnd_message.raise_error;
202: End If;
203: --

Line 261: end per_ose_shd;

257: Return(l_rec);
258: --
259: End convert_args;
260: --
261: end per_ose_shd;