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.PER_SSL_BUS dependencies on PER_SALARY_SURVEY_LINES

Line 63: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');

59: <> per_ssl_shd.g_old_rec.salary_survey_line_id) Then
60: --
61: -- raise error as Primary Key has changed
62: --
63: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');
64: --
65: elsIf not l_api_updating Then
66: --
67: -- This is an insert so check that the primary key is null.

Line 73: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');

69: If p_salary_survey_line_id is not null Then
70: --
71: -- raise error as Primary Key is not null
72: --
73: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_PK');
74: --
75: End If;
76: --
77: End If;

Line 152: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_FK1');

148: --
149: -- raise error as FK does not relate to PK in per_salary_surveys
150: -- table.
151: --
152: per_ssl_shd.constraint_error('PER_SALARY_SURVEY_LINES_FK1');
153: --
154: End If;
155: --
156: close csr_chk_survey_exists;

Line 210: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,

206: Procedure chk_unique_key
207: (p_salary_survey_line_id in number,
208: p_object_version_number in number,
209: p_salary_survey_id in number,
210: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
211: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
212: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,

Line 211: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,

207: (p_salary_survey_line_id in number,
208: p_object_version_number in number,
209: p_salary_survey_id in number,
210: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
211: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
212: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
215: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,

Line 212: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,

208: p_object_version_number in number,
209: p_salary_survey_id in number,
210: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
211: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
212: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
215: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
216: p_start_date in per_salary_survey_lines.start_date%TYPE,

Line 213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,

209: p_salary_survey_id in number,
210: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
211: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
212: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
215: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
216: p_start_date in per_salary_survey_lines.start_date%TYPE,
217: p_end_date in per_salary_survey_lines.end_date%TYPE)is

Line 214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,

210: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
211: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
212: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
215: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
216: p_start_date in per_salary_survey_lines.start_date%TYPE,
217: p_end_date in per_salary_survey_lines.end_date%TYPE)is
218: --

Line 215: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,

211: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
212: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
215: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
216: p_start_date in per_salary_survey_lines.start_date%TYPE,
217: p_end_date in per_salary_survey_lines.end_date%TYPE)is
218: --
219: l_proc varchar2(72) := g_package||'chk_unique_key';

Line 216: p_start_date in per_salary_survey_lines.start_date%TYPE,

212: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
215: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
216: p_start_date in per_salary_survey_lines.start_date%TYPE,
217: p_end_date in per_salary_survey_lines.end_date%TYPE)is
218: --
219: l_proc varchar2(72) := g_package||'chk_unique_key';
220: l_api_updating boolean;

Line 217: p_end_date in per_salary_survey_lines.end_date%TYPE)is

213: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
214: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
215: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
216: p_start_date in per_salary_survey_lines.start_date%TYPE,
217: p_end_date in per_salary_survey_lines.end_date%TYPE)is
218: --
219: l_proc varchar2(72) := g_package||'chk_unique_key';
220: l_api_updating boolean;
221: l_exists varchar2(1);

Line 226: from per_salary_survey_lines

222: l_eot date := hr_general.End_of_time;
223: --
224: cursor csr_duplicate_key is
225: select null
226: from per_salary_survey_lines
227: where p_start_date = start_date
228: and survey_job_name_code = p_survey_job_name_code
229: and nvl(survey_region_code,hr_api.g_varchar2)
230: = nvl(p_survey_region_code,hr_api.g_varchar2)

Line 243: from per_salary_survey_lines

239: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
240: --
241: cursor csr_overlap_date is
242: select null
243: from per_salary_survey_lines
244: where p_start_date <= nvl(end_date,l_eot)
245: and nvl(p_end_date,l_eot) >= start_date
246: and survey_job_name_code = p_survey_job_name_code
247: and nvl(survey_region_code,hr_api.g_varchar2)

Line 263: from per_salary_survey_lines

259: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
260: --
261: cursor csr_invalid_end_date is
262: select null
263: from per_salary_survey_lines
264: where p_start_date < start_date
265: and (nvl(p_end_date,l_eot) >= start_date and
266: nvl(p_end_date,l_eot) <= nvl(end_date,l_eot)
267: )

Line 356: 'PER_SALARY_SURVEY_LINES_UK1');

352: --
353: close csr_duplicate_key;
354: --
355: per_ssl_shd.constraint_error(p_constraint_name =>
356: 'PER_SALARY_SURVEY_LINES_UK1');
357: --
358: End If;
359: --
360: close csr_duplicate_key;

Line 462: in per_salary_survey_lines.survey_job_name_code%TYPE

458: in number
459: ,p_salary_survey_id
460: in number
461: ,p_survey_job_name_code
462: in per_salary_survey_lines.survey_job_name_code%TYPE
463: ,p_effective_date
464: in date) is
465: --
466: l_proc varchar2(72) := g_package||'chk_survey_job_name_code';

Line 611: in per_salary_survey_lines.survey_region_code%TYPE

607: in number
608: ,p_salary_survey_id
609: in number
610: ,p_survey_region_code
611: in per_salary_survey_lines.survey_region_code%TYPE
612: ,p_effective_date
613: in date) is
614: --
615: l_proc varchar2(72) := g_package||'chk_survey_region_code';

Line 757: in per_salary_survey_lines.survey_seniority_code%TYPE

753: in number
754: ,p_salary_survey_id
755: in number
756: ,p_survey_seniority_code
757: in per_salary_survey_lines.survey_seniority_code%TYPE
758: ,p_effective_date
759: in date) is
760: --
761: l_proc varchar2(72) := g_package||'chk_survey_seniority_code';

Line 902: in per_salary_survey_lines.company_size_code%TYPE

898: in number
899: ,p_salary_survey_id
900: in number
901: ,p_company_size_code
902: in per_salary_survey_lines.company_size_code%TYPE
903: ,p_effective_date
904: in date) is
905: --
906: l_proc varchar2(72) := g_package||'chk_company_size_code';

Line 1047: in per_salary_survey_lines.industry_code%TYPE

1043: in number
1044: ,p_salary_survey_id
1045: in number
1046: ,p_industry_code
1047: in per_salary_survey_lines.industry_code%TYPE
1048: ,p_effective_date
1049: in date) is
1050: --
1051: l_proc varchar2(72) := g_package||'chk_industry_code';

Line 1196: in per_salary_survey_lines.survey_age_code%TYPE

1192: in number
1193: ,p_salary_survey_id
1194: in number
1195: ,p_survey_age_code
1196: in per_salary_survey_lines.survey_age_code%TYPE
1197: ,p_effective_date
1198: in date) is
1199: --
1200: l_proc varchar2(72) := g_package||'chk_survey_age_code';

Line 1337: in per_salary_survey_lines.stock_display_type%TYPE

1333: in number
1334: ,p_object_version_number
1335: in number
1336: ,p_stock_display_type_code
1337: in per_salary_survey_lines.stock_display_type%TYPE
1338: ,p_effective_date
1339: in date) is
1340: --
1341: l_proc varchar2(72) := g_package||'chk_stock_display_type_code';

Line 1519: in per_salary_survey_lines.currency_code%TYPE,

1515: in number,
1516: p_object_version_number
1517: in number,
1518: p_currency_code
1519: in per_salary_survey_lines.currency_code%TYPE,
1520: p_minimum_pay
1521: in per_salary_survey_lines.minimum_pay%TYPE,
1522: p_mean_pay
1523: in per_salary_survey_lines.mean_pay%TYPE,

Line 1521: in per_salary_survey_lines.minimum_pay%TYPE,

1517: in number,
1518: p_currency_code
1519: in per_salary_survey_lines.currency_code%TYPE,
1520: p_minimum_pay
1521: in per_salary_survey_lines.minimum_pay%TYPE,
1522: p_mean_pay
1523: in per_salary_survey_lines.mean_pay%TYPE,
1524: p_maximum_pay
1525: in per_salary_survey_lines.maximum_pay%TYPE,

Line 1523: in per_salary_survey_lines.mean_pay%TYPE,

1519: in per_salary_survey_lines.currency_code%TYPE,
1520: p_minimum_pay
1521: in per_salary_survey_lines.minimum_pay%TYPE,
1522: p_mean_pay
1523: in per_salary_survey_lines.mean_pay%TYPE,
1524: p_maximum_pay
1525: in per_salary_survey_lines.maximum_pay%TYPE,
1526: p_graduate_pay
1527: in per_salary_survey_lines.graduate_pay%TYPE,

Line 1525: in per_salary_survey_lines.maximum_pay%TYPE,

1521: in per_salary_survey_lines.minimum_pay%TYPE,
1522: p_mean_pay
1523: in per_salary_survey_lines.mean_pay%TYPE,
1524: p_maximum_pay
1525: in per_salary_survey_lines.maximum_pay%TYPE,
1526: p_graduate_pay
1527: in per_salary_survey_lines.graduate_pay%TYPE,
1528: p_starting_pay
1529: in per_salary_survey_lines.starting_pay%TYPE,

Line 1527: in per_salary_survey_lines.graduate_pay%TYPE,

1523: in per_salary_survey_lines.mean_pay%TYPE,
1524: p_maximum_pay
1525: in per_salary_survey_lines.maximum_pay%TYPE,
1526: p_graduate_pay
1527: in per_salary_survey_lines.graduate_pay%TYPE,
1528: p_starting_pay
1529: in per_salary_survey_lines.starting_pay%TYPE,
1530: p_percentage_change
1531: in per_salary_survey_lines.percentage_change%TYPE,

Line 1529: in per_salary_survey_lines.starting_pay%TYPE,

1525: in per_salary_survey_lines.maximum_pay%TYPE,
1526: p_graduate_pay
1527: in per_salary_survey_lines.graduate_pay%TYPE,
1528: p_starting_pay
1529: in per_salary_survey_lines.starting_pay%TYPE,
1530: p_percentage_change
1531: in per_salary_survey_lines.percentage_change%TYPE,
1532: p_job_first_quartile
1533: in per_salary_survey_lines.job_first_quartile%TYPE,

Line 1531: in per_salary_survey_lines.percentage_change%TYPE,

1527: in per_salary_survey_lines.graduate_pay%TYPE,
1528: p_starting_pay
1529: in per_salary_survey_lines.starting_pay%TYPE,
1530: p_percentage_change
1531: in per_salary_survey_lines.percentage_change%TYPE,
1532: p_job_first_quartile
1533: in per_salary_survey_lines.job_first_quartile%TYPE,
1534: p_job_median_quartile
1535: in per_salary_survey_lines.job_median_quartile%TYPE,

Line 1533: in per_salary_survey_lines.job_first_quartile%TYPE,

1529: in per_salary_survey_lines.starting_pay%TYPE,
1530: p_percentage_change
1531: in per_salary_survey_lines.percentage_change%TYPE,
1532: p_job_first_quartile
1533: in per_salary_survey_lines.job_first_quartile%TYPE,
1534: p_job_median_quartile
1535: in per_salary_survey_lines.job_median_quartile%TYPE,
1536: p_job_third_quartile
1537: in per_salary_survey_lines.job_third_quartile%TYPE,

Line 1535: in per_salary_survey_lines.job_median_quartile%TYPE,

1531: in per_salary_survey_lines.percentage_change%TYPE,
1532: p_job_first_quartile
1533: in per_salary_survey_lines.job_first_quartile%TYPE,
1534: p_job_median_quartile
1535: in per_salary_survey_lines.job_median_quartile%TYPE,
1536: p_job_third_quartile
1537: in per_salary_survey_lines.job_third_quartile%TYPE,
1538: p_job_fourth_quartile
1539: in per_salary_survey_lines.job_fourth_quartile%TYPE,

Line 1537: in per_salary_survey_lines.job_third_quartile%TYPE,

1533: in per_salary_survey_lines.job_first_quartile%TYPE,
1534: p_job_median_quartile
1535: in per_salary_survey_lines.job_median_quartile%TYPE,
1536: p_job_third_quartile
1537: in per_salary_survey_lines.job_third_quartile%TYPE,
1538: p_job_fourth_quartile
1539: in per_salary_survey_lines.job_fourth_quartile%TYPE,
1540: p_minimum_total_compensation
1541: in per_salary_survey_lines.minimum_total_compensation%TYPE,

Line 1539: in per_salary_survey_lines.job_fourth_quartile%TYPE,

1535: in per_salary_survey_lines.job_median_quartile%TYPE,
1536: p_job_third_quartile
1537: in per_salary_survey_lines.job_third_quartile%TYPE,
1538: p_job_fourth_quartile
1539: in per_salary_survey_lines.job_fourth_quartile%TYPE,
1540: p_minimum_total_compensation
1541: in per_salary_survey_lines.minimum_total_compensation%TYPE,
1542: p_mean_total_compensation
1543: in per_salary_survey_lines.mean_total_compensation%TYPE,

Line 1541: in per_salary_survey_lines.minimum_total_compensation%TYPE,

1537: in per_salary_survey_lines.job_third_quartile%TYPE,
1538: p_job_fourth_quartile
1539: in per_salary_survey_lines.job_fourth_quartile%TYPE,
1540: p_minimum_total_compensation
1541: in per_salary_survey_lines.minimum_total_compensation%TYPE,
1542: p_mean_total_compensation
1543: in per_salary_survey_lines.mean_total_compensation%TYPE,
1544: p_maximum_total_compensation
1545: in per_salary_survey_lines.maximum_total_compensation%TYPE,

Line 1543: in per_salary_survey_lines.mean_total_compensation%TYPE,

1539: in per_salary_survey_lines.job_fourth_quartile%TYPE,
1540: p_minimum_total_compensation
1541: in per_salary_survey_lines.minimum_total_compensation%TYPE,
1542: p_mean_total_compensation
1543: in per_salary_survey_lines.mean_total_compensation%TYPE,
1544: p_maximum_total_compensation
1545: in per_salary_survey_lines.maximum_total_compensation%TYPE,
1546: p_compnstn_first_quartile
1547: in per_salary_survey_lines.compnstn_first_quartile%TYPE,

Line 1545: in per_salary_survey_lines.maximum_total_compensation%TYPE,

1541: in per_salary_survey_lines.minimum_total_compensation%TYPE,
1542: p_mean_total_compensation
1543: in per_salary_survey_lines.mean_total_compensation%TYPE,
1544: p_maximum_total_compensation
1545: in per_salary_survey_lines.maximum_total_compensation%TYPE,
1546: p_compnstn_first_quartile
1547: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
1548: p_compnstn_median_quartile
1549: in per_salary_survey_lines.compnstn_median_quartile%TYPE,

Line 1547: in per_salary_survey_lines.compnstn_first_quartile%TYPE,

1543: in per_salary_survey_lines.mean_total_compensation%TYPE,
1544: p_maximum_total_compensation
1545: in per_salary_survey_lines.maximum_total_compensation%TYPE,
1546: p_compnstn_first_quartile
1547: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
1548: p_compnstn_median_quartile
1549: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
1550: p_compnstn_third_quartile
1551: in per_salary_survey_lines.compnstn_third_quartile%TYPE,

Line 1549: in per_salary_survey_lines.compnstn_median_quartile%TYPE,

1545: in per_salary_survey_lines.maximum_total_compensation%TYPE,
1546: p_compnstn_first_quartile
1547: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
1548: p_compnstn_median_quartile
1549: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
1550: p_compnstn_third_quartile
1551: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
1552: p_compnstn_fourth_quartile
1553: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE

Line 1551: in per_salary_survey_lines.compnstn_third_quartile%TYPE,

1547: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
1548: p_compnstn_median_quartile
1549: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
1550: p_compnstn_third_quartile
1551: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
1552: p_compnstn_fourth_quartile
1553: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE
1554: ) is
1555: --

Line 1553: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE

1549: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
1550: p_compnstn_third_quartile
1551: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
1552: p_compnstn_fourth_quartile
1553: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE
1554: ) is
1555: --
1556: l_proc varchar2(72) := g_package||'chk_salary_figures';
1557: --

Line 1806: p_start_date in per_salary_survey_lines.start_date%TYPE,

1802: -- Internal row handler use only.
1803: --
1804: Procedure chk_dates
1805: (p_salary_survey_line_id in number,
1806: p_start_date in per_salary_survey_lines.start_date%TYPE,
1807: p_end_date in per_salary_survey_lines.end_date%TYPE)is
1808: --
1809: l_proc varchar2(72) := g_package||'chk_dates';
1810: l_eot date := hr_general.End_of_time;

Line 1807: p_end_date in per_salary_survey_lines.end_date%TYPE)is

1803: --
1804: Procedure chk_dates
1805: (p_salary_survey_line_id in number,
1806: p_start_date in per_salary_survey_lines.start_date%TYPE,
1807: p_end_date in per_salary_survey_lines.end_date%TYPE)is
1808: --
1809: l_proc varchar2(72) := g_package||'chk_dates';
1810: l_eot date := hr_general.End_of_time;
1811: --

Line 1894: (p_salary_survey_line_id in per_salary_survey_lines.salary_survey_line_id%TYPE

1890: -- Access Status
1891: -- Internal row handler use only.
1892: --
1893: procedure chk_currency_code
1894: (p_salary_survey_line_id in per_salary_survey_lines.salary_survey_line_id%TYPE
1895: ,p_currency_code in per_salary_survey_lines.currency_code%TYPE) is
1896: --
1897: l_proc varchar2(72) :=
1898: g_package||'chk_currency_code';

Line 1895: ,p_currency_code in per_salary_survey_lines.currency_code%TYPE) is

1891: -- Internal row handler use only.
1892: --
1893: procedure chk_currency_code
1894: (p_salary_survey_line_id in per_salary_survey_lines.salary_survey_line_id%TYPE
1895: ,p_currency_code in per_salary_survey_lines.currency_code%TYPE) is
1896: --
1897: l_proc varchar2(72) :=
1898: g_package||'chk_currency_code';
1899: --

Line 2213: ,p_descflex_name => 'PER_SALARY_SURVEY_LINES'

2209: -- b) During insert.
2210: --
2211: hr_dflex_utility.ins_or_upd_descflex_attribs
2212: (p_appl_short_name => 'PER'
2213: ,p_descflex_name => 'PER_SALARY_SURVEY_LINES'
2214: ,p_attribute_category => p_rec.attribute_category
2215: ,p_attribute1_name => 'ATTRIBUTE1'
2216: ,p_attribute1_value => p_rec.attribute1
2217: ,p_attribute2_name => 'ATTRIBUTE2'