APPS.PQH_WF dependencies on HR_GENERAL

Line 1490: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

1486: else
1487: if l_role_name is not null then
1488: if instr(l_user_name,'POS:') >0 then
1489: -- Position is the owner
1490: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
1491: p_lookup_code => 'POSITION');
1492: elsif instr(l_user_name,'PQH_ROLE:') >0 then
1493: -- PQH role is the owner
1494: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

Line 1494: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

1490: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
1491: p_lookup_code => 'POSITION');
1492: elsif instr(l_user_name,'PQH_ROLE:') >0 then
1493: -- PQH role is the owner
1494: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
1495: p_lookup_code => 'ROLE');
1496: else
1497: -- user is the owner
1498: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

Line 1498: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',

1494: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
1495: p_lookup_code => 'ROLE');
1496: else
1497: -- user is the owner
1498: l_role_prefix := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
1499: p_lookup_code => 'USER');
1500: end if;
1501: l_user_name_display := l_role_prefix||':'||l_role_name;
1502: end if;

Line 1760: l_effective_date := hr_general.get_position_date_end(p_position_id => l_forwarded_to_position_id);

1756: -- user should be asked for immediate rejection.
1757: hr_utility.set_location('requestor different than rejector ', 404);
1758: if l_forwarded_to_position_id is not null then
1759: hr_utility.set_location('is sent to pos', 405);
1760: l_effective_date := hr_general.get_position_date_end(p_position_id => l_forwarded_to_position_id);
1761: hr_utility.set_location('pos effective date is'||to_char(l_effective_date,'ddmmRRRR'), 406);
1762: if (l_effective_date is null or l_effective_date > trunc(sysdate)) then
1763: hr_utility.set_location(l_proc || 'initiator position valid', 41);
1764: l_route_to_user := l_requestor;