DBA Data[Home] [Help]

APPS.PA_UTILS3 dependencies on PA_PROJECTS_ALL

Line 5: Project_Number Pa_Projects_All.Segment1%TYPE);

1: PACKAGE PA_UTILS3 AUTHID CURRENT_USER AS
2: /* $Header: PAXGUT3S.pls 120.9 2011/01/18 13:12:22 ethella ship $*/
3:
4: TYPE ProjectsRec IS RECORD (
5: Project_Number Pa_Projects_All.Segment1%TYPE);
6:
7: TYPE ProjectsTab IS TABLE OF ProjectsRec
8: INDEX BY BINARY_INTEGER;
9:

Line 74: Function GetCachedProjNum (P_Project_Id IN NUMBER) RETURN pa_projects_all.segment1%TYPE;

70: Procedure GetCachedOrgId (P_Inc_By_Per_Id IN NUMBER,
71: P_Exp_Item_Date IN DATE,
72: X_Inc_By_Org_Id OUT NOCOPY NUMBER);
73:
74: Function GetCachedProjNum (P_Project_Id IN NUMBER) RETURN pa_projects_all.segment1%TYPE;
75:
76: Function GetCachedTaskNum (P_Task_Id IN NUMBER) RETURN pa_tasks.task_number%TYPE;
77: Function GetEmpNum (P_Person_Id IN NUMBER,P_ei_date IN DATE DEFAULT sysdate) RETURN per_people_f.employee_number%TYPE;
78:

Line 85: (p_project_id IN pa_projects_all.project_id%TYPE,

81: P_Transferred_from_exp_id IN NUMBER)
82: RETURN VARCHAR2;
83:
84: PROCEDURE get_asset_addition_flag
85: (p_project_id IN pa_projects_all.project_id%TYPE,
86: x_asset_addition_flag OUT NOCOPY ap_invoice_distributions_all.assets_addition_flag%TYPE);
87:
88: FUNCTION Get_Project_Type ( p_project_id IN pa_projects_all.project_id%TYPE)
89: RETURN varchar2;

Line 88: FUNCTION Get_Project_Type ( p_project_id IN pa_projects_all.project_id%TYPE)

84: PROCEDURE get_asset_addition_flag
85: (p_project_id IN pa_projects_all.project_id%TYPE,
86: x_asset_addition_flag OUT NOCOPY ap_invoice_distributions_all.assets_addition_flag%TYPE);
87:
88: FUNCTION Get_Project_Type ( p_project_id IN pa_projects_all.project_id%TYPE)
89: RETURN varchar2;
90:
91: /* Bug 10158684 changes start */
92: Function GetPastEmpNum (P_Person_Id IN NUMBER,P_ei_date IN DATE DEFAULT sysdate)