APPS.GHR_CPDF_STATRPT 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: PROCEDURE get_from_history_posiei
32: (
33: p_sr_position_id IN NUMBER

Line 35: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

31: PROCEDURE get_from_history_posiei
32: (
33: p_sr_position_id IN NUMBER
34: ,p_sr_report_date IN DATE
35: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
36: );
37: PROCEDURE get_from_history_gradef
38: (
39: p_sr_grade_id IN NUMBER

Line 41: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

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

Line 47: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

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

Line 53: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

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

Line 59: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE

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

Line 70: PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,

66: p_suffix OUT NOCOPY VARCHAR2,
67: p_lname OUT NOCOPY VARCHAR2);
68: PROCEDURE insert_row;
69: PROCEDURE purge_suppression;
70: PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,
71: p_report_date IN DATE);
72:
73: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
74: g_agency VARCHAR2(04);

Line 73: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;

69: PROCEDURE purge_suppression;
70: PROCEDURE populate_ghr_cpdf_temp (p_agency IN VARCHAR2,
71: p_report_date IN DATE);
72:
73: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
74: g_agency VARCHAR2(04);
75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;