APPS.PQH_CER_BUS dependencies on PQH_COPY_ENTITY_RESULTS

Line 56: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_PK');

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

Line 66: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_PK');

62: if p_copy_entity_result_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_PK');
67: --
68: end if;
69: --
70: end if;

Line 111: from pqh_copy_entity_results a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from pqh_copy_entity_results a
112: where a.copy_entity_result_id = p_src_copy_entity_result_id;
113: --
114: Begin
115: --

Line 120: -- check if src_copy_entity_result_id value exists in pqh_copy_entity_results table

116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: if p_src_copy_entity_result_id is not null then
119: --
120: -- check if src_copy_entity_result_id value exists in pqh_copy_entity_results table
121: --
122: open c1;
123: --
124: fetch c1 into l_dummy;

Line 129: -- raise error as FK does not relate to PK in pqh_copy_entity_results

125: if c1%notfound then
126: --
127: close c1;
128: --
129: -- raise error as FK does not relate to PK in pqh_copy_entity_results
130: -- table.
131: --
132: -- pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK2');
133: null;

Line 132: -- pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK2');

128: --
129: -- raise error as FK does not relate to PK in pqh_copy_entity_results
130: -- table.
131: --
132: -- pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK2');
133: null;
134: --
135: end if;
136: --

Line 208: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK1');

204: --
205: -- raise error as FK does not relate to PK in pqh_copy_entity_txns
206: -- table.
207: --
208: pqh_cer_shd.constraint_error('PQH_COPY_ENTITY_RESULTS_FK1');
209: --
210: end if;
211: --
212: close c1;