APPS.PER_REQ_SHD dependencies on PER_REQ_SHD

Line 1: Package Body per_req_shd as

1: Package Body per_req_shd as
2: /* $Header: pereqrhi.pkb 120.0.12000000.2 2007/07/10 05:22:20 mkjayara noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 110: = per_req_shd.g_old_rec.requisition_id and

106: --
107: l_fct_ret := false;
108: Else
109: If (p_requisition_id
110: = per_req_shd.g_old_rec.requisition_id and
111: p_object_version_number
112: = per_req_shd.g_old_rec.object_version_number
113: ) Then
114: --

Line 112: = per_req_shd.g_old_rec.object_version_number

108: Else
109: If (p_requisition_id
110: = per_req_shd.g_old_rec.requisition_id and
111: p_object_version_number
112: = per_req_shd.g_old_rec.object_version_number
113: ) Then
114: --
115: -- The g_old_rec is current therefore we must
116: -- set the returning function to true

Line 124: Fetch C_Sel1 Into per_req_shd.g_old_rec;

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

Line 135: <> per_req_shd.g_old_rec.object_version_number) Then

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

Line 214: Fetch C_Sel1 Into per_req_shd.g_old_rec;

210: ,p_argument_value => p_object_version_number
211: );
212: --
213: Open C_Sel1;
214: Fetch C_Sel1 Into per_req_shd.g_old_rec;
215: If C_Sel1%notfound then
216: Close C_Sel1;
217: --
218: -- The primary key is invalid therefore we must error

Line 225: <> per_req_shd.g_old_rec.object_version_number) Then

221: fnd_message.raise_error;
222: End If;
223: Close C_Sel1;
224: If (p_object_version_number
225: <> per_req_shd.g_old_rec.object_version_number) Then
226: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
227: fnd_message.raise_error;
228: End If;
229: --

Line 333: end per_req_shd;

329: Return(l_rec);
330: --
331: End convert_args;
332: --
333: end per_req_shd;