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_SCORE_CARD_TRNSF dependencies on PER_PERSONAL_SCORECARDS

Line 37: select scorecard_id, object_version_number from per_personal_scorecards

33: l_sc_ovn_list varchar2(1000);
34:
35: cursor get_score_cards ( p_sc_id varchar2 )
36: is
37: select scorecard_id, object_version_number from per_personal_scorecards
38: where scorecard_id = p_sc_id;
39:
40:
41: api_return_status varchar2(10);

Line 47: l_sc_id per_personal_scorecards.scorecard_id%TYPE;

43: formatted_sc_list varchar2(1000) default null;
44:
45: i PLS_INTEGER := 1 ;
46: temp_str varchar2(20);
47: l_sc_id per_personal_scorecards.scorecard_id%TYPE;
48: l_sc_ovn per_personal_scorecards.object_version_number%TYPE;
49: l_sc_latest_ovn per_personal_scorecards.object_version_number%TYPE;
50: l_sc_latest_id per_personal_scorecards.scorecard_id%TYPE;
51:

Line 48: l_sc_ovn per_personal_scorecards.object_version_number%TYPE;

44:
45: i PLS_INTEGER := 1 ;
46: temp_str varchar2(20);
47: l_sc_id per_personal_scorecards.scorecard_id%TYPE;
48: l_sc_ovn per_personal_scorecards.object_version_number%TYPE;
49: l_sc_latest_ovn per_personal_scorecards.object_version_number%TYPE;
50: l_sc_latest_id per_personal_scorecards.scorecard_id%TYPE;
51:
52: begin

Line 49: l_sc_latest_ovn per_personal_scorecards.object_version_number%TYPE;

45: i PLS_INTEGER := 1 ;
46: temp_str varchar2(20);
47: l_sc_id per_personal_scorecards.scorecard_id%TYPE;
48: l_sc_ovn per_personal_scorecards.object_version_number%TYPE;
49: l_sc_latest_ovn per_personal_scorecards.object_version_number%TYPE;
50: l_sc_latest_id per_personal_scorecards.scorecard_id%TYPE;
51:
52: begin
53: --l_sc_list := p_score_card_list;

Line 50: l_sc_latest_id per_personal_scorecards.scorecard_id%TYPE;

46: temp_str varchar2(20);
47: l_sc_id per_personal_scorecards.scorecard_id%TYPE;
48: l_sc_ovn per_personal_scorecards.object_version_number%TYPE;
49: l_sc_latest_ovn per_personal_scorecards.object_version_number%TYPE;
50: l_sc_latest_id per_personal_scorecards.scorecard_id%TYPE;
51:
52: begin
53: --l_sc_list := p_score_card_list;
54: --OPEN :sc_cursor FOR select scorecard_id, object_version_number from per_personal_scorecards

Line 54: --OPEN :sc_cursor FOR select scorecard_id, object_version_number from per_personal_scorecards

50: l_sc_latest_id per_personal_scorecards.scorecard_id%TYPE;
51:
52: begin
53: --l_sc_list := p_score_card_list;
54: --OPEN :sc_cursor FOR select scorecard_id, object_version_number from per_personal_scorecards
55: --where scorecard_id in (p_score_card_list);
56: --dbms_output.put_line( ' p_score_card_list ' || p_score_card_list);
57:
58:

Line 330: from per_personal_scorecards sc, per_all_assignments_f asgn,

326:
327: cursor get_score_card_role(p_score_card_id in number)
328: IS
329: select wf.name wf_role, people.global_name emp_name, sc.scorecard_name, sc.plan_id
330: from per_personal_scorecards sc, per_all_assignments_f asgn,
331: per_all_people_f people, wf_roles wf
332: where sc.scorecard_id = p_score_card_id
333: and asgn.assignment_id = sc.assignment_id
334: and sysdate between asgn.effective_start_date and asgn.effective_end_date

Line 344: and transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

340: cursor get_score_card_txn(p_score_card_id number, txn_owner per_all_people_f.person_id%TYPE)
341: IS
342: select transaction_id from hr_api_transactions
343: where transaction_ref_id = p_score_card_id
344: and transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
345: and creator_person_id = txn_owner;
346:
347: -- cursor to get the ovn for a scorecardId.
348: cursor get_score_cards ( p_sc_id varchar2 )

Line 350: select object_version_number from per_personal_scorecards

346:
347: -- cursor to get the ovn for a scorecardId.
348: cursor get_score_cards ( p_sc_id varchar2 )
349: is
350: select object_version_number from per_personal_scorecards
351: where scorecard_id = p_sc_id;
352: -- to be sorted with the lenght
353: score_card_list varchar2(1000);
354: SC_OVN_LIST varchar2(1000);

Line 369: score_card_name per_personal_scorecards.scorecard_name%TYPE;

365: score_card_performer wf_local_roles.name%TYPE;
366: score_card_emp_name per_all_people_f.global_name%TYPE;
367: score_card_txn_id number default null;
368: l_error_log varchar2(20000);
369: score_card_name per_personal_scorecards.scorecard_name%TYPE;
370: txn_owner_person_id per_all_people_f.person_id%TYPE;
371: temp varchar2(2000);
372: l_duplsicate_name_warning boolean;
373: l_proc varchar2(72) := g_package || 'PROCESS_SCORE_CARD';

Line 374: l_score_card_plan_id per_personal_scorecards.plan_id%TYPE;

370: txn_owner_person_id per_all_people_f.person_id%TYPE;
371: temp varchar2(2000);
372: l_duplsicate_name_warning boolean;
373: l_proc varchar2(72) := g_package || 'PROCESS_SCORE_CARD';
374: l_score_card_plan_id per_personal_scorecards.plan_id%TYPE;
375:
376:
377: BEGIN
378:

Line 479: --update per_personal_scorecards

475:
476: fnd_msg_pub.Delete_Msg;
477:
478: -- to be changed once the error_log column is added
479: --update per_personal_scorecards
480: --set error_log = l_error_log
481: --where scorecard_id = next_score_card;
482: per_pms_upd.upd(p_effective_date => trunc(sysdate),
483: p_scorecard_id => to_number(next_score_card),

Line 521: --update per_personal_scorecards

517: end loop;
518:
519: fnd_msg_pub.Delete_Msg;
520:
521: --update per_personal_scorecards
522: --set error_log = l_error_log
523: --where scorecard_id = next_score_card;
524: end if;
525: