APPS.PER_SSM_BUS dependencies on PER_SALARY_SURVEY_MAPPINGS

Line 26: per_salary_survey_mappings ssm

22: --
23: cursor csr_leg_code is
24: select pbg.legislation_code
25: from per_business_groups pbg,
26: per_salary_survey_mappings ssm
27: where ssm.salary_survey_mapping_id = p_salary_survey_mapping_id
28: and pbg.business_group_id = ssm.business_group_id;
29: --
30: -- Declare local variables

Line 312: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK1');

308: --
309: -- raise error as FK does not relate to PK in per_salary_survey_lines
310: -- table.
311: --
312: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK1');
313: --
314: End If;
315: --
316: close csr_chk_survey_line_exists;

Line 597: -- compared to other rows in the table per_salary_survey_mappings.

593: --
594: -- Description
595: -- This Procedure is used to check that salary_survey_line_id,
596: -- parent_table_name and the parent_table_id are in a unique combination
597: -- compared to other rows in the table per_salary_survey_mappings.
598: --
599: --
600: -- Pre-Conditions
601: -- None.

Line 614: -- other rows in the table per_salary_survey_mappings.

610: --
611: -- Post Success
612: -- Processing continues If the salary_survey_line_id, parent_table_name
613: -- and the parent_table_id are in a unique combination compared to
614: -- other rows in the table per_salary_survey_mappings.
615: --
616: -- Post Failure
617: -- Processing stops and an error is raised if the unique key validation
618: -- is breeched.

Line 640: from per_salary_survey_mappings ssm

636: l_exists varchar2(1);
637: --
638: cursor csr_chk_unique_key is
639: select 'Y'
640: from per_salary_survey_mappings ssm
641: where ssm.parent_id = p_parent_id
642: and ssm.parent_table_name = p_parent_table_name
643: and ssm.salary_survey_line_id = p_salary_survey_line_id
644: and ssm.grade_id = p_grade_id

Line 669: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_UK');

665: open csr_chk_unique_key;
666: fetch csr_chk_unique_key into l_exists;
667: If csr_chk_unique_key%found Then
668: close csr_chk_unique_key;
669: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_UK');
670: Else
671: close csr_chk_unique_key;
672: End If;
673: End If;

Line 743: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK2');

739: --
740: -- raise error as FK does not relate to PK in hr_locations
741: -- table.
742: --
743: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK2');
744: --
745: Elsif l_loc_date_to < p_ssl_start_date then
746: --
747: close csr_chk_location_exists;

Line 816: from per_salary_survey_mappings

812: where g.grade_id = p_grade_id;
813: --
814: cursor csr_get_bg is
815: select business_group_id
816: from per_salary_survey_mappings
817: where salary_survey_mapping_id = p_salary_survey_mapping_id;
818: --
819: Begin
820: --

Line 844: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK3');

840: --
841: -- raise error as FK does not relate to PK in per_grades
842: -- table.
843: --
844: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK3');
845: --
846: -- Elsif l_business_group_id <> p_business_group_id then
847: Elsif l_business_group_id <> l_bg then
848: close csr_chk_grade_exists;

Line 919: from per_salary_survey_mappings

915: where o.organization_id = p_company_organization_id;
916: --
917: cursor csr_get_bg is
918: select business_group_id
919: from per_salary_survey_mappings
920: where salary_survey_mapping_id = p_salary_survey_mapping_id;
921: --
922: Begin
923: --

Line 950: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK5');

946: --
947: -- raise error as FK does not relate to PK in hr_all_organization_units
948: -- table.
949: --
950: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK5');
951: --
952: -- Elsif l_business_group_id <> p_business_group_id then
953: Elsif l_business_group_id <> l_bg then
954: hr_utility.set_location(l_proc,30);

Line 1035: -- per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK');

1031: --
1032: -- raise error as FK does not relate to PK in hr_all_organization_units
1033: -- table.
1034: --
1035: -- per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK');
1036: fnd_message.set_name('PER','PER_52495_SSM_AGE_DATE_INVL');
1037: fnd_message.raise_error;
1038: --
1039: Else

Line 1192: ,p_descflex_name => 'PER_SALARY_SURVEY_MAPPINGS'

1188: -- b) During insert.
1189: --
1190: hr_dflex_utility.ins_or_upd_descflex_attribs
1191: (p_appl_short_name => 'PER'
1192: ,p_descflex_name => 'PER_SALARY_SURVEY_MAPPINGS'
1193: ,p_attribute_category => p_rec.attribute_category
1194: ,p_attribute1_name => 'ATTRIBUTE1'
1195: ,p_attribute1_value => p_rec.attribute1
1196: ,p_attribute2_name => 'ATTRIBUTE2'