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.PA_TASK_MANAGER dependencies on PA_PROJECTS_ALL

Line 738: from pa_projects_all p

734: p_project_type IN VARCHAR2) IS
735:
736: CURSOR c_selprojs IS
737: select p.project_id
738: from pa_projects_all p
739: where p.segment1 between p_project_num_from and p_project_num_to
740: and p.carrying_out_organization_id = nvl(p_project_org, p.carrying_out_organization_id)
741: and p.project_type = nvl(p_project_type, p.project_type);
742:

Line 982: l_proj_num pa_projects_all.segment1%TYPE;

978:
979: procedure tm_out ( p_project_id IN NUMBER,
980: p_task_manager_person_id IN NUMBER,
981: p_message IN VARCHAR2) IS
982: l_proj_num pa_projects_all.segment1%TYPE;
983: l_emp_name pa_employees_res_v.employee_name%TYPE;
984: len_msg NUMBER;
985: l_count_msg NUMBER;
986: x NUMBER;

Line 992: from pa_projects_all

988:
989: begin
990: select segment1
991: into l_proj_num
992: from pa_projects_all
993: where project_id = p_project_id;
994:
995: select employee_name
996: into l_emp_name