[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pap.parameter_value
FROM pay_action_parameters pap
WHERE pap.parameter_name = p_parameter_name;
('DRAFT', 'UPDATED', 'SUBMITTED', 'RESUBMITTED')
)
THEN
-- Set the message name, so that exception handler can get translated text
IF g_dbg
THEN
op (l_proc, g_debug_log, 20);
SELECT appraisal_period_id, appraisal_template_id, start_date,
end_date, task_start_date, task_end_date, initiator_code,
appraisal_system_type, auto_conc_process,
days_before_task_st_dt, appraisal_assmt_status,
appraisal_type, participation_type,
questionnaire_template_id
FROM per_appraisal_periods pap
WHERE pap.plan_id = p_plan_id
AND pap.appraisal_period_id = p_appr_period_id;
l_selected_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
SELECT menu_functions.function_id, ff.function_name, ff.PARAMETERS,
menu_id
FROM fnd_compiled_menu_functions menu_functions,
fnd_form_functions ff
WHERE menu_id = (SELECT menu_id
FROM fnd_menus
WHERE menu_name = p_menu_name)
AND ff.function_id = menu_functions.function_id
AND ff.PARAMETERS LIKE p_search_func;
l_selected_menu := l_appraisal_mgr_menu;
l_selected_menu := l_appraisal_empl_menu;
op ('l_selected_menu = ' || l_selected_menu, g_debug_log);
OPEN get_appraisal_function (l_selected_menu, l_system_type);
SELECT pc.NAME competence_name, pce.competence_id,
pce.competence_element_id, pce.mandatory,
pce.proficiency_level_id, pce.high_proficiency_level_id,
pce.organization_id, NVL (pce.job_id, -1) job_id,
NVL (pce.position_id, -1) position_id, pce.valid_grade_id,
NVL (pce.business_group_id, -1) business_group_id,
pce.enterprise_id, hrl.meaning structure_type,
DECODE (job_id,
NULL, DECODE (position_id, NULL, 1, 0),
0
) read_only_attr,
0 detail_attr, pc.competence_alias,
DECODE (pc.business_group_id, NULL, 'Y', 'N') GLOBAL,
pc.description, pc.date_from, pc.certification_required,
pc.behavioural_indicator, r1.step_value low_step_value,
r1.NAME low_step_name, r2.step_value high_step_value,
r2.NAME high_step_name, hrl.lookup_code,
DECODE (r1.step_value,
NULL, NULL,
r1.step_value || ' - ' || r1.NAME
) minimum_proficiency,
DECODE (r2.step_value,
NULL, NULL,
r2.step_value || ' - ' || r2.NAME
) maximum_proficiency,
pce.TYPE
FROM per_competence_elements pce,
per_competences_vl pc,
hr_lookups hrl,
per_rating_levels_vl r1,
per_rating_levels_vl r2
WHERE pce.TYPE = 'REQUIREMENT'
AND pce.competence_id = pc.competence_id
AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,
TRUNC (SYSDATE)
)
AND NVL (pce.effective_date_to,
TRUNC (SYSDATE)
)
AND hrl.lookup_type = 'STRUCTURE_TYPE'
AND hrl.lookup_code = 'BUS'
AND pce.proficiency_level_id = r1.rating_level_id(+)
AND pce.high_proficiency_level_id = r2.rating_level_id(+)
AND pce.business_group_id = p_enterprise_id
AND pce.enterprise_id = p_enterprise_id
AND pce.job_id IS NULL
AND pce.organization_id IS NULL
AND pce.position_id IS NULL;
SELECT pc.NAME competence_name, pce.competence_id,
pce.competence_element_id, pce.mandatory,
pce.proficiency_level_id, pce.high_proficiency_level_id,
pce.organization_id, NVL (pce.job_id, -1) job_id,
NVL (pce.position_id, -1) position_id, pce.valid_grade_id,
NVL (pce.business_group_id, -1) business_group_id,
pce.enterprise_id, hrl.meaning structure_type,
DECODE (job_id,
NULL, DECODE (position_id, NULL, 1, 0),
0
) read_only_attr,
0 detail_attr, pc.competence_alias,
DECODE (pc.business_group_id, NULL, 'Y', 'N') GLOBAL,
pc.description, pc.date_from, pc.certification_required,
pc.behavioural_indicator, r1.step_value low_step_value,
r1.NAME low_step_name, r2.step_value high_step_value,
r2.NAME high_step_name, hrl.lookup_code,
DECODE (r1.step_value,
NULL, NULL,
r1.step_value || ' - ' || r1.NAME
) minimum_proficiency,
DECODE (r2.step_value,
NULL, NULL,
r2.step_value || ' - ' || r2.NAME
) maximum_proficiency,
pce.TYPE
FROM per_competence_elements pce,
per_competences_vl pc,
hr_lookups hrl,
per_rating_levels_vl r1,
per_rating_levels_vl r2
WHERE pce.TYPE = 'REQUIREMENT'
AND pce.competence_id = pc.competence_id
AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,
TRUNC (SYSDATE)
)
AND NVL (pce.effective_date_to,
TRUNC (SYSDATE)
)
AND hrl.lookup_type = 'STRUCTURE_TYPE'
AND hrl.lookup_code = 'ORG'
AND pce.proficiency_level_id = r1.rating_level_id(+)
AND pce.high_proficiency_level_id = r2.rating_level_id(+)
AND pce.business_group_id = p_enterprise_id
AND pce.organization_id = p_in_org_id
AND pce.enterprise_id IS NULL
AND pce.job_id IS NULL
AND pce.position_id IS NULL;
SELECT pc.NAME competence_name, pce.competence_id,
pce.competence_element_id, pce.mandatory,
pce.proficiency_level_id, pce.high_proficiency_level_id,
pce.organization_id, NVL (pce.job_id, -1) job_id,
NVL (pce.position_id, -1) position_id, pce.valid_grade_id,
NVL (pce.business_group_id, -1) business_group_id,
pce.enterprise_id, hrl.meaning structure_type,
DECODE (job_id,
NULL, DECODE (position_id, NULL, 1, 0),
0
) read_only_attr,
0 detail_attr, pc.competence_alias,
DECODE (pc.business_group_id, NULL, 'Y', 'N') GLOBAL,
pc.description, pc.date_from, pc.certification_required,
pc.behavioural_indicator, r1.step_value low_step_value,
r1.NAME low_step_name, r2.step_value high_step_value,
r2.NAME high_step_name, hrl.lookup_code,
DECODE (r1.step_value,
NULL, NULL,
r1.step_value || ' - ' || r1.NAME
) minimum_proficiency,
DECODE (r2.step_value,
NULL, NULL,
r2.step_value || ' - ' || r2.NAME
) maximum_proficiency,
pce.TYPE
FROM per_competence_elements pce,
per_competences_vl pc,
hr_lookups hrl,
per_rating_levels_vl r1,
per_rating_levels_vl r2
WHERE pce.TYPE = 'REQUIREMENT'
AND pce.competence_id = pc.competence_id
AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,
TRUNC (SYSDATE)
)
AND NVL (pce.effective_date_to,
TRUNC (SYSDATE)
)
AND hrl.lookup_type = 'STRUCTURE_TYPE'
AND hrl.lookup_code = 'POS'
AND pce.proficiency_level_id = r1.rating_level_id(+)
AND pce.high_proficiency_level_id = r2.rating_level_id(+)
AND pce.business_group_id = p_enterprise_id
AND pce.position_id = p_in_pos_id
AND pce.organization_id IS NULL
AND pce.job_id IS NULL
AND pce.enterprise_id IS NULL;
SELECT pc.NAME competence_name, pce.competence_id,
pce.competence_element_id, pce.mandatory,
pce.proficiency_level_id, pce.high_proficiency_level_id,
pce.organization_id, NVL (pce.job_id, -1) job_id,
NVL (pce.position_id, -1) position_id, pce.valid_grade_id,
NVL (pce.business_group_id, -1) business_group_id,
pce.enterprise_id, hrl.meaning structure_type,
DECODE (job_id,
NULL, DECODE (position_id, NULL, 1, 0),
0
) read_only_attr,
0 detail_attr, pc.competence_alias,
DECODE (pc.business_group_id, NULL, 'Y', 'N') GLOBAL,
pc.description, pc.date_from, pc.certification_required,
pc.behavioural_indicator, r1.step_value low_step_value,
r1.NAME low_step_name, r2.step_value high_step_value,
r2.NAME high_step_name, hrl.lookup_code,
DECODE (r1.step_value,
NULL, NULL,
r1.step_value || ' - ' || r1.NAME
) minimum_proficiency,
DECODE (r2.step_value,
NULL, NULL,
r2.step_value || ' - ' || r2.NAME
) maximum_proficiency,
pce.TYPE
FROM per_competence_elements pce,
per_competences_vl pc,
hr_lookups hrl,
per_rating_levels_vl r1,
per_rating_levels_vl r2
WHERE pce.TYPE = 'REQUIREMENT'
AND pce.competence_id = pc.competence_id
AND TRUNC (SYSDATE) BETWEEN NVL (pce.effective_date_from,
TRUNC (SYSDATE)
)
AND NVL (pce.effective_date_to,
TRUNC (SYSDATE)
)
AND hrl.lookup_type = 'STRUCTURE_TYPE'
AND hrl.lookup_code = 'JOB'
AND pce.proficiency_level_id = r1.rating_level_id(+)
AND pce.high_proficiency_level_id = r2.rating_level_id(+)
AND pce.business_group_id = p_enterprise_id
AND pce.job_id = p_in_job_id
AND pce.organization_id IS NULL
AND pce.position_id IS NULL
AND pce.enterprise_id IS NULL;
SELECT scorecard_id, assignment_id, person_id, scorecard_name
FROM per_personal_scorecards
WHERE scorecard_id = p_scorecard_id;
SELECT paf.assignment_id, paf.business_group_id, paf.grade_id,
paf.position_id, paf.job_id, paf.organization_id,
paf.supervisor_id, paf.effective_start_date,
pps.date_start empl_start_date,
ppf.effective_end_date empl_end_date, ppf.person_id
FROM per_all_assignments_f paf,
per_all_people_f ppf,
per_periods_of_service pps
WHERE paf.person_id = p_person_id --8780710 bug fix
AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND paf.person_id = ppf.person_id
AND paf.assignment_type = 'E'
AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date
AND ppf.effective_end_date
AND pps.period_of_service_id = paf.period_of_service_id
AND paf.primary_flag = 'Y'
UNION ALL
SELECT paf.assignment_id, paf.business_group_id, paf.grade_id,
paf.position_id, paf.job_id, paf.organization_id,
paf.supervisor_id, paf.effective_start_date,
pps.date_start empl_start_date,
ppf.effective_end_date empl_end_date, ppf.person_id
FROM per_all_assignments_f paf,
per_all_people_f ppf,
per_periods_of_placement pps
WHERE paf.person_id = p_person_id --8780710 bug fix
AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND paf.assignment_type = 'C'
AND paf.person_id = ppf.person_id
AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date
AND ppf.effective_end_date
AND pps.date_start = paf.period_of_placement_date_start
AND pps.person_id = paf.person_id
AND paf.primary_flag = 'Y'; --8780710 bug fix
SELECT date_start
FROM per_periods_of_service
WHERE person_id = p_ma_person_id
AND TRUNC (SYSDATE) BETWEEN date_start
AND NVL (actual_termination_date,
TRUNC (SYSDATE)
)
UNION ALL
SELECT date_start
FROM per_periods_of_placement
WHERE person_id = p_ma_person_id
AND TRUNC (SYSDATE) BETWEEN date_start
AND NVL (actual_termination_date,
TRUNC (SYSDATE)
);
SELECT appraisal_template_id, assessment_type_id,
objective_asmnt_type_id, business_group_id,
show_competency_ratings, show_objective_ratings,
show_questionnaire_info, show_participant_details,
show_participant_ratings, show_participant_names,
show_overall_ratings, provide_overall_feedback,
-- Bug7393131
show_overall_comments
FROM per_appraisal_templates
WHERE appraisal_template_id = p_appraisal_templ_id;
SELECT ce.competence_id, ce.competence_element_id, ce.TYPE,
ce.parent_competence_element_id, c.NAME,
RANK () OVER (PARTITION BY ce.competence_id ORDER BY ce.competence_element_id)
RANK
FROM per_competence_elements a,
per_competence_elements ce,
per_competences_vl c
WHERE a.assessment_type_id = p_assess_type_id
AND a.TYPE = 'ASSESSMENT_GROUP'
AND (NVL (c.date_from, TRUNC (SYSDATE)) <= TRUNC (SYSDATE))
AND NVL (c.date_to, TRUNC (SYSDATE)) >= TRUNC (SYSDATE)
AND a.competence_element_id = ce.parent_competence_element_id
AND ce.competence_id = c.competence_id;
SELECT default_job_competencies
FROM per_assessment_types
WHERE assessment_type_id = p_assessment_type_id;
SELECT objective_id, scorecard_id, object_version_number, NAME
FROM per_objectives
WHERE scorecard_id = p_scorecard_id
AND appraise_flag = 'Y'
AND appraisal_id IS NULL;
SELECT default_job_competencies, assessment_type_id
FROM per_assessment_types
WHERE assessment_type_id = p_assess_templ;
SELECT DISTINCT (supervisor_id)
FROM per_all_assignments_f
WHERE person_id = p_person_id AND primary_flag <> 'Y';
SELECT appraisal_id, appraisal_system_status
FROM per_appraisals
WHERE plan_id = p_plan_id
AND appraisal_period_start_date = p_appr_prd_st_dt
--5194541 to_date(p_appr_prd_st_dt,'RRRR-MM-DD')
AND appraisal_period_end_date = p_appr_prd_ed_dt
--5194541 to_date(p_appr_prd_ed_dt,'RRRR-MM-DD')
AND appraisee_person_id = p_appraisee_person_id
AND appraisal_system_status <> 'TRANSFER_OUT' -- 7321947
-- and appraiser_person_id = p_appraiser_person_id
-- and main_appraiser_id = p_main_appraiser_id
AND appraisal_template_id = p_appr_templ_id;
SELECT 'Y'
FROM DUAL
WHERE EXISTS (
SELECT '1'
FROM per_assessments
WHERE appraisal_id = p_appraisal_id
AND assessment_type_id = p_assessment_type_id);
hr_objectives_api.update_objective
(p_validate => FALSE,
p_objective_id => objectives.objective_id,
p_object_version_number => objectives.object_version_number,
p_effective_date => p_effective_date,
p_appraisal_id => l_found_appraisal_id,
-- modified by AM --
p_weighting_over_100_warning => l_weighting_over_100_warning,
p_weighting_appraisal_warning => l_weighting_appraisal_warning
);
p_update_appraisal => 'Y',
p_appraisee_person_id => l_scorecard_info.person_id,
p_appraiser_person_id => l_appraiser_id,
--to be changed for position
p_appraisal_date => l_appraisal_date,
p_appraisal_period_start_date => l_appraisal_period_start_date,
p_appraisal_period_end_date => p_appraisal_end_date,
p_type => p_type, -- ANN,
p_next_appraisal_date => p_next_appraisal_date,
p_status => p_status,
-- PLANNED,TRANSFER,RFC,
p_comments => p_comments,
p_system_type => l_appraisal_sys_type,
--MGR360 EMP360
p_system_params => l_func_params,
--p_appraisee_access,
p_main_appraiser_id => l_main_appraiser_id,
--to be changed for position
p_assignment_id => l_assignment_info.assignment_id,
p_assignment_start_date => l_assignment_info.effective_state_date,
p_asg_business_group_id => l_assignment_info.business_group_id,
p_assignment_organization_id => l_assignment_info.org_id,
p_assignment_job_id => l_assignment_info.job_id,
--p_assignment_position_id = l_assignment_info.position_id ,
p_assignment_grade_id => l_assignment_info.grade_id,
p_appraisal_id => l_apprl_id,
p_object_version_number => l_appraisal_ovn,
p_appraisal_system_status => p_appraisal_status,
p_plan_id => p_plan_id
);
hr_objectives_api.update_objective
(p_validate => FALSE,
p_objective_id => objectives.objective_id,
p_object_version_number => objectives.object_version_number,
p_effective_date => p_effective_date,
p_appraisal_id => l_apprl_id,
-- to be changed in SWI,API,RHI
p_weighting_over_100_warning => l_weighting_over_100_warning,
p_weighting_appraisal_warning => l_weighting_appraisal_warning
);
p_delete_pending_trans IN VARCHAR2 DEFAULT 'N'
)
IS
--
CURSOR csr_plan_ovn
IS
SELECT object_version_number
FROM per_perf_mgmt_plans
WHERE plan_id = p_plan_id;
SELECT 'x'
FROM DUAL
WHERE EXISTS (
SELECT 'x'
FROM hr_api_transactions t, per_personal_scorecards sc
WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
AND t.transaction_ref_id = sc.scorecard_id
AND sc.plan_id = p_plan_id);
INSERT INTO per_wpm_batch_actions
(wpm_batch_action_id,
conc_request_id, conc_program_name, plan_id,
appraisal_period_id, status, start_date, end_date
)
VALUES (per_wpm_batch_actions_s.NEXTVAL,
fnd_global.conc_request_id, 'WPMAPRPUSH', p_plan_id,
p_appraisal_period_id, 'PENDING', SYSDATE,
--p_effective_date, -- trunc(sysdate)
NULL
)
RETURNING wpm_batch_action_id
INTO l_current_wpm_batch_action_id;
IF NVL (p_delete_pending_trans, 'N') = 'N'
THEN
OPEN csr_pend_trans (p_plan_id);
g_wpm_person_actions.DELETE;
UPDATE per_wpm_batch_actions
SET end_date = SYSDATE,
status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')
WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;
UPDATE per_wpm_batch_actions
SET status = 'ERROR',
end_date = SYSDATE
WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;
UPDATE per_wpm_batch_actions
SET status = 'ERROR',
end_date = SYSDATE
WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;
SELECT *
FROM per_perf_mgmt_plans
WHERE plan_id = p_plan_id;
select objective_id, object_version_number
from per_objectives
where scorecard_id = p_scorecard_id;
SELECT appraisal_id, object_version_number
FROM per_appraisals
WHERE plan_id = plan_id;
SELECT pc.scorecard_id, pc.plan_id, pc.object_version_number,
papf.business_group_id, pc.assignment_id, pc.person_id,
pc.status_code, papf.full_name
FROM per_personal_scorecards pc,
per_people_f papf,
per_assignments_f paaf
WHERE pc.plan_id = p_plan_id
AND pc.assignment_id = paaf.assignment_id
AND pc.person_id = papf.person_id
AND p_effective_date BETWEEN paaf.effective_start_date
AND paaf.effective_end_date
AND p_effective_date BETWEEN papf.effective_start_date
AND papf.effective_end_date;
SELECT elig.elig_obj_id
FROM ben_elig_obj_f elig
WHERE elig.table_name = 'PER_APPRAISAL_PERIODS'
AND elig.column_name = 'APPRAISAL_PERIOD_ID'
AND elig.COLUMN_VALUE = p_appr_period_id
AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date
AND elig.effective_end_date;
SELECT transaction_id
FROM hr_api_transactions
WHERE transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
AND transaction_ref_id = p_sc_card_id;
DELETE FROM hr_api_transaction_steps
WHERE transaction_id = l_trx_id;
DELETE FROM hr_api_transactions
WHERE transaction_id = l_trx_id;
hr_personal_scorecard_api.update_scorecard_status
(p_effective_date => TRUNC (SYSDATE),
p_scorecard_id => curr_scorecard.scorecard_id,
p_object_version_number => l_sc_ovn,
p_status_code => 'PUBLISHED'
);
SELECT full_name
FROM per_all_people_f ppf
WHERE ppf.person_id = p_person_id
AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date
AND ppf.effective_end_date;
INSERT INTO per_wpm_person_actions
(wpm_person_action_id,
wpm_batch_action_id,
person_id,
assignment_id,
business_group_id,
processing_status,
eligibility_status,
MESSAGE_TYPE,
message_number,
MESSAGE_TEXT,
transaction_ref_table,
transaction_ref_id,
information_category,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12,
information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20
)
VALUES (per_wpm_person_actions_s.NEXTVAL,
g_wpm_person_actions (l_person_index).wpm_batch_action_id,
g_wpm_person_actions (l_person_index).person_id,
g_wpm_person_actions (l_person_index).assignment_id,
g_wpm_person_actions (l_person_index).business_group_id,
g_wpm_person_actions (l_person_index).processing_status,
g_wpm_person_actions (l_person_index).eligibility_status,
g_wpm_person_actions (l_person_index).MESSAGE_TYPE,
g_wpm_person_actions (l_person_index).message_number,
g_wpm_person_actions (l_person_index).MESSAGE_TEXT,
g_wpm_person_actions (l_person_index).transaction_ref_table,
g_wpm_person_actions (l_person_index).transaction_ref_id,
g_wpm_person_actions (l_person_index).information_category,
g_wpm_person_actions (l_person_index).information1,
g_wpm_person_actions (l_person_index).information2,
g_wpm_person_actions (l_person_index).information3,
g_wpm_person_actions (l_person_index).information4,
g_wpm_person_actions (l_person_index).information5,
g_wpm_person_actions (l_person_index).information6,
g_wpm_person_actions (l_person_index).information7,
g_wpm_person_actions (l_person_index).information8,
g_wpm_person_actions (l_person_index).information9,
g_wpm_person_actions (l_person_index).information10,
g_wpm_person_actions (l_person_index).information11,
g_wpm_person_actions (l_person_index).information12,
g_wpm_person_actions (l_person_index).information13,
g_wpm_person_actions (l_person_index).information14,
g_wpm_person_actions (l_person_index).information15,
g_wpm_person_actions (l_person_index).information16,
g_wpm_person_actions (l_person_index).information17,
g_wpm_person_actions (l_person_index).information18,
g_wpm_person_actions (l_person_index).information19,
g_wpm_person_actions (l_person_index).information20
);
op ( 'Insertion falied for: '
|| l_person_name
|| '('
|| g_wpm_person_actions (l_person_index).person_id
|| ').',
g_regular_log,
10
);
SELECT ben.wpm_person_action_id, ben.information1 appraisal_id,
ben.information3 new_main_appraiser_id
FROM per_wpm_person_actions ben
WHERE ben.wpm_batch_action_id = p_batch_action_id
AND ben.processing_status = 'PENDING'
ORDER BY ben.wpm_person_action_id;
SELECT pa.plan_id, pa.appraiser_person_id, pa.object_version_number,
usr.user_name, pa.main_appraiser_id, pa.appraisee_person_id,
ppl.full_name
FROM per_appraisals pa, fnd_user usr, per_all_people_f ppl
WHERE appraisal_id = p_appraisal_id
AND ppl.person_id = usr.employee_id(+)
AND ppl.person_id = pa.main_appraiser_id
AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date
AND ppl.effective_end_date;
SELECT 'Y'
FROM per_personal_scorecards
WHERE plan_id = p_plan_id
AND person_id = p_person_id
AND status_code <> 'TRANSFER_OUT';
SELECT item_type, item_key
FROM hr_api_transactions
WHERE transaction_ref_table = 'PER_APPRAISALS'
AND transaction_ref_id = p_appraisal_id;
SELECT instance_label
FROM wf_process_activities
WHERE instance_id = p_block_activity_id;
SELECT wf.NAME role_name, ppl.full_name
FROM wf_roles wf, per_all_people_f ppl
WHERE wf.orig_system = 'PER'
AND wf.orig_system_id = p_person_id
AND wf.orig_system_id = ppl.person_id
AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date
AND ppl.effective_end_date;
hr_appraisals_api.update_appraisal
(p_validate => FALSE,
p_effective_date => l_effective_date,
p_appraisal_id => l_appraisal_id,
p_appraiser_person_id => l_appraiser_person_id,
p_main_appraiser_id => l_new_main_appraiser_id,
p_object_version_number => l_object_version_number
);
op ('Successfully updated appraisal: ' || l_appraisal_id,
g_regular_log
);
op ( 'Workflow attrs not updated. No transactions found.'
|| l_item_key,
g_regular_log
);
UPDATE per_wpm_person_actions
SET processing_status = 'SUCCESS'
WHERE wpm_person_action_id = l_wpm_person_action_id;
UPDATE per_wpm_person_actions
SET processing_status = 'ERROR',
message_number = ecode,
MESSAGE_TEXT = emesg
WHERE wpm_person_action_id = l_wpm_person_action_id;
UPDATE per_wpm_batch_actions
SET status =
DECODE (l_no_of_processed,
0, 'ERROR',
DECODE (l_no_of_errors, 0, 'SUCCESS', 'WARNING')
),
conc_request_id = fnd_global.conc_request_id,
information19 = TO_CHAR (l_no_of_processed),
information20 = TO_CHAR (l_no_of_errors)
WHERE wpm_batch_action_id = p_batch_action_id;
UPDATE per_wpm_batch_actions
SET status = 'ERROR',
conc_request_id = fnd_global.conc_request_id,
end_date = SYSDATE
WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;