APPS.PQH_BPL_BUS dependencies on PQH_BUDGET_POOLS

Line 30: , pqh_budget_pools bpl

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_budget_pools bpl
31: where bpl.pool_id = p_pool_id
32: and pbg.business_group_id = bpl.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_budget_pools bpl

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_budget_pools bpl
95: where bpl.pool_id = p_pool_id
96: and pbg.business_group_id (+) = bpl.business_group_id;
97: --
98: -- Declare local variables

Line 249: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_PK');

245: <> pqh_bpl_shd.g_old_rec.pool_id) then
246: --
247: -- raise error as PK has changed
248: --
249: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_PK');
250: --
251: elsif not l_api_updating then
252: --
253: -- check if PK is null

Line 259: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_PK');

255: if p_pool_id is not null then
256: --
257: -- raise error as PK is not null
258: --
259: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_PK');
260: --
261: end if;
262: --
263: end if;

Line 337: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_FK1');

333: --
334: -- raise error as FK does not relate to PK in pqh_budgets
335: -- table.
336: --
337: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_FK1');
338: --
339: end if;
340: --
341: close c1;

Line 500: from pqh_budget_pools

496: l_dummy varchar2(1);
497: --
498: Cursor csr_folder_trnxs IS
499: select null
500: from pqh_budget_pools
501: where parent_pool_id = p_pool_id;
502: Cursor csr_trnx_dtls is
503: Select null
504: from pqh_bdgt_pool_realloctions a

Line 542: -- Check if folder_name is unique in pqh_budget_pools_table

538: hr_utility.set_location('Leaving:'||l_proc, 10);
539: --
540: End chk_upd_allowed;
541: --
542: -- Check if folder_name is unique in pqh_budget_pools_table
543: -- Also, Raise error if the entered folder_name is null.
544: --
545: Procedure chk_pool_name(p_pool_id in number,
546: p_name in varchar2,

Line 557: from pqh_budget_pools a

553: --
554: -- added approval_status<>'T' condition by mvanakda
555: Cursor csr_folder_name is
556: Select null
557: from pqh_budget_pools a
558: Where a.name = p_name
559: AND a.parent_pool_id IS NULL
560: AND (p_pool_id IS NULL or a.pool_id <> p_pool_id)
561: AND a.approval_status<>'T';

Line 564: from pqh_budget_pools a

560: AND (p_pool_id IS NULL or a.pool_id <> p_pool_id)
561: AND a.approval_status<>'T';
562: Cursor csr_trnx_name is
563: Select null
564: from pqh_budget_pools a
565: Where a.name = p_name
566: AND a.parent_pool_id IS NOT NULL
567: AND a.parent_pool_id =p_parent_pool_id
568: AND (p_pool_id IS NULL or a.pool_id <> p_pool_id);

Line 634: from pqh_budget_pools a

630: l_dummy varchar2(1);
631: --
632: Cursor c1 is
633: Select null
634: from pqh_budget_pools a
635: Where budget_version_id = p_budget_version_id
636: AND budget_unit_id = p_budget_unit_id
637: AND (p_pool_id IS NULL or a.pool_id <> p_pool_id);
638: --

Line 662: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_U1');

658: --
659: if c1%found then
660:
661: Close c1;
662: pqh_bpl_shd.constraint_error('PQH_BUDGET_POOLS_U1');
663:
664: End if;
665: --
666: Close c1;