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

Line 279: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD','PC');

275: begin
276: hr_utility.set_location('entering '||code||l_proc,10);
277: if code = 'PC' then
278: l_code := get_parent_value(p_worksheet_detail_id,p_worksheet_propagate_code);
279: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD','PC');
280: l_meaning1 := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',l_code);
281: l_meaning := l_meaning||'('||l_meaning1||')' ;
282: elsif code in ('RV','RP','UE') then
283: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',code);

Line 280: l_meaning1 := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',l_code);

276: hr_utility.set_location('entering '||code||l_proc,10);
277: if code = 'PC' then
278: l_code := get_parent_value(p_worksheet_detail_id,p_worksheet_propagate_code);
279: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD','PC');
280: l_meaning1 := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',l_code);
281: l_meaning := l_meaning||'('||l_meaning1||')' ;
282: elsif code in ('RV','RP','UE') then
283: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',code);
284: else

Line 283: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',code);

279: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD','PC');
280: l_meaning1 := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',l_code);
281: l_meaning := l_meaning||'('||l_meaning1||')' ;
282: elsif code in ('RV','RP','UE') then
283: l_meaning := hr_general.decode_lookup('PQH_WORKSHEET_PROPAGATE_METHOD',code);
284: else
285: hr_utility.set_message(8302,'PQH_INVALID_PROPAGATION_METHOD');
286: hr_utility.raise_error;
287: end if;

Line 1107: --and decode(hr_general.get_xbg_profile,'Y', business_group_id , hr_general.get_business_group_id) = business_group_id

1103: and date_from < l_budget_end_date
1104: and (date_to > l_budget_start_date or date_to is null)
1105: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1106: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID))='TRUE'
1107: --and decode(hr_general.get_xbg_profile,'Y', business_group_id , hr_general.get_business_group_id) = business_group_id
1108: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE';
1109: cursor c2 is select w.organization_id_child organization_id
1110: from pqh_worksheet_organizations_v w
1111: where org_structure_version_id = p_org_hier_ver

Line 1121: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id , hr_general.get_business_group_id) = hao.business_group_id)

1117: and date_from < l_budget_end_date
1118: and (date_to > l_budget_start_date or date_to is null)
1119: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1120: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' )
1121: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id , hr_general.get_business_group_id) = hao.business_group_id)
1122: connect by prior organization_id_child = organization_id_parent
1123: and org_structure_version_id = p_org_hier_ver
1124: start with organization_id_parent = p_start_organization_id
1125: and org_structure_version_id = p_org_hier_ver

Line 1135: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id ,

1131: and date_from < l_budget_end_date
1132: and (date_to > l_budget_start_date or date_to is null)
1133: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1134: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' ;
1135: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id ,
1136: -- hr_general.get_business_group_id) = hao.business_group_id;
1137:
1138: l_budget_detail_id number;
1139: l_object_version_number number := 1;

Line 1136: -- hr_general.get_business_group_id) = hao.business_group_id;

1132: and (date_to > l_budget_start_date or date_to is null)
1133: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1134: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' ;
1135: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id ,
1136: -- hr_general.get_business_group_id) = hao.business_group_id;
1137:
1138: l_budget_detail_id number;
1139: l_object_version_number number := 1;
1140: l_rows_inserted number := 0;

Line 1508: l_org_name := hr_general.decode_organization(l_org_id);

1504: fetch c1 into l_worksheet_name,l_org_id;
1505: close c1;
1506: --
1507: if l_org_id is not null then
1508: l_org_name := hr_general.decode_organization(l_org_id);
1509: l_transaction_name := l_worksheet_name||'('||l_org_name||')';
1510: else
1511: l_transaction_name := l_worksheet_name;
1512: end if;