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 1112: --and decode(hr_general.get_xbg_profile,'Y', business_group_id , hr_general.get_business_group_id) = business_group_id

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

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

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

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

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

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

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

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

1509: fetch c1 into l_worksheet_name,l_org_id;
1510: close c1;
1511: --
1512: if l_org_id is not null then
1513: l_org_name := hr_general.decode_organization(l_org_id);
1514: l_transaction_name := l_worksheet_name||'('||l_org_name||')';
1515: else
1516: l_transaction_name := l_worksheet_name;
1517: end if;