1 PACKAGE PA_EVENT_UTILS AS
2 /* $Header: PAEVAPUS.pls 120.2 2007/02/07 10:42:29 rgandhi ship $ */
3
4
5 pvt_excp exception; --user defined exception
6
7
8 FUNCTION CHECK_VALID_PROJECT
9 (P_project_num IN VARCHAR2
10 ,P_project_id OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
11 RETURN VARCHAR2;
12
13 FUNCTION CHECK_VALID_TASK
14 (P_project_id IN NUMBER
15 ,P_task_num IN VARCHAR2
16 ,P_task_id OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
17 RETURN VARCHAR2;
18
19 FUNCTION CHECK_VALID_EVENT_TYPE
20 (P_event_type IN VARCHAR2
21 ,P_context IN VARCHAR2
22 ,X_event_type_classification OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
23 RETURN VARCHAR2;
24
25 FUNCTION CHECK_VALID_EVENT_ORG
26 (P_event_org_name IN VARCHAR2
27 ,P_event_org_id OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
28 RETURN VARCHAR2;
29
30 FUNCTION CHECK_VALID_CURR
31 (P_bill_trans_curr IN VARCHAR2)
32 RETURN VARCHAR2;
33
34 FUNCTION CHECK_VALID_FUND_RATE_TYPE
35 (P_fund_rate_type IN VARCHAR2
36 ,x_fund_rate_type OUT NOCOPY VARCHAR2 -- Added for bug 3009307 --File.Sql.39 bug 4440895
37 )
38 RETURN VARCHAR2;
39
40 FUNCTION CHECK_VALID_PROJ_RATE_TYPE
41 (P_proj_rate_type IN VARCHAR2
42 ,P_bill_trans_currency_code IN VARCHAR2
43 ,P_project_currency_code IN VARCHAR2
44 ,P_proj_level_rt_dt_code IN VARCHAR2
45 ,P_project_rate_date IN DATE
46 ,P_event_date IN DATE
47 ,x_proj_rate_type OUT NOCOPY VARCHAR2 -- Added for bug 3009307 --File.Sql.39 bug 4440895
48 )
49 RETURN VARCHAR2;
50
51 FUNCTION CHECK_VALID_PFC_RATE_TYPE
52 (P_pfc_rate_type IN VARCHAR2
53 ,P_bill_trans_currency_code IN VARCHAR2
54 ,P_proj_func_currency_code IN VARCHAR2
55 ,P_proj_level_func_rt_dt_code IN VARCHAR2
56 ,P_projfunc_rate_date IN DATE
57 ,P_event_date IN DATE
58 ,x_pfc_rate_type OUT NOCOPY VARCHAR2 -- Added for bug 3009307 --File.Sql.39 bug 4440895
59 )
60 RETURN VARCHAR2;
61
62 FUNCTION CHECK_VALID_REV_AMT
63 (P_event_type_classification IN VARCHAR2
64 ,P_rev_amt IN NUMBER)
65 RETURN VARCHAR2;
66
67 FUNCTION CHECK_VALID_BILL_AMT
68 (P_event_type_classification IN VARCHAR2
69 ,P_bill_amt IN NUMBER)
70 RETURN VARCHAR2;
71
72 FUNCTION CHECK_VALID_EVENT_NUM
73 (P_project_id IN NUMBER
74 ,P_task_id IN NUMBER
75 ,P_event_num IN NUMBER)
76 RETURN VARCHAR2;
77
78 FUNCTION CHECK_VALID_INV_ORG
79 (P_inv_org_name IN VARCHAR2
80 ,P_inv_org_id OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
81 RETURN VARCHAR2;
82
83 FUNCTION CHECK_VALID_INV_ITEM
84 (P_inv_item_id IN NUMBER)
85 RETURN VARCHAR2;
86
87 FUNCTION CHECK_EVENT_PROCESSED
88 (P_event_id IN NUMBER)
89 RETURN VARCHAR2;
90
91 FUNCTION CHECK_FUNDING
92 (P_project_id IN NUMBER
93 ,P_task_id IN NUMBER)
94 RETURN VARCHAR2;
95
96 FUNCTION CHECK_WRITE_OFF_AMT(
97 P_project_id IN NUMBER
98 ,P_task_id IN NUMBER
99 ,P_event_id IN NUMBER
100 ,P_rev_amt IN NUMBER
101 ,P_bill_trans_currency IN VARCHAR2
102 ,P_proj_func_currency IN VARCHAR2
103 ,P_proj_func_rate_type IN VARCHAR2
104 ,P_proj_func_rate IN NUMBER
105 ,P_proj_func_rate_date IN DATE
106 ,P_event_date IN DATE )
107 RETURN VARCHAR2;
108
109 -- Federal Uptake
110 FUNCTION CHECK_VALID_AGREEMENT(
111 P_project_id IN NUMBER
112 ,P_task_id IN NUMBER
113 ,P_agreement_number IN VARCHAR2
114 ,P_agreement_type IN VARCHAR2
115 ,P_customer_number IN VARCHAR2
116 ,P_agreement_id OUT NOCOPY NUMBER) --Federal Uptake
117 RETURN VARCHAR2;
118 -- Federal Uptake
119 FUNCTION CHECK_VALID_EVENT_DATE(
120 P_event_date IN DATE
121 ,P_agreement_id IN NUMBER )
122 RETURN VARCHAR2;
123
124 END PA_EVENT_UTILS;