APPS.PER_DPF_BUS dependencies on PER_DEPLOYMENT_FACTORS

Line 62: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_PK');

58: <> per_dpf_shd.g_old_rec.deployment_factor_id) then
59: --
60: -- raise error as PK has changed
61: --
62: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_PK');
63: --
64: elsif not l_api_updating then
65: --
66: -- check if PK is null

Line 72: per_esa_shd.constraint_error('PER_DEPLOYMENT_FACTORS_PK');

68: if p_deployment_factor_id is not null then
69: --
70: -- raise error as PK is not null
71: --
72: per_esa_shd.constraint_error('PER_DEPLOYMENT_FACTORS_PK');
73: --
74: end if;
75: --
76: end if;

Line 248: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_FK2');

244: fetch c1 into l_dummy;
245: if c1%notfound then
246: --
247: close c1;
248: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_FK2');
249: --
250: end if;
251: --
252: close c1;

Line 334: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_FK1');

330: fetch c1 into l_dummy;
331: if c1%notfound then
332: --
333: close c1;
334: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_FK1');
335: --
336: end if;
337: --
338: close c1;

Line 1634: from per_deployment_factors per

1630: l_dummy varchar2(1);
1631: --
1632: cursor c1 is
1633: select null
1634: from per_deployment_factors per
1635: where per.deployment_factor_id <> nvl(p_deployment_factor_id,-1)
1636: and nvl(per.job_id,-1) = nvl(p_job_id,-1)
1637: and nvl(per.position_id,-1) = nvl(p_position_id,-1)
1638: and nvl(per.person_id,-1) = nvl(p_person_id,-1);

Line 1666: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_UK');

1662: fetch c1 into l_dummy;
1663: if c1%found then
1664: --
1665: close c1;
1666: per_dpf_shd.constraint_error('PER_DEPLOYMENT_FACTORS_UK');
1667: --
1668: end if;
1669: --
1670: close c1;

Line 1900: ,p_descflex_name => 'PER_DEPLOYMENT_FACTORS'

1896: -- b) During insert.
1897: --
1898: hr_dflex_utility.ins_or_upd_descflex_attribs
1899: (p_appl_short_name => 'PER'
1900: ,p_descflex_name => 'PER_DEPLOYMENT_FACTORS'
1901: ,p_attribute_category => p_rec.attribute_category
1902: ,p_attribute1_name => 'ATTRIBUTE1'
1903: ,p_attribute1_value => p_rec.attribute1
1904: ,p_attribute2_name => 'ATTRIBUTE2'

Line 2353: (p_deployment_factor_id in per_deployment_factors.deployment_factor_id%TYPE

2349: -- |---------------------< return_legislation_code >-------------------------|
2350: -- ---------------------------------------------------------------------------
2351: --
2352: function return_legislation_code
2353: (p_deployment_factor_id in per_deployment_factors.deployment_factor_id%TYPE
2354: ) return varchar2 is
2355: --
2356: -- to find legislation code
2357: --

Line 2361: , per_deployment_factors pdf

2357: --
2358: cursor csr_leg_code is
2359: select pbg.legislation_code
2360: from per_business_groups pbg
2361: , per_deployment_factors pdf
2362: where pdf.deployment_factor_id = p_deployment_factor_id
2363: and pbg.business_group_id = pdf.business_group_id;
2364: --
2365: -- Declare local variables