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.GHR_MASS_AWARDS_PKG dependencies on GHR_MASS_AWARDS

Line 1: PACKAGE BODY GHR_MASS_AWARDS_PKG AS

1: PACKAGE BODY GHR_MASS_AWARDS_PKG AS
2: /* $Header: ghrmarpa.pkb 120.13 2010/04/09 05:25:19 vmididho ship $ */
3:
4:
5: g_package varchar2(32) := 'GHR_MASS_AWARDS_PKG.';

Line 5: g_package varchar2(32) := 'GHR_MASS_AWARDS_PKG.';

1: PACKAGE BODY GHR_MASS_AWARDS_PKG AS
2: /* $Header: ghrmarpa.pkb 120.13 2010/04/09 05:25:19 vmididho ship $ */
3:
4:
5: g_package varchar2(32) := 'GHR_MASS_AWARDS_PKG.';
6: l_information_type varchar2(40) := 'GHR_US_PAR_AWARDS_BONUS';
7: g_log_name varchar2(30);
8: g_log_text varchar2(2000);
9:

Line 91: p_mass_award_id in ghr_mass_awards.mass_award_id%type)

87: END get_business_group;
88:
89:
90: FUNCTION get_noa_id (
91: p_mass_award_id in ghr_mass_awards.mass_award_id%type)
92: RETURN NUMBER IS
93: --
94: CURSOR cur_noa_id IS
95: SELECT nature_of_action_id

Line 96: FROM ghr_mass_awards

92: RETURN NUMBER IS
93: --
94: CURSOR cur_noa_id IS
95: SELECT nature_of_action_id
96: FROM ghr_mass_awards
97: WHERE mass_award_id = p_mass_award_id;
98:
99: l_ret_val NUMBER(15);
100:

Line 113: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

109: END get_noa_id;
110:
111: --Bug#3804067 Added new parameter p_mass_action_comments
112: PROCEDURE get_pa_request_id_ovn (
113: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
114: p_effective_date in date,
115: p_person_id in per_people_f.person_id%TYPE,
116: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,

Line 185: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

181: END get_pa_request_id_ovn;
182:
183: PROCEDURE get_award_details
184: (
185: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
186: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
187: p_effective_date in date,
188: p_person_id in ghr_pa_requests.person_id%TYPE,
189: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,

Line 321: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

317: END get_award_details;
318:
319: PROCEDURE get_award_lac
320: (
321: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
322: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
323: p_effective_date in date,
324: p_first_lac1_record out nocopy first_lac1_record,
325: p_first_lac2_record out nocopy first_lac2_record

Line 503: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

499:
500:
501: PROCEDURE main_awards
502: (
503: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
504: p_action_type in varchar2,
505: p_errbuf out nocopy varchar2, --\___ error log
506: p_status out nocopy varchar2, --||
507: p_retcode out nocopy number, --/ in conc. manager.

Line 529: FROM ghr_mass_awards

525: l_prog_name varchar2(30);
526:
527: CURSOR cur_ma IS
528: SELECT trunc(effective_date) effective_date
529: FROM ghr_mass_awards
530: WHERE mass_award_id = p_mass_award_id;
531:
532: CURSOR cur_get_seq is
533: SELECT to_char(ghr_process_log_s.nextval)

Line 562: ghr_mass_awards_elig.get_eligible_employees

558: p_effective_date => l_effective_date);
559:
560:
561: hr_utility.set_location( l_proc,30);
562: ghr_mass_awards_elig.get_eligible_employees
563: ( p_mass_award_id => p_mass_award_id,
564: p_action_type => p_action_type,
565: p_errbuf => l_errbuf,
566: p_status => l_status,

Line 586: hr_utility.set_location( 'Updating ghr_mass_awards table ...' ||l_proc,50);

582: ( p_mass_award_id => p_mass_award_id,
583: p_rpa_type => l_rpa_type,
584: p_effective_date => l_effective_date);
585:
586: hr_utility.set_location( 'Updating ghr_mass_awards table ...' ||l_proc,50);
587:
588: IF p_action_type = 'FINAL' THEN
589: update ghr_mass_awards set status_flag = l_status_flag
590: where mass_award_id = p_mass_award_id;

Line 589: update ghr_mass_awards set status_flag = l_status_flag

585:
586: hr_utility.set_location( 'Updating ghr_mass_awards table ...' ||l_proc,50);
587:
588: IF p_action_type = 'FINAL' THEN
589: update ghr_mass_awards set status_flag = l_status_flag
590: where mass_award_id = p_mass_award_id;
591: END IF;
592:
593: hr_utility.set_location('Leaving ' || l_proc,60);

Line 610: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

606: END main_awards;
607:
608: PROCEDURE upd_elig_flag_bef_selection
609: (
610: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
611: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
612: p_effective_date in date
613: )
614:

Line 646: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

642: end;
643:
644: PROCEDURE del_elig_flag_aft_selection
645: (
646: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
647: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
648: p_effective_date in date
649: )
650:

Line 700: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

696: END del_elig_flag_aft_selection;
697:
698: Procedure marpa_process
699: (
700: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
701: p_action_type in VARCHAR2,
702: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
703: p_effective_date in date,
704: p_person_id in per_people_f.person_id%TYPE,

Line 1605: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

1601: END marpa_process;
1602:
1603: Procedure build_rpa_for_mass_awards
1604: (
1605: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
1606: p_action_type in VARCHAR2,
1607: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
1608: p_effective_date in date,
1609: p_person_id in per_people_f.person_id%TYPE,

Line 1714: FROM ghr_mass_awards

1710: ORDER by 1 desc;
1711:
1712: CURSOR cur_maw_name IS
1713: SELECT name
1714: FROM ghr_mass_awards
1715: WHERE mass_award_id = p_mass_award_id;
1716:
1717: l_maw_name ghr_mass_awards.name%type;
1718:

Line 1717: l_maw_name ghr_mass_awards.name%type;

1713: SELECT name
1714: FROM ghr_mass_awards
1715: WHERE mass_award_id = p_mass_award_id;
1716:
1717: l_maw_name ghr_mass_awards.name%type;
1718:
1719: l_from_basic_pay_pa number;
1720: l_comments varchar2(2000);
1721: l_error_flag boolean;

Line 2727: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

2723:
2724:
2725: PROCEDURE refresh_award_details
2726: (
2727: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
2728: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
2729: p_effective_date in date,
2730: p_person_id in per_people_f.person_id%TYPE,
2731: p_pa_request_id in ghr_pa_requests.pa_request_id%type

Line 3176: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

3172:
3173: end update_shadow_row;
3174:
3175: Procedure create_remarks
3176: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
3177: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
3178: p_effective_date in date,
3179: p_pa_request_id in ghr_pa_requests.pa_request_id%type
3180: )

Line 3544: END GHR_MASS_AWARDS_PKG;

3540: END IF;
3541:
3542: END check_award_amount;
3543:
3544: END GHR_MASS_AWARDS_PKG;