[Home] [Help]
PACKAGE: APPS.OKL_CDJ_PVT
Source
1 PACKAGE OKL_CDJ_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSCDJS.pls 120.2 2006/04/13 10:28:14 ssdeshpa noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_CDJ_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
9 G_API_VERSION CONSTANT NUMBER := 1;
10 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
11 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
12 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
18 G_COL_ERROR CONSTANT VARCHAR2(30) := 'OKL_COL_ERROR';
19 G_OVN_ERROR CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR';
20 G_OVN_ERROR2 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR2';
21 G_OVN_ERROR3 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR3';
22 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
23 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
24 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := 'COL_NAME';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
27
28 ------------------
29 -- DATA STRUCTURES
30 ------------------
31
32 -- Do not include WHO columns in the base table record structure
33 TYPE cdj_rec_type IS RECORD (
34 id okl_cost_adjustments_b.id%TYPE
35 ,object_version_number okl_cost_adjustments_b.object_version_number%TYPE
36 ,attribute_category okl_cost_adjustments_b.attribute_category%TYPE
37 ,attribute1 okl_cost_adjustments_b.attribute1%TYPE
38 ,attribute2 okl_cost_adjustments_b.attribute2%TYPE
39 ,attribute3 okl_cost_adjustments_b.attribute3%TYPE
40 ,attribute4 okl_cost_adjustments_b.attribute4%TYPE
41 ,attribute5 okl_cost_adjustments_b.attribute5%TYPE
42 ,attribute6 okl_cost_adjustments_b.attribute6%TYPE
43 ,attribute7 okl_cost_adjustments_b.attribute7%TYPE
44 ,attribute8 okl_cost_adjustments_b.attribute8%TYPE
45 ,attribute9 okl_cost_adjustments_b.attribute9%TYPE
46 ,attribute10 okl_cost_adjustments_b.attribute10%TYPE
47 ,attribute11 okl_cost_adjustments_b.attribute11%TYPE
48 ,attribute12 okl_cost_adjustments_b.attribute12%TYPE
49 ,attribute13 okl_cost_adjustments_b.attribute13%TYPE
50 ,attribute14 okl_cost_adjustments_b.attribute14%TYPE
51 ,attribute15 okl_cost_adjustments_b.attribute15%TYPE
52 ,parent_object_code okl_cost_adjustments_b.parent_object_code%TYPE
53 ,parent_object_id okl_cost_adjustments_b.parent_object_id%TYPE
54 ,adjustment_source_type okl_cost_adjustments_b.adjustment_source_type%TYPE
55 ,adjustment_source_id okl_cost_adjustments_b.adjustment_source_id%TYPE
56 ,basis okl_cost_adjustments_b.basis%TYPE
57 ,value okl_cost_adjustments_b.value%TYPE
58 ,processing_type okl_cost_adjustments_b.processing_type%TYPE
59 ,supplier_id okl_cost_adjustments_b.supplier_id%TYPE
60 ,default_subsidy_amount okl_cost_adjustments_b.default_subsidy_amount%TYPE
61 ,percent_basis_value okl_cost_adjustments_b.percent_basis_value%TYPE
62 --Bug # 5142940 ssdeshpa start added new column
63 ,stream_type_id okl_cost_adjustments_b.stream_type_id%TYPE
64 --Bug # 5142940 ssdeshpa end
65 );
66
67 -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
68 TYPE cdjtl_rec_type IS RECORD (
69 id okl_cost_adjustments_tl.id%TYPE
70 ,short_description okl_cost_adjustments_tl.short_description%TYPE
71 ,description okl_cost_adjustments_tl.description%TYPE
72 ,comments okl_cost_adjustments_tl.comments%TYPE
73 );
74
75 -- view record structure
76 TYPE cdjv_rec_type IS RECORD (
77 id okl_cost_adjustments_b.id%TYPE
78 ,object_version_number okl_cost_adjustments_b.object_version_number%TYPE
79 ,attribute_category okl_cost_adjustments_b.attribute_category%TYPE
80 ,attribute1 okl_cost_adjustments_b.attribute1%TYPE
81 ,attribute2 okl_cost_adjustments_b.attribute2%TYPE
82 ,attribute3 okl_cost_adjustments_b.attribute3%TYPE
83 ,attribute4 okl_cost_adjustments_b.attribute4%TYPE
84 ,attribute5 okl_cost_adjustments_b.attribute5%TYPE
85 ,attribute6 okl_cost_adjustments_b.attribute6%TYPE
86 ,attribute7 okl_cost_adjustments_b.attribute7%TYPE
87 ,attribute8 okl_cost_adjustments_b.attribute8%TYPE
88 ,attribute9 okl_cost_adjustments_b.attribute9%TYPE
89 ,attribute10 okl_cost_adjustments_b.attribute10%TYPE
90 ,attribute11 okl_cost_adjustments_b.attribute11%TYPE
91 ,attribute12 okl_cost_adjustments_b.attribute12%TYPE
92 ,attribute13 okl_cost_adjustments_b.attribute13%TYPE
93 ,attribute14 okl_cost_adjustments_b.attribute14%TYPE
94 ,attribute15 okl_cost_adjustments_b.attribute15%TYPE
95 ,parent_object_code okl_cost_adjustments_b.parent_object_code%TYPE
96 ,parent_object_id okl_cost_adjustments_b.parent_object_id%TYPE
97 ,adjustment_source_type okl_cost_adjustments_b.adjustment_source_type%TYPE
98 ,adjustment_source_id okl_cost_adjustments_b.adjustment_source_id%TYPE
99 ,basis okl_cost_adjustments_b.basis%TYPE
100 ,value okl_cost_adjustments_b.value%TYPE
101 ,processing_type okl_cost_adjustments_b.processing_type%TYPE
102 ,supplier_id okl_cost_adjustments_b.supplier_id%TYPE
103 ,default_subsidy_amount okl_cost_adjustments_b.default_subsidy_amount%TYPE
104 ,short_description okl_cost_adjustments_tl.short_description%TYPE
105 ,description okl_cost_adjustments_tl.description%TYPE
106 ,comments okl_cost_adjustments_tl.comments%TYPE
107 ,percent_basis_value okl_cost_adjustments_b.percent_basis_value%TYPE
108 --Bug # 5142940 ssdeshpa start
109 ,stream_type_id okl_cost_adjustments_b.stream_type_id%TYPE
110 --Bug # 5142940 ssdeshpa end
111 );
112
113 TYPE cdjv_tbl_type IS TABLE OF cdjv_rec_type INDEX BY BINARY_INTEGER;
114
115 ----------------
116 -- PROGRAM UNITS
117 ----------------
118 PROCEDURE add_language;
119
120 PROCEDURE insert_row(
121 p_api_version IN NUMBER
122 ,p_init_msg_list IN VARCHAR2
123 ,x_return_status OUT NOCOPY VARCHAR2
124 ,x_msg_count OUT NOCOPY NUMBER
125 ,x_msg_data OUT NOCOPY VARCHAR2
126 ,p_cdjv_tbl IN cdjv_tbl_type
127 ,x_cdjv_tbl OUT NOCOPY cdjv_tbl_type);
128
129 PROCEDURE update_row(
130 p_api_version IN NUMBER
131 ,p_init_msg_list IN VARCHAR2
132 ,x_return_status OUT NOCOPY VARCHAR2
133 ,x_msg_count OUT NOCOPY NUMBER
134 ,x_msg_data OUT NOCOPY VARCHAR2
135 ,p_cdjv_tbl IN cdjv_tbl_type
136 ,x_cdjv_tbl OUT NOCOPY cdjv_tbl_type);
137
138 PROCEDURE delete_row(
139 p_api_version IN NUMBER
140 ,p_init_msg_list IN VARCHAR2
141 ,x_return_status OUT NOCOPY VARCHAR2
142 ,x_msg_count OUT NOCOPY NUMBER
143 ,x_msg_data OUT NOCOPY VARCHAR2
144 ,p_cdjv_tbl IN cdjv_tbl_type);
145
146 PROCEDURE insert_row(
147 p_api_version IN NUMBER
148 ,p_init_msg_list IN VARCHAR2
149 ,x_return_status OUT NOCOPY VARCHAR2
150 ,x_msg_count OUT NOCOPY NUMBER
151 ,x_msg_data OUT NOCOPY VARCHAR2
152 ,p_cdjv_rec IN cdjv_rec_type
153 ,x_cdjv_rec OUT NOCOPY cdjv_rec_type);
154
155 PROCEDURE update_row(
156 p_api_version IN NUMBER
157 ,p_init_msg_list IN VARCHAR2
158 ,x_return_status OUT NOCOPY VARCHAR2
159 ,x_msg_count OUT NOCOPY NUMBER
160 ,x_msg_data OUT NOCOPY VARCHAR2
161 ,p_cdjv_rec IN cdjv_rec_type
162 ,x_cdjv_rec OUT NOCOPY cdjv_rec_type);
163
164 PROCEDURE delete_row(
165 p_api_version IN NUMBER
166 ,p_init_msg_list IN VARCHAR2
167 ,x_return_status OUT NOCOPY VARCHAR2
168 ,x_msg_count OUT NOCOPY NUMBER
169 ,x_msg_data OUT NOCOPY VARCHAR2
170 ,p_cdjv_rec IN cdjv_rec_type);
171
172 END OKL_CDJ_PVT;