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_UTILS3 dependencies on PA_TASKS

Line 146: Pa_Tasks

142: Task_Number
143: Into
144: X_Task_Number
145: From
146: Pa_Tasks
147: Where
148: Task_Id = P_Task_Id;
149:
150: -- Add the task number to the pl/sql table using the task_id

Line 405: Function GetCachedTaskNum (P_Task_Id IN NUMBER) RETURN pa_tasks.task_number%TYPE

401: return l_Project_Number;
402:
403: End GetCachedProjNum;
404:
405: Function GetCachedTaskNum (P_Task_Id IN NUMBER) RETURN pa_tasks.task_number%TYPE
406: Is
407: l_Task_Number pa_tasks.task_number%TYPE;
408: Begin
409:

Line 407: l_Task_Number pa_tasks.task_number%TYPE;

403: End GetCachedProjNum;
404:
405: Function GetCachedTaskNum (P_Task_Id IN NUMBER) RETURN pa_tasks.task_number%TYPE
406: Is
407: l_Task_Number pa_tasks.task_number%TYPE;
408: Begin
409:
410: If P_Task_Id > 0 THEN
411: GetCachedTaskNum(P_Task_Id => P_Task_Id,

Line 457: ,pa_tasks task

453: SELECT proj.segment1||'/'||TASK.task_number
454: INTO l_proj_task_info
455: FROM pa_expenditure_items ei
456: ,pa_projects_all proj
457: ,pa_tasks task
458: WHERE ei.expenditure_item_id = P_Transferred_from_exp_id
459: AND ei.task_id = task.task_id
460: AND proj.project_id = task.project_id;
461: EXCEPTION

Line 472: ,pa_tasks task

468: SELECT proj.segment1||'/'||TASK.task_number
469: INTO l_proj_task_info
470: FROM pa_expenditure_items ei
471: ,pa_projects_all proj
472: ,pa_tasks task
473: WHERE ei.transferred_from_exp_item_id = P_exp_item_id
474: AND ei.task_id = task.task_id
475: AND proj.project_id = task.project_id;
476: EXCEPTION