APPS.PQH_BGT_BUS dependencies on PQH_BUDGETS

Line 56: pqh_bgt_shd.constraint_error('PQH_BUDGETS_PK');

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

Line 66: pqh_bgt_shd.constraint_error('PQH_BUDGETS_PK');

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

Line 161: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK4');

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: --
163: end if;
164: --
165: close c1;

Line 259: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK3');

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: --
261: end if;
262: --
263: close c1;

Line 357: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK2');

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: --
359: end if;
360: --
361: close c1;

Line 419: from pqh_budgets

415: l_units varchar2(200);
416:
417: cursor c1 is
418: select budget_unit1_id,budget_unit2_id,budget_unit3_id,budget_name,budget_start_date,budget_end_date
419: from pqh_budgets
420: where position_control_flag ='Y'
421: and (business_group_id = p_business_group_id and business_group_id is not null)
422: and budget_start_date 423: and budget_end_date>p_budget_start_date

Line 544: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK1');

540: --
541: -- raise error as FK does not relate to PK in pay_calendars
542: -- table.
543: --
544: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK1');
545: --
546: end if;
547: --
548: close c1;

Line 1482: from pqh_budgets

1478: l_dummy varchar2(1) ;
1479:
1480: cursor csr_budget_name is
1481: select 'X'
1482: from pqh_budgets
1483: where budget_name = p_budget_name
1484: and budget_id <> nvl(p_budget_id,0);
1485:
1486: Begin

Line 1913: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK5');

1909: --
1910: -- raise error as FK does not relate to PK in fnd_currencies
1911: -- table.
1912: --
1913: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK5');
1914: --
1915: end if;
1916: --
1917: --

Line 2347: pqh_budgets b

2343: --
2344: cursor csr_leg_code is
2345: select a.legislation_code
2346: from per_business_groups a,
2347: pqh_budgets b
2348: where b.budget_id = p_budget_id
2349: and a.business_group_id = b.business_group_id;
2350: --
2351: -- Declare local variables