[Home] [Help]
PACKAGE: APPS.OKL_QUE_PVT
Source
1 PACKAGE OKL_QUE_PVT AS
2 /* $Header: OKLSQUES.pls 120.0 2005/11/30 17:18:19 stmathew noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_QUE_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 que_rec_type IS RECORD (
34 id okl_insurance_estimates_b.id%TYPE
35 ,object_version_number okl_insurance_estimates_b.object_version_number%TYPE
36 ,attribute_category okl_insurance_estimates_b.attribute_category%TYPE
37 ,attribute1 okl_insurance_estimates_b.attribute1%TYPE
38 ,attribute2 okl_insurance_estimates_b.attribute2%TYPE
39 ,attribute3 okl_insurance_estimates_b.attribute3%TYPE
40 ,attribute4 okl_insurance_estimates_b.attribute4%TYPE
41 ,attribute5 okl_insurance_estimates_b.attribute5%TYPE
42 ,attribute6 okl_insurance_estimates_b.attribute6%TYPE
43 ,attribute7 okl_insurance_estimates_b.attribute7%TYPE
44 ,attribute8 okl_insurance_estimates_b.attribute8%TYPE
45 ,attribute9 okl_insurance_estimates_b.attribute9%TYPE
46 ,attribute10 okl_insurance_estimates_b.attribute10%TYPE
47 ,attribute11 okl_insurance_estimates_b.attribute11%TYPE
48 ,attribute12 okl_insurance_estimates_b.attribute12%TYPE
49 ,attribute13 okl_insurance_estimates_b.attribute13%TYPE
50 ,attribute14 okl_insurance_estimates_b.attribute14%TYPE
51 ,attribute15 okl_insurance_estimates_b.attribute15%TYPE
52 ,lease_quote_id okl_insurance_estimates_b.lease_quote_id%TYPE
53 ,policy_term okl_insurance_estimates_b.policy_term%TYPE
54 );
55
56 -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
57 TYPE quetl_rec_type IS RECORD (
58 id okl_insurance_estimates_tl.id%TYPE
59 ,short_description okl_insurance_estimates_tl.short_description%TYPE
60 ,description okl_insurance_estimates_tl.description%TYPE
61 ,comments okl_insurance_estimates_tl.comments%TYPE
62 );
63
64 -- view record structure
65 TYPE quev_rec_type IS RECORD (
66 id okl_insurance_estimates_b.id%TYPE
67 ,object_version_number okl_insurance_estimates_b.object_version_number%TYPE
68 ,attribute_category okl_insurance_estimates_b.attribute_category%TYPE
69 ,attribute1 okl_insurance_estimates_b.attribute1%TYPE
70 ,attribute2 okl_insurance_estimates_b.attribute2%TYPE
71 ,attribute3 okl_insurance_estimates_b.attribute3%TYPE
72 ,attribute4 okl_insurance_estimates_b.attribute4%TYPE
73 ,attribute5 okl_insurance_estimates_b.attribute5%TYPE
74 ,attribute6 okl_insurance_estimates_b.attribute6%TYPE
75 ,attribute7 okl_insurance_estimates_b.attribute7%TYPE
76 ,attribute8 okl_insurance_estimates_b.attribute8%TYPE
77 ,attribute9 okl_insurance_estimates_b.attribute9%TYPE
78 ,attribute10 okl_insurance_estimates_b.attribute10%TYPE
79 ,attribute11 okl_insurance_estimates_b.attribute11%TYPE
80 ,attribute12 okl_insurance_estimates_b.attribute12%TYPE
81 ,attribute13 okl_insurance_estimates_b.attribute13%TYPE
82 ,attribute14 okl_insurance_estimates_b.attribute14%TYPE
83 ,attribute15 okl_insurance_estimates_b.attribute15%TYPE
84 ,lease_quote_id okl_insurance_estimates_b.lease_quote_id%TYPE
85 ,policy_term okl_insurance_estimates_b.policy_term%TYPE
86 ,short_description okl_insurance_estimates_tl.short_description%TYPE
87 ,description okl_insurance_estimates_tl.description%TYPE
88 ,comments okl_insurance_estimates_tl.comments%TYPE
89 );
90
91 TYPE quev_tbl_type IS TABLE OF quev_rec_type INDEX BY BINARY_INTEGER;
92
93 ----------------
94 -- PROGRAM UNITS
95 ----------------
96 PROCEDURE add_language;
97
98 PROCEDURE insert_row(
99 p_api_version IN NUMBER
100 ,p_init_msg_list IN VARCHAR2
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_count OUT NOCOPY NUMBER
103 ,x_msg_data OUT NOCOPY VARCHAR2
104 ,p_quev_tbl IN quev_tbl_type
105 ,x_quev_tbl OUT NOCOPY quev_tbl_type);
106
107 PROCEDURE update_row(
108 p_api_version IN NUMBER
109 ,p_init_msg_list IN VARCHAR2
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 ,p_quev_tbl IN quev_tbl_type
114 ,x_quev_tbl OUT NOCOPY quev_tbl_type);
115
116 PROCEDURE delete_row(
117 p_api_version IN NUMBER
118 ,p_init_msg_list IN VARCHAR2
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122 ,p_quev_tbl IN quev_tbl_type);
123
124 PROCEDURE insert_row(
125 p_api_version IN NUMBER
126 ,p_init_msg_list IN VARCHAR2
127 ,x_return_status OUT NOCOPY VARCHAR2
128 ,x_msg_count OUT NOCOPY NUMBER
129 ,x_msg_data OUT NOCOPY VARCHAR2
130 ,p_quev_rec IN quev_rec_type
131 ,x_quev_rec OUT NOCOPY quev_rec_type);
132
133 PROCEDURE update_row(
134 p_api_version IN NUMBER
135 ,p_init_msg_list IN VARCHAR2
136 ,x_return_status OUT NOCOPY VARCHAR2
137 ,x_msg_count OUT NOCOPY NUMBER
138 ,x_msg_data OUT NOCOPY VARCHAR2
139 ,p_quev_rec IN quev_rec_type
140 ,x_quev_rec OUT NOCOPY quev_rec_type);
141
142 PROCEDURE delete_row(
143 p_api_version IN NUMBER
144 ,p_init_msg_list IN VARCHAR2
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_msg_count OUT NOCOPY NUMBER
147 ,x_msg_data OUT NOCOPY VARCHAR2
148 ,p_quev_rec IN quev_rec_type);
149
150 END OKL_QUE_PVT;