APPS.PQH_BGT_BUS dependencies on PER_SHARED_TYPES

Line 114: from per_shared_types a

110: l_dummy varchar2(1);
111: --
112: cursor c1 is
113: select null
114: from per_shared_types a
115: where a.shared_type_id = p_budget_unit3_id;
116: --
117: Begin
118: --

Line 149: -- check if budget_unit3_id value exists in per_shared_types table

145: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)
146: or not l_api_updating) and
147: p_budget_unit3_id is not null then
148: --
149: -- check if budget_unit3_id value exists in per_shared_types table
150: --
151: open c1;
152: --
153: fetch c1 into l_dummy;

Line 158: -- raise error as FK does not relate to PK in per_shared_types

154: if c1%notfound then
155: --
156: close c1;
157: --
158: -- raise error as FK does not relate to PK in per_shared_types
159: -- table.
160: --
161: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK4');
162: --

Line 209: from per_shared_types a

205: l_dummy varchar2(1);
206: --
207: cursor c1 is
208: select null
209: from per_shared_types a
210: where a.shared_type_id = p_budget_unit2_id;
211: --
212: Begin
213: --

Line 247: -- check if budget_unit2_id value exists in per_shared_types table

243: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)
244: or not l_api_updating) and
245: p_budget_unit2_id is not null then
246: --
247: -- check if budget_unit2_id value exists in per_shared_types table
248: --
249: open c1;
250: --
251: fetch c1 into l_dummy;

Line 256: -- raise error as FK does not relate to PK in per_shared_types

252: if c1%notfound then
253: --
254: close c1;
255: --
256: -- raise error as FK does not relate to PK in per_shared_types
257: -- table.
258: --
259: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK3');
260: --

Line 307: from per_shared_types a

303: l_dummy varchar2(1);
304: --
305: cursor c1 is
306: select null
307: from per_shared_types a
308: where a.shared_type_id = p_budget_unit1_id;
309: --
310: Begin
311: --

Line 345: -- check if budget_unit1_id value exists in per_shared_types table

341: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)
342: or not l_api_updating) and
343: p_budget_unit1_id is not null then
344: --
345: -- check if budget_unit1_id value exists in per_shared_types table
346: --
347: open c1;
348: --
349: fetch c1 into l_dummy;

Line 354: -- raise error as FK does not relate to PK in per_shared_types

350: if c1%notfound then
351: --
352: close c1;
353: --
354: -- raise error as FK does not relate to PK in per_shared_types
355: -- table.
356: --
357: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK2');
358: --

Line 1337: from per_shared_types

1333: l_proc varchar2(72) := g_package||'chk_budget_unit_id';
1334:
1335: cursor csr_lookup_cd(p_shared_type_id in number) is
1336: select system_type_cd
1337: from per_shared_types
1338: where shared_type_id = p_shared_type_id;
1339:
1340: l_system_type_cd1 VARCHAR2(50);
1341: l_system_type_cd2 VARCHAR2(50);

Line 1525: from per_shared_types a

1521:
1522: cursor csr_unit is
1523: select a.system_type_cd,
1524: a.shared_type_name
1525: from per_shared_types a
1526: where a.shared_type_id = p_budget_unit1_id;
1527:
1528: --
1529: Begin

Line 1620: from per_shared_types a

1616:
1617: cursor csr_unit is
1618: select a.system_type_cd,
1619: a.shared_type_name
1620: from per_shared_types a
1621: where a.shared_type_id = p_budget_unit2_id;
1622:
1623: --
1624: Begin

Line 1719: from per_shared_types a

1715:
1716: cursor csr_unit is
1717: select a.system_type_cd,
1718: a.shared_type_name
1719: from per_shared_types a
1720: where a.shared_type_id = p_budget_unit3_id;
1721:
1722: --
1723: Begin