APPS.PQH_DST_BUS dependencies on PQH_DFLT_BUDGET_SETS

Line 56: pqh_dst_shd.constraint_error('PQH_DFLT_BUDGET_SETS_PK');

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

Line 66: pqh_dst_shd.constraint_error('PQH_DFLT_BUDGET_SETS_PK');

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

Line 88: from pqh_dflt_budget_sets

84: l_dummy varchar2(1) ;
85:
86: cursor csr_budget_set_name is
87: select 'X'
88: from pqh_dflt_budget_sets
89: where dflt_budget_set_name = p_dflt_budget_set_name
90: and dflt_budget_set_id <> nvl(p_dflt_budget_set_id,0);
91:
92: Begin

Line 191: pqh_dflt_budget_sets b

187: --
188: cursor csr_leg_code is
189: select a.legislation_code
190: from per_business_groups a,
191: pqh_dflt_budget_sets b
192: where b.dflt_budget_set_id = p_dflt_budget_set_id
193: and a.business_group_id = b.business_group_id;
194: --
195: -- Declare local variables