DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_WPM_BATCH_ACTIONS

Line 4675: -- HR_WPM_MASS_APR_PUSH.l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;

4671: RAISE;
4672: END;
4673:
4674: -- WPM Logging Changes
4675: -- HR_WPM_MASS_APR_PUSH.l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;
4676: SELECT per_wpm_batch_actions_s.NEXTVAL
4677: INTO l_wpm_batch_action_id
4678: FROM DUAL;
4679:

Line 4676: SELECT per_wpm_batch_actions_s.NEXTVAL

4672: END;
4673:
4674: -- WPM Logging Changes
4675: -- HR_WPM_MASS_APR_PUSH.l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;
4676: SELECT per_wpm_batch_actions_s.NEXTVAL
4677: INTO l_wpm_batch_action_id
4678: FROM DUAL;
4679:
4680: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;

Line 4682: INSERT INTO per_wpm_batch_actions

4678: FROM DUAL;
4679:
4680: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;
4681:
4682: INSERT INTO per_wpm_batch_actions
4683: (wpm_batch_action_id, conc_request_id, conc_program_name, plan_id, appraisal_period_id, status, start_date,
4684: end_date
4685: )
4686: VALUES (l_wpm_batch_action_id, fnd_global.conc_request_id, 'PERPLNPUB', p_plan_id, NULL, 'PENDING', SYSDATE,

Line 4759: UPDATE per_wpm_batch_actions

4755: --
4756: -- WPM Logging Changes
4757: hr_wpm_mass_apr_push.print_cache ();
4758:
4759: UPDATE per_wpm_batch_actions
4760: SET end_date = SYSDATE,
4761: status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')
4762: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
4763:

Line 4773: UPDATE per_wpm_batch_actions

4769: ROLLBACK;
4770: -- WPM Logging Changes
4771: hr_wpm_mass_apr_push.print_cache ();
4772:
4773: UPDATE per_wpm_batch_actions
4774: SET status = 'ERROR',
4775: end_date = SYSDATE
4776: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
4777:

Line 11127: SELECT per_wpm_batch_actions_s.NEXTVAL

11123: l_effective_date := fnd_date.canonical_to_date (p_effective_date);
11124:
11125: --
11126: -- WPM Logging Changes
11127: SELECT per_wpm_batch_actions_s.NEXTVAL
11128: INTO l_wpm_batch_action_id
11129: FROM DUAL;
11130:
11131: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;

Line 11133: INSERT INTO per_wpm_batch_actions

11129: FROM DUAL;
11130:
11131: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;
11132:
11133: INSERT INTO per_wpm_batch_actions
11134: (wpm_batch_action_id, conc_request_id, conc_program_name, plan_id, appraisal_period_id, status, start_date,
11135: end_date
11136: )
11137: VALUES (l_wpm_batch_action_id, fnd_global.conc_request_id, 'PERPLNREPUB', p_plan_id, NULL, 'PENDING', SYSDATE,

Line 11212: UPDATE per_wpm_batch_actions

11208: --
11209: -- WPM Logging Changes
11210: hr_wpm_mass_apr_push.print_cache ();
11211:
11212: UPDATE per_wpm_batch_actions
11213: SET end_date = SYSDATE,
11214: status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')
11215: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
11216:

Line 11231: UPDATE per_wpm_batch_actions

11227: hr_wpm_mass_apr_push.print_cache ();
11228: log_message('Inside Exception in Plan_republish');
11229: log_message(SQLERRM);
11230:
11231: UPDATE per_wpm_batch_actions
11232: SET status = 'ERROR',
11233: end_date = SYSDATE
11234: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
11235: