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 (
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 (
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 (
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 (
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 (
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 (
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:
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);
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
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;
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:
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
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;
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: