[Home] [Help]
PACKAGE: APPS.PQH_COMP_SURVEY
Source
1 package PQH_COMP_SURVEY as
2 /* $Header: pqhsuadi.pkh 120.0 2005/05/29 02:07:39 appldev noship $ */
3
4 procedure import_row
5 ( P_survey_name VARCHAR2 default null
6 , P_identifier VARCHAR2 default null
7 , P_survey_company VARCHAR2 default null
8 , P_survey_type VARCHAR2 default null
9 , P_base_region VARCHAR2 default null
10 , P_SALARY_SURVEY_ID NUMBER default null
11 , P_SALARY_SURVEY_LINE_ID NUMBER default null
12 , P_OBJECT_VERSION_NUMBER NUMBER default null
13 , P_SURVEY_JOB_NAME_CODE VARCHAR2 default null
14 , P_SURVEY_REGION_CODE VARCHAR2 default null
15 , P_SURVEY_SENIORITY_CODE VARCHAR2 default null
16 , P_COMPANY_SIZE_CODE VARCHAR2 default null
17 , P_INDUSTRY_CODE VARCHAR2 default null
18 , P_SURVEY_AGE_CODE VARCHAR2 default null
19 , P_CURRENCY_CODE VARCHAR2 default null
20 , P_STOCK_DISPLAY_TYPE_CODE VARCHAR2 default null
21 , P_SURVEY_JOB_NAME VARCHAR2 default null
22 , P_SURVEY_REGION VARCHAR2 default null
23 , P_SURVEY_SENIORITY VARCHAR2 default null
24 , P_COMPANY_SIZE VARCHAR2 default null
25 , P_INDUSTRY VARCHAR2 default null
26 , P_SURVEY_AGE VARCHAR2 default null
27 , P_CURRENCY VARCHAR2 default null
28 , P_START_DATE DATE default null
29 , P_END_DATE DATE default null
30 , P_DIFFERENTIAL NUMBER default null
31 , P_MINIMUM_PAY NUMBER default null
32 , P_MEAN_PAY NUMBER default null
33 , P_MAXIMUM_PAY NUMBER default null
34 , P_GRADUATE_PAY NUMBER default null
35 , P_STARTING_PAY NUMBER default null
36 , P_PERCENTAGE_CHANGE NUMBER default null
37 , P_JOB_FIRST_QUARTILE NUMBER default null
38 , P_JOB_MEDIAN_QUARTILE NUMBER default null
39 , P_JOB_THIRD_QUARTILE NUMBER default null
40 , P_JOB_FOURTH_QUARTILE NUMBER default null
41 , P_MINIMUM_TOTAL_COMPENSATION NUMBER default null
42 , P_MEAN_TOTAL_COMPENSATION NUMBER default null
43 , P_MAXIMUM_TOTAL_COMPENSATION NUMBER default null
44 , P_COMPNSTN_FIRST_QUARTILE NUMBER default null
45 , P_COMPNSTN_MEDIAN_QUARTILE NUMBER default null
46 , P_COMPNSTN_THIRD_QUARTILE NUMBER default null
47 , P_COMPNSTN_FOURTH_QUARTILE NUMBER default null
48 , P_TENTH_PERCENTILE NUMBER default null
49 , P_TWENTY_FIFTH_PERCENTILE NUMBER default null
50 , P_FIFTIETH_PERCENTILE NUMBER default null
51 , P_SEVENTY_FIFTH_PERCENTILE NUMBER default null
52 , P_NINETIETH_PERCENTILE NUMBER default null
53 , P_MINIMUM_BONUS NUMBER default null
54 , P_MEAN_BONUS NUMBER default null
55 , P_MAXIMUM_BONUS NUMBER default null
56 , P_MINIMUM_SALARY_INCREASE NUMBER default null
57 , P_MEAN_SALARY_INCREASE NUMBER default null
58 , P_MAXIMUM_SALARY_INCREASE NUMBER default null
59 , P_MIN_VARIABLE_COMPENSATION NUMBER default null
60 , P_MEAN_VARIABLE_COMPENSATION NUMBER default null
61 , P_MAX_VARIABLE_COMPENSATION NUMBER default null
62 , P_MINIMUM_STOCK NUMBER default null
63 , P_MEAN_STOCK NUMBER default null
64 , P_MAXIMUM_STOCK NUMBER default null
65 , P_STOCK_DISPLAY_TYPE VARCHAR2 default null
66 , P_ATTRIBUTE_CATEGORY VARCHAR2 default null
67 , P_ATTRIBUTE1 VARCHAR2 default null
68 , P_ATTRIBUTE2 VARCHAR2 default null
69 , P_ATTRIBUTE3 VARCHAR2 default null
70 , P_ATTRIBUTE4 VARCHAR2 default null
71 , P_ATTRIBUTE5 VARCHAR2 default null
72 , P_ATTRIBUTE6 VARCHAR2 default null
73 , P_ATTRIBUTE7 VARCHAR2 default null
74 , P_ATTRIBUTE8 VARCHAR2 default null
75 , P_ATTRIBUTE9 VARCHAR2 default null
76 , P_ATTRIBUTE10 VARCHAR2 default null
77 , P_ATTRIBUTE11 VARCHAR2 default null
78 , P_ATTRIBUTE12 VARCHAR2 default null
79 , P_ATTRIBUTE13 VARCHAR2 default null
80 , P_ATTRIBUTE14 VARCHAR2 default null
81 , P_ATTRIBUTE15 VARCHAR2 default null
82 , P_ATTRIBUTE16 VARCHAR2 default null
83 , P_ATTRIBUTE17 VARCHAR2 default null
84 , P_ATTRIBUTE18 VARCHAR2 default null
85 , P_ATTRIBUTE19 VARCHAR2 default null
86 , P_ATTRIBUTE20 VARCHAR2 default null
87 , P_ATTRIBUTE21 VARCHAR2 default null
88 , P_ATTRIBUTE22 VARCHAR2 default null
89 , P_ATTRIBUTE23 VARCHAR2 default null
90 , P_ATTRIBUTE24 VARCHAR2 default null
91 , P_ATTRIBUTE25 VARCHAR2 default null
92 , P_ATTRIBUTE26 VARCHAR2 default null
93 , P_ATTRIBUTE27 VARCHAR2 default null
94 , P_ATTRIBUTE28 VARCHAR2 default null
95 , P_ATTRIBUTE29 VARCHAR2 default null
96 , P_ATTRIBUTE30 VARCHAR2 default null
97 , P_LAST_UPDATE_DATE DATE default null
98 , P_LAST_UPDATED_BY NUMBER default null
99 , P_LAST_UPDATE_LOGIN NUMBER default null
100 , P_CREATED_BY NUMBER default null
101 , P_CREATION_DATE DATE default null
102 );
103
104 end PQH_COMP_SURVEY;