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 54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,

50: g_fetched_plan_member_index number;
51: --
52:
53: TYPE scorecard_info is RECORD (
54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
55: assignment_id per_personal_scorecards.assignment_id%TYPE,
56: person_id per_personal_scorecards.person_id%TYPE,
57: scorecard_name per_personal_scorecards.scorecard_name%TYPE);
58:

Line 55: assignment_id per_personal_scorecards.assignment_id%TYPE,

51: --
52:
53: TYPE scorecard_info is RECORD (
54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
55: assignment_id per_personal_scorecards.assignment_id%TYPE,
56: person_id per_personal_scorecards.person_id%TYPE,
57: scorecard_name per_personal_scorecards.scorecard_name%TYPE);
58:
59: TYPE assignment_info is RECORD (

Line 56: person_id per_personal_scorecards.person_id%TYPE,

52:
53: TYPE scorecard_info is RECORD (
54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
55: assignment_id per_personal_scorecards.assignment_id%TYPE,
56: person_id per_personal_scorecards.person_id%TYPE,
57: scorecard_name per_personal_scorecards.scorecard_name%TYPE);
58:
59: TYPE assignment_info is RECORD (
60: assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 57: scorecard_name per_personal_scorecards.scorecard_name%TYPE);

53: TYPE scorecard_info is RECORD (
54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
55: assignment_id per_personal_scorecards.assignment_id%TYPE,
56: person_id per_personal_scorecards.person_id%TYPE,
57: scorecard_name per_personal_scorecards.scorecard_name%TYPE);
58:
59: TYPE assignment_info is RECORD (
60: assignment_id per_all_assignments_f.assignment_id%TYPE,
61: business_group_id per_all_assignments_f.business_group_id%TYPE,

Line 767: ( p_score_card_id per_personal_scorecards.scorecard_id%TYPE,

763: --
764: -- {End Of Comments}
765: -- ----------------------------------------------------------------------------
766: PROCEDURE create_appraisal_for_person
767: ( p_score_card_id per_personal_scorecards.scorecard_id%TYPE,
768: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
769: p_effective_date DATE,
770: p_appraisal_start_date DATE,
771: p_appraisal_end_date DATE,

Line 787: cursor get_scorecard_info(p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)

783: p_return_status out nocopy VARCHAR2
784: )
785: IS
786:
787: cursor get_scorecard_info(p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)
788: IS
789: SELECT scorecard_id, assignment_id, person_id, scorecard_name FROM per_personal_scorecards
790: WHERE scorecard_id = p_scorecard_id;
791: --changed cursor for fixing 6924829

Line 789: SELECT scorecard_id, assignment_id, person_id, scorecard_name FROM per_personal_scorecards

785: IS
786:
787: cursor get_scorecard_info(p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)
788: IS
789: SELECT scorecard_id, assignment_id, person_id, scorecard_name FROM per_personal_scorecards
790: WHERE scorecard_id = p_scorecard_id;
791: --changed cursor for fixing 6924829
792: cursor get_assignment_info(p_assignment_id per_all_assignments_f.assignment_id%TYPE)
793: IS

Line 1447: ,per_personal_scorecards sc

1443: SELECT 'x'
1444: FROM DUAL
1445: WHERE EXISTS (SELECT 'x'
1446: FROM hr_api_transactions t
1447: ,per_personal_scorecards sc
1448: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1449: AND t.transaction_ref_id = sc.scorecard_id
1450: AND sc.plan_id = p_plan_id);
1451: l_chk VARCHAR2(10);

Line 1448: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

1444: FROM DUAL
1445: WHERE EXISTS (SELECT 'x'
1446: FROM hr_api_transactions t
1447: ,per_personal_scorecards sc
1448: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1449: AND t.transaction_ref_id = sc.scorecard_id
1450: AND sc.plan_id = p_plan_id);
1451: l_chk VARCHAR2(10);
1452: SCORECARD_PENDING_TRANSACTION exception;

Line 1533: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;

1529: l_status_code per_perf_mgmt_plans.status_code%TYPE;
1530: l_dummy boolean;
1531:
1532: --
1533: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;
1534: --
1535: l_message_count number := 0;
1536: l_message varchar2(256);
1537: l_qual_pop_index binary_integer;

Line 1564: FROM per_personal_scorecards

1560: --
1561: -- Scorecard cursor
1562: CURSOR csr_get_scorecards IS
1563: SELECT scorecard_id,object_version_number,status_code
1564: FROM per_personal_scorecards
1565: WHERE plan_id = p_plan_id;
1566: --
1567:
1568: l_plan_rec per_perf_mgmt_plans%ROWTYPE;

Line 1578: WHERE transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

1574: CURSOR c_trx (p_sc_card_id number)
1575: is
1576: SELECT transaction_id
1577: FROM hr_api_transactions
1578: WHERE transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1579: AND transaction_ref_id = p_sc_card_id;
1580: l_sc_ovn number;
1581: l_trx_id number;
1582: --