DBA Data[Home] [Help]

APPS.PER_PMA_BUS dependencies on PER_APPRAISAL_PERIODS

Line 126: ,p_descflex_name => 'PER_APPRAISAL_PERIODS'

122: -- b) During insert.
123: --
124: hr_dflex_utility.ins_or_upd_descflex_attribs
125: (p_appl_short_name => 'PER'
126: ,p_descflex_name => 'PER_APPRAISAL_PERIODS'
127: ,p_attribute_category => p_rec.attribute_category
128: ,p_attribute1_name => 'ATTRIBUTE1'
129: ,p_attribute1_value => p_rec.attribute1
130: ,p_attribute2_name => 'ATTRIBUTE2'

Line 364: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.PLAN_ID')

360: EXCEPTION
361:
362: WHEN app_exception.application_exception THEN
363: IF hr_multi_message.exception_add
364: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.PLAN_ID')
365: THEN
366: hr_utility.set_location(' Leaving:'|| l_proc, 980);
367: RAISE;
368: END IF;

Line 439: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.APPRAISAL_TEMPLATE_ID')

435: EXCEPTION
436:
437: WHEN app_exception.application_exception THEN
438: IF hr_multi_message.exception_add
439: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.APPRAISAL_TEMPLATE_ID')
440: THEN
441: hr_utility.set_location(' Leaving:'|| l_proc, 980);
442: RAISE;
443: END IF;

Line 592: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.START_DATE'

588: EXCEPTION
589:
590: WHEN app_exception.application_exception THEN
591: IF hr_multi_message.exception_add
592: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.START_DATE'
593: ,p_associated_column2 => 'PER_APPRAISAL_PERIODS.END_DATE')
594: THEN
595: hr_utility.set_location(' Leaving:'|| l_proc, 980);
596: RAISE;

Line 593: ,p_associated_column2 => 'PER_APPRAISAL_PERIODS.END_DATE')

589:
590: WHEN app_exception.application_exception THEN
591: IF hr_multi_message.exception_add
592: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.START_DATE'
593: ,p_associated_column2 => 'PER_APPRAISAL_PERIODS.END_DATE')
594: THEN
595: hr_utility.set_location(' Leaving:'|| l_proc, 980);
596: RAISE;
597: END IF;

Line 642: FROM per_appraisal_periods pma

638: --
639:
640: CURSOR csr_chk_duplicate IS
641: SELECT 'TRUE'
642: FROM per_appraisal_periods pma
643: WHERE pma.plan_id = p_plan_id
644: AND pma.appraisal_template_id = p_appraisal_template_id
645: AND pma.start_date = p_start_date
646: AND pma.end_date = p_end_date

Line 789: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.INITIATOR_CODE'

785:
786: exception
787: when app_exception.application_exception then
788: IF hr_multi_message.exception_add
789: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.INITIATOR_CODE'
790: ) THEN
791: hr_utility.set_location(' Leaving:'||l_proc, 980);
792: raise;
793: END IF;

Line 863: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.TASK_START_DATE'

859: EXCEPTION
860:
861: WHEN app_exception.application_exception THEN
862: IF hr_multi_message.exception_add
863: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.TASK_START_DATE'
864: ,p_associated_column2 => 'PER_APPRAISAL_PERIODS.TASK_END_DATE')
865: THEN
866: hr_utility.set_location(' Leaving:'|| l_proc, 980);
867: RAISE;

Line 864: ,p_associated_column2 => 'PER_APPRAISAL_PERIODS.TASK_END_DATE')

860:
861: WHEN app_exception.application_exception THEN
862: IF hr_multi_message.exception_add
863: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.TASK_START_DATE'
864: ,p_associated_column2 => 'PER_APPRAISAL_PERIODS.TASK_END_DATE')
865: THEN
866: hr_utility.set_location(' Leaving:'|| l_proc, 980);
867: RAISE;
868: END IF;