[Home] [Help]
PACKAGE: APPS.PQP_HROSS_REPORTS
Source
1 PACKAGE pqp_hross_reports AUTHID CURRENT_USER AS
2 /* $Header: pqphrossrpt.pkh 120.5 2006/01/05 04:13 nkkrishn noship $ */
3
4 -- =============================================================================
5 -- ~ Declare Package Variables:
6 -- =============================================================================
7
8 --Lexical Reference Variable
9 GENERIC_WHERE VARCHAR2(250);
10 PERSON_TYPE_WHERE VARCHAR2(250);
11 ORGANNIZATION_NAME_WHERE VARCHAR2(250);
12 PAYROLL_NAME_WHERE VARCHAR2(250);
13 LOCATION_NAME_WHERE VARCHAR2(250);
14 LAST_NAME_WHERE VARCHAR2(250);
15 FIRST_NAME_WHERE VARCHAR2(250);
16 NATIONAL_IDENTIFIER_WHERE VARCHAR2(250);
17 STUDENT_NUMBER_WHERE VARCHAR2(250);
18 PERSON_ID_GROUP_QUERY_WHERE VARCHAR2(250);
19 PERSON_ID_LIST_WHERE VARCHAR2(32000);
20 PERSON_END_DATE_WHERE VARCHAR2(32000);
21 --PERSON_END_DATE_WHERE2 VARCHAR2(32000);
22 ASSIGNMENT_END_DATE_WHERE VARCHAR2(32000);
23 ADDRESS_END_DATE_WHERE VARCHAR2(1000);
24 ORDER_BY_CLAUSE VARCHAR2(1000);
25
26 --Parameters passed as input to the Data Template Wrapper Concurrent Program
27 --P_GROUP_QUERY VARCHAR2(32000);
28 P_PERSON_ID_GROUP_QUERY VARCHAR2(32000);
29 P_BUSINESS_GROUP_NAME VARCHAR2(240);
30 P_BUSINESS_GROUP_ID VARCHAR2(50);
31 P_EFFECTIVE_START_DATE VARCHAR2(20);
32 P_EFFECTIVE_END_DATE VARCHAR2(20);
33 P_PERSON_TYPE VARCHAR2(50);
34 P_PERSON_TYPE_DESC VARCHAR2(240);
35 P_ORGANIZATION_NAME VARCHAR2(240);
36 P_ORGANIZATION_ID VARCHAR2(50);
37 P_PAYROLL_NAME VARCHAR2(240);
38 P_PAYROLL_ID VARCHAR2(50);
39 P_LOCATION_VALUE VARCHAR2(240);
40 P_LOCATION_ID VARCHAR2(50);
41 P_PERSON_ID_GROUP VARCHAR2(240);
42 P_LAST_NAME VARCHAR2(240);
43 P_FIRST_NAME VARCHAR2(240);
44 P_NATIONAL_IDENTIFIER VARCHAR2(240);
45 P_STUDENT_NUMBER VARCHAR2(240);
46 P_REPORT_NAME VARCHAR2(240);
47 P_DATA_MATCH_FILTER VARCHAR2(20);
48 P_REPORT_RUN_DATE VARCHAR2(20);
49 P_DATA_MATCH_FILTER_DESC VARCHAR2(240);
50 P_SORT_BY VARCHAR2(20);
51 P_SORT_BY_DESC VARCHAR2(240);
52
53 MATCHING_RECORDS_COUNTER NUMBER;
54 MISMATCH_RECORDS_COUNTER NUMBER;
55
56 --Package Global Variables
57 P_DATA_MISMATCH_FLAG BOOLEAN;
58
59 -- =============================================================================
60 -- ~ Before_Report_Trigger:
61 -- =============================================================================
62 PROCEDURE Before_Report_Trigger;
63
64 -- =============================================================================
65 -- ~ Before_Report_Trigger:
66 -- =============================================================================
67 FUNCTION Before_Report_Trigger RETURN BOOLEAN;
68
69 -- =============================================================================
70 -- ~ Generate_Report:
71 -- =============================================================================
72 PROCEDURE Generate_Report
73 (p_person_id_group_query IN VARCHAR2
74 ,p_business_group_name IN VARCHAR2
75 ,p_business_group_id IN VARCHAR2
76 ,p_effective_start_date IN VARCHAR2
77 ,p_effective_end_date IN VARCHAR2
78 ,p_person_type IN VARCHAR2
79 ,p_person_type_desc IN VARCHAR2
80 ,p_organization_name IN VARCHAR2
81 ,p_organization_id IN VARCHAR2
82 ,p_payroll_name IN VARCHAR2
83 ,p_payroll_id IN VARCHAR2
84 ,p_location_value IN VARCHAR2
85 ,p_location_id IN VARCHAR2
86 ,p_person_id_group IN VARCHAR2
87 ,p_last_name IN VARCHAR2
88 ,p_first_name IN VARCHAR2
89 ,p_national_identifier IN VARCHAR2
90 ,p_student_number IN VARCHAR2
91 ,p_template_code IN VARCHAR2
92 ,p_template_lang IN VARCHAR2
93 ,p_template_ter IN VARCHAR2
94 ,p_output_format IN VARCHAR2
95 ,p_report_name IN VARCHAR2
96 ,p_data_match_filter IN VARCHAR2
97 ,p_report_run_date IN VARCHAR2
98 ,p_data_match_filter_desc IN VARCHAR2
99 ,p_sort_by IN VARCHAR2
100 ,p_sort_by_desc IN VARCHAR2
101 ,p_return_status IN OUT NOCOPY VARCHAR2);
102
103 -- =============================================================================
104 -- ~ Compare_Values: Function to determine whether two strings are the same or
105 -- ~ different
106 -- =============================================================================
107 FUNCTION Compare_Values
108 (p_parameter1 IN VARCHAR2
109 ,p_parameter2 IN VARCHAR2
110 ) RETURN VARCHAR2;
111
112 -- =============================================================================
113 -- ~ Get_Mismatch_Indicator_Flag: Function to return Mismatch Indicator Flag
114 -- =============================================================================
115 FUNCTION Get_Mismatch_Indicator_Flag RETURN VARCHAR2;
116
117 -- =============================================================================
118 -- ~ Record_Filter: Function to return Mismatch Indicator Flag
119 -- =============================================================================
120 FUNCTION Record_Filter(p_mismatch_indicator_flag IN VARCHAR2
121 ,p_full_name IN VARCHAR2) RETURN BOOLEAN;
122
123 -- =============================================================================
124 -- ~ Get_Date: Function to return date value in session format
125 -- =============================================================================
126 Function Get_Date(p_date IN DATE) RETURN VARCHAR2;
127
128 -- =============================================================================
129 -- ~ Get_Count: Function to return the count of matching and mismatching records
130 -- =============================================================================
131 Function Get_Count(p_parameter IN VARCHAR2) RETURN VARCHAR2;
132
133 -- =============================================================================
134 -- ~ Get_Primary_Telephone_Number: Returns the secondary telephone number
135 -- =============================================================================
136 Function Get_Primary_Telephone_Number(p_owner_table_id IN VARCHAR2) RETURN VARCHAR2;
137
138 -- =============================================================================
139 -- ~ Get_Secondary_Telephone_Number: Returns the secondary telephone number
140 -- =============================================================================
141 Function Get_Secondary_Telephone_Number(p_owner_table_id IN VARCHAR2) RETURN VARCHAR2;
142
143 END pqp_hross_reports;