DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PA_TASKS

Line 209: PA_TASKS PT

205: PA_Resources RS,
206: PA_Resource_List_Members RM,
207: PA_Resource_Assignments RA,
208: PA_Resource_Txn_Attributes RT,
209: PA_TASKS PT
210: WHERE
211: -- ra.Budget_Version_ID = P_Budget_Version_ID AND
212: ra.Resource_Assignment_ID = BL.Resource_Assignment_ID
213: AND RA.Resource_List_Member_ID = RM.Resource_List_Member_ID

Line 751: P_Task_ID IN PA_Tasks.Task_ID%TYPE,

747: P_Project_Org_Name IN HR_Organization_Units.Name%TYPE,
748: P_project_Org_ID IN HR_Organization_Units.Organization_ID %TYPE,
749: P_Project_Type IN PA_Project_Types_All.Project_Type%TYPE,
750: P_Project_Class_Code IN PA_Project_Classes.Class_Code%TYPE, /* added for bug 2914197 */
751: P_Task_ID IN PA_Tasks.Task_ID%TYPE,
752:
753: P_Resource_List_Flag IN VARCHAR2,
754: P_Resource_Type_ID IN PA_Resource_Types.Resource_Type_Code%TYPE,
755: P_Resource_Group_ID IN PA_Resource_Types.Resource_Type_ID%TYPE,

Line 789: l_top_task_Id pa_tasks.task_Id%TYPE;

785: l_Concat_Descrs VARCHAR2(500);
786: l_Error_message VARCHAR2(100);
787: l_return_Ccid GL_Code_Combinations.code_Combination_Id%TYPE;
788:
789: l_top_task_Id pa_tasks.task_Id%TYPE;
790: l_top_task_number pa_tasks.task_number%TYPE;
791: l_task_org_name hr_organization_units.name%TYPE;
792: l_task_org_Id hr_organization_units.organization_Id %TYPE;
793: l_task_service_type pa_tasks.service_type_Code%TYPE;

Line 790: l_top_task_number pa_tasks.task_number%TYPE;

786: l_Error_message VARCHAR2(100);
787: l_return_Ccid GL_Code_Combinations.code_Combination_Id%TYPE;
788:
789: l_top_task_Id pa_tasks.task_Id%TYPE;
790: l_top_task_number pa_tasks.task_number%TYPE;
791: l_task_org_name hr_organization_units.name%TYPE;
792: l_task_org_Id hr_organization_units.organization_Id %TYPE;
793: l_task_service_type pa_tasks.service_type_Code%TYPE;
794:

Line 793: l_task_service_type pa_tasks.service_type_Code%TYPE;

789: l_top_task_Id pa_tasks.task_Id%TYPE;
790: l_top_task_number pa_tasks.task_number%TYPE;
791: l_task_org_name hr_organization_units.name%TYPE;
792: l_task_org_Id hr_organization_units.organization_Id %TYPE;
793: l_task_service_type pa_tasks.service_type_Code%TYPE;
794:
795: l_low_task_Id pa_tasks.task_Id%TYPE;
796: l_low_task_number pa_tasks.task_number%TYPE;
797:

Line 795: l_low_task_Id pa_tasks.task_Id%TYPE;

791: l_task_org_name hr_organization_units.name%TYPE;
792: l_task_org_Id hr_organization_units.organization_Id %TYPE;
793: l_task_service_type pa_tasks.service_type_Code%TYPE;
794:
795: l_low_task_Id pa_tasks.task_Id%TYPE;
796: l_low_task_number pa_tasks.task_number%TYPE;
797:
798: l_Employee_number per_All_people_F.employee_number%TYPE;
799:

Line 796: l_low_task_number pa_tasks.task_number%TYPE;

792: l_task_org_Id hr_organization_units.organization_Id %TYPE;
793: l_task_service_type pa_tasks.service_type_Code%TYPE;
794:
795: l_low_task_Id pa_tasks.task_Id%TYPE;
796: l_low_task_number pa_tasks.task_number%TYPE;
797:
798: l_Employee_number per_All_people_F.employee_number%TYPE;
799:
800: -- Added in FP_M for CWK changes

