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.HR_WPM_MASS_APR_PUSH dependencies on PER_APPRAISALS

Line 524: p_appraisal_sys_type IN OUT NOCOPY per_appraisals.appraisal_system_status%TYPE

520: p_appr_initiator_code IN per_appraisal_periods.initiator_code%TYPE,
521: p_function_id IN OUT NOCOPY fnd_form_functions.function_id%TYPE,
522: p_function_name IN OUT NOCOPY fnd_form_functions.function_name%TYPE,
523: p_func_parameters IN OUT NOCOPY fnd_form_functions.PARAMETERS%TYPE,
524: p_appraisal_sys_type IN OUT NOCOPY per_appraisals.appraisal_system_status%TYPE
525: )
526: RETURN BOOLEAN
527: IS
528: l_resp_id NUMBER;

Line 1026: p_appraisal_status per_appraisals.status%TYPE

1022: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
1023: p_effective_date DATE,
1024: p_appraisal_start_date DATE,
1025: p_appraisal_end_date DATE,
1026: p_appraisal_status per_appraisals.status%TYPE
1027: DEFAULT 'PLANNED',
1028: p_type per_appraisals.TYPE%TYPE
1029: DEFAULT NULL,
1030: p_appraisal_date per_appraisals.appraisal_date%TYPE,

Line 1028: p_type per_appraisals.TYPE%TYPE

1024: p_appraisal_start_date DATE,
1025: p_appraisal_end_date DATE,
1026: p_appraisal_status per_appraisals.status%TYPE
1027: DEFAULT 'PLANNED',
1028: p_type per_appraisals.TYPE%TYPE
1029: DEFAULT NULL,
1030: p_appraisal_date per_appraisals.appraisal_date%TYPE,
1031: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
1032: p_plan_id NUMBER,

Line 1030: p_appraisal_date per_appraisals.appraisal_date%TYPE,

1026: p_appraisal_status per_appraisals.status%TYPE
1027: DEFAULT 'PLANNED',
1028: p_type per_appraisals.TYPE%TYPE
1029: DEFAULT NULL,
1030: p_appraisal_date per_appraisals.appraisal_date%TYPE,
1031: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
1032: p_plan_id NUMBER,
1033: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE
1034: DEFAULT NULL,

Line 1031: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,

1027: DEFAULT 'PLANNED',
1028: p_type per_appraisals.TYPE%TYPE
1029: DEFAULT NULL,
1030: p_appraisal_date per_appraisals.appraisal_date%TYPE,
1031: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
1032: p_plan_id NUMBER,
1033: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE
1034: DEFAULT NULL,
1035: p_status per_appraisals.status%TYPE

Line 1033: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE

1029: DEFAULT NULL,
1030: p_appraisal_date per_appraisals.appraisal_date%TYPE,
1031: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
1032: p_plan_id NUMBER,
1033: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE
1034: DEFAULT NULL,
1035: p_status per_appraisals.status%TYPE
1036: DEFAULT NULL,
1037: p_comments per_appraisals.comments%TYPE

Line 1035: p_status per_appraisals.status%TYPE

1031: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
1032: p_plan_id NUMBER,
1033: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE
1034: DEFAULT NULL,
1035: p_status per_appraisals.status%TYPE
1036: DEFAULT NULL,
1037: p_comments per_appraisals.comments%TYPE
1038: DEFAULT NULL,
1039: p_appraisee_access per_appraisals.appraisee_access%TYPE

Line 1037: p_comments per_appraisals.comments%TYPE

1033: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE
1034: DEFAULT NULL,
1035: p_status per_appraisals.status%TYPE
1036: DEFAULT NULL,
1037: p_comments per_appraisals.comments%TYPE
1038: DEFAULT NULL,
1039: p_appraisee_access per_appraisals.appraisee_access%TYPE
1040: DEFAULT NULL,
1041: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,

Line 1039: p_appraisee_access per_appraisals.appraisee_access%TYPE

1035: p_status per_appraisals.status%TYPE
1036: DEFAULT NULL,
1037: p_comments per_appraisals.comments%TYPE
1038: DEFAULT NULL,
1039: p_appraisee_access per_appraisals.appraisee_access%TYPE
1040: DEFAULT NULL,
1041: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
1042: p_appraisal_system_type IN per_appraisal_periods.appraisal_system_type%TYPE,
1043: p_participation_type IN per_appraisal_periods.participation_type%TYPE

