[Home] [Help]
PACKAGE: APPS.PA_EXPENDITURES_UTILS
Source
1 PACKAGE PA_EXPENDITURES_UTILS AUTHID CURRENT_USER AS
2 /* $Header: PAXEXUTS.pls 120.2.12010000.3 2010/02/05 20:00:35 djanaswa ship $*/
3
4 G_exp_item_id NUMBER;
5 G_Pa_Date DATE;
6 G_Gl_Date DATE;
7 G_Recvr_Pa_Date DATE;
8 G_Recvr_Gl_Date DATE;
9 G_Pa_Period_Name VARCHAR2(15);
10 G_Gl_Period_Name VARCHAR2(15);
11 G_Recvr_Pa_Period_Name VARCHAR2(15);
12 G_Recvr_Gl_Period_Name VARCHAR2(15);
13
14 /* Additional variables for Bug 6450225 */
15 PREV_CC_PRVDR_ORG_ID NUMBER (15);
16 PREV_CC_RECVR_ORG_ID NUMBER (15);
17 PREV_PRVDR_ORG_ID NUMBER (15);
18 PREV_RECVR_ORG_ID NUMBER (15);
19 PREV_NLR_ORG_ID NUMBER (15);
20
21 PREV_CC_PRVDR_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ; --VARCHAR2 (60); changed for bug 7011574
22 PREV_CC_RECVR_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ; --VARCHAR2 (60);
23 PREV_PRVDR_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ; --VARCHAR2 (60);
24 PREV_RECVR_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ; --VARCHAR2 (60);
25 PREV_NLR_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE ; --VARCHAR2 (60);
26 /* End of Additional variables for Bug 6450225 */
27
28 FUNCTION GetOrgTlName ( P_Organization_Id IN NUMBER ) RETURN VARCHAR2;
29 pragma RESTRICT_REFERENCES (GetOrgTlName , WNDS );
30
31 /* Bug 3637411 : Added the following function to get the Organisation Name
32 in the Base Language */
33 FUNCTION GetOrgName ( P_Organization_Id IN NUMBER ) RETURN VARCHAR2;
34 pragma RESTRICT_REFERENCES (GetOrgName , WNDS );
35
36 /* Added Function GET_ORG_NAME for Bug 6450225 */
37 FUNCTION GET_ORG_NAME ( P_Org_ID IN NUMBER , P_Org_Ctl IN VARCHAR ) RETURN VARCHAR2;
38 pragma RESTRICT_REFERENCES (GET_ORG_NAME , WNDS );
39
40 /* Added Function GET_LATEST_DATE_PERIOD_NAME for Bug 6450225 */
41 FUNCTION GET_LATEST_DATE_PERIOD_NAME ( P_EXP_ITEM_ID IN NUMBER,
42 P_FUN_CTL IN VARCHAR) RETURN VARCHAR2;
43 pragma RESTRICT_REFERENCES ( GET_LATEST_DATE_PERIOD_NAME, WNDS );
44 FUNCTION GetJobName ( P_Job_Id IN NUMBER ) RETURN VARCHAR2;
45 pragma RESTRICT_REFERENCES (GetJobName, WNDS );
46
47 PROCEDURE Check_Expenditure_Type(
48 p_expenditure_type IN VARCHAR2,
49 p_date IN DATE,
50 x_valid OUT NOCOPY VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_error_message_code OUT NOCOPY VARCHAR2);
53
54 PROCEDURE Check_Exp_Type_Class_Code(
55 p_sys_link_func IN VARCHAR2,
56 p_exp_meaning IN VARCHAR2,
57 p_check_id_flag IN VARCHAR2,
58 x_sys_link_func OUT NOCOPY VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_error_message_code OUT NOCOPY VARCHAR2 ) ;
61
62 PROCEDURE Check_Exp_Type_Sys_Link_Combo(
63 p_exp_type IN VARCHAR2,
64 p_ei_date IN DATE,
65 p_sys_link_func IN VARCHAR2,
66 x_valid OUT NOCOPY VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_error_message_code OUT NOCOPY VARCHAR2);
69
70 Function Get_Latest_GL_Date(P_Exp_Item_Id IN NUMBER) return DATE;
71 pragma RESTRICT_REFERENCES (Get_Latest_GL_Date , WNDS );
72
73 Function Get_Latest_PA_Date(P_Exp_Item_Id IN NUMBER) return DATE;
74 pragma RESTRICT_REFERENCES (Get_Latest_PA_Date , WNDS );
75
76 Function Get_Latest_Recvr_Pa_Date(P_Exp_Item_Id IN NUMBER) return DATE;
77 pragma RESTRICT_REFERENCES (Get_Latest_Recvr_Pa_Date, WNDS );
78
79 Function Get_Latest_Recvr_Gl_Date(P_Exp_Item_Id IN NUMBER) return DATE;
80 pragma RESTRICT_REFERENCES (Get_Latest_Recvr_Gl_Date, WNDS );
81
82 Function Get_Latest_Pa_Per_Name(P_Exp_Item_Id IN NUMBER) return VARCHAR2;
83 pragma RESTRICT_REFERENCES (Get_Latest_Pa_Per_Name, WNDS );
84
85 Function Get_Latest_Gl_Per_Name(P_Exp_Item_Id IN NUMBER) return VARCHAR2;
86 pragma RESTRICT_REFERENCES (Get_Latest_Gl_Per_Name, WNDS );
87
88 Function Get_Latest_Recvr_Pa_Per_Name(P_Exp_Item_Id IN NUMBER) return VARCHAR2;
89 pragma RESTRICT_REFERENCES (Get_Latest_Recvr_Pa_Per_Name, WNDS );
90
91 Function Get_Latest_Recvr_Gl_Per_Name(P_Exp_Item_Id IN NUMBER) return VARCHAR2;
92 pragma RESTRICT_REFERENCES (Get_Latest_Recvr_Gl_Per_Name, WNDS );
93
94 /* Added Function GET_ORG_NAME_WOSEC for Bug 9321568 */
95 FUNCTION GET_ORG_NAME_WOSEC ( P_Org_ID IN NUMBER ) RETURN VARCHAR2;
96 pragma RESTRICT_REFERENCES (GET_ORG_NAME , WNDS );
97
98
99 END PA_EXPENDITURES_UTILS;