APPS.PER_APR_BUS dependencies on PER_ASSESSMENTS

Line 1374: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE

1370: -- ACCESS STATUS
1371: -- Internal Development Use Only
1372:
1373: Procedure chk_group_date_id
1374: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1375: ,p_group_date in per_assessments.group_date%TYPE
1376: )
1377: is
1378:

Line 1375: ,p_group_date in per_assessments.group_date%TYPE

1371: -- Internal Development Use Only
1372:
1373: Procedure chk_group_date_id
1374: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1375: ,p_group_date in per_assessments.group_date%TYPE
1376: )
1377: is
1378:
1379: l_proc varchar2(72):=g_package||'chk_group_date_id';

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

1405: hr_utility.set_location('Leaving:'|| l_proc, 2);
1406: EXCEPTION
1407: when app_exception.application_exception then
1408: if hr_multi_message.exception_add
1409: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_DATE'
1410: ) then
1411: raise;
1412: end if;
1413:

Line 1441: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE

1437: -- ACCESS STATUS
1438: -- Internal Development Use Only
1439:
1440: Procedure chk_group_initiator_id
1441: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1442: ,p_business_group_id in per_assessments.business_group_id%TYPE
1443: ,p_group_date in per_assessments.group_date%TYPE
1444: )
1445: is

Line 1442: ,p_business_group_id in per_assessments.business_group_id%TYPE

1438: -- Internal Development Use Only
1439:
1440: Procedure chk_group_initiator_id
1441: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1442: ,p_business_group_id in per_assessments.business_group_id%TYPE
1443: ,p_group_date in per_assessments.group_date%TYPE
1444: )
1445: is
1446:

Line 1443: ,p_group_date in per_assessments.group_date%TYPE

1439:
1440: Procedure chk_group_initiator_id
1441: (p_group_initiator_id in per_assessments.group_initiator_id%TYPE
1442: ,p_business_group_id in per_assessments.business_group_id%TYPE
1443: ,p_group_date in per_assessments.group_date%TYPE
1444: )
1445: is
1446:
1447: l_proc varchar2(72):=g_package||'chk_group_initiator_id';

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

1517:
1518: EXCEPTION
1519: when app_exception.application_exception then
1520: if hr_multi_message.exception_add
1521: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_INITIATOR_ID'
1522: ) then
1523: raise;
1524: end if;
1525: end chk_group_initiator_id;

Line 1987: -- - per_assessments

1983: -- -Appraisal overall_performance_level_id is not null
1984: -- -Appraisal is referenced in:
1985: -- - per_assign_proposal_answers
1986: -- - per_objectives
1987: -- - per_assessments
1988: -- - per_performance_ratings
1989:
1990: -- Pre_conditions:
1991: -- - A valid appraisal_id

Line 2006: -- per_assessments, per_performance_ratings

2002: -- An application error is raised and processing is terminated if any of
2003: -- the following cases are found :
2004: -- - appraisal overall_performance_level_id is not null
2005: -- - appraisal is refrenced in per_assign_proposal_answers, per_objectives
2006: -- per_assessments, per_performance_ratings
2007:
2008: -- Access Status
2009: -- Internal Table Handler Use Only.
2010:

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

2039: select 'Y'
2040: from per_objectives
2041: where appraisal_id = p_appraisal_id;
2042:
2043: -- Cursor to check if the appraisal is used in per_assessments
2044:
2045: cursor csr_apr_exists_in_assessments
2046: is
2047: select 'Y'

Line 2048: from per_assessments

2044:
2045: cursor csr_apr_exists_in_assessments
2046: is
2047: select 'Y'
2048: from per_assessments
2049: where appraisal_id = p_appraisal_id;
2050:
2051: -- Cursor to check if the appraisal is used in per_performance_ratings
2052: