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_PSS_BUS dependencies on PER_SALARY_SURVEYS

Line 56: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');

52: <> per_pss_shd.g_old_rec.salary_survey_id) then
53: --
54: -- raise error as PK has changed
55: --
56: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');

62: if p_salary_survey_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');
67: --
68: end if;
69: --
70: end if;

Line 113: p_survey_name in per_salary_surveys.survey_name%TYPE,

109: --
110: Procedure chk_survey_name_company_code
111: (p_salary_survey_id in number,
112: p_object_version_number in number,
113: p_survey_name in per_salary_surveys.survey_name%TYPE,
114: p_survey_company_code in per_salary_surveys.survey_company_code%TYPE) is
115: --
116: l_proc varchar2(72) := g_package||'chk_survey_name_company_code';
117: l_api_updating boolean;

Line 114: p_survey_company_code in per_salary_surveys.survey_company_code%TYPE) is

110: Procedure chk_survey_name_company_code
111: (p_salary_survey_id in number,
112: p_object_version_number in number,
113: p_survey_name in per_salary_surveys.survey_name%TYPE,
114: p_survey_company_code in per_salary_surveys.survey_company_code%TYPE) is
115: --
116: l_proc varchar2(72) := g_package||'chk_survey_name_company_code';
117: l_api_updating boolean;
118: l_exists varchar2(1);

Line 122: from per_salary_surveys

118: l_exists varchar2(1);
119: --
120: cursor csr_unique_surv_name_comp_code is
121: select null
122: from per_salary_surveys
123: where upper(survey_name) = upper(p_survey_name)
124: and survey_company_code = p_survey_company_code
125: and salary_survey_id <> nvl(p_salary_survey_id,hr_api.g_number);
126: --

Line 185: 'PER_SALARY_SURVEYS_UK1');

181: --
182: if csr_unique_surv_name_comp_code%found then
183: --
184: per_pss_shd.constraint_error(p_constraint_name =>
185: 'PER_SALARY_SURVEYS_UK1');
186: --
187: end if;
188: --
189: hr_utility.set_location(l_proc, 30);

Line 229: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE

225: -- Access Status
226: -- Internal row handler use only.
227: --
228: procedure chk_survey_company_code
229: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE
230: ,p_survey_company_code
231: in per_salary_surveys.survey_company_code%TYPE
232: ,p_effective_date in date
233: ) is

Line 231: in per_salary_surveys.survey_company_code%TYPE

227: --
228: procedure chk_survey_company_code
229: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE
230: ,p_survey_company_code
231: in per_salary_surveys.survey_company_code%TYPE
232: ,p_effective_date in date
233: ) is
234: --
235: l_proc varchar2(72) :=

Line 320: (p_identifier in per_salary_surveys.identifier%TYPE) is

316: -- Access Status
317: -- Internal row handler use only.
318: --
319: procedure chk_identifier
320: (p_identifier in per_salary_surveys.identifier%TYPE) is
321: --
322: l_proc varchar2(72) := g_package||'chk_identifier';
323: l_api_updating boolean;
324: --

Line 373: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE

369: -- Access Status
370: -- Internal row handler use only.
371: --
372: procedure chk_currency_code
373: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE
374: ,p_currency_code
375: in per_salary_surveys.currency_code%TYPE) is
376: --
377: l_proc varchar2(72) :=

Line 375: in per_salary_surveys.currency_code%TYPE) is

371: --
372: procedure chk_currency_code
373: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE
374: ,p_currency_code
375: in per_salary_surveys.currency_code%TYPE) is
376: --
377: l_proc varchar2(72) :=
378: g_package||'chk_currency_code';
379: --

Line 475: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE

471: -- Access Status
472: -- Internal row handler use only.
473: --
474: procedure chk_survey_type_code
475: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE
476: ,p_survey_type_code
477: in per_salary_surveys.survey_type_code%TYPE
478: ,p_effective_date in date
479: ) is

Line 477: in per_salary_surveys.survey_type_code%TYPE

473: --
474: procedure chk_survey_type_code
475: (p_salary_survey_id in per_salary_surveys.salary_survey_id%TYPE
476: ,p_survey_type_code
477: in per_salary_surveys.survey_type_code%TYPE
478: ,p_effective_date in date
479: ) is
480: --
481: l_proc varchar2(72) :=

Line 571: in per_salary_surveys.salary_survey_id%TYPE) is

567: --
568: -- {End Of Comments}
569:
570: Procedure chk_delete(p_salary_survey_id
571: in per_salary_surveys.salary_survey_id%TYPE) is
572: --
573: l_proc varchar2(72) := g_package||'chk_delete';
574: l_exists varchar2(1);
575: --

Line 779: ,p_descflex_name => 'PER_SALARY_SURVEYS'

775: -- b) During insert.
776: --
777: hr_dflex_utility.ins_or_upd_descflex_attribs
778: (p_appl_short_name => 'PER'
779: ,p_descflex_name => 'PER_SALARY_SURVEYS'
780: ,p_attribute_category => p_rec.attribute_category
781: ,p_attribute1_name => 'ATTRIBUTE1'
782: ,p_attribute1_value => p_rec.attribute1
783: ,p_attribute2_name => 'ATTRIBUTE2'