Line 845: PA_Tasks

841: INTO
842: l_top_task_Id,
843: l_low_task_Id
844: FROM
845: PA_Tasks
846: WHERE
847: task_Id = p_task_Id
848: AND project_Id = p_project_Id ;
849: END;

Line 1779: p_top_task_Id IN pa_tasks.task_Id%TYPE,

1775: END Derive_Resource_Params ; /* End API Derive_Resource_Params */
1776:
1777: PROCEDURE Derive_Task_Params (
1778: p_project_Id IN pa_projects_All.project_Id%TYPE,
1779: p_top_task_Id IN pa_tasks.task_Id%TYPE,
1780: p_low_task_Id IN pa_tasks.task_Id%TYPE,
1781: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
1782: x_task_organization_Id OUT NOCOPY hr_organization_units.organization_Id%TYPE,
1783: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

Line 1780: p_low_task_Id IN pa_tasks.task_Id%TYPE,

1776:
1777: PROCEDURE Derive_Task_Params (
1778: p_project_Id IN pa_projects_All.project_Id%TYPE,
1779: p_top_task_Id IN pa_tasks.task_Id%TYPE,
1780: p_low_task_Id IN pa_tasks.task_Id%TYPE,
1781: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
1782: x_task_organization_Id OUT NOCOPY hr_organization_units.organization_Id%TYPE,
1783: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
1784: x_task_service_type OUT NOCOPY pa_tasks.service_type_Code%TYPE,

Line 1781: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

1777: PROCEDURE Derive_Task_Params (
1778: p_project_Id IN pa_projects_All.project_Id%TYPE,
1779: p_top_task_Id IN pa_tasks.task_Id%TYPE,
1780: p_low_task_Id IN pa_tasks.task_Id%TYPE,
1781: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
1782: x_task_organization_Id OUT NOCOPY hr_organization_units.organization_Id%TYPE,
1783: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
1784: x_task_service_type OUT NOCOPY pa_tasks.service_type_Code%TYPE,
1785: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

Line 1784: x_task_service_type OUT NOCOPY pa_tasks.service_type_Code%TYPE,

1780: p_low_task_Id IN pa_tasks.task_Id%TYPE,
1781: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
1782: x_task_organization_Id OUT NOCOPY hr_organization_units.organization_Id%TYPE,
1783: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
1784: x_task_service_type OUT NOCOPY pa_tasks.service_type_Code%TYPE,
1785: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
1786: X_Return_Status OUT NOCOPY VARCHAR2,
1787: X_Msg_Count OUT NOCOPY NUMBER,
1788: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1785: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

1781: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
1782: x_task_organization_Id OUT NOCOPY hr_organization_units.organization_Id%TYPE,
1783: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
1784: x_task_service_type OUT NOCOPY pa_tasks.service_type_Code%TYPE,
1785: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
1786: X_Return_Status OUT NOCOPY VARCHAR2,
1787: X_Msg_Count OUT NOCOPY NUMBER,
1788: X_Msg_Data OUT NOCOPY VARCHAR2
1789: )

Line 1820: PA_Tasks TOP_TASK

1816: X_Task_Organization_Name,
1817: X_Task_Service_Type
1818: FROM
1819: HR_All_Organization_Units ORG,
1820: PA_Tasks TOP_TASK
1821: WHERE
1822: TOP_TASK.task_Id = p_top_task_Id
1823: AND TOP_TASK.Top_Task_ID = TOP_TASK.Task_ID
1824: AND TOP_TASK.Project_ID = p_project_Id

Line 1839: PA_Tasks TASK

1835: TASK.task_number TASK_NUMBER
1836: INTO
1837: x_task_number
1838: FROM
1839: PA_Tasks TASK
1840: WHERE
1841: TASK.task_Id = p_low_task_Id;
1842: END;
1843: END IF;