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_CPDF_EHRIS dependencies on GHR_CPDF_TEMP

Line 11: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

7: PROCEDURE get_from_history_asgnei
8: (
9: p_sr_assignment_id IN NUMBER
10: ,p_sr_report_date IN DATE
11: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
12: );
13: PROCEDURE get_from_history_people
14: (
15: p_sr_person_id IN NUMBER

Line 17: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

13: PROCEDURE get_from_history_people
14: (
15: p_sr_person_id IN NUMBER
16: ,p_sr_report_date IN DATE
17: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
18: );
19: PROCEDURE get_from_history_ancrit
20: (
21: p_sr_person_id IN NUMBER

Line 23: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

19: PROCEDURE get_from_history_ancrit
20: (
21: p_sr_person_id IN NUMBER
22: ,p_sr_report_date IN DATE
23: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
24: );
25: PROCEDURE get_from_history_peopei
26: (
27: p_sr_person_id IN NUMBER

Line 29: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

25: PROCEDURE get_from_history_peopei
26: (
27: p_sr_person_id IN NUMBER
28: ,p_sr_report_date IN DATE
29: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
30: );
31:
32: PROCEDURE get_from_per_wrkadd --Bug# 4725292
33: (

Line 36: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

32: PROCEDURE get_from_per_wrkadd --Bug# 4725292
33: (
34: p_sr_person_id IN NUMBER
35: ,p_sr_report_date IN DATE
36: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
37: );
38: PROCEDURE get_from_history_posiei
39: (
40: p_sr_position_id IN NUMBER

Line 42: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

38: PROCEDURE get_from_history_posiei
39: (
40: p_sr_position_id IN NUMBER
41: ,p_sr_report_date IN DATE
42: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
43: );
44: PROCEDURE get_from_history_gradef
45: (
46: p_sr_grade_id IN NUMBER

Line 48: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

44: PROCEDURE get_from_history_gradef
45: (
46: p_sr_grade_id IN NUMBER
47: ,p_sr_report_date IN DATE
48: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
49: );
50: PROCEDURE get_from_history_jobdef
51: (
52: p_sr_job_id IN NUMBER

Line 54: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

50: PROCEDURE get_from_history_jobdef
51: (
52: p_sr_job_id IN NUMBER
53: ,p_sr_report_date IN DATE
54: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
55: );
56: PROCEDURE get_from_history_dutsta
57: (
58: p_sr_location_id IN NUMBER

Line 60: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

56: PROCEDURE get_from_history_dutsta
57: (
58: p_sr_location_id IN NUMBER
59: ,p_sr_report_date IN DATE
60: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
61: );
62: PROCEDURE get_from_history_payele
63: (
64: p_sr_assignment_id IN NUMBER

Line 66: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

62: PROCEDURE get_from_history_payele
63: (
64: p_sr_assignment_id IN NUMBER
65: ,p_sr_report_date IN DATE
66: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
67: );
68: PROCEDURE calc_is_foreign_duty_station
69: (p_report_date IN DATE
70: );

Line 79: PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,

75:
76: PROCEDURE insert_row;
77: PROCEDURE purge_suppression;
78:
79: PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,
80: p_report_date IN DATE,
81: p_count_only IN BOOLEAN);
82:
83: TYPE t_tag_type IS RECORD

Line 87: PROCEDURE WriteTagValues(p_cpdf_status GHR_CPDF_TEMP%rowtype,p_tags OUT NOCOPY t_tags);

83: TYPE t_tag_type IS RECORD
84: (tagname VARCHAR2(240),
85: tagvalue VARCHAR2(4000));
86: TYPE t_tags IS TABLE OF t_tag_type INDEX BY BINARY_INTEGER;
87: PROCEDURE WriteTagValues(p_cpdf_status GHR_CPDF_TEMP%rowtype,p_tags OUT NOCOPY t_tags);
88: PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type, p_tags t_tags );
89: PROCEDURE WriteAsciivalues(p_l_fp utl_file.file_type, p_tags t_tags,p_gen_txt_file IN VARCHAR2);
90:
91: PROCEDURE ehri_status_main

Line 106: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;

102: PROCEDURE WritetoFile (p_input_file_name VARCHAR2
103: ,p_gen_xml_file IN VARCHAR2
104: ,p_gen_txt_file IN VARCHAR2);
105:
106: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
107: g_agency VARCHAR2(04);
108: g_report_date DATE;
109: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
110: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;