APPS.PA_OTC_API dependencies on PA_TASKS

Line 1584: l_Task_Id Pa_Tasks.Task_Id%TYPE;

1580: l_Exp_End_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE;
1581: l_Inc_By_Org_Id Hr_Organization_Units.Organization_Id%TYPE;
1582: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;
1583: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
1584: l_Task_Id Pa_Tasks.Task_Id%TYPE;
1585: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
1586: l_Sys_Link Pa_Expenditure_Items_All.System_Linkage_Function%TYPE;
1587: l_Quantity Pa_Expenditure_Items_All.Quantity%TYPE;
1588: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;

Line 1725: --Pa_Tasks T

1721: Pa_Expenditure_Items EI,
1722: Pa_Expenditure_Comments PEC,
1723: Pa_Expenditures E
1724: -- 3457943 S.N.
1725: --Pa_Tasks T
1726: -- 3457943 E.N.
1727: Where
1728: -- 3457943 S.N.
1729: --T.Task_Id = EI.Task_Id

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

6162: -- exists in the online view, X_task_Id will be populated
6163: -- with task_id, else X_task_id will be null.
6164: -- Parameters :
6165: -- IN
6166: -- P_Task_Id - Pa_Tasks.Task_Id%TYPE
6167: -- P_Project_Id - Pa_Projects.Project_Id%TYPE
6168: -- OUT
6169: -- X_Error_Code - Varchar2
6170: -- X_Error_Type - Varchar2

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

6167: -- P_Project_Id - Pa_Projects.Project_Id%TYPE
6168: -- OUT
6169: -- X_Error_Code - Varchar2
6170: -- X_Error_Type - Varchar2
6171: -- X_Task_Number - Pa_Tasks.Task_Number%TYPE
6172: /*-------------------------------------------------------------------------*/
6173:
6174: Procedure Validate_Task_Exists(
6175: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,

Line 6175: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,

6171: -- X_Task_Number - Pa_Tasks.Task_Number%TYPE
6172: /*-------------------------------------------------------------------------*/
6173:
6174: Procedure Validate_Task_Exists(
6175: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,
6176: P_Project_Id IN Pa_Projects.Project_Id%TYPE,
6177: X_Error_Code OUT NOCOPY Varchar2,
6178: X_Error_Type OUT NOCOPY Varchar2,
6179: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)

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

6175: P_Task_Id IN Pa_Tasks.Task_Id%TYPE,
6176: P_Project_Id IN Pa_Projects.Project_Id%TYPE,
6177: X_Error_Code OUT NOCOPY Varchar2,
6178: X_Error_Type OUT NOCOPY Varchar2,
6179: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)
6180: Is
6181:
6182: l_Task_Num Pa_Tasks.Task_Number%TYPE := Null;
6183: l_Task_Name Pa_Tasks.Task_Name%TYPE := Null;

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

6178: X_Error_Type OUT NOCOPY Varchar2,
6179: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)
6180: Is
6181:
6182: l_Task_Num Pa_Tasks.Task_Number%TYPE := Null;
6183: l_Task_Name Pa_Tasks.Task_Name%TYPE := Null;
6184:
6185: /* begin bug 4766396
6186: Cursor Validate_ProjTask_Combo(P_Prj_Id IN Number,

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

6179: X_Task_Number OUT NOCOPY Pa_Tasks.Task_Number%TYPE)
6180: Is
6181:
6182: l_Task_Num Pa_Tasks.Task_Number%TYPE := Null;
6183: l_Task_Name Pa_Tasks.Task_Name%TYPE := Null;
6184:
6185: /* begin bug 4766396
6186: Cursor Validate_ProjTask_Combo(P_Prj_Id IN Number,
6187: P_Tsk_Id IN Number) Is

Line 6201: pa_tasks t

6197: P_Tsk_Id IN NUMBER) is
6198: select
6199: t.task_number
6200: from pa_online_tasks_v tt,
6201: pa_tasks t
6202: where
6203: tt.task_id = P_Tsk_Id
6204: and tt.project_id = P_Prj_Id
6205: and t.task_id = tt.task_id;

Line 6735: l_Task_Id Pa_Tasks.Task_Id%TYPE;

6731: l_Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE; -- Added for CBS Enhancement Bug 16220146
6732:
6733: /*Start -changes for bug:7604482 */
6734: l_Proj_Id Pa_Projects_All.Project_Id%TYPE;
6735: l_Task_Id Pa_Tasks.Task_Id%TYPE;
6736: l_Exp_Type Pa_Expenditure_Types.Expenditure_Type%TYPE;
6737: /*End -changes for bug:7604482 */
6738:
6739: Cursor AdjustmentRecords (P_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE) Is