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_PERSONAL_SCORECARDS

Line 64: scorecard_id per_personal_scorecards.scorecard_id%TYPE,

60: g_fetched_plan_member_index NUMBER;
61:
62: --
63: TYPE scorecard_info IS RECORD (
64: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
65: assignment_id per_personal_scorecards.assignment_id%TYPE,
66: person_id per_personal_scorecards.person_id%TYPE,
67: scorecard_name per_personal_scorecards.scorecard_name%TYPE
68: );

Line 65: assignment_id per_personal_scorecards.assignment_id%TYPE,

61:
62: --
63: TYPE scorecard_info IS RECORD (
64: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
65: assignment_id per_personal_scorecards.assignment_id%TYPE,
66: person_id per_personal_scorecards.person_id%TYPE,
67: scorecard_name per_personal_scorecards.scorecard_name%TYPE
68: );
69:

Line 66: person_id per_personal_scorecards.person_id%TYPE,

62: --
63: TYPE scorecard_info IS RECORD (
64: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
65: assignment_id per_personal_scorecards.assignment_id%TYPE,
66: person_id per_personal_scorecards.person_id%TYPE,
67: scorecard_name per_personal_scorecards.scorecard_name%TYPE
68: );
69:
70: TYPE assignment_info IS RECORD (

Line 67: scorecard_name per_personal_scorecards.scorecard_name%TYPE

63: TYPE scorecard_info IS RECORD (
64: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
65: assignment_id per_personal_scorecards.assignment_id%TYPE,
66: person_id per_personal_scorecards.person_id%TYPE,
67: scorecard_name per_personal_scorecards.scorecard_name%TYPE
68: );
69:
70: TYPE assignment_info IS RECORD (
71: assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 1021: p_score_card_id per_personal_scorecards.scorecard_id%TYPE,

1017: --
1018: -- {End Of Comments}
1019: -- ----------------------------------------------------------------------------
1020: PROCEDURE create_appraisal_for_person (
1021: p_score_card_id per_personal_scorecards.scorecard_id%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,

Line 1051: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE

1047: p_return_status OUT NOCOPY VARCHAR2
1048: )
1049: IS
1050: CURSOR get_scorecard_info (
1051: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
1052: )
1053: IS
1054: SELECT scorecard_id, assignment_id, person_id, scorecard_name
1055: FROM per_personal_scorecards

Line 1055: FROM per_personal_scorecards

1051: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
1052: )
1053: IS
1054: SELECT scorecard_id, assignment_id, person_id, scorecard_name
1055: FROM per_personal_scorecards
1056: WHERE scorecard_id = p_scorecard_id;
1057:
1058: --changed cursor for fixing 6924829
1059: CURSOR get_assignment_info (

Line 2230: FROM hr_api_transactions t, per_personal_scorecards sc

2226: SELECT 'x'
2227: FROM DUAL
2228: WHERE EXISTS (
2229: SELECT 'x'
2230: FROM hr_api_transactions t, per_personal_scorecards sc
2231: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
2232: AND t.transaction_ref_id = sc.scorecard_id
2233: AND sc.plan_id = p_plan_id);
2234:

Line 2231: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

2227: FROM DUAL
2228: WHERE EXISTS (
2229: SELECT 'x'
2230: FROM hr_api_transactions t, per_personal_scorecards sc
2231: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
2232: AND t.transaction_ref_id = sc.scorecard_id
2233: AND sc.plan_id = p_plan_id);
2234:
2235: l_chk VARCHAR2 (10);

Line 2371: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;

2367: l_object_version_number NUMBER;
2368: l_status_code per_perf_mgmt_plans.status_code%TYPE;
2369: l_dummy BOOLEAN;
2370: --
2371: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;
2372: --
2373: l_message_count NUMBER := 0;
2374: l_message VARCHAR2 (256);
2375: l_qual_pop_index BINARY_INTEGER;

Line 2410: FROM per_personal_scorecards pc,

2406: IS
2407: SELECT pc.scorecard_id, pc.plan_id, pc.object_version_number,
2408: papf.business_group_id, pc.assignment_id, pc.person_id,
2409: pc.status_code, papf.full_name
2410: FROM per_personal_scorecards pc,
2411: per_people_f papf,
2412: per_assignments_f paaf
2413: WHERE pc.plan_id = p_plan_id
2414: AND pc.assignment_id = paaf.assignment_id

Line 2447: WHERE transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

2443: CURSOR c_trx (p_sc_card_id NUMBER)
2444: IS
2445: SELECT transaction_id
2446: FROM hr_api_transactions
2447: WHERE transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
2448: AND transaction_ref_id = p_sc_card_id;
2449:
2450: l_sc_ovn NUMBER;
2451: l_trx_id NUMBER;

Line 2556: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table := 'PER_PERSONAL_SCORECARDS';

2552: curr_scorecard.business_group_id;
2553: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
2554: 'P';
2555: -- Processing
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';

Line 3134: FROM per_personal_scorecards

3130:
3131: CURSOR in_plan (p_plan_id IN NUMBER, p_person_id IN NUMBER)
3132: IS
3133: SELECT 'Y'
3134: FROM per_personal_scorecards
3135: WHERE plan_id = p_plan_id
3136: AND person_id = p_person_id
3137: AND status_code <> 'TRANSFER_OUT';
3138:

Line 3195: l_plan_id per_personal_scorecards.plan_id%TYPE;

3191: l_to_nma_name per_all_people_f.full_name%TYPE;
3192: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3193: ln_notification_id NUMBER;
3194: l_dummy VARCHAR2 (1) DEFAULT 'N';
3195: l_plan_id per_personal_scorecards.plan_id%TYPE;
3196: BEGIN
3197: initialize_logging (p_action_parameter_group_id => NULL,
3198: p_log_output => p_log_output
3199: );