Line 1120: p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE

1116: TRUNC (SYSDATE)
1117: );
1118:
1119: CURSOR get_appraisal_templ_info (
1120: p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE
1121: )
1122: IS
1123: SELECT appraisal_template_id, assessment_type_id,
1124: objective_asmnt_type_id, business_group_id,

Line 1189: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,

1185: WHERE person_id = p_person_id AND primary_flag <> 'Y';
1186:
1187: CURSOR find_appraisal (
1188: p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
1189: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
1190: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
1191: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1192: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1193: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,

Line 1190: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,

1186:
1187: CURSOR find_appraisal (
1188: p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
1189: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
1190: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
1191: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1192: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1193: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
1194: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE

Line 1191: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,

1187: CURSOR find_appraisal (
1188: p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
1189: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
1190: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
1191: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1192: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1193: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
1194: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
1195: )

Line 1192: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,

1188: p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
1189: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
1190: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
1191: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1192: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1193: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
1194: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
1195: )
1196: IS

Line 1193: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,

1189: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
1190: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
1191: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1192: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1193: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
1194: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
1195: )
1196: IS
1197: SELECT appraisal_id, appraisal_system_status

Line 1194: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE

1190: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
1191: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1192: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
1193: -- p_main_appraiser_id per_appraisals.main_appraiser_id%TYPE,
1194: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
1195: )
1196: IS
1197: SELECT appraisal_id, appraisal_system_status
1198: FROM per_appraisals

Line 1198: FROM per_appraisals

1194: p_appr_templ_id per_appraisals.appraisal_template_id%TYPE
1195: )
1196: IS
1197: SELECT appraisal_id, appraisal_system_status
1198: FROM per_appraisals
1199: WHERE plan_id = p_plan_id
1200: AND appraisal_period_start_date = p_appr_prd_st_dt
1201: --5194541 to_date(p_appr_prd_st_dt,'RRRR-MM-DD')
1202: AND appraisal_period_end_date = p_appr_prd_ed_dt

Line 1215: l_ma_start_date per_appraisals.appraisal_date%TYPE;

1211: l_scorecard_info scorecard_info;
1212: no_score_card_with_this_id EXCEPTION;
1213: l_assignment_info assignment_info;
1214: no_assignment_with_this_id EXCEPTION;
1215: l_ma_start_date per_appraisals.appraisal_date%TYPE;
1216: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
1217: l_apprl_return_status VARCHAR2 (10) DEFAULT NULL;
1218: l_assess_comp_return_status VARCHAR2 (10) DEFAULT NULL;
1219: l_assess_obj_return_status VARCHAR2 (10) DEFAULT NULL;

Line 1216: l_appraisal_ovn per_appraisals.object_version_number%TYPE;

1212: no_score_card_with_this_id EXCEPTION;
1213: l_assignment_info assignment_info;
1214: no_assignment_with_this_id EXCEPTION;
1215: l_ma_start_date per_appraisals.appraisal_date%TYPE;
1216: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
1217: l_apprl_return_status VARCHAR2 (10) DEFAULT NULL;
1218: l_assess_comp_return_status VARCHAR2 (10) DEFAULT NULL;
1219: l_assess_obj_return_status VARCHAR2 (10) DEFAULT NULL;
1220: l_apprl_id per_appraisals.appraisal_id%TYPE

Line 1220: l_apprl_id per_appraisals.appraisal_id%TYPE

1216: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
1217: l_apprl_return_status VARCHAR2 (10) DEFAULT NULL;
1218: l_assess_comp_return_status VARCHAR2 (10) DEFAULT NULL;
1219: l_assess_obj_return_status VARCHAR2 (10) DEFAULT NULL;
1220: l_apprl_id per_appraisals.appraisal_id%TYPE
1221: DEFAULT NULL;
1222: l_apprl_templ_info appraisal_templ_info;
1223: no_apprl_templ_with_this_id EXCEPTION;
1224: l_assessment_comp_id per_assessments.assessment_id%TYPE;

