DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 151: l_Project_Org_Name HR_Organization_Units.Name%TYPE;

147: l_Msg_Data VARCHAR2(500);
148:
149: l_Max_Version_Number NUMBER;
150: l_Project_Number PA_Projects_All.Segment1%TYPE;
151: l_Project_Org_Name HR_Organization_Units.Name%TYPE;
152: l_Project_Org_ID HR_Organization_Units.Organization_ID %TYPE;
153: l_Project_Type PA_Project_Types_All.Project_Type%TYPE;
154: l_Project_Class_Code PA_Project_Classes.Class_Code%TYPE; /* Added for bug 2914197 */
155: l_Project_Start_Date DATE;

Line 152: l_Project_Org_ID HR_Organization_Units.Organization_ID %TYPE;

148:
149: l_Max_Version_Number NUMBER;
150: l_Project_Number PA_Projects_All.Segment1%TYPE;
151: l_Project_Org_Name HR_Organization_Units.Name%TYPE;
152: l_Project_Org_ID HR_Organization_Units.Organization_ID %TYPE;
153: l_Project_Type PA_Project_Types_All.Project_Type%TYPE;
154: l_Project_Class_Code PA_Project_Classes.Class_Code%TYPE; /* Added for bug 2914197 */
155: l_Project_Start_Date DATE;
156: l_Project_End_Date DATE;

Line 747: P_Project_Org_Name IN HR_Organization_Units.Name%TYPE,

743: P_Budget_Version_ID IN PA_Budget_Versions.Budget_Version_ID%TYPE,
744:
745: P_Project_ID IN PA_Projects_All.Project_ID%TYPE,
746: P_Project_Number IN PA_Projects_All.Segment1%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,

Line 748: P_project_Org_ID IN HR_Organization_Units.Organization_ID %TYPE,

744:
745: P_Project_ID IN PA_Projects_All.Project_ID%TYPE,
746: P_Project_Number IN PA_Projects_All.Segment1%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:

Line 791: l_task_org_name hr_organization_units.name%TYPE;

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:
795: l_low_task_Id pa_tasks.task_Id%TYPE;

Line 792: l_task_org_Id hr_organization_units.organization_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:
795: l_low_task_Id pa_tasks.task_Id%TYPE;
796: l_low_task_number pa_tasks.task_number%TYPE;

Line 807: l_organization_name hr_organization_units.name%TYPE;

803: l_Job_name per_Jobs.name%TYPE;
804: l_Job_Group_Id per_Jobs.job_Group_Id%TYPE;
805: l_Job_Group_name per_Job_Groups.internal_name%TYPE;
806:
807: l_organization_name hr_organization_units.name%TYPE;
808: l_organization_type hr_organization_units.type%TYPE;
809:
810: l_supplier_name po_vendors.vendor_name%TYPE;
811:

Line 808: l_organization_type hr_organization_units.type%TYPE;

804: l_Job_Group_Id per_Jobs.job_Group_Id%TYPE;
805: l_Job_Group_name per_Job_Groups.internal_name%TYPE;
806:
807: l_organization_name hr_organization_units.name%TYPE;
808: l_organization_type hr_organization_units.type%TYPE;
809:
810: l_supplier_name po_vendors.vendor_name%TYPE;
811:
812: l_Chart_of_Accounts_Id NUMBER; -- Eg. 50234;

Line 1782: x_task_organization_Id OUT NOCOPY hr_organization_units.organization_Id%TYPE,

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,
1786: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1783: x_task_organization_name OUT NOCOPY hr_organization_units.name%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,
1786: X_Return_Status OUT NOCOPY VARCHAR2,
1787: X_Msg_Count OUT NOCOPY NUMBER,