APPS.PQH_TRL_SHD dependencies on PQH_TRL_SHD

Line 1: Package Body pqh_trl_shd as

1: Package Body pqh_trl_shd as
2: /* $Header: pqtrlrhi.pkb 115.3 2002/12/12 21:39:54 rpasapul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 66: = pqh_trl_shd.g_old_rec.table_route_id and

62: --
63: l_fct_ret := false;
64: Else
65: If (p_table_route_id
66: = pqh_trl_shd.g_old_rec.table_route_id and
67: p_language
68: = pqh_trl_shd.g_old_rec.language
69: ) Then
70: --

Line 68: = pqh_trl_shd.g_old_rec.language

64: Else
65: If (p_table_route_id
66: = pqh_trl_shd.g_old_rec.table_route_id and
67: p_language
68: = pqh_trl_shd.g_old_rec.language
69: ) Then
70: --
71: -- The g_old_rec is current therefore we must
72: -- set the returning function to true

Line 80: Fetch C_Sel1 Into pqh_trl_shd.g_old_rec;

76: --
77: -- Select the current row into g_old_rec
78: --
79: Open C_Sel1;
80: Fetch C_Sel1 Into pqh_trl_shd.g_old_rec;
81: If C_Sel1%notfound Then
82: Close C_Sel1;
83: --
84: -- The primary key is invalid therefore we must error

Line 137: Fetch C_Sel1 Into pqh_trl_shd.g_old_rec;

133: ,p_argument_value => p_language
134: );
135: --
136: Open C_Sel1;
137: Fetch C_Sel1 Into pqh_trl_shd.g_old_rec;
138: If C_Sel1%notfound then
139: Close C_Sel1;
140: --
141: -- The primary key is invalid therefore we must error

Line 257: end pqh_trl_shd;

253: Return(l_rec);
254: --
255: End convert_args;
256: --
257: end pqh_trl_shd;