87: -- Internal Table Handler Use Only.
88:
89:
90: procedure chk_name
91: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
92: ,p_name in per_appraisal_templates.name%TYPE
93: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
94: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
95: )
88:
89:
90: procedure chk_name
91: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
92: ,p_name in per_appraisal_templates.name%TYPE
93: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
94: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
95: )
96: is
89:
90: procedure chk_name
91: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
92: ,p_name in per_appraisal_templates.name%TYPE
93: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
94: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
95: )
96: is
97:
90: procedure chk_name
91: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
92: ,p_name in per_appraisal_templates.name%TYPE
93: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
94: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
95: )
96: is
97:
98: l_exists varchar2(1);
95: )
96: is
97:
98: l_exists varchar2(1);
99: l_business_group_id per_appraisal_templates.business_group_id%TYPE;
100: l_api_updating boolean;
101: l_proc varchar2(72) := g_package||'chk_name';
102:
103:
105:
106: Cursor csr_name_unique
107: is
108: select business_group_id
109: from per_appraisal_templates apt
110: where ( (p_appraisal_template_id is null)
111: or(p_appraisal_template_id <> apt.appraisal_template_id)
112: )
113: and apt.name = p_name and
197: -- Access Status
198: -- Internal Development Use Only
199:
200: Procedure chk_template_dates
201: (p_date_from in per_appraisal_templates.date_from%TYPE
202: ,p_date_to in per_appraisal_templates.date_to%TYPE
203: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
204: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
205: ) is
198: -- Internal Development Use Only
199:
200: Procedure chk_template_dates
201: (p_date_from in per_appraisal_templates.date_from%TYPE
202: ,p_date_to in per_appraisal_templates.date_to%TYPE
203: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
204: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
205: ) is
206:
199:
200: Procedure chk_template_dates
201: (p_date_from in per_appraisal_templates.date_from%TYPE
202: ,p_date_to in per_appraisal_templates.date_to%TYPE
203: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
204: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
205: ) is
206:
207: l_exists varchar2(1);
200: Procedure chk_template_dates
201: (p_date_from in per_appraisal_templates.date_from%TYPE
202: ,p_date_to in per_appraisal_templates.date_to%TYPE
203: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
204: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
205: ) is
206:
207: l_exists varchar2(1);
208: l_api_updating boolean;
309: -- Access Status
310: -- Internal Table Handler Use Only.
311:
312: procedure chk_assessment_type
313: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
314: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
315: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
316: ,p_date_from in per_appraisal_templates.date_from%TYPE
317: ,p_date_to in per_appraisal_templates.date_to%TYPE
310: -- Internal Table Handler Use Only.
311:
312: procedure chk_assessment_type
313: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
314: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
315: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
316: ,p_date_from in per_appraisal_templates.date_from%TYPE
317: ,p_date_to in per_appraisal_templates.date_to%TYPE
318: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
311:
312: procedure chk_assessment_type
313: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
314: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
315: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
316: ,p_date_from in per_appraisal_templates.date_from%TYPE
317: ,p_date_to in per_appraisal_templates.date_to%TYPE
318: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
319: )
312: procedure chk_assessment_type
313: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
314: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
315: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
316: ,p_date_from in per_appraisal_templates.date_from%TYPE
317: ,p_date_to in per_appraisal_templates.date_to%TYPE
318: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
319: )
320: is
313: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
314: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
315: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
316: ,p_date_from in per_appraisal_templates.date_from%TYPE
317: ,p_date_to in per_appraisal_templates.date_to%TYPE
318: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
319: )
320: is
321:
314: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
315: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
316: ,p_date_from in per_appraisal_templates.date_from%TYPE
317: ,p_date_to in per_appraisal_templates.date_to%TYPE
318: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
319: )
320: is
321:
322: l_exists varchar2(1);
321:
322: l_exists varchar2(1);
323: l_api_updating boolean;
324: l_proc varchar2(72) := g_package||'chk_assessment_type';
325: l_business_group_id per_appraisal_templates.business_group_id%TYPE;
326:
327:
328: -- Cursor to check if appraisal exists
329:
442: -- Access Status
443: -- Internal Table Handler Use Only.
444:
445: procedure chk_objective_asmnt_type
446: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
447: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
448: ,p_objective_asmnt_type_id in per_appraisal_templates.objective_asmnt_type_id%TYPE
449: ,p_date_from in per_appraisal_templates.date_from%TYPE
450: ,p_date_to in per_appraisal_templates.date_to%TYPE
443: -- Internal Table Handler Use Only.
444:
445: procedure chk_objective_asmnt_type
446: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
447: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
448: ,p_objective_asmnt_type_id in per_appraisal_templates.objective_asmnt_type_id%TYPE
449: ,p_date_from in per_appraisal_templates.date_from%TYPE
450: ,p_date_to in per_appraisal_templates.date_to%TYPE
451: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
444:
445: procedure chk_objective_asmnt_type
446: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
447: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
448: ,p_objective_asmnt_type_id in per_appraisal_templates.objective_asmnt_type_id%TYPE
449: ,p_date_from in per_appraisal_templates.date_from%TYPE
450: ,p_date_to in per_appraisal_templates.date_to%TYPE
451: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
452: )
445: procedure chk_objective_asmnt_type
446: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
447: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
448: ,p_objective_asmnt_type_id in per_appraisal_templates.objective_asmnt_type_id%TYPE
449: ,p_date_from in per_appraisal_templates.date_from%TYPE
450: ,p_date_to in per_appraisal_templates.date_to%TYPE
451: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
452: )
453: is
446: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
447: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
448: ,p_objective_asmnt_type_id in per_appraisal_templates.objective_asmnt_type_id%TYPE
449: ,p_date_from in per_appraisal_templates.date_from%TYPE
450: ,p_date_to in per_appraisal_templates.date_to%TYPE
451: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
452: )
453: is
454:
447: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
448: ,p_objective_asmnt_type_id in per_appraisal_templates.objective_asmnt_type_id%TYPE
449: ,p_date_from in per_appraisal_templates.date_from%TYPE
450: ,p_date_to in per_appraisal_templates.date_to%TYPE
451: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
452: )
453: is
454:
455: l_exists varchar2(1);
454:
455: l_exists varchar2(1);
456: l_api_updating boolean;
457: l_proc varchar2(72) := g_package||'chk_objective_asmnt_type';
458: l_business_group_id per_appraisal_templates.business_group_id%TYPE;
459:
460:
461: -- Cursor to check if appraisal exists
462:
573: -- Access Status
574: -- Internal Table Handler Use Only.
575:
576: procedure chk_question_template
577: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE
578: ,p_questionnaire_template_id in per_appraisal_templates.questionnaire_template_id%TYPE
579: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
580: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
581: )
574: -- Internal Table Handler Use Only.
575:
576: procedure chk_question_template
577: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE
578: ,p_questionnaire_template_id in per_appraisal_templates.questionnaire_template_id%TYPE
579: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
580: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
581: )
582: is
575:
576: procedure chk_question_template
577: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE
578: ,p_questionnaire_template_id in per_appraisal_templates.questionnaire_template_id%TYPE
579: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
580: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
581: )
582: is
583:
576: procedure chk_question_template
577: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE
578: ,p_questionnaire_template_id in per_appraisal_templates.questionnaire_template_id%TYPE
579: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
580: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
581: )
582: is
583:
584: l_exists varchar2(1);
762: -- Access Status
763: -- Internal Table Handler Use Only.
764:
765: procedure chk_ma_question_template
766: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE
767: ,p_ma_quest_template_id in per_appraisal_templates.ma_quest_template_id%TYPE
768: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
769: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
770: )
763: -- Internal Table Handler Use Only.
764:
765: procedure chk_ma_question_template
766: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE
767: ,p_ma_quest_template_id in per_appraisal_templates.ma_quest_template_id%TYPE
768: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
769: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
770: )
771: is
764:
765: procedure chk_ma_question_template
766: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE
767: ,p_ma_quest_template_id in per_appraisal_templates.ma_quest_template_id%TYPE
768: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
769: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
770: )
771: is
772:
765: procedure chk_ma_question_template
766: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE
767: ,p_ma_quest_template_id in per_appraisal_templates.ma_quest_template_id%TYPE
768: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE
769: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
770: )
771: is
772:
773: l_exists varchar2(1);
948: -- Access Status
949: -- Internal Table Handler Use Only.
950:
951: procedure chk_rating_scale
952: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
953: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
954: ,p_rating_scale_id in per_appraisal_templates.rating_scale_id%TYPE
955: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE default null
956: )
949: -- Internal Table Handler Use Only.
950:
951: procedure chk_rating_scale
952: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
953: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
954: ,p_rating_scale_id in per_appraisal_templates.rating_scale_id%TYPE
955: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE default null
956: )
957: is
950:
951: procedure chk_rating_scale
952: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
953: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
954: ,p_rating_scale_id in per_appraisal_templates.rating_scale_id%TYPE
955: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE default null
956: )
957: is
958:
951: procedure chk_rating_scale
952: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
953: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
954: ,p_rating_scale_id in per_appraisal_templates.rating_scale_id%TYPE
955: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE default null
956: )
957: is
958:
959: l_exists varchar2(1);
959: l_exists varchar2(1);
960: l_api_updating boolean;
961: l_proc varchar2(72) := g_package||'chk_rating_scale';
962: l_type per_rating_scales.type%TYPE;
963: l_business_group_id per_appraisal_templates.business_group_id%TYPE;
964: l_overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE;
965:
966:
967: -- Cursor to check if rating scale exists and get
1147: -- Access Status
1148: -- Internal Table Handler Use Only.
1149:
1150: procedure chk_template_delete
1151: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1152: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1153: )
1154: is
1155:
1148: -- Internal Table Handler Use Only.
1149:
1150: procedure chk_template_delete
1151: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1152: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1153: )
1154: is
1155:
1156: l_exists varchar2(1);
1231: -- Internal Table Handler Use Only.
1232: --
1233: Procedure chk_update_comp_profile
1234: (
1235: p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE
1236: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
1237: ,p_effective_date in date
1238: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1239: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1232: --
1233: Procedure chk_update_comp_profile
1234: (
1235: p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE
1236: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
1237: ,p_effective_date in date
1238: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1239: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1240: )
1234: (
1235: p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE
1236: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
1237: ,p_effective_date in date
1238: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1239: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1240: )
1241: is
1242: --
1235: p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE
1236: ,p_assessment_type_id in per_appraisal_templates.assessment_type_id%TYPE
1237: ,p_effective_date in date
1238: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1239: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1240: )
1241: is
1242: --
1243: l_proc varchar2(72):=g_package||'chk_update_comp_profile';
1336: --
1337:
1338: Procedure chk_comp_profile_source_type
1339: (
1340: p_comp_profile_source_type in per_appraisal_templates.comp_profile_source_type%TYPE
1341: ,p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE
1342: ,p_effective_date in date
1343: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1344: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1337:
1338: Procedure chk_comp_profile_source_type
1339: (
1340: p_comp_profile_source_type in per_appraisal_templates.comp_profile_source_type%TYPE
1341: ,p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE
1342: ,p_effective_date in date
1343: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1344: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1345: )
1339: (
1340: p_comp_profile_source_type in per_appraisal_templates.comp_profile_source_type%TYPE
1341: ,p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE
1342: ,p_effective_date in date
1343: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1344: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1345: )
1346: is
1347: --
1340: p_comp_profile_source_type in per_appraisal_templates.comp_profile_source_type%TYPE
1341: ,p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE
1342: ,p_effective_date in date
1343: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1344: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1345: )
1346: is
1347: --
1348: l_proc varchar2(72):=g_package||'chk_comp_profile_source_type';
1436: --
1437:
1438: Procedure chk_link_appr_to_learning_path
1439: (
1440: p_link_appr_to_learning_path in per_appraisal_templates.link_appr_to_learning_path%TYPE
1441: ,p_effective_date in date
1442: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1443: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1444: )
1438: Procedure chk_link_appr_to_learning_path
1439: (
1440: p_link_appr_to_learning_path in per_appraisal_templates.link_appr_to_learning_path%TYPE
1441: ,p_effective_date in date
1442: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1443: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1444: )
1445: is
1446: --
1439: (
1440: p_link_appr_to_learning_path in per_appraisal_templates.link_appr_to_learning_path%TYPE
1441: ,p_effective_date in date
1442: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1443: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1444: )
1445: is
1446: --
1447: l_proc varchar2(72):=g_package||'chk_link_appr_to_learning_path';
1531: --
1532:
1533: Procedure chk_available_flag
1534: (
1535: p_available_flag in per_appraisal_templates.available_flag%TYPE
1536: ,p_effective_date in date
1537: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1538: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1539: )
1533: Procedure chk_available_flag
1534: (
1535: p_available_flag in per_appraisal_templates.available_flag%TYPE
1536: ,p_effective_date in date
1537: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1538: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1539: )
1540: is
1541: --
1534: (
1535: p_available_flag in per_appraisal_templates.available_flag%TYPE
1536: ,p_effective_date in date
1537: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE
1538: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE
1539: )
1540: is
1541: --
1542: l_proc varchar2(72):=g_package||'chk_available_flag';
1678: -- b) During insert.
1679:
1680: hr_dflex_utility.ins_or_upd_descflex_attribs
1681: (p_appl_short_name => 'PER'
1682: ,p_descflex_name => 'PER_APPRAISAL_TEMPLATES'
1683: ,p_attribute_category => p_rec.attribute_category
1684: ,p_attribute1_name => 'ATTRIBUTE1'
1685: ,p_attribute1_value => p_rec.attribute1
1686: ,p_attribute2_name => 'ATTRIBUTE2'
2037:
2038: cursor csr_leg_code is
2039: select legislation_code
2040: from per_business_groups pbg,
2041: per_appraisal_templates pat
2042: where pat.appraisal_template_id = p_appraisal_template_id
2043: and pbg.business_group_id = pat.business_group_id;
2044:
2045: l_proc varchar2(72) := g_package||'return_legislation_code';