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