APPS.PQH_DEL_BUS dependencies on PQH_DFLT_BUDGET_ELEMENTS

Line 56: pqh_del_shd.constraint_error('PQH_DFLT_BUDGET_ELEMENTS_PK');

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

Line 66: pqh_del_shd.constraint_error('PQH_DFLT_BUDGET_ELEMENTS_PK');

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

Line 139: pqh_del_shd.constraint_error('PQH_DFLT_BUDGET_ELEMENTS_FK1');

135: --
136: -- raise error as FK does not relate to PK in pqh_dflt_budget_sets
137: -- table.
138: --
139: pqh_del_shd.constraint_error('PQH_DFLT_BUDGET_ELEMENTS_FK1');
140: --
141: end if;
142: --
143: close c1;

Line 165: from pqh_dflt_budget_elements

161: l_dummy varchar2(1) ;
162:
163: cursor csr_element is
164: select 'X'
165: from pqh_dflt_budget_elements
166: where dflt_budget_set_id = p_dflt_budget_set_id
167: and dflt_budget_element_id <> nvl(p_dflt_budget_element_id,0)
168: and element_type_id = p_element_type_id;
169:

Line 202: from pqh_dflt_budget_elements

198: l_sum number(15,2) := 0;
199:
200: cursor csr_element is
201: select SUM(NVL(dflt_dist_percentage,0))
202: from pqh_dflt_budget_elements
203: where dflt_budget_set_id = p_dflt_budget_set_id;
204:
205: Begin
206: --