eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APT_BUS dependencies on PER_APPRAISAL_TEMPLATES

Line 91: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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: )

Line 92: ,p_name in per_appraisal_templates.name%TYPE

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

Line 93: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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:

Line 94: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE

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);

Line 99: l_business_group_id per_appraisal_templates.business_group_id%TYPE;

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:

Line 109: from per_appraisal_templates apt

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

Line 201: (p_date_from in per_appraisal_templates.date_from%TYPE

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

Line 202: ,p_date_to in per_appraisal_templates.date_to%TYPE

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:

Line 203: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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);

Line 204: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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;

Line 313: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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

Line 314: ,p_object_version_number in per_appraisal_templates.object_version_number%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

Line 315: ,p_assessment_type_id in per_appraisal_templates.assessment_type_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: )

Line 316: ,p_date_from in per_appraisal_templates.date_from%TYPE

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

Line 317: ,p_date_to in per_appraisal_templates.date_to%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
321:

Line 318: ,p_business_group_id in per_appraisal_templates.business_group_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:
322: l_exists varchar2(1);

Line 325: l_business_group_id per_appraisal_templates.business_group_id%TYPE;

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:

Line 446: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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

Line 447: ,p_object_version_number in per_appraisal_templates.object_version_number%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

Line 448: ,p_objective_asmnt_type_id in per_appraisal_templates.objective_asmnt_type_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: )

Line 449: ,p_date_from in per_appraisal_templates.date_from%TYPE

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

Line 450: ,p_date_to in per_appraisal_templates.date_to%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
454:

Line 451: ,p_business_group_id in per_appraisal_templates.business_group_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:
455: l_exists varchar2(1);

Line 458: l_business_group_id per_appraisal_templates.business_group_id%TYPE;

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:

Line 577: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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: )

Line 578: ,p_questionnaire_template_id in per_appraisal_templates.questionnaire_template_id%TYPE

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

Line 579: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE

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:

Line 580: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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);

Line 766: (p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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: )

Line 767: ,p_ma_quest_template_id in per_appraisal_templates.ma_quest_template_id%TYPE

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

Line 768: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE

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:

Line 769: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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);

Line 952: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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: )

Line 953: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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

Line 954: ,p_rating_scale_id in per_appraisal_templates.rating_scale_id%TYPE

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:

Line 955: ,p_business_group_id in per_appraisal_templates.business_group_id%TYPE default null

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);

Line 963: l_business_group_id per_appraisal_templates.business_group_id%TYPE;

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

Line 1151: (p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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:

Line 1152: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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);

Line 1235: p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%TYPE

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

Line 1236: ,p_assessment_type_id in per_appraisal_templates.assessment_type_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: )

Line 1238: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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: --

Line 1239: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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';

Line 1340: p_comp_profile_source_type in per_appraisal_templates.comp_profile_source_type%TYPE

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

Line 1341: ,p_update_personal_comp_profile in per_appraisal_templates.update_personal_comp_profile%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: )

Line 1343: ,p_object_version_number in per_appraisal_templates.object_version_number%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: )
1346: is
1347: --

Line 1344: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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';

Line 1440: p_link_appr_to_learning_path in per_appraisal_templates.link_appr_to_learning_path%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: )

Line 1442: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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: --

Line 1443: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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';

Line 1535: p_available_flag in per_appraisal_templates.available_flag%TYPE

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: )

Line 1537: ,p_object_version_number in per_appraisal_templates.object_version_number%TYPE

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: --

Line 1538: ,p_appraisal_template_id in per_appraisal_templates.appraisal_template_id%TYPE

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';

Line 1682: ,p_descflex_name => 'PER_APPRAISAL_TEMPLATES'

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'

Line 2041: per_appraisal_templates pat

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';