DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_POSTING dependencies on HR_GENERAL

Line 3133: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_budget_details_rec.position_id);

3129: OPEN csr_bdt_detail_rec;
3130: FETCH csr_bdt_detail_rec INTO l_budget_details_rec;
3131: CLOSE csr_bdt_detail_rec;
3132: --
3133: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_budget_details_rec.position_id);
3134: --
3135: hr_utility.set_location('Position :'||l_position_name, 8);
3136: --
3137: p_log_context := SUBSTR(l_position_name,1,255);

Line 4181: hr_general.decode_shared_type(budget_unit1_id) UOM1,

4177:
4178:
4179: Cursor csr_budget_units IS
4180: Select
4181: hr_general.decode_shared_type(budget_unit1_id) UOM1,
4182: hr_general.decode_shared_type(budget_unit2_id) UOM2,
4183: hr_general.decode_shared_type(budget_unit3_id) UOM3
4184: From
4185: pqh_budgets

Line 4182: hr_general.decode_shared_type(budget_unit2_id) UOM2,

4178:
4179: Cursor csr_budget_units IS
4180: Select
4181: hr_general.decode_shared_type(budget_unit1_id) UOM1,
4182: hr_general.decode_shared_type(budget_unit2_id) UOM2,
4183: hr_general.decode_shared_type(budget_unit3_id) UOM3
4184: From
4185: pqh_budgets
4186: Where budget_id=g_budget_id;

Line 4183: hr_general.decode_shared_type(budget_unit3_id) UOM3

4179: Cursor csr_budget_units IS
4180: Select
4181: hr_general.decode_shared_type(budget_unit1_id) UOM1,
4182: hr_general.decode_shared_type(budget_unit2_id) UOM2,
4183: hr_general.decode_shared_type(budget_unit3_id) UOM3
4184: From
4185: pqh_budgets
4186: Where budget_id=g_budget_id;
4187: