[Home] [Help]
PACKAGE: APPS.OKE_ALLOCATION_PVT
Source
1 package OKE_ALLOCATION_PVT AUTHID CURRENT_USER as
2 /* $Header: OKEVFDAS.pls 120.0 2005/05/25 17:55:18 appldev noship $ */
3
4
5 --
6 -- Global variables
7 --
8
9 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
10 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKE_ALLOCATION_PVT';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
15 G_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'OKE_K_HEADERS';
16 G_PRODUCT_CODE CONSTANT VARCHAR2(3) := 'OKE';
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 G_RESOURCE_BUSY EXCEPTION;
19 PRAGMA EXCEPTION_INIT(G_RESOURCE_BUSY, -54);
20
21 --
22 -- Allocation_Rec_In_Type
23 --
24
25 TYPE allocation_rec_in_type is RECORD
26 (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
27 funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
28 object_id NUMBER := OKE_API.G_MISS_NUM ,
29 k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30 project_id NUMBER := OKE_API.G_MISS_NUM ,
31 task_id NUMBER := OKE_API.G_MISS_NUM ,
32 agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33 project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34 amount NUMBER := OKE_API.G_MISS_NUM ,
35 hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36 fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37 funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38 start_date_active DATE := OKE_API.G_MISS_DATE ,
39 end_date_active DATE := OKE_API.G_MISS_DATE ,
40 fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41 reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42 reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43 reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44 pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45 pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46 pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47 -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48 oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49 oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50 oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51 oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52 oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53 oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54 oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55 oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56 oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57 oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58 oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59 oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60 oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61 oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62 oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63 oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64 revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65 funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66 pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67 pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68 pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69 pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70 pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71 pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72 pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73 pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74 pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
75 pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
76 pa_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR
77 );
78
79
80 --
81 -- Allocation_Rec_Out_Type
82 --
83
84 TYPE allocation_rec_out_type is RECORD
85 (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
86 return_status VARCHAR2(1) := OKE_API.G_MISS_CHAR
87 );
88
89
90 --
91 -- Allocation_In_Tbl_Type
92 --
93
94 TYPE allocation_in_tbl_type is TABLE of allocation_rec_in_type
95 index by binary_integer;
96
97
98 --
99 -- Allocation_Out_Tbl_Type
100 --
101 TYPE allocation_out_tbl_type is TABLE of allocation_rec_out_type
102 index by binary_integer;
103
104
105
106 --
107 -- Procedure: add_allocation
108 --
109 -- Description: This procedure is used to insert record in OKE_K_FUND_ALLOCATIONS table
110 --
111
112 PROCEDURE add_allocation(p_api_version IN NUMBER ,
113 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
114 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
115 p_msg_count OUT NOCOPY NUMBER ,
116 p_msg_data OUT NOCOPY VARCHAR2 ,
117 p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
118 p_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE ,
119 p_validation_flag IN VARCHAR2 := OKE_API.G_TRUE ,
120 p_return_status OUT NOCOPY VARCHAR2
121 );
122
123
124 --
125 -- Procedure: update_allocation
126 --
127 -- Description: This procedure is used to update record in OKE_K_FUND_ALLOCATIONS table
128 --
129
130 PROCEDURE update_allocation(p_api_version IN NUMBER ,
131 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
132 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
133 p_msg_count OUT NOCOPY NUMBER ,
134 p_msg_data OUT NOCOPY VARCHAR2 ,
135 p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
136 p_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE ,
137 p_validation_flag IN VARCHAR2 := OKE_API.G_TRUE ,
138 p_return_status OUT NOCOPY VARCHAR2
139 );
140
141
142 --
143 -- Procedure: delete_allocation
144 --
145 -- Description: This procedure is used to delete record in OKE_K_FUND_ALLOCATIONS and PA_PROJECT_FUNDINGS tables
146 --
147
148 PROCEDURE delete_allocation(p_api_version IN NUMBER ,
149 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
150 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
151 p_msg_count OUT NOCOPY NUMBER ,
152 p_msg_data OUT NOCOPY VARCHAR2 ,
153 p_fund_allocation_id IN NUMBER ,
154 -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
155 p_return_status OUT NOCOPY VARCHAR2
156 );
157
158
159 --
160 -- Function: get_allocation_tbl
161 --
162 -- Description: This function is used to return a initialized OKE_FUNDING_PUB.ALLOCATION_IN_TBL_TYPE
163 --
164
165 FUNCTION get_allocation_tbl RETURN ALLOCATION_IN_TBL_TYPE;
166
167
168 end OKE_ALLOCATION_PVT;