APPS.PA_OTC_API dependencies on PA_TASKS

Line 1554: l_Task_Id Pa_Tasks.Task_Id%TYPE;

1550: l_Exp_End_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE;
1551: l_Inc_By_Org_Id Hr_Organization_Units.Organization_Id%TYPE;
1552: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;
1553: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
1554: l_Task_Id Pa_Tasks.Task_Id%TYPE;
1555: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
1556: l_Sys_Link Pa_Expenditure_Items_All.System_Linkage_Function%TYPE;
1557: l_Quantity Pa_Expenditure_Items_All.Quantity%TYPE;
1558: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;

Line 1677: --Pa_Tasks T

1673: Pa_Expenditure_Items EI,
1674: Pa_Expenditure_Comments EC,
1675: Pa_Expenditures E
1676: -- 3457943 S.N.
1677: --Pa_Tasks T
1678: -- 3457943 E.N.
1679: Where
1680: -- 3457943 S.N.
1681: --T.Task_Id = EI.Task_Id

Line 5699: -- P_Task_Id - Pa_Tasks.Task_Id%TYPE

5695: -- exists in the online view, X_task_Id will be populated
5696: -- with task_id, else X_task_id will be null.
5697: -- Parameters :
5698: -- IN
5699: -- P_Task_Id - Pa_Tasks.Task_Id%TYPE
5700: -- P_Project_Id - Pa_Projects.Project_Id%TYPE
5701: -- OUT
5702: -- X_Error_Code - Varchar2
5703: -- X_Error_Type - Varchar2

Line 5704: -- X_Task_Number - Pa_Tasks.Task_Number%TYPE

5700: -- P_Project_Id - Pa_Projects.Project_Id%TYPE
5701: -- OUT
5702: -- X_Error_Code - Varchar2
5703: -- X_Error_Type - Varchar2
5704: -- X_Task_Number - Pa_Tasks.Task_Number%TYPE
5705: /*-------------------------------------------------------------------------*/
5706:
5707: Procedure Validate_Task_Exists(
5708: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,

Line 5708: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,

5704: -- X_Task_Number - Pa_Tasks.Task_Number%TYPE
5705: /*-------------------------------------------------------------------------*/
5706:
5707: Procedure Validate_Task_Exists(
5708: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,
5709: P_Project_Id IN Pa_Projects.Project_Id%TYPE,
5710: X_Error_Code OUT NOCOPY Varchar2,
5711: X_Error_Type OUT NOCOPY Varchar2,
5712: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)

Line 5712: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)

5708: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,
5709: P_Project_Id IN Pa_Projects.Project_Id%TYPE,
5710: X_Error_Code OUT NOCOPY Varchar2,
5711: X_Error_Type OUT NOCOPY Varchar2,
5712: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)
5713: Is
5714:
5715: l_Task_Num Pa_Tasks.Task_Number%TYPE := Null;
5716: l_Task_Name Pa_Tasks.Task_Name%TYPE := Null;

Line 5715: l_Task_Num Pa_Tasks.Task_Number%TYPE := Null;

5711: X_Error_Type OUT NOCOPY Varchar2,
5712: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)
5713: Is
5714:
5715: l_Task_Num Pa_Tasks.Task_Number%TYPE := Null;
5716: l_Task_Name Pa_Tasks.Task_Name%TYPE := Null;
5717:
5718: /* begin bug 4766396
5719: Cursor Validate_ProjTask_Combo(P_Prj_Id IN Number,

Line 5716: l_Task_Name Pa_Tasks.Task_Name%TYPE := Null;

5712: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)
5713: Is
5714:
5715: l_Task_Num Pa_Tasks.Task_Number%TYPE := Null;
5716: l_Task_Name Pa_Tasks.Task_Name%TYPE := Null;
5717:
5718: /* begin bug 4766396
5719: Cursor Validate_ProjTask_Combo(P_Prj_Id IN Number,
5720: P_Tsk_Id IN Number) Is

Line 5734: pa_tasks t

5730: P_Tsk_Id IN NUMBER) is
5731: select
5732: t.task_number
5733: from pa_online_tasks_v tt,
5734: pa_tasks t
5735: where
5736: tt.task_id = P_Tsk_Id
5737: and tt.project_id = P_Prj_Id
5738: and t.task_id = tt.task_id;