Line 1256: l_found_appraisal_id per_appraisals.appraisal_id%TYPE;

1252: l_def_job_comps sel_comp_tab;
1253: appraisal_setup_issue EXCEPTION;
1254: l_appraiser_id per_people_f.person_id%TYPE;
1255: l_main_appraiser_id per_people_f.person_id%TYPE;
1256: l_found_appraisal_id per_appraisals.appraisal_id%TYPE;
1257: l_found_appraisal BOOLEAN;
1258: -- Declare local variables
1259: l_proc VARCHAR2 (72)
1260: := g_package || 'create_appraisal_for_person';

Line 1270: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;

1266: l_found_comp BOOLEAN;
1267: --
1268: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
1269: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
1270: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;
1271: l_appraisal_date per_appraisals.appraisal_date%TYPE;
1272: l_participant_id per_participants.participant_id%TYPE;
1273: l_default_participant VARCHAR2 (30)
1274: := NVL (p_participation_type, 'N');

Line 1271: l_appraisal_date per_appraisals.appraisal_date%TYPE;

1267: --
1268: l_templ_def_job_comps per_assessment_types.default_job_competencies%TYPE;
1269: l_assess_type_id per_assessment_types.assessment_type_id%TYPE;
1270: l_appraisal_period_start_date per_appraisals.appraisal_period_start_date%TYPE;
1271: l_appraisal_date per_appraisals.appraisal_date%TYPE;
1272: l_participant_id per_participants.participant_id%TYPE;
1273: l_default_participant VARCHAR2 (30)
1274: := NVL (p_participation_type, 'N');
1275:

Line 2056: p_participation_in_table => 'PER_APPRAISALS',

2052: hr_participants_api.create_participant
2053: (p_effective_date => p_effective_date,
2054: p_business_group_id => l_assignment_info.business_group_id,
2055: p_questionnaire_template_id => p_questionnaire_template_id,
2056: p_participation_in_table => 'PER_APPRAISALS',
2057: p_participation_in_column => 'APPRAISAL_ID',
2058: p_participation_in_id => l_apprl_id,
2059: p_participation_status => 'OPEN',
2060: p_participation_type => p_participation_type,

Line 2396: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)

2392: select objective_id, object_version_number
2393: from per_objectives
2394: where scorecard_id = p_scorecard_id;
2395: */
2396: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
2397: IS
2398: SELECT appraisal_id, object_version_number
2399: FROM per_appraisals
2400: WHERE plan_id = plan_id;

Line 2399: FROM per_appraisals

2395: */
2396: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
2397: IS
2398: SELECT appraisal_id, object_version_number
2399: FROM per_appraisals
2400: WHERE plan_id = plan_id;
2401:
2402: --
2403: -- Scorecard cursor modified

Line 2560: 'PER_APPRAISALS';

2556: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table := 'PER_PERSONAL_SCORECARDS';
2557: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id := curr_scorecard.scorecard_id;
2558: -- WPM Logging Changes Post Review
2559: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table :=
2560: 'PER_APPRAISALS';
2561: END IF;
2562:
2563: IF (curr_scorecard.status_code <> 'TRANSFER_OUT')
2564: THEN

Line 3124: FROM per_appraisals pa, fnd_user usr, per_all_people_f ppl

3120: IS
3121: SELECT pa.plan_id, pa.appraiser_person_id, pa.object_version_number,
3122: usr.user_name, pa.main_appraiser_id, pa.appraisee_person_id,
3123: ppl.full_name
3124: FROM per_appraisals pa, fnd_user usr, per_all_people_f ppl
3125: WHERE appraisal_id = p_appraisal_id
3126: AND ppl.person_id = usr.employee_id(+)
3127: AND ppl.person_id = pa.main_appraiser_id
3128: AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date

Line 3143: WHERE transaction_ref_table = 'PER_APPRAISALS'

3139: CURSOR get_wf_details (p_appraisal_id IN NUMBER)
3140: IS
3141: SELECT item_type, item_key
3142: FROM hr_api_transactions
3143: WHERE transaction_ref_table = 'PER_APPRAISALS'
3144: AND transaction_ref_id = p_appraisal_id;
3145:
3146: CURSOR get_instance_label (p_block_activity_id IN NUMBER)
3147: IS