DBA Data[Home] [Help]

APPS.HR_BIS_ALERTS dependencies on HR_REPORTS

Line 734: RETURN hr_reports.get_job(p_job_id);

730: BEGIN
731: IF p_job_id = -1 THEN
732: RETURN translate_all;
733: ELSE
734: RETURN hr_reports.get_job(p_job_id);
735: END IF;
736: END;
737:
738:

Line 750: RETURN hr_reports.get_lookup_meaning('JOB_CATEGORIES',p_jobcat_id);

746: BEGIN
747: IF p_jobcat_id = '-1' THEN
748: RETURN translate_all;
749: ELSE
750: RETURN hr_reports.get_lookup_meaning('JOB_CATEGORIES',p_jobcat_id);
751: END IF;
752: END;
753:
754:

Line 1354: hr_reports.get_organization(p_target_rec.org_level_value_id

1350: -- ---------------------------------------------------------------------
1351: --
1352: -- Organization
1353: --
1354: hr_reports.get_organization(p_target_rec.org_level_value_id
1355: ,l_org_name
1356: ,l_dummy);
1357: pl(' org name : ',l_org_name);
1358: --

Line 1362: l_bmt_name := hr_reports.get_lookup_meaning('BUDGET_MEASUREMENT_TYPE'

1358: --
1359: -- Budget Name
1360: --
1361: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
1362: l_bmt_name := hr_reports.get_lookup_meaning('BUDGET_MEASUREMENT_TYPE'
1363: ,p_target_rec.unit_of_measure);
1364: pl(' bmt name : ',l_bmt_name);
1365: --
1366: -- Period Name

Line 1809: hr_reports.get_organization(p_target_rec.org_level_value_id,l_org_name,l_org_type);

1805: -- ---------------------------------------------------------------------
1806: --
1807: -- Organization
1808: --
1809: hr_reports.get_organization(p_target_rec.org_level_value_id,l_org_name,l_org_type);
1810: l_orgprc := translate_orgprc(g_orgprc_const);
1811: pl(' org name: ',l_org_name);
1812: --
1813: -- Location

Line 1835: l_bmt_name := hr_reports.get_lookup_meaning

1831: pl(' job category name: ',l_job_cat);
1832: --
1833: -- Budget
1834: --
1835: l_bmt_name := hr_reports.get_lookup_meaning
1836: ('BUDGET_MEASUREMENT_TYPE',p_target_rec.unit_of_measure);
1837: pl(' bmt name: ',l_bmt_name);
1838: --
1839: -- Period

Line 2451: hr_reports.get_organization(p_target_rec.org_level_value_id,l_org_name,l_org_type);

2447: -- ---------------------------------------------------------------------
2448: --
2449: -- Organization
2450: --
2451: hr_reports.get_organization(p_target_rec.org_level_value_id,l_org_name,l_org_type);
2452: l_orgprc := translate_orgprc(g_orgprc_const);
2453: pl(' org name: ',l_org_name);
2454: --
2455: -- Location

Line 2478: l_bmt_name := hr_reports.get_lookup_meaning('BUDGET_MEASUREMENT_TYPE'

2474: --
2475: -- Budget Name
2476: --
2477: -- Bug 2530846 replacing use of budget_measurement_type with Unit_of_measure
2478: l_bmt_name := hr_reports.get_lookup_meaning('BUDGET_MEASUREMENT_TYPE'
2479: ,p_target_rec.unit_of_measure);
2480: pl(' bmt name: ',l_bmt_name);
2481: --
2482: -- Period Name

Line 2956: hr_reports.get_organization(p_target_rec.org_level_value_id,l_org_name,l_dummy);

2952: -- ---------------------------------------------------------------------
2953: --
2954: -- Organization
2955: --
2956: hr_reports.get_organization(p_target_rec.org_level_value_id,l_org_name,l_dummy);
2957: l_orgprc := translate_orgprc(g_orgprc_const);
2958: pl(' org name: ',l_org_name);
2959: --
2960: -- Location

Line 2968: l_job_name := hr_reports.get_job(p_target_rec.dim2_level_value_id);

2964: --
2965: -- Job / Job Category
2966: --
2967: IF p_target_rec.dim2_level_short_name = 'JOB' THEN
2968: l_job_name := hr_reports.get_job(p_target_rec.dim2_level_value_id);
2969: l_job_cat := translate_all;
2970: ELSIF p_target_rec.dim2_level_short_name = 'JOB CATEGORY' THEN
2971: l_job_name := translate_all;
2972: l_job_cat := hr_reports.get_lookup_meaning('JOB_CATEGORIES',p_target_rec.dim2_level_value_id);

Line 2972: l_job_cat := hr_reports.get_lookup_meaning('JOB_CATEGORIES',p_target_rec.dim2_level_value_id);

2968: l_job_name := hr_reports.get_job(p_target_rec.dim2_level_value_id);
2969: l_job_cat := translate_all;
2970: ELSIF p_target_rec.dim2_level_short_name = 'JOB CATEGORY' THEN
2971: l_job_name := translate_all;
2972: l_job_cat := hr_reports.get_lookup_meaning('JOB_CATEGORIES',p_target_rec.dim2_level_value_id);
2973: ELSIF p_target_rec.dim2_level_short_name = 'TOTAL JOBS' THEN
2974: l_job_name := translate_all;
2975: l_job_cat := translate_all;
2976: END IF;