DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on PER_JOBS

Line 762: P_Job_ID IN PER_Jobs.Job_ID%TYPE,

758:
759: P_Person_ID IN PER_All_People_F.Person_ID%TYPE,
760: P_Expenditure_Category IN PA_Expenditure_Categories.Expenditure_Category%TYPE,
761: P_Expenditure_Type IN PA_Expenditure_Types.Expenditure_Type%TYPE,
762: P_Job_ID IN PER_Jobs.Job_ID%TYPE,
763: P_Organization_ID IN HR_All_Organization_Units.Organization_ID%TYPE,
764: P_Supplier_ID IN PO_Vendors.Vendor_ID%TYPE,
765:
766: X_Return_CCID OUT NOCOPY GL_Code_Combinations.Code_Combination_ID%TYPE,

Line 803: l_Job_name per_Jobs.name%TYPE;

799:
800: -- Added in FP_M for CWK changes
801: l_Person_Type PA_Employees.Person_Type%TYPE;
802:
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;

Line 804: l_Job_Group_Id per_Jobs.job_Group_Id%TYPE;

800: -- Added in FP_M for CWK changes
801: l_Person_Type PA_Employees.Person_Type%TYPE;
802:
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;

Line 1654: p_Job_Id IN per_Jobs.job_Id%TYPE,

1650: END Insert_Into_Budget_Lines ; /* End API Insert_Into_Budget_Lines */
1651:
1652: PROCEDURE Derive_Resource_Params (
1653: p_person_Id IN per_All_people_F.person_Id%TYPE,
1654: p_Job_Id IN per_Jobs.job_Id%TYPE,
1655: p_organization_Id IN hr_All_organization_units.organization_Id%TYPE,
1656: p_supplier_Id IN po_vendors.vendor_Id%TYPE,
1657: x_Employee_number OUT NOCOPY per_All_people_F.employee_number%TYPE,
1658: x_Person_Type OUT NOCOPY PA_Employees.Person_Type%TYPE,

Line 1659: x_Job_name OUT NOCOPY per_Jobs.name%TYPE,

1655: p_organization_Id IN hr_All_organization_units.organization_Id%TYPE,
1656: p_supplier_Id IN po_vendors.vendor_Id%TYPE,
1657: x_Employee_number OUT NOCOPY per_All_people_F.employee_number%TYPE,
1658: x_Person_Type OUT NOCOPY PA_Employees.Person_Type%TYPE,
1659: x_Job_name OUT NOCOPY per_Jobs.name%TYPE,
1660: x_Job_Group_Id OUT NOCOPY per_Jobs.job_Group_Id%TYPE,
1661: x_Job_Group_name OUT NOCOPY per_Job_Groups.internal_name%TYPE,
1662: x_organization_type OUT NOCOPY hr_All_organization_units.type%TYPE,
1663: x_organization_name OUT NOCOPY hr_All_organization_units.name%TYPE,

Line 1660: x_Job_Group_Id OUT NOCOPY per_Jobs.job_Group_Id%TYPE,

1656: p_supplier_Id IN po_vendors.vendor_Id%TYPE,
1657: x_Employee_number OUT NOCOPY per_All_people_F.employee_number%TYPE,
1658: x_Person_Type OUT NOCOPY PA_Employees.Person_Type%TYPE,
1659: x_Job_name OUT NOCOPY per_Jobs.name%TYPE,
1660: x_Job_Group_Id OUT NOCOPY per_Jobs.job_Group_Id%TYPE,
1661: x_Job_Group_name OUT NOCOPY per_Job_Groups.internal_name%TYPE,
1662: x_organization_type OUT NOCOPY hr_All_organization_units.type%TYPE,
1663: x_organization_name OUT NOCOPY hr_All_organization_units.name%TYPE,
1664: x_supplier_name OUT NOCOPY po_vendors.vendor_name%TYPE,

Line 1718: PER_Jobs JOB,

1714: X_Job_Name,
1715: X_Job_Group_ID,
1716: X_Job_Group_Name
1717: FROM
1718: PER_Jobs JOB,
1719: PER_Job_Groups JBGRP
1720: WHERE
1721: JOB.job_Id = p_Job_Id
1722: AND JOB.job_Group_Id = JBGRP.job_Group_Id ;