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.PQH_GL_POSTING dependencies on HR_GENERAL

Line 2609: l_position_name := HR_GENERAL.DECODE_POSITION (

2605:
2606:
2607: -- this is budgeted record , display Primary Budgeted Entity
2608: IF NVL(g_budgeted_entity_cd ,'OPEN') = 'POSITION' THEN
2609: l_position_name := HR_GENERAL.DECODE_POSITION (
2610: p_position_id => l_budget_details_rec.position_id);
2611: p_log_context := SUBSTR(l_position_name,1,255);
2612: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'JOB' THEN
2613: l_job_name := HR_GENERAL.DECODE_JOB (

Line 2613: l_job_name := HR_GENERAL.DECODE_JOB (

2609: l_position_name := HR_GENERAL.DECODE_POSITION (
2610: p_position_id => l_budget_details_rec.position_id);
2611: p_log_context := SUBSTR(l_position_name,1,255);
2612: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'JOB' THEN
2613: l_job_name := HR_GENERAL.DECODE_JOB (
2614: p_job_id => l_budget_details_rec.job_id);
2615: p_log_context := SUBSTR(l_job_name,1,255);
2616: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'ORGANIZATION' THEN
2617: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (

Line 2617: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (

2613: l_job_name := HR_GENERAL.DECODE_JOB (
2614: p_job_id => l_budget_details_rec.job_id);
2615: p_log_context := SUBSTR(l_job_name,1,255);
2616: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'ORGANIZATION' THEN
2617: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (
2618: p_organization_id => l_budget_details_rec.organization_id);
2619: p_log_context := SUBSTR(l_organization_name,1,255);
2620: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'GRADE' THEN
2621: l_grade_name := HR_GENERAL.DECODE_GRADE (

Line 2621: l_grade_name := HR_GENERAL.DECODE_GRADE (

2617: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (
2618: p_organization_id => l_budget_details_rec.organization_id);
2619: p_log_context := SUBSTR(l_organization_name,1,255);
2620: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'GRADE' THEN
2621: l_grade_name := HR_GENERAL.DECODE_GRADE (
2622: p_grade_id => l_budget_details_rec.grade_id);
2623: p_log_context := SUBSTR(l_grade_name,1,255);
2624: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'OPEN' THEN
2625: l_position_name := HR_GENERAL.DECODE_POSITION (

Line 2625: l_position_name := HR_GENERAL.DECODE_POSITION (

2621: l_grade_name := HR_GENERAL.DECODE_GRADE (
2622: p_grade_id => l_budget_details_rec.grade_id);
2623: p_log_context := SUBSTR(l_grade_name,1,255);
2624: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'OPEN' THEN
2625: l_position_name := HR_GENERAL.DECODE_POSITION (
2626: p_position_id => l_budget_details_rec.position_id);
2627: l_job_name := HR_GENERAL.DECODE_JOB (
2628: p_job_id => l_budget_details_rec.job_id);
2629: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (

Line 2627: l_job_name := HR_GENERAL.DECODE_JOB (

2623: p_log_context := SUBSTR(l_grade_name,1,255);
2624: ELSIF NVL(g_budgeted_entity_cd ,'OPEN') = 'OPEN' THEN
2625: l_position_name := HR_GENERAL.DECODE_POSITION (
2626: p_position_id => l_budget_details_rec.position_id);
2627: l_job_name := HR_GENERAL.DECODE_JOB (
2628: p_job_id => l_budget_details_rec.job_id);
2629: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (
2630: p_organization_id => l_budget_details_rec.organization_id);
2631: l_grade_name := HR_GENERAL.DECODE_GRADE (

Line 2629: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (

2625: l_position_name := HR_GENERAL.DECODE_POSITION (
2626: p_position_id => l_budget_details_rec.position_id);
2627: l_job_name := HR_GENERAL.DECODE_JOB (
2628: p_job_id => l_budget_details_rec.job_id);
2629: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (
2630: p_organization_id => l_budget_details_rec.organization_id);
2631: l_grade_name := HR_GENERAL.DECODE_GRADE (
2632: p_grade_id => l_budget_details_rec.grade_id);
2633:

Line 2631: l_grade_name := HR_GENERAL.DECODE_GRADE (

2627: l_job_name := HR_GENERAL.DECODE_JOB (
2628: p_job_id => l_budget_details_rec.job_id);
2629: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (
2630: p_organization_id => l_budget_details_rec.organization_id);
2631: l_grade_name := HR_GENERAL.DECODE_GRADE (
2632: p_grade_id => l_budget_details_rec.grade_id);
2633:
2634: IF l_position_name IS NOT NULL THEN
2635: p_log_context := SUBSTR(l_position_name,1,255);

Line 4573: hr_general.decode_shared_type(budget_unit1_id) UOM1,

4569: time_period_id = p_time_period_id;
4570:
4571: Cursor csr_budget_units IS
4572: Select
4573: hr_general.decode_shared_type(budget_unit1_id) UOM1,
4574: hr_general.decode_shared_type(budget_unit2_id) UOM2,
4575: hr_general.decode_shared_type(budget_unit3_id) UOM3
4576: From
4577: pqh_budgets

Line 4574: hr_general.decode_shared_type(budget_unit2_id) UOM2,

4570:
4571: Cursor csr_budget_units IS
4572: Select
4573: hr_general.decode_shared_type(budget_unit1_id) UOM1,
4574: hr_general.decode_shared_type(budget_unit2_id) UOM2,
4575: hr_general.decode_shared_type(budget_unit3_id) UOM3
4576: From
4577: pqh_budgets
4578: Where budget_id=g_budget_id;

Line 4575: hr_general.decode_shared_type(budget_unit3_id) UOM3

4571: Cursor csr_budget_units IS
4572: Select
4573: hr_general.decode_shared_type(budget_unit1_id) UOM1,
4574: hr_general.decode_shared_type(budget_unit2_id) UOM2,
4575: hr_general.decode_shared_type(budget_unit3_id) UOM3
4576: From
4577: pqh_budgets
4578: Where budget_id=g_budget_id;
4579:

Line 5078: hr_general.decode_shared_type(budget_unit1_id) UOM1,

5074:
5075:
5076: Cursor csr_budget_units IS
5077: Select
5078: hr_general.decode_shared_type(budget_unit1_id) UOM1,
5079: hr_general.decode_shared_type(budget_unit2_id) UOM2,
5080: hr_general.decode_shared_type(budget_unit3_id) UOM3
5081: From
5082: pqh_budgets

Line 5079: hr_general.decode_shared_type(budget_unit2_id) UOM2,

5075:
5076: Cursor csr_budget_units IS
5077: Select
5078: hr_general.decode_shared_type(budget_unit1_id) UOM1,
5079: hr_general.decode_shared_type(budget_unit2_id) UOM2,
5080: hr_general.decode_shared_type(budget_unit3_id) UOM3
5081: From
5082: pqh_budgets
5083: Where budget_id=g_budget_id;

Line 5080: hr_general.decode_shared_type(budget_unit3_id) UOM3

5076: Cursor csr_budget_units IS
5077: Select
5078: hr_general.decode_shared_type(budget_unit1_id) UOM1,
5079: hr_general.decode_shared_type(budget_unit2_id) UOM2,
5080: hr_general.decode_shared_type(budget_unit3_id) UOM3
5081: From
5082: pqh_budgets
5083: Where budget_id=g_budget_id;
5084: