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_CON_PROGRAM dependencies on GHR_PA_REQUESTS

Line 5: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,

1: PACKAGE GHR_MASS_CON_PROGRAM AUTHID CURRENT_USER AS
2: /* $Header: ghmascon.pkh 120.3 2011/04/09 15:11:46 utokachi noship $ */
3:
4: type first_lac1_record is record
5: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
6: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
7: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
8: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
9: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,

Line 6: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,

2: /* $Header: ghmascon.pkh 120.3 2011/04/09 15:11:46 utokachi noship $ */
3:
4: type first_lac1_record is record
5: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
6: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
7: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
8: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
9: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
10: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,

Line 7: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,

3:
4: type first_lac1_record is record
5: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
6: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
7: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
8: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
9: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
10: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
11: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);

Line 8: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,

4: type first_lac1_record is record
5: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
6: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
7: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
8: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
9: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
10: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
11: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
12:

Line 9: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,

5: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
6: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
7: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
8: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
9: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
10: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
11: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
12:
13: type first_lac2_record is record

Line 10: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,

6: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
7: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
8: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
9: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
10: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
11: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
12:
13: type first_lac2_record is record
14: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,

Line 11: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);

7: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
8: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
9: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
10: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
11: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
12:
13: type first_lac2_record is record
14: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
15: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,

Line 14: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,

10: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
11: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
12:
13: type first_lac2_record is record
14: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
15: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
16: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
17: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
18: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,

Line 15: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,

11: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
12:
13: type first_lac2_record is record
14: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
15: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
16: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
17: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
18: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
19: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,

Line 16: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,

12:
13: type first_lac2_record is record
14: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
15: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
16: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
17: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
18: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
19: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
20: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);

Line 17: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,

13: type first_lac2_record is record
14: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
15: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
16: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
17: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
18: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
19: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
20: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
21:

Line 18: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,

14: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
15: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
16: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
17: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
18: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
19: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
20: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
21:
22: PROCEDURE get_furlough_rtd_lac

Line 19: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,

15: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
16: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
17: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
18: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
19: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
20: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
21:
22: PROCEDURE get_furlough_rtd_lac
23: (

Line 20: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);

16: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
17: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
18: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
19: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
20: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
21:
22: PROCEDURE get_furlough_rtd_lac
23: (
24: p_noa_action in VARCHAR2,

Line 35: p_pa_request_id in ghr_pa_requests.pa_request_id%type,

31: Procedure create_remarks
32: (p_noa_action in VARCHAR2,
33: p_effective_date in date,
34: p_person_id IN number,
35: p_pa_request_id in ghr_pa_requests.pa_request_id%type,
36: p_work_schedule IN ghr_pa_requests.work_schedule%type,
37: p_fegli IN VARCHAR2,
38: p_fehb_plan IN VARCHAR2,
39: p_prd IN VARCHAR2

Line 36: p_work_schedule IN ghr_pa_requests.work_schedule%type,

32: (p_noa_action in VARCHAR2,
33: p_effective_date in date,
34: p_person_id IN number,
35: p_pa_request_id in ghr_pa_requests.pa_request_id%type,
36: p_work_schedule IN ghr_pa_requests.work_schedule%type,
37: p_fegli IN VARCHAR2,
38: p_fehb_plan IN VARCHAR2,
39: p_prd IN VARCHAR2
40: );

Line 53: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

49: ) ;
50:
51: Procedure build_rpa
52: ( p_noa_action in VARCHAR2,
53: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
54: p_effective_date in date,
55: p_nte_date in varchar2,
56: p_person_id in per_people_f.person_id%TYPE,
57: p_assignment_id in per_assignments_f.assignment_id%TYPE,

Line 67: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,

63: p_retcode out nocopy number
64: );
65: PROCEDURE get_pa_request_id_ovn
66: (
67: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
68: p_effective_date in date,
69: p_person_id in per_people_f.person_id%TYPE,
70: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
71: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,

Line 70: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,

66: (
67: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
68: p_effective_date in date,
69: p_person_id in per_people_f.person_id%TYPE,
70: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
71: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
72: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE
73: );
74: procedure marpa_process

Line 71: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,

67: p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE,
68: p_effective_date in date,
69: p_person_id in per_people_f.person_id%TYPE,
70: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
71: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
72: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE
73: );
74: procedure marpa_process
75: (

Line 72: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE

68: p_effective_date in date,
69: p_person_id in per_people_f.person_id%TYPE,
70: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
71: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
72: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE
73: );
74: procedure marpa_process
75: (
76: p_noa_action in VARCHAR2,

Line 77: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

73: );
74: procedure marpa_process
75: (
76: p_noa_action in VARCHAR2,
77: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
78: p_effective_date in date,
79: p_person_id in per_people_f.person_id%TYPE,
80: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
81: p_log_text out nocopy varchar2

Line 80: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,

76: p_noa_action in VARCHAR2,
77: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
78: p_effective_date in date,
79: p_person_id in per_people_f.person_id%TYPE,
80: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
81: p_log_text out nocopy varchar2
82: );
83:
84:

Line 85: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype);

81: p_log_text out nocopy varchar2
82: );
83:
84:
85: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype);
86:
87: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
88: p_result out nocopy Boolean );
89:

Line 87: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,

83:
84:
85: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype);
86:
87: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
88: p_result out nocopy Boolean );
89:
90: END GHR_MASS_CON_PROGRAM;