1 package PA_AGREEMENT_PVT as
2 /*$Header: PAAFAPVS.pls 120.5.12010000.2 2008/09/04 22:25:14 jngeorge ship $*/
3
4 PROCEDURE convert_ag_ref_to_id
5 (p_pm_agreement_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug 1851096 */
6 ,p_af_agreement_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* Bug 1851096 */
7 ,p_out_agreement_id OUT NOCOPY NUMBER /*File.sql.39*/
8 ,p_return_status OUT NOCOPY VARCHAR2 /*File.sql.39*/
9 );
10
11 PROCEDURE Convert_fu_ref_to_id
12 (p_pm_funding_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug 1851096 */
13 ,p_af_funding_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* Bug 1851096 */
14 ,p_out_funding_id OUT NOCOPY NUMBER /*File.sql.39*/
15 ,p_return_status OUT NOCOPY VARCHAR2 /*File.sql.39*/
16 );
17
18 FUNCTION fetch_agreement_id
19 (p_pm_agreement_reference IN VARCHAR2 )
20 RETURN NUMBER;
21
22 FUNCTION fetch_funding_id
23 (p_pm_funding_reference IN VARCHAR2 )
24 RETURN NUMBER;
25
26 /* Modified for MCB2 change */
27 FUNCTION check_create_agreement_ok
28 (p_pm_agreement_reference IN VARCHAR2
29 ,p_customer_id IN NUMBER
30 ,p_agreement_type IN VARCHAR2
31 ,p_agreement_num IN VARCHAR2
32 ,p_term_id IN NUMBER
33 ,p_template_flag IN VARCHAR2
34 ,p_revenue_limit_flag IN VARCHAR2
35 ,p_owned_by_person_id IN NUMBER
36 ,p_owning_organization_id IN NUMBER default null
37 ,p_agreement_currency_code IN VARCHAR2 default null
38 ,p_invoice_limit_flag IN VARCHAR2 default null
39 /*Federal*/
40 ,p_start_date IN DATE DEFAULT NULL
41 ,p_end_date IN DATE DEFAULT NULL
42 ,p_advance_required IN VARCHAR2 DEFAULT NULL
43 ,p_billing_sequence IN Number DEFAULT NULL)
44 RETURN VARCHAR2;
45
46 /* Modified for MCB2 change */
47 FUNCTION check_update_agreement_ok
48 (p_pm_agreement_reference IN VARCHAR2
49 ,p_agreement_id IN NUMBER
50 ,p_funding_id IN NUMBER
51 ,p_customer_id IN OUT NOCOPY NUMBER /*Bug 6602451*/
52 ,p_agreement_type IN OUT NOCOPY VARCHAR2 /*Bug 6602451*/
53 ,p_term_id IN OUT NOCOPY NUMBER /*Bug 6602451*/
54 ,p_template_flag IN VARCHAR2
55 ,p_revenue_limit_flag IN OUT NOCOPY VARCHAR2 /*Bug 6602451*/
56 ,p_owned_by_person_id IN OUT NOCOPY NUMBER /*Bug 6602451*/
57 ,p_owning_organization_id IN OUT NOCOPY NUMBER /*Bug 6602451*/
58 ,p_agreement_currency_code IN OUT NOCOPY VARCHAR2 /*Bug 6602451*/
59 ,p_invoice_limit_flag IN OUT NOCOPY VARCHAR2 /*Bug 6602451*/
60 /*Federal*/
61 ,p_start_date IN DATE DEFAULT NULL
62 ,p_end_date IN DATE DEFAULT NULL
63 ,p_advance_required IN VARCHAR2 DEFAULT NULL
64 ,p_billing_sequence IN Number DEFAULT NULL
65 ,p_amount IN NUMBER DEFAULT NULL)
66
67 RETURN VARCHAR2;
68
69 FUNCTION check_delete_agreement_ok
70 (p_agreement_id IN NUMBER
71 ,p_pm_agreement_reference IN VARCHAR2)
72 RETURN VARCHAR2;
73
74 /* Added for Bug 2403652 */
75
76 FUNCTION check_funding_category
77 ( p_project_id IN NUMBER
78 ,p_task_id IN NUMBER
79 ,p_agreement_id IN NUMBER
80 ,p_pm_funding_reference IN VARCHAR2
81 ,p_funding_category IN VARCHAR2)
82 RETURN VARCHAR2;
83
84
85 /* Modified for MCB2 change */
86 FUNCTION check_add_funding_ok
87 (p_project_id IN NUMBER
88 ,p_task_id IN NUMBER
89 ,p_agreement_id IN NUMBER
90 ,p_pm_funding_reference IN VARCHAR2
91 ,p_funding_amt IN NUMBER
92 ,p_customer_id IN NUMBER
93 ,p_project_rate_type IN VARCHAR2 default null
94 ,p_project_rate_date IN DATE default null
95 ,p_project_exchange_rate IN NUMBER default null
96 ,p_projfunc_rate_type IN VARCHAR2 default null
97 ,p_projfunc_rate_date IN DATE default null
98 ,p_projfunc_exchange_rate IN NUMBER default null
99 ,p_calling_context IN VARCHAR2 default null)-- Bug 6600563
100 RETURN VARCHAR2;
101 -- Nikhil added to validate the funding amount
102
103 /* Modified for MCB2 change */
104 FUNCTION check_update_funding_ok
105 (p_project_id IN NUMBER
106 ,p_task_id IN NUMBER
107 ,p_agreement_id IN NUMBER
108 ,p_customer_id IN NUMBER
109 ,p_pm_funding_reference IN VARCHAR2
110 ,p_funding_id IN NUMBER
111 ,p_funding_amt IN NUMBER
112 ,p_project_rate_type IN VARCHAR2 default null
113 ,p_project_rate_date IN DATE default null
114 ,p_project_exchange_rate IN NUMBER default null
115 ,p_projfunc_rate_type IN VARCHAR2 default null
116 ,p_projfunc_rate_date IN DATE default null
117 ,p_projfunc_exchange_rate IN NUMBER default null)
118 RETURN VARCHAR2;
119
120 FUNCTION check_delete_funding_ok
121 (p_agreement_id IN NUMBER
122 ,p_funding_id IN NUMBER
123 ,p_pm_funding_reference IN VARCHAR2)
124 RETURN VARCHAR2;
125
126 PROCEDURE validate_flex_fields
127 (p_desc_flex_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
128 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
129 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
130 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
131 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
132 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
133 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
134 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
135 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
136 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
138 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
139 /*Federal*/
140 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
141 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
143 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
144 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145 ,p_attribute16 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
146 ,p_attribute17 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
147 ,p_attribute18 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148 ,p_attribute19 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
149 ,p_attribute20 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
150 ,p_attribute21 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
151 ,p_attribute22 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
152 ,p_attribute23 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
153 ,p_attribute24 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
154 ,p_attribute25 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
155
156 ,p_return_msg OUT NOCOPY VARCHAR2 /*File.sql.39*/
157 ,p_validate_status OUT NOCOPY VARCHAR2 /*File.sql.39*/
158 );
159
160 FUNCTION check_yes_no
161 (p_val VARCHAR2)
162 RETURN VARCHAR2;
163
164 FUNCTION check_add_update
165 (p_funding_reference VARCHAR2)
166 RETURN VARCHAR2;
167
168 FUNCTION validate_funding_amt
169 (p_funding_amt NUMBER
170 ,p_agreement_id NUMBER
171 ,p_operation_flag VARCHAR2
172 ,p_funding_id NUMBER DEFAULT NULL
173 ,p_pm_funding_reference VARCHAR2 )
174 RETURN VARCHAR2;
175
176
177 END PA_AGREEMENT_PVT;