APPS.PQH_OPL_SHD dependencies on PQH_OPL_SHD

Line 1: Package Body pqh_opl_shd as

1: Package Body pqh_opl_shd as
2: /* $Header: pqoplrhi.pkb 115.4 2002/12/03 00:09:31 rpasapul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 70: = pqh_opl_shd.g_old_rec.operation_id and

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

Line 72: = pqh_opl_shd.g_old_rec.object_version_number

68: Else
69: If (p_operation_id
70: = pqh_opl_shd.g_old_rec.operation_id and
71: p_object_version_number
72: = pqh_opl_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 pqh_opl_shd.g_old_rec;

80: --
81: -- Select the current row into g_old_rec
82: --
83: Open C_Sel1;
84: Fetch C_Sel1 Into pqh_opl_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: <> pqh_opl_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: <> pqh_opl_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 144: Fetch C_Sel1 Into pqh_opl_shd.g_old_rec;

140: ,p_argument_value => p_object_version_number
141: );
142: --
143: Open C_Sel1;
144: Fetch C_Sel1 Into pqh_opl_shd.g_old_rec;
145: If C_Sel1%notfound then
146: Close C_Sel1;
147: --
148: -- The primary key is invalid therefore we must error

Line 155: <> pqh_opl_shd.g_old_rec.object_version_number) Then

151: fnd_message.raise_error;
152: End If;
153: Close C_Sel1;
154: If (p_object_version_number
155: <> pqh_opl_shd.g_old_rec.object_version_number) Then
156: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
157: fnd_message.raise_error;
158: End If;
159: --

Line 203: end pqh_opl_shd;

199: Return(l_rec);
200: --
201: End convert_args;
202: --
203: end pqh_opl_shd;