1 PACKAGE per_us_ipeds_pkg AUTHID CURRENT_USER AS
2 /* $Header: peusiped.pkh 120.0.12020000.2 2012/11/07 08:27:08 nkjaladi noship $*/
3 p_business_group_id VARCHAR2(40);
4 p_report_date DATE;
5 p_tenured VARCHAR2(40);
6 p_race_gender VARCHAR2(40);
7 p_report_type VARCHAR2(40);
8
9 /*****************************************************************************
10 Name : get_report_date
11 Type : Function
12 Return Type : VARCHAR2
13 Description : Returns the Report Run date in Month DD,YYYY format
14 ***************************************************************************/
15 FUNCTION get_report_date
16 RETURN VARCHAR2;
17
18 /*****************************************************************************
19 Name : get_tenured
20 Type : Function
21 Return Type : VARCHAR2
22 Description : Returns the Tenured Flag Value
23 ***************************************************************************/
24 FUNCTION get_tenured
25 RETURN VARCHAR2;
26
27 /*****************************************************************************
28 Name : get_race_gender
29 Type : Function
30 Return Type : VARCHAR2
31 Description : Returns the Race/Ethnicity Value
32 ***************************************************************************/
33 FUNCTION get_race_gender
34 RETURN VARCHAR2;
35
36 /***************************************************************************
37 Name : get_new_hire_start_date
38 Type : Function
39 Return Type : VARCHAR2
40 Description : Returns the Start Date for IPED Part H(New Hire) Report
41 in Month DD,YYYY format
42 ***************************************************************************/
43 FUNCTION get_new_hire_start_date
44 RETURN VARCHAR2;
45
46 /***************************************************************************
47 Name : get_new_hire_end_date
48 Type : Function
49 Return Type : VARCHAR2
50 Description : Returns the End Date for IPED Part H(New Hire) Report
51 in Month DD,YYYY format
52 ***************************************************************************/
53 FUNCTION get_new_hire_end_date
54 RETURN VARCHAR2;
55
56 /***************************************************************************
57 Name : get_report_type
58 Type : Function
59 Return Type : VARCHAR2
60 Description : Returns the Report Type description
61 ***************************************************************************/
62 FUNCTION get_report_type
63 RETURN VARCHAR2;
64
65 /***************************************************************************
66 Name : get_non_deg_gnt_label
67 Type : Function
68 Return Type : VARCHAR2
69 Description : Returns the Report Label depending on the report type.
70 ***************************************************************************/
71 FUNCTION get_non_deg_gnt_label
72 RETURN VARCHAR2;
73
74 /***************************************************************************
75 Name : deg_gnt_parta_bef_rpt
76 Type : Function
77 Return Type : Boolean
78 Description : Populates the PER_US_RPT_TOTALS with information required to
79 generate the IPEDS Part A report
80 ***************************************************************************/
81 FUNCTION deg_gnt_parta_bef_rpt
82 RETURN BOOLEAN;
83
84 /***************************************************************************
85 Name : deg_gnt_partb_e_bef_rpt
86 Type : Function
87 Return Type : Boolean
88 Description : Populates the PER_US_RPT_TOTALS with information required to
89 generate the IPEDS Part B and E based on report name
90 ***************************************************************************/
91 FUNCTION deg_gnt_partb_e_bef_rpt(p_report_name IN VARCHAR2)
92 RETURN BOOLEAN;
93
94 /***************************************************************************
95 Name : deg_gnt_partd_bef_rpt
96 Type : Function
97 Return Type : Boolean
98 Description : Populates the PER_US_RPT_TOTALS with information required to
99 generate the IPEDS Part D report
100 ***************************************************************************/
101 FUNCTION deg_gnt_partd_bef_rpt
102 RETURN BOOLEAN;
103
104 /***************************************************************************
105 Name : deg_gnt_partg_bef_rpt
106 Type : Function
107 Return Type : Boolean
108 Description : Populates the PER_US_RPT_TOTALS with information required to
109 generate the IPEDS Part G report
110 ***************************************************************************/
111 FUNCTION deg_gnt_partg_bef_rpt
112 RETURN BOOLEAN;
113
114 /*****************************************************************************
115 Name : deg_gnt_parth_bef_rpt
116 Type : Function
117 Return Type : Boolean
118 Description : Populates the PER_US_RPT_TOTALS with information required to
119 generate the IPEDS Part H report
120 ***************************************************************************/
121 FUNCTION deg_gnt_parth_bef_rpt
122 RETURN BOOLEAN;
123
124 /***************************************************************************
125 Name : non_deg_gnt_part_bef_rpt
126 Type : Function
127 Return Type : Boolean
128 Description : Populates the PER_US_RPT_TOTALS with information required to
129 generate the Non Degree Granting institutions IPEDS report
130 Part A or B based on Parameter selected by user
131 ***************************************************************************/
132 FUNCTION non_deg_gnt_part_bef_rpt(p_report_type IN VARCHAR2)
133 RETURN BOOLEAN;
134
135 /***************************************************************************
136 Name : BeforeReport
137 Type : Function
138 Return Type : Boolean
139 Description : This is common procedure called from XML data definition that
140 inturn calls the repective report procedures to populate the
141 PAY_US_RPT_TOTALS for generating the report.
142 ***************************************************************************/
143 FUNCTION BeforeReport(p_report_name IN VARCHAR2
144 ,p_report_type IN VARCHAR2 DEFAULT NULL)
145 RETURN BOOLEAN;
146
147 /*****************************************************************************
148 Name : AfterReport
149 Type : Function
150 Return Type : Boolean
151 Description : This is common procedure called from XML data definition
152 After Report trigger to delete the data from PAY_US_RPT_TOTALS.
153 *****************************************************************************/
154 FUNCTION AfterReport(p_report_name IN VARCHAR2)
155 RETURN BOOLEAN;
156
157 END per_us_ipeds_pkg;