APPS.PQH_WEL_BUS dependencies on PQH_WORKSHEET_BUDGET_SETS

Line 111: from pqh_worksheet_budget_sets a

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

Line 127: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table

123: and nvl(p_worksheet_budget_set_id,hr_api.g_number)
124: <> nvl(pqh_wel_shd.g_old_rec.worksheet_budget_set_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;

Line 136: -- raise error as FK does not relate to PK in pqh_worksheet_budget_sets

132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in pqh_worksheet_budget_sets
137: -- table.
138: --
139: pqh_wel_shd.constraint_error('PQH_WORKSHEET_BDGT_ELMNTS_FK2');
140: --

Line 183: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table

179: and nvl(p_element_type_id,hr_api.g_number)
180: <> nvl(pqh_wel_shd.g_old_rec.element_type_id,hr_api.g_number)
181: or not l_api_updating) then
182: --
183: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table
184: --
185: open c1;
186: --
187: fetch c1 into l_dummy;

Line 231: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table

227: <> nvl(pqh_wel_shd.g_old_rec.distribution_percentage,hr_api.g_number)
228: or not l_api_updating)
229: and p_distribution_percentage is not null then
230: --
231: -- check if worksheet_budget_set_id value exists in pqh_worksheet_budget_sets table
232: --
233: If p_distribution_percentage < 0 then
234: hr_utility.set_message(8302,'PQH_INVALID_DISTRIB_PERCENT');
235: hr_utility.raise_error;