DBA Data[Home] [Help]

APPS.PQH_CEC_BUS dependencies on PQH_CEC_SHD

Line 46: l_api_updating := pqh_cec_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_cec_shd.api_updating
47: (p_context => p_context,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqh_cec_shd.g_old_rec.context) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_context,hr_api.g_varchar2)
52: <> pqh_cec_shd.g_old_rec.context) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_cec_shd.constraint_error('PQH_COPY_ENTITY_CONTEXTS_PK');

Line 56: pqh_cec_shd.constraint_error('PQH_COPY_ENTITY_CONTEXTS_PK');

52: <> pqh_cec_shd.g_old_rec.context) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_cec_shd.constraint_error('PQH_COPY_ENTITY_CONTEXTS_PK');
57: --
58: -- elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 67: -- pqh_cec_shd.constraint_error('PQH_COPY_ENTITY_CONTEXTS_PK');

63: -- if p_context is not null then
64: --
65: -- raise error as PK is not null
66: --
67: -- pqh_cec_shd.constraint_error('PQH_COPY_ENTITY_CONTEXTS_PK');
68: --
69: -- end if;
70: --
71: end if;

Line 80: Procedure insert_validate(p_rec in pqh_cec_shd.g_rec_type) is

76: --
77: -- ----------------------------------------------------------------------------
78: -- |---------------------------< insert_validate >----------------------------|
79: -- ----------------------------------------------------------------------------
80: Procedure insert_validate(p_rec in pqh_cec_shd.g_rec_type) is
81: --
82: l_proc varchar2(72) := g_package||'insert_validate';
83: --
84: Begin

Line 101: Procedure update_validate(p_rec in pqh_cec_shd.g_rec_type) is

97: --
98: -- ----------------------------------------------------------------------------
99: -- |---------------------------< update_validate >----------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure update_validate(p_rec in pqh_cec_shd.g_rec_type) is
102: --
103: l_proc varchar2(72) := g_package||'update_validate';
104: --
105: Begin

Line 122: Procedure delete_validate(p_rec in pqh_cec_shd.g_rec_type) is

118: --
119: -- ----------------------------------------------------------------------------
120: -- |---------------------------< delete_validate >----------------------------|
121: -- ----------------------------------------------------------------------------
122: Procedure delete_validate(p_rec in pqh_cec_shd.g_rec_type) is
123: --
124: l_proc varchar2(72) := g_package||'delete_validate';
125: --
126: Begin