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.

[Home] [Help]

APPS.HR_BIS_ALERTS dependencies on HR_LOOKUPS

Line 89: -- ,budget_measurement_type hr_lookups.lookup_code%TYPE

85: ,notify_resp3_id fnd_responsibility.responsibility_id%TYPE
86: ,notify_resp3_appl_id fnd_responsibility.application_id%TYPE
87: ,notify_resp3_short_name bisfv_targets.notify_resp3_short_name%TYPE
88: ,notify_resp3_name bisfv_targets.notify_resp3_name%TYPE
89: -- ,budget_measurement_type hr_lookups.lookup_code%TYPE
90: ,period_start_DATE DATE
91: ,period_end_DATE DATE);
92:
93: --**********************************************************************

Line 344: FROM hr_lookups

340: CURSOR bmt_cur
341: (p_c_bmt IN VARCHAR2)
342: IS
343: SELECT lookup_code
344: FROM hr_lookups
345: WHERE lookup_type = 'BUDGET_MEASUREMENT_TYPE'
346: AND lookup_code = p_c_bmt;
347:
348: -- Cursor to obtain fnd_responsibility_id

Line 761: l_text hr_lookups.meaning%TYPE;

757: -------------------------------------------------------------------------
758:
759: FUNCTION translate_orgprc(p_orgprc IN VARCHAR2) RETURN VARCHAR2 IS
760:
761: l_text hr_lookups.meaning%TYPE;
762:
763: BEGIN
764: IF p_orgprc = 'SINR' THEN
765: l_text := Hr_General.Decode_Lookup('YES_NO','N');

Line 1291: l_bmt_name hr_lookups.meaning%TYPE;

1287: ,p_actual IN NUMBER
1288: ,p_target_rec IN hri_target_rec_type)
1289: IS
1290:
1291: l_bmt_name hr_lookups.meaning%TYPE;
1292: l_dummy VARCHAR2(2000);
1293: l_freq_code VARCHAR2(4);
1294: l_subject fnd_new_messages.message_text%TYPE;
1295: l_message VARCHAR2(2000);

Line 1748: l_org_type hr_lookups.meaning%TYPE;

1744: l_param VARCHAR2(2000);
1745:
1746: -- Dimension Params
1747: l_org_name per_organization_units.name%TYPE;
1748: l_org_type hr_lookups.meaning%TYPE;
1749: l_orgprc hr_lookups.meaning%TYPE;
1750: l_bmt_name hr_lookups.meaning%TYPE;
1751: l_job_name per_jobs.name%TYPE;
1752: l_job_cat hr_lookups.meaning%TYPE;

Line 1749: l_orgprc hr_lookups.meaning%TYPE;

1745:
1746: -- Dimension Params
1747: l_org_name per_organization_units.name%TYPE;
1748: l_org_type hr_lookups.meaning%TYPE;
1749: l_orgprc hr_lookups.meaning%TYPE;
1750: l_bmt_name hr_lookups.meaning%TYPE;
1751: l_job_name per_jobs.name%TYPE;
1752: l_job_cat hr_lookups.meaning%TYPE;
1753: l_loc_name hr_locations.location_code%TYPE;

Line 1750: l_bmt_name hr_lookups.meaning%TYPE;

1746: -- Dimension Params
1747: l_org_name per_organization_units.name%TYPE;
1748: l_org_type hr_lookups.meaning%TYPE;
1749: l_orgprc hr_lookups.meaning%TYPE;
1750: l_bmt_name hr_lookups.meaning%TYPE;
1751: l_job_name per_jobs.name%TYPE;
1752: l_job_cat hr_lookups.meaning%TYPE;
1753: l_loc_name hr_locations.location_code%TYPE;
1754:

Line 1752: l_job_cat hr_lookups.meaning%TYPE;

1748: l_org_type hr_lookups.meaning%TYPE;
1749: l_orgprc hr_lookups.meaning%TYPE;
1750: l_bmt_name hr_lookups.meaning%TYPE;
1751: l_job_name per_jobs.name%TYPE;
1752: l_job_cat hr_lookups.meaning%TYPE;
1753: l_loc_name hr_locations.location_code%TYPE;
1754:
1755: l_period_name VARCHAR2(50);
1756:

Line 2393: l_org_type hr_lookups.meaning%TYPE;

2389: l_actual VARCHAR2(30);
2390: l_target VARCHAR2(30);
2391:
2392: l_org_name per_organization_units.name%TYPE;
2393: l_org_type hr_lookups.meaning%TYPE;
2394: l_orgprc hr_lookups.meaning%TYPE;
2395: l_bmt_name hr_lookups.meaning%TYPE;
2396: l_job_name per_jobs.name%TYPE;
2397: l_job_cat hr_lookups.meaning%TYPE := '';

Line 2394: l_orgprc hr_lookups.meaning%TYPE;

2390: l_target VARCHAR2(30);
2391:
2392: l_org_name per_organization_units.name%TYPE;
2393: l_org_type hr_lookups.meaning%TYPE;
2394: l_orgprc hr_lookups.meaning%TYPE;
2395: l_bmt_name hr_lookups.meaning%TYPE;
2396: l_job_name per_jobs.name%TYPE;
2397: l_job_cat hr_lookups.meaning%TYPE := '';
2398: l_loc_name hr_locations.location_code%TYPE;

Line 2395: l_bmt_name hr_lookups.meaning%TYPE;

2391:
2392: l_org_name per_organization_units.name%TYPE;
2393: l_org_type hr_lookups.meaning%TYPE;
2394: l_orgprc hr_lookups.meaning%TYPE;
2395: l_bmt_name hr_lookups.meaning%TYPE;
2396: l_job_name per_jobs.name%TYPE;
2397: l_job_cat hr_lookups.meaning%TYPE := '';
2398: l_loc_name hr_locations.location_code%TYPE;
2399:

Line 2397: l_job_cat hr_lookups.meaning%TYPE := '';

2393: l_org_type hr_lookups.meaning%TYPE;
2394: l_orgprc hr_lookups.meaning%TYPE;
2395: l_bmt_name hr_lookups.meaning%TYPE;
2396: l_job_name per_jobs.name%TYPE;
2397: l_job_cat hr_lookups.meaning%TYPE := '';
2398: l_loc_name hr_locations.location_code%TYPE;
2399:
2400: l_period_name VARCHAR2(50);
2401:

Line 2898: l_job_cat hr_lookups.meaning%TYPE; -- Job category

2894: l_report_name VARCHAR2(8) := 'HRTRNSUC';
2895:
2896: l_activity_version_name ota_activity_versions.version_name%TYPE; -- name of training course (activity version)
2897: l_actual VARCHAR2(80); -- Actual value (e.g. 25%)
2898: l_job_cat hr_lookups.meaning%TYPE; -- Job category
2899: l_job_name per_jobs.name%TYPE; -- Job name
2900: l_loc_name hr_locations.location_code%TYPE; -- Location name
2901: l_org_name per_organization_units.name%TYPE; -- Organization name
2902: l_org_type hr_lookups.meaning%TYPE; --

Line 2902: l_org_type hr_lookups.meaning%TYPE; --

2898: l_job_cat hr_lookups.meaning%TYPE; -- Job category
2899: l_job_name per_jobs.name%TYPE; -- Job name
2900: l_loc_name hr_locations.location_code%TYPE; -- Location name
2901: l_org_name per_organization_units.name%TYPE; -- Organization name
2902: l_org_type hr_lookups.meaning%TYPE; --
2903: l_orgprc hr_lookups.meaning%TYPE; -- include subordinate indicator (yes/no)
2904: l_target VARCHAR2(80); -- Target value (e.g. 75%)
2905: l_period_name VARCHAR2(50);
2906:

Line 2903: l_orgprc hr_lookups.meaning%TYPE; -- include subordinate indicator (yes/no)

2899: l_job_name per_jobs.name%TYPE; -- Job name
2900: l_loc_name hr_locations.location_code%TYPE; -- Location name
2901: l_org_name per_organization_units.name%TYPE; -- Organization name
2902: l_org_type hr_lookups.meaning%TYPE; --
2903: l_orgprc hr_lookups.meaning%TYPE; -- include subordinate indicator (yes/no)
2904: l_target VARCHAR2(80); -- Target value (e.g. 75%)
2905: l_period_name VARCHAR2(50);
2906:
2907: -- Session params