APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_WPM_PERSON_ACTIONS

Line 2926: INSERT INTO per_wpm_person_actions

2922: INTO l_person_name;
2923:
2924: CLOSE get_person_name;
2925:
2926: INSERT INTO per_wpm_person_actions
2927: (wpm_person_action_id,
2928: wpm_batch_action_id,
2929: person_id,
2930: assignment_id,

Line 2961: VALUES (per_wpm_person_actions_s.NEXTVAL,

2957: information18,
2958: information19,
2959: information20
2960: )
2961: VALUES (per_wpm_person_actions_s.NEXTVAL,
2962: g_wpm_person_actions (l_person_index).wpm_batch_action_id,
2963: g_wpm_person_actions (l_person_index).person_id,
2964: g_wpm_person_actions (l_person_index).assignment_id,
2965: g_wpm_person_actions (l_person_index).business_group_id,

Line 3114: FROM per_wpm_person_actions ben

3110: CURSOR person_action_details (p_batch_action_id IN NUMBER)
3111: IS
3112: SELECT ben.wpm_person_action_id, ben.information1 appraisal_id,
3113: ben.information3 new_main_appraiser_id
3114: FROM per_wpm_person_actions ben
3115: WHERE ben.wpm_batch_action_id = p_batch_action_id
3116: AND ben.processing_status = 'PENDING'
3117: ORDER BY ben.wpm_person_action_id;
3118:

Line 3497: UPDATE per_wpm_person_actions

3493: g_regular_log);
3494: op ('Not able to send notification.', g_regular_log);
3495: END IF;
3496:
3497: UPDATE per_wpm_person_actions
3498: SET processing_status = 'SUCCESS'
3499: WHERE wpm_person_action_id = l_wpm_person_action_id;
3500:
3501: l_no_of_processed := l_no_of_processed + 1;

Line 3514: UPDATE per_wpm_person_actions

3510: );
3511: hr_utility.set_location ('ecode: ' || ecode, 11);
3512: hr_utility.set_location ('emesg:: ' || emesg, 11);
3513:
3514: UPDATE per_wpm_person_actions
3515: SET processing_status = 'ERROR',
3516: message_number = ecode,
3517: MESSAGE_TEXT = emesg
3518: WHERE wpm_person_action_id = l_wpm_person_action_id;