APPS.PER_APR_BUS dependencies on PER_ASSESSMENTS

Line 1252: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE

1248: -- ACCESS STATUS
1249: -- Internal Development Use Only
1250:
1251: Procedure chk_group_date_id
1252: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1253: ,p_group_date in per_assessments.group_date%TYPE
1254: )
1255: is
1256:

Line 1253: ,p_group_date in per_assessments.group_date%TYPE

1249: -- Internal Development Use Only
1250:
1251: Procedure chk_group_date_id
1252: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1253: ,p_group_date in per_assessments.group_date%TYPE
1254: )
1255: is
1256:
1257: l_proc varchar2(72):=g_package||'chk_group_date_id';

Line 1287: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_DATE'

1283: hr_utility.set_location('Leaving:'|| l_proc, 2);
1284: EXCEPTION
1285: when app_exception.application_exception then
1286: if hr_multi_message.exception_add
1287: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_DATE'
1288: ) then
1289: raise;
1290: end if;
1291:

Line 1319: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE

1315: -- ACCESS STATUS
1316: -- Internal Development Use Only
1317:
1318: Procedure chk_group_initiator_id
1319: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1320: ,p_business_group_id in per_assessments.business_group_id%TYPE
1321: ,p_group_date in per_assessments.group_date%TYPE
1322: )
1323: is

Line 1320: ,p_business_group_id in per_assessments.business_group_id%TYPE

1316: -- Internal Development Use Only
1317:
1318: Procedure chk_group_initiator_id
1319: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1320: ,p_business_group_id in per_assessments.business_group_id%TYPE
1321: ,p_group_date in per_assessments.group_date%TYPE
1322: )
1323: is
1324:

Line 1321: ,p_group_date in per_assessments.group_date%TYPE

1317:
1318: Procedure chk_group_initiator_id
1319: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1320: ,p_business_group_id in per_assessments.business_group_id%TYPE
1321: ,p_group_date in per_assessments.group_date%TYPE
1322: )
1323: is
1324:
1325: l_proc varchar2(72):=g_package||'chk_group_initiator_id';

Line 1399: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_INITIATOR_ID'

1395:
1396: EXCEPTION
1397: when app_exception.application_exception then
1398: if hr_multi_message.exception_add
1399: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_INITIATOR_ID'
1400: ) then
1401: raise;
1402: end if;
1403: end chk_group_initiator_id;

Line 1819: -- - per_assessments

1815: -- -Appraisal overall_performance_level_id is not null
1816: -- -Appraisal is referenced in:
1817: -- - per_assign_proposal_answers
1818: -- - per_objectives
1819: -- - per_assessments
1820: -- - per_performance_ratings
1821:
1822: -- Pre_conditions:
1823: -- - A valid appraisal_id

Line 1838: -- per_assessments, per_performance_ratings

1834: -- An application error is raised and processing is terminated if any of
1835: -- the following cases are found :
1836: -- - appraisal overall_performance_level_id is not null
1837: -- - appraisal is refrenced in per_assign_proposal_answers, per_objectives
1838: -- per_assessments, per_performance_ratings
1839:
1840: -- Access Status
1841: -- Internal Table Handler Use Only.
1842:

Line 1875: -- Cursor to check if the appraisal is used in per_assessments

1871: select 'Y'
1872: from per_objectives
1873: where appraisal_id = p_appraisal_id;
1874:
1875: -- Cursor to check if the appraisal is used in per_assessments
1876:
1877: cursor csr_apr_exists_in_assessments
1878: is
1879: select 'Y'

Line 1880: from per_assessments

1876:
1877: cursor csr_apr_exists_in_assessments
1878: is
1879: select 'Y'
1880: from per_assessments
1881: where appraisal_id = p_appraisal_id;
1882:
1883: -- Cursor to check if the appraisal is used in per_performance_ratings
1884: