1 PACKAGE PA_EVENT_PVT AUTHID DEFINER AS
2 /* $Header: PAEVAPVS.pls 120.5 2008/05/23 10:54:57 arbandyo ship $ */
3
4 /* Global Constants */
5 pub_excp exception;--user defined exception
6 G_PKG_PVT constant varchar2(100):='PA_EVENT_PVT';
7
8 FUNCTION CHECK_CREATE_EVENT_OK
9 (P_pm_product_code IN VARCHAR2
10 ,P_event_in_rec IN PA_EVENT_PUB.Event_Rec_in_type
11 ,P_project_currency_code IN VARCHAR2
12 ,P_proj_func_currency_code IN VARCHAR2
13 ,P_project_bil_rate_date_code IN VARCHAR2
14 ,P_project_rate_type IN VARCHAR2
15 ,p_project_bil_rate_date IN VARCHAR2
16 ,p_projfunc_bil_rate_date_code IN VARCHAR2
17 ,P_projfunc_rate_type IN VARCHAR2
18 ,p_projfunc_bil_rate_date IN VARCHAR2
19 ,P_funding_rate_type IN VARCHAR2
20 ,P_multi_currency_billing_flag IN VARCHAR2
21 ,p_project_id IN NUMBER
22 ,p_projfunc_bil_exchange_rate IN NUMBER -- Added for bug 3013137
23 ,p_funding_bil_rate_date_code IN VARCHAR2 --Added for bug 3053190
24 ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
25 ,x_organization_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
26 ,x_inv_org_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27 ,x_agreement_id OUT NOCOPY NUMBER -- Federal Uptake
28 ,P_event_type_classification OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
29 RETURN VARCHAR2;
30
31
32 FUNCTION CHECK_UPDATE_EVENT_OK
33 (P_pm_product_code IN VARCHAR2
34 ,P_event_in_rec IN PA_EVENT_PUB.Event_rec_in_type
35 ,P_project_currency_code IN VARCHAR2
36 ,P_proj_func_currency_code IN VARCHAR2
37 ,P_project_bil_rate_date_code IN VARCHAR2
38 ,P_project_rate_type IN VARCHAR2
39 ,p_project_bil_rate_date IN VARCHAR2
40 ,p_projfunc_bil_rate_date_code IN VARCHAR2
41 ,P_projfunc_rate_type IN VARCHAR2
42 ,p_projfunc_bil_rate_date IN VARCHAR2
43 ,P_funding_rate_type IN VARCHAR2
44 ,P_multi_currency_billing_flag IN VARCHAR2
45 ,p_project_id IN NUMBER
46 ,p_projfunc_bil_exchange_rate IN NUMBER -- Added for bug 3013137
47 ,p_funding_bill_rate_date_code IN VARCHAR2 --Added for bug 3053190
48 ,x_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49 ,x_organization_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
50 ,x_inv_org_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
51 ,x_agreement_id OUT NOCOPY NUMBER -- Federal Uptake
52 ,p_event_type_classification OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53 ,P_event_processed OUT NOCOPY VARCHAR2) /* Added for Bug 7110782 */
54 RETURN VARCHAR2;
55
56 PROCEDURE VALIDATE_FLEXFIELD
57 ( P_desc_flex_name IN VARCHAR2
58 ,P_attribute_category IN VARCHAR2
59 ,P_attribute1 IN VARCHAR2
60 ,P_attribute2 IN VARCHAR2
61 ,P_attribute3 IN VARCHAR2
62 ,P_attribute4 IN VARCHAR2
63 ,P_attribute5 IN VARCHAR2
64 ,P_attribute6 IN VARCHAR2
65 ,P_attribute7 IN VARCHAR2
66 ,P_attribute8 IN VARCHAR2
67 ,P_attribute9 IN VARCHAR2
68 ,P_attribute10 IN VARCHAR2
69 ,P_return_msg OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
70 ,P_valid_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
71
72
73 PROCEDURE CHECK_MDTY_PARAMS1
74 ( p_api_version_number IN NUMBER
75 ,p_api_name IN VARCHAR2
76 ,p_pm_product_code IN VARCHAR2
77 ,p_function_name IN VARCHAR2
78 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
79 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
80 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
81
82
83 g_api_version_number NUMBER := 1.0;
84
85 PROCEDURE CHECK_MDTY_PARAMS2
86 ( p_pm_event_reference IN VARCHAR2
87 ,P_pm_product_code IN VARCHAR2
88 ,p_project_number IN VARCHAR2
89 ,p_event_type IN VARCHAR2
90 ,p_organization_name IN VARCHAR2
91 ,p_calling_place IN VARCHAR2
92 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
93
94
95 FUNCTION CONV_EVENT_REF_TO_ID
96 (P_pm_product_code IN VARCHAR2
97 ,P_pm_event_reference IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98 ,P_event_id IN OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
99 RETURN VARCHAR2;
100
101 FUNCTION CHECK_DELETE_EVENT_OK
102 (P_pm_event_reference IN VARCHAR2
103 ,P_event_id IN NUMBER)
104 RETURN VARCHAR2;
105
106
107 FUNCTION CHECK_EVENT_REF_UNQ
108 (P_pm_product_code IN VARCHAR2
109 ,P_pm_event_reference IN VARCHAR2)
110 RETURN VARCHAR2;
111
112 FUNCTION CHECK_YES_NO
113 (P_flag IN VARCHAR2)
114 RETURN VARCHAR2;
115
116 FUNCTION FETCH_EVENT_ID
117 (P_pm_product_code IN VARCHAR2
118 ,P_pm_event_reference IN VARCHAR2)
119 RETURN NUMBER;
120
121
122
123 END PA_EVENT_PVT;