APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_APPRAISAL_TEMPLATES

Line 541: p_talent_mang_src_typ per_appraisal_templates.comp_profile_source_type%TYPE

537: appr_id per_appraisals.appraisal_id%TYPE,
538: p_log IN OUT NOCOPY VARCHAR2,
539: apply_pers_profile_status IN OUT NOCOPY VARCHAR2,
540: p_new_appraisal IN BOOLEAN DEFAULT TRUE,
541: p_talent_mang_src_typ per_appraisal_templates.comp_profile_source_type%TYPE
542: )
543: IS
544: CURSOR get_assessment_competences (appr_id IN NUMBER)
545: IS

Line 2283: l_curr_appr_tmplt_id per_appraisal_templates.appraisal_template_id%TYPE;

2279:
2280: PROCEDURE post_appraisal_completion (p_appraisal_id IN NUMBER)
2281: IS
2282: l_plan_id per_perf_mgmt_plans.plan_id%TYPE;
2283: l_curr_appr_tmplt_id per_appraisal_templates.appraisal_template_id%TYPE;
2284:
2285: CURSOR get_plan_template_id
2286: IS
2287: SELECT plan_id,

Line 2468: ,per_appraisal_templates pat

2464: WHERE EXISTS
2465: (
2466: SELECT 'x'
2467: FROM per_appraisals pa
2468: ,per_appraisal_templates pat
2469: ,hr_questionnaires hq
2470: ,hr_quest_fields hqf
2471: WHERE pa.appraisal_id = c_appraisal_id
2472: AND pa.appraisal_template_id = pat.appraisal_template_id

Line 2605: l_talent_mang_src_typ per_appraisal_templates.comp_profile_source_type%TYPE;

2601: lv_apply_pers_comps_log wf_item_attributes.text_default%TYPE;
2602: lv_upd_train_comps_status_log wf_item_attributes.text_default%TYPE;
2603: lv_upd_create_event_status_log wf_item_attributes.text_default%TYPE;
2604: p_new_appraisal BOOLEAN;
2605: l_talent_mang_src_typ per_appraisal_templates.comp_profile_source_type%TYPE;
2606: l_available_flag per_appraisal_templates.available_flag%TYPE;
2607: update_personal_profile VARCHAR2 (100) DEFAULT NULL;
2608: l_proc VARCHAR2 (100);
2609:

Line 2606: l_available_flag per_appraisal_templates.available_flag%TYPE;

2602: lv_upd_train_comps_status_log wf_item_attributes.text_default%TYPE;
2603: lv_upd_create_event_status_log wf_item_attributes.text_default%TYPE;
2604: p_new_appraisal BOOLEAN;
2605: l_talent_mang_src_typ per_appraisal_templates.comp_profile_source_type%TYPE;
2606: l_available_flag per_appraisal_templates.available_flag%TYPE;
2607: update_personal_profile VARCHAR2 (100) DEFAULT NULL;
2608: l_proc VARCHAR2 (100);
2609:
2610: CURSOR c_appr_template_details (c_appraisal_id IN NUMBER)

Line 2615: FROM per_appraisal_templates pat, per_appraisals pa

2611: IS
2612: SELECT available_flag,
2613: update_personal_comp_profile,
2614: comp_profile_source_type
2615: FROM per_appraisal_templates pat, per_appraisals pa
2616: WHERE pa.appraisal_template_id = pat.appraisal_template_id
2617: AND pa.appraisal_id = c_appraisal_id;
2618:
2619: --