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

Line 218: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);

214: if p_person_id is null then
215: hr_utility.set_location('person does not exist'||l_proc,21);
216: p_role_id := -2;
217: else
218: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);
219: hr_utility.set_location('person_id is'||p_person_id||l_proc,25);
220: hr_utility.set_location('person is'||l_person_name||l_proc,26);
221: if l_member_cd = 'R' then
222: hr_utility.set_location('routing style RL'||l_proc,30);

Line 245: l_position_name := hr_general.decode_position_latest_name(p_position_id =>l_position_id);

241: open c_get_pos_role(p_assignment_id => l_assignment_id);
242: fetch c_get_pos_role into p_role_id;
243: if c_get_pos_role%notfound then
244: hr_utility.set_location('role not attached to POS'||l_proc,52);
245: l_position_name := hr_general.decode_position_latest_name(p_position_id =>l_position_id);
246: hr_utility.set_location('POS name'||l_position_name||l_proc,53);
247: hr_utility.set_message(8302,'PQH_NO_ACTIVE_ROLE_FOR_POS');
248: hr_utility.set_message_token('POSITION',l_position_name);
249: hr_utility.set_message_token('PERSON',l_person_name);

Line 314: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);

310: l_position_name varchar2(240);
311: l_person_name varchar2(240);
312: begin
313: hr_utility.set_location('Entering '||l_proc,10);
314: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);
315: get_primary_asg_details(p_person_id => p_person_id,
316: p_effective_date => p_value_date,
317: p_assignment_id => l_assignment_id,
318: p_position_id => l_position_id);

Line 333: l_effective_date := hr_general.get_position_date_end(p_position_id => l_position_id);

329: hr_utility.set_message(8302,'PQH_PRIMARY_ASG_NOT_POS');
330: hr_utility.set_message_token('PERSON',l_person_name);
331: else
332: hr_utility.set_location('position found '||l_position_id||l_proc,60);
333: l_effective_date := hr_general.get_position_date_end(p_position_id => l_position_id);
334: if (l_effective_date is null or l_effective_date > trunc(sysdate)) then
335: hr_utility.set_location('valid position '||l_proc,61);
336: else
337: l_error_cd := 4;

Line 338: l_position_name := hr_general.decode_position_latest_name(l_position_id);

334: if (l_effective_date is null or l_effective_date > trunc(sysdate)) then
335: hr_utility.set_location('valid position '||l_proc,61);
336: else
337: l_error_cd := 4;
338: l_position_name := hr_general.decode_position_latest_name(l_position_id);
339: hr_utility.set_location('Position Eliminated '||l_proc,62);
340: hr_utility.set_message(8302,'PQH_POS_ELIMINATED');
341: hr_utility.set_message_token('POSITION',l_position_name);
342: end if;

Line 359: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);

355: l_proc varchar2(256) := g_package||'check_user_asg_details';
356: begin
357: hr_utility.set_location('Entering '||l_proc,10);
358: hr_utility.set_location('Value date is '||to_char(p_value_date,'dd/MM/RRRR')||l_proc,22);
359: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);
360: get_primary_asg_details(p_person_id => p_person_id,
361: p_effective_date => p_value_date,
362: p_assignment_id => l_assignment_id,
363: p_position_id => l_position_id);

Line 512: l_person_name := hr_general.decode_person_name(p_person_id =>l_person_id);

508: if nvl(p_routing_history_id,-1) >0 then
509: open c_person_details;
510: fetch c_person_details into l_person_id;
511: close c_person_details;
512: l_person_name := hr_general.decode_person_name(p_person_id =>l_person_id);
513: hr_utility.set_location('person_id is'||l_person_id||l_proc,20);
514: hr_utility.set_location('person_name is'||l_person_name||l_proc,21);
515: select forwarded_to_member_id, forwarded_to_position_id,forwarded_to_assignment_id
516: into l_rht_member_id,l_rht_position_id,l_rht_assignment_id

Line 545: l_position_name := hr_general.decode_position_latest_name(l_position_id);

541: fetch c_position_role into l_role_id;
542: if c_position_role%notfound then
543: hr_utility.set_location('position role notfound '||l_proc,90);
544: close c_position_role;
545: l_position_name := hr_general.decode_position_latest_name(l_position_id);
546: hr_utility.set_message(8302,'PQH_NO_ACTIVE_ROLE_FOR_POS');
547: hr_utility.set_message_token('POSITION',l_position_name);
548: hr_utility.set_message_token('PERSON',l_person_name);
549: else

Line 575: l_position_name := hr_general.decode_position_latest_name(l_rht_position_id);

571: fetch c_position_role into l_role_id;
572: if c_position_role%notfound then
573: hr_utility.set_location('position role notfound'||l_proc,160);
574: close c_position_role;
575: l_position_name := hr_general.decode_position_latest_name(l_rht_position_id);
576: hr_utility.set_message(8302,'PQH_NO_ACTIVE_ROLE_FOR_POS');
577: hr_utility.set_message_token('POSITION',l_position_name);
578: hr_utility.set_message_token('PERSON',l_person_name);
579: else

Line 3728: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);

3724: hr_utility.raise_error;
3725: end if;
3726: else
3727: hr_utility.set_location('employee # is '||to_char(p_person_id)||l_proc,40 );
3728: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);
3729: get_primary_asg_details(p_person_id => p_person_id,
3730: p_effective_date => p_value_date,
3731: p_assignment_id => p_assignment_id,
3732: p_position_id => l_position_id );

Line 3792: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);

3788: hr_utility.raise_error;
3789: end if;
3790: else
3791: hr_utility.set_location('employee # is '||to_char(p_person_id)||l_proc,40 );
3792: l_person_name := hr_general.decode_person_name(p_person_id =>p_person_id);
3793: get_primary_asg_details(p_person_id => p_person_id,
3794: p_effective_date => p_value_date,
3795: p_assignment_id => p_assignment_id,
3796: p_position_id => p_position_id );

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

3807: hr_utility.set_message_token('PERSON',l_person_name);
3808: hr_utility.raise_error;
3809: else
3810: hr_utility.set_location('position found '||p_position_id||l_proc,60);
3811: l_effective_date := hr_general.get_position_date_end(p_position_id => p_position_id);
3812: if (l_effective_date is null or l_effective_date > trunc(sysdate)) then
3813: hr_utility.set_location('valid position '||l_proc,61);
3814: else
3815: hr_utility.set_location('Position Eliminated '||l_proc,62);

Line 3817: l_position := hr_general.decode_position_latest_name(p_position_id);

3813: hr_utility.set_location('valid position '||l_proc,61);
3814: else
3815: hr_utility.set_location('Position Eliminated '||l_proc,62);
3816: hr_utility.set_message(8302,'PQH_POSITION_ELIMINATED');
3817: l_position := hr_general.decode_position_latest_name(p_position_id);
3818: hr_utility.set_message_token('POSITION',l_position);
3819: hr_utility.raise_error;
3820: end if;
3821: end if;

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

4538: hr_utility.set_location('eol set'||l_proc,200);
4539: p_status_flag := 1 ;
4540: else
4541: hr_utility.set_location('position found'||l_proc,210);
4542: l_effective_date := hr_general.get_position_date_end(p_position_id => p_position_id);
4543: if l_effective_date is not null then
4544: if l_effective_date < trunc(sysdate) then
4545: hr_utility.set_location('position eliminated'||l_proc,220);
4546: p_status_flag := 8 ;

Line 4632: and p_date between ppos.date_start and nvl(ppos.actual_termination_date, hr_general.end_of_time) ;

4628: cursor c_emp_term(p_date date) is
4629: select ppos.date_start, ppos.actual_termination_date
4630: from per_periods_of_service ppos
4631: where ppos.person_id = l_person_id
4632: and p_date between ppos.date_start and nvl(ppos.actual_termination_date, hr_general.end_of_time) ;
4633:
4634: cursor c_emp_date_start is
4635: select min(ppos.date_start)
4636: from per_periods_of_service ppos

Line 4724: l_scope_name := hr_general.decode_organization(p_business_group_id);

4720: hr_utility.set_location('txn_cat details pulled '||l_proc,60);
4721: if nvl(l_freeze_status_cd,'NOT_FROZEN') <> 'FREEZE_CATEGORY' then
4722: hr_utility.set_location('txn_cat not frozen'||l_proc,70);
4723: if p_wf_transaction_category_id <> p_glb_transaction_category_id then
4724: l_scope_name := hr_general.decode_organization(p_business_group_id);
4725: else
4726: l_scope_name := hr_general.decode_lookup('PQH_TCT_SCOPE','GLOBAL');
4727: end if;
4728: p_status_flag := 2;

Line 4726: l_scope_name := hr_general.decode_lookup('PQH_TCT_SCOPE','GLOBAL');

4722: hr_utility.set_location('txn_cat not frozen'||l_proc,70);
4723: if p_wf_transaction_category_id <> p_glb_transaction_category_id then
4724: l_scope_name := hr_general.decode_organization(p_business_group_id);
4725: else
4726: l_scope_name := hr_general.decode_lookup('PQH_TCT_SCOPE','GLOBAL');
4727: end if;
4728: p_status_flag := 2;
4729: hr_utility.set_message(8302,'PQH_TXN_CAT_NOT_FROZEN');
4730: hr_utility.set_message_token('TRANSACTION',l_txn_catg_name);