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_APPLY_BUDGET dependencies on HR_GENERAL

Line 2081: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);

2077: FETCH csr_wks_detail_rec INTO l_worksheet_details_rec;
2078: CLOSE csr_wks_detail_rec;
2079:
2080:
2081: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);
2082: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);
2083: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);
2084: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);
2085:

Line 2082: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);

2078: CLOSE csr_wks_detail_rec;
2079:
2080:
2081: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);
2082: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);
2083: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);
2084: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);
2085:
2086: IF NVL(l_worksheet_details_rec.action_cd , 'R') = 'R' THEN

Line 2083: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);

2079:
2080:
2081: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);
2082: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);
2083: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);
2084: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);
2085:
2086: IF NVL(l_worksheet_details_rec.action_cd , 'R') = 'R' THEN
2087: -- this is the main parent record , display Organization Name

Line 2084: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);

2080:
2081: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);
2082: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);
2083: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);
2084: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);
2085:
2086: IF NVL(l_worksheet_details_rec.action_cd , 'R') = 'R' THEN
2087: -- this is the main parent record , display Organization Name
2088: p_log_context := SUBSTR(l_organization_name,1,255);

Line 3122: p_budget_style := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_STYLE',

3118: fetch c4 into p_organization_name;
3119: close c4;
3120: hr_utility.set_location('organization fetched'||l_proc,60);
3121: end if;
3122: p_budget_style := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_STYLE',
3123: p_lookup_code => l_budget_style_cd);
3124: p_budget_entity := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_ENTITY',
3125: p_lookup_code => l_budget_entity_cd);
3126: p_worksheet_mode := hr_general.decode_lookup(p_lookup_type =>'PQH_WORKSHEET_MODE' ,

Line 3124: p_budget_entity := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_ENTITY',

3120: hr_utility.set_location('organization fetched'||l_proc,60);
3121: end if;
3122: p_budget_style := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_STYLE',
3123: p_lookup_code => l_budget_style_cd);
3124: p_budget_entity := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_ENTITY',
3125: p_lookup_code => l_budget_entity_cd);
3126: p_worksheet_mode := hr_general.decode_lookup(p_lookup_type =>'PQH_WORKSHEET_MODE' ,
3127: p_lookup_code =>l_worksheet_mode_cd );
3128: exception

Line 3126: p_worksheet_mode := hr_general.decode_lookup(p_lookup_type =>'PQH_WORKSHEET_MODE' ,

3122: p_budget_style := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_STYLE',
3123: p_lookup_code => l_budget_style_cd);
3124: p_budget_entity := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_ENTITY',
3125: p_lookup_code => l_budget_entity_cd);
3126: p_worksheet_mode := hr_general.decode_lookup(p_lookup_type =>'PQH_WORKSHEET_MODE' ,
3127: p_lookup_code =>l_worksheet_mode_cd );
3128: exception
3129: when others then
3130: p_worksheet_name := null;