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.HR_SALARY_SURVEY_MAPPING_API dependencies on HR_API

Line 105: when hr_api.cannot_find_prog_unit then

101: ,p_attribute19 => p_attribute19
102: ,p_attribute20 => p_attribute20
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'CREATE_MAPPING'
108: ,p_hook_type => 'BP'
109: );

Line 106: hr_api.cannot_find_prog_unit_error

102: ,p_attribute20 => p_attribute20
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'CREATE_MAPPING'
108: ,p_hook_type => 'BP'
109: );
110: end;

Line 200: when hr_api.cannot_find_prog_unit then

196: ,p_salary_survey_mapping_id => p_salary_survey_mapping_id
197: ,p_object_version_number => p_object_version_number
198: );
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'CREATE_MAPPING'
203: ,p_hook_type => 'AP'
204: );

Line 201: hr_api.cannot_find_prog_unit_error

197: ,p_object_version_number => p_object_version_number
198: );
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'CREATE_MAPPING'
203: ,p_hook_type => 'AP'
204: );
205: end;

Line 212: raise hr_api.validate_enabled;

208: --
209: -- When in validation only mode raise the Validate_Enabled exception
210: --
211: if p_validate then
212: raise hr_api.validate_enabled;
213: end if;
214: --
215: -- Set all output arguments
216: --

Line 222: when hr_api.validate_enabled then

218: p_object_version_number := l_object_version_number;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 70);
221: exception
222: when hr_api.validate_enabled then
223: --
224: -- As the Validate_Enabled exception has been raised
225: -- we must rollback to the savepoint
226: --

Line 338: when hr_api.cannot_find_prog_unit then

334: ,p_salary_survey_mapping_id => p_salary_survey_mapping_id
335: ,p_object_version_number => l_object_version_number
336: );
337: exception
338: when hr_api.cannot_find_prog_unit then
339: hr_api.cannot_find_prog_unit_error
340: (p_module_name => 'update_mapping'
341: ,p_hook_type => 'BP'
342: );

Line 339: hr_api.cannot_find_prog_unit_error

335: ,p_object_version_number => l_object_version_number
336: );
337: exception
338: when hr_api.cannot_find_prog_unit then
339: hr_api.cannot_find_prog_unit_error
340: (p_module_name => 'update_mapping'
341: ,p_hook_type => 'BP'
342: );
343: end;

Line 428: when hr_api.cannot_find_prog_unit then

424: ,p_salary_survey_mapping_id => p_salary_survey_mapping_id
425: ,p_object_version_number => l_object_version_number
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'update_mapping'
431: ,p_hook_type => 'AP'
432: );

Line 429: hr_api.cannot_find_prog_unit_error

425: ,p_object_version_number => l_object_version_number
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'update_mapping'
431: ,p_hook_type => 'AP'
432: );
433: end;

Line 440: raise hr_api.validate_enabled;

436: --
437: -- When in validation only mode raise the Validate_Enabled exception
438: --
439: if p_validate then
440: raise hr_api.validate_enabled;
441: end if;
442: --
443: -- Set all output arguments
444: --

Line 449: when hr_api.validate_enabled then

445: p_object_version_number := l_object_version_number;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 70);
448: exception
449: when hr_api.validate_enabled then
450: --
451: -- As the Validate_Enabled exception has been raised
452: -- we must rollback to the savepoint
453: --

Line 506: when hr_api.cannot_find_prog_unit then

502: (p_salary_survey_mapping_id => p_salary_survey_mapping_id
503: ,p_object_version_number => p_object_version_number
504: );
505: exception
506: when hr_api.cannot_find_prog_unit then
507: hr_api.cannot_find_prog_unit_error
508: (p_module_name => 'DELETE_MAPPING'
509: ,p_hook_type => 'BP'
510: );

Line 507: hr_api.cannot_find_prog_unit_error

503: ,p_object_version_number => p_object_version_number
504: );
505: exception
506: when hr_api.cannot_find_prog_unit then
507: hr_api.cannot_find_prog_unit_error
508: (p_module_name => 'DELETE_MAPPING'
509: ,p_hook_type => 'BP'
510: );
511: end;

Line 538: when hr_api.cannot_find_prog_unit then

534: (p_salary_survey_mapping_id => p_salary_survey_mapping_id
535: ,p_object_version_number => p_object_version_number
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'DELETE_MAPPING'
541: ,p_hook_type => 'AP'
542: );

Line 539: hr_api.cannot_find_prog_unit_error

535: ,p_object_version_number => p_object_version_number
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'DELETE_MAPPING'
541: ,p_hook_type => 'AP'
542: );
543: end;

Line 549: raise hr_api.validate_enabled;

545: --
546: -- When in validation only mode raise the Validate_Enabled exception
547: --
548: if p_validate then
549: raise hr_api.validate_enabled;
550: end if;
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 70);
553: exception

Line 554: when hr_api.validate_enabled then

550: end if;
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 70);
553: exception
554: when hr_api.validate_enabled then
555: --
556: -- As the Validate_Enabled exception has been raised
557: -- we must rollback to the savepoint
558: --

Line 601: select j.date_from, nvl(j.date_to, hr_api.g_eot)

597: l_company_organization_id number;
598: l_grade_id number;
599: --
600: cursor csr_get_job_dates is
601: select j.date_from, nvl(j.date_to, hr_api.g_eot)
602: from per_jobs j
603: where j.job_id = p_job_id;
604: --
605: -- Changes 13-Oct-99 SCNair (per_positions to hr_positions_f)Date tracked position req

Line 641: select g.date_from, nvl(g.date_to,hr_api.g_eot)

637: ssl.industry_code;
638:
639: --
640: cursor csr_get_grade_dates(c_grade_id number) is
641: select g.date_from, nvl(g.date_to,hr_api.g_eot)
642: from per_grades g
643: where grade_id = c_grade_id;
644: --
645: cursor csr_get_org_dates(c_org_id number) is

Line 646: select o.date_from, nvl(o.date_to,hr_api.g_eot)

642: from per_grades g
643: where grade_id = c_grade_id;
644: --
645: cursor csr_get_org_dates(c_org_id number) is
646: select o.date_from, nvl(o.date_to,hr_api.g_eot)
647: from hr_all_organization_units o
648: where o.organization_id = c_org_id;
649: --
650: cursor csr_get_ssl_ids(c_survey_job_name_code varchar2

Line 660: and nvl(ssl.survey_job_name_code,hr_api.g_varchar2) = nvl(c_survey_job_name_code,hr_api.g_varchar2)

656: ,c_date_to date) is
657: select salary_survey_line_id
658: from per_salary_survey_lines ssl
659: where ssl.start_date between c_date_from and c_date_to
660: and nvl(ssl.survey_job_name_code,hr_api.g_varchar2) = nvl(c_survey_job_name_code,hr_api.g_varchar2)
661: and nvl(ssl.survey_region_code,hr_api.g_varchar2) = nvl(c_survey_region_code,hr_api.g_varchar2)
662: and nvl(ssl.survey_seniority_code,hr_api.g_varchar2) = nvl(c_survey_seniority_code,hr_api.g_varchar2)
663: and nvl(ssl.company_size_code,hr_api.g_varchar2) = nvl(c_company_size_code,hr_api.g_varchar2)
664: and nvl(ssl.industry_code,hr_api.g_varchar2) = nvl(c_industry_code,hr_api.g_varchar2);

Line 661: and nvl(ssl.survey_region_code,hr_api.g_varchar2) = nvl(c_survey_region_code,hr_api.g_varchar2)

657: select salary_survey_line_id
658: from per_salary_survey_lines ssl
659: where ssl.start_date between c_date_from and c_date_to
660: and nvl(ssl.survey_job_name_code,hr_api.g_varchar2) = nvl(c_survey_job_name_code,hr_api.g_varchar2)
661: and nvl(ssl.survey_region_code,hr_api.g_varchar2) = nvl(c_survey_region_code,hr_api.g_varchar2)
662: and nvl(ssl.survey_seniority_code,hr_api.g_varchar2) = nvl(c_survey_seniority_code,hr_api.g_varchar2)
663: and nvl(ssl.company_size_code,hr_api.g_varchar2) = nvl(c_company_size_code,hr_api.g_varchar2)
664: and nvl(ssl.industry_code,hr_api.g_varchar2) = nvl(c_industry_code,hr_api.g_varchar2);
665:

Line 662: and nvl(ssl.survey_seniority_code,hr_api.g_varchar2) = nvl(c_survey_seniority_code,hr_api.g_varchar2)

658: from per_salary_survey_lines ssl
659: where ssl.start_date between c_date_from and c_date_to
660: and nvl(ssl.survey_job_name_code,hr_api.g_varchar2) = nvl(c_survey_job_name_code,hr_api.g_varchar2)
661: and nvl(ssl.survey_region_code,hr_api.g_varchar2) = nvl(c_survey_region_code,hr_api.g_varchar2)
662: and nvl(ssl.survey_seniority_code,hr_api.g_varchar2) = nvl(c_survey_seniority_code,hr_api.g_varchar2)
663: and nvl(ssl.company_size_code,hr_api.g_varchar2) = nvl(c_company_size_code,hr_api.g_varchar2)
664: and nvl(ssl.industry_code,hr_api.g_varchar2) = nvl(c_industry_code,hr_api.g_varchar2);
665:
666:

Line 663: and nvl(ssl.company_size_code,hr_api.g_varchar2) = nvl(c_company_size_code,hr_api.g_varchar2)

659: where ssl.start_date between c_date_from and c_date_to
660: and nvl(ssl.survey_job_name_code,hr_api.g_varchar2) = nvl(c_survey_job_name_code,hr_api.g_varchar2)
661: and nvl(ssl.survey_region_code,hr_api.g_varchar2) = nvl(c_survey_region_code,hr_api.g_varchar2)
662: and nvl(ssl.survey_seniority_code,hr_api.g_varchar2) = nvl(c_survey_seniority_code,hr_api.g_varchar2)
663: and nvl(ssl.company_size_code,hr_api.g_varchar2) = nvl(c_company_size_code,hr_api.g_varchar2)
664: and nvl(ssl.industry_code,hr_api.g_varchar2) = nvl(c_industry_code,hr_api.g_varchar2);
665:
666:
667: begin

Line 664: and nvl(ssl.industry_code,hr_api.g_varchar2) = nvl(c_industry_code,hr_api.g_varchar2);

660: and nvl(ssl.survey_job_name_code,hr_api.g_varchar2) = nvl(c_survey_job_name_code,hr_api.g_varchar2)
661: and nvl(ssl.survey_region_code,hr_api.g_varchar2) = nvl(c_survey_region_code,hr_api.g_varchar2)
662: and nvl(ssl.survey_seniority_code,hr_api.g_varchar2) = nvl(c_survey_seniority_code,hr_api.g_varchar2)
663: and nvl(ssl.company_size_code,hr_api.g_varchar2) = nvl(c_company_size_code,hr_api.g_varchar2)
664: and nvl(ssl.industry_code,hr_api.g_varchar2) = nvl(c_industry_code,hr_api.g_varchar2);
665:
666:
667: begin
668: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 690: when hr_api.cannot_find_prog_unit then

686: ,p_job_id => p_job_id
687: ,p_position_id => p_position_id
688: );
689: exception
690: when hr_api.cannot_find_prog_unit then
691: hr_api.cannot_find_prog_unit_error
692: (p_module_name => 'MASS_UPDATE'
693: ,p_hook_type => 'BP'
694: );

Line 691: hr_api.cannot_find_prog_unit_error

687: ,p_position_id => p_position_id
688: );
689: exception
690: when hr_api.cannot_find_prog_unit then
691: hr_api.cannot_find_prog_unit_error
692: (p_module_name => 'MASS_UPDATE'
693: ,p_hook_type => 'BP'
694: );
695: end;

Line 906: when hr_api.cannot_find_prog_unit then

902: ,p_job_id => p_job_id
903: ,p_position_id => p_position_id
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'MASS_UPDATE'
909: ,p_hook_type => 'AP'
910: );

Line 907: hr_api.cannot_find_prog_unit_error

903: ,p_position_id => p_position_id
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'MASS_UPDATE'
909: ,p_hook_type => 'AP'
910: );
911: end;

Line 918: raise hr_api.validate_enabled;

914: --
915: -- When in validation only mode raise the Validate_Enabled exception
916: --
917: if p_validate then
918: raise hr_api.validate_enabled;
919: end if;
920: --
921: -- Set all output arguments
922: --

Line 925: when hr_api.validate_enabled then

921: -- Set all output arguments
922: --
923: hr_utility.set_location(' Leaving:'||l_proc, 520);
924: exception
925: when hr_api.validate_enabled then
926: --
927: -- As the Validate_Enabled exception has been raised
928: -- we must rollback to the savepoint
929: --