APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_WPM_BATCH_ACTIONS

Line 2240: -- l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;

2236: scorecard_pending_transaction EXCEPTION;
2237: --
2238: BEGIN
2239: -- WPM Logging Changes
2240: -- l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;
2241: INSERT INTO per_wpm_batch_actions
2242: (wpm_batch_action_id,
2243: conc_request_id, conc_program_name, plan_id,
2244: appraisal_period_id, status, start_date, end_date

Line 2241: INSERT INTO per_wpm_batch_actions

2237: --
2238: BEGIN
2239: -- WPM Logging Changes
2240: -- l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;
2241: INSERT INTO per_wpm_batch_actions
2242: (wpm_batch_action_id,
2243: conc_request_id, conc_program_name, plan_id,
2244: appraisal_period_id, status, start_date, end_date
2245: )

Line 2246: VALUES (per_wpm_batch_actions_s.NEXTVAL,

2242: (wpm_batch_action_id,
2243: conc_request_id, conc_program_name, plan_id,
2244: appraisal_period_id, status, start_date, end_date
2245: )
2246: VALUES (per_wpm_batch_actions_s.NEXTVAL,
2247: fnd_global.conc_request_id, 'WPMAPRPUSH', p_plan_id,
2248: p_appraisal_period_id, 'PENDING', SYSDATE,
2249: --p_effective_date, -- trunc(sysdate)
2250: NULL

Line 2305: UPDATE per_wpm_batch_actions

2301: --
2302: -- WPM Logging Changes
2303: print_cache ();
2304:
2305: UPDATE per_wpm_batch_actions
2306: SET end_date = SYSDATE,
2307: status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')
2308: WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;
2309:

Line 2322: UPDATE per_wpm_batch_actions

2318: ROLLBACK;
2319: -- WPM Logging Changes
2320: print_cache ();
2321:
2322: UPDATE per_wpm_batch_actions
2323: SET status = 'ERROR',
2324: end_date = SYSDATE
2325: WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;
2326:

Line 2334: UPDATE per_wpm_batch_actions

2330: ROLLBACK;
2331: -- WPM Logging Changes
2332: print_cache ();
2333:
2334: UPDATE per_wpm_batch_actions
2335: SET status = 'ERROR',
2336: end_date = SYSDATE
2337: WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;
2338:

Line 3526: UPDATE per_wpm_batch_actions

3522: CLOSE person_action_details;
3523:
3524: CLOSE in_plan;
3525:
3526: UPDATE per_wpm_batch_actions
3527: SET status =
3528: DECODE (l_no_of_processed,
3529: 0, 'ERROR',
3530: DECODE (l_no_of_errors, 0, 'SUCCESS', 'WARNING')

Line 3551: UPDATE per_wpm_batch_actions

3547: WHEN OTHERS
3548: THEN
3549: ROLLBACK;
3550:
3551: UPDATE per_wpm_batch_actions
3552: SET status = 'ERROR',
3553: conc_request_id = fnd_global.conc_request_id,
3554: end_date = SYSDATE
3555: WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;