[Home] [Help]
PACKAGE: APPS.OKL_QUL_PVT
Source
1 PACKAGE OKL_QUL_PVT AS
2 /* $Header: OKLSQULS.pls 120.1 2005/08/31 23:33:25 rravikir noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_QUL_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 qul_rec_type IS RECORD (
34 id okl_quote_subpool_usage.id%TYPE
35 ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE
36 ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
37 ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
38 ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
39 ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
40 ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
41 ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
42 ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
43 ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
44 ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
45 ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
46 ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
47 ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
48 ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
49 ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
50 ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
51 ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
52 ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
53 ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
54 ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
55 ,asset_number okl_quote_subpool_usage.asset_number%TYPE
56 ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
57 ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
58 ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
59 ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
60 ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
61 ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
62 ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
63 ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
64 ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
65 );
66
67 -- view record structure
68 TYPE qulv_rec_type IS RECORD (
69 id okl_quote_subpool_usage.id%TYPE
70 ,object_version_number okl_quote_subpool_usage.object_version_number%TYPE
71 ,attribute_category okl_quote_subpool_usage.attribute_category%TYPE
72 ,attribute1 okl_quote_subpool_usage.attribute1%TYPE
73 ,attribute2 okl_quote_subpool_usage.attribute2%TYPE
74 ,attribute3 okl_quote_subpool_usage.attribute3%TYPE
75 ,attribute4 okl_quote_subpool_usage.attribute4%TYPE
76 ,attribute5 okl_quote_subpool_usage.attribute5%TYPE
77 ,attribute6 okl_quote_subpool_usage.attribute6%TYPE
78 ,attribute7 okl_quote_subpool_usage.attribute7%TYPE
79 ,attribute8 okl_quote_subpool_usage.attribute8%TYPE
80 ,attribute9 okl_quote_subpool_usage.attribute9%TYPE
81 ,attribute10 okl_quote_subpool_usage.attribute10%TYPE
82 ,attribute11 okl_quote_subpool_usage.attribute11%TYPE
83 ,attribute12 okl_quote_subpool_usage.attribute12%TYPE
84 ,attribute13 okl_quote_subpool_usage.attribute13%TYPE
85 ,attribute14 okl_quote_subpool_usage.attribute14%TYPE
86 ,attribute15 okl_quote_subpool_usage.attribute15%TYPE
87 ,subpool_trx_id okl_quote_subpool_usage.subpool_trx_id%TYPE
88 ,source_type_code okl_quote_subpool_usage.source_type_code%TYPE
89 ,source_object_id okl_quote_subpool_usage.source_object_id%TYPE
90 ,asset_number okl_quote_subpool_usage.asset_number%TYPE
91 ,asset_start_date okl_quote_subpool_usage.asset_start_date%TYPE
92 ,subsidy_pool_id okl_quote_subpool_usage.subsidy_pool_id%TYPE
93 ,subsidy_pool_amount okl_quote_subpool_usage.subsidy_pool_amount%TYPE
94 ,subsidy_pool_currency_code okl_quote_subpool_usage.subsidy_pool_currency_code%TYPE
95 ,subsidy_id okl_quote_subpool_usage.subsidy_id%TYPE
96 ,subsidy_amount okl_quote_subpool_usage.subsidy_amount%TYPE
97 ,subsidy_currency_code okl_quote_subpool_usage.subsidy_currency_code%TYPE
98 ,vendor_id okl_quote_subpool_usage.vendor_id%TYPE
99 ,conversion_rate okl_quote_subpool_usage.conversion_rate%TYPE
100 );
101
102 TYPE qulv_tbl_type IS TABLE OF qulv_rec_type INDEX BY BINARY_INTEGER;
103
104 ----------------
105 -- PROGRAM UNITS
106 ----------------
107
108 PROCEDURE insert_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_qulv_tbl IN qulv_tbl_type,
115 x_qulv_tbl OUT NOCOPY qulv_tbl_type);
116
117 PROCEDURE update_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_qulv_tbl IN qulv_tbl_type,
124 x_qulv_tbl OUT NOCOPY qulv_tbl_type);
125
126 PROCEDURE delete_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_qulv_tbl IN qulv_tbl_type);
133
134 PROCEDURE insert_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_qulv_rec IN qulv_rec_type,
141 x_qulv_rec OUT NOCOPY qulv_rec_type);
142
143 PROCEDURE update_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_qulv_rec IN qulv_rec_type,
150 x_qulv_rec OUT NOCOPY qulv_rec_type);
151
152 PROCEDURE delete_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_qulv_rec IN qulv_rec_type);
159
160 END OKL_QUL_PVT;