DBA Data[Home] [Help]

APPS.PQH_BUDGET_DATA_MIGRATION dependencies on HR_GENERAL

Line 1331: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_budget_elements_rec.position_id);

1327: FETCH csr_bdg_elmnt_rec INTO l_budget_elements_rec;
1328: CLOSE csr_bdg_elmnt_rec;
1329:
1330:
1331: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_budget_elements_rec.position_id);
1332: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_budget_elements_rec.job_id);
1333: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_budget_elements_rec.organization_id);
1334: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_budget_elements_rec.grade_id);
1335:

Line 1332: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_budget_elements_rec.job_id);

1328: CLOSE csr_bdg_elmnt_rec;
1329:
1330:
1331: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_budget_elements_rec.position_id);
1332: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_budget_elements_rec.job_id);
1333: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_budget_elements_rec.organization_id);
1334: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_budget_elements_rec.grade_id);
1335:
1336:

Line 1333: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_budget_elements_rec.organization_id);

1329:
1330:
1331: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_budget_elements_rec.position_id);
1332: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_budget_elements_rec.job_id);
1333: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_budget_elements_rec.organization_id);
1334: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_budget_elements_rec.grade_id);
1335:
1336:
1337: IF l_position_name IS NOT NULL THEN

Line 1334: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_budget_elements_rec.grade_id);

1330:
1331: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_budget_elements_rec.position_id);
1332: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_budget_elements_rec.job_id);
1333: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_budget_elements_rec.organization_id);
1334: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_budget_elements_rec.grade_id);
1335:
1336:
1337: IF l_position_name IS NOT NULL THEN
1338: p_log_context := SUBSTR(l_position_name,1,255);