[Home] [Help]
PACKAGE: APPS.OKL_MST_PVT
Source
1 PACKAGE OKL_MST_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSMSTS.pls 115.3 2004/02/24 22:42:38 dedey noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_RBK_SELECTED_CONTRACT_V Record Spec
7 TYPE mstv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
10 ,khr_id NUMBER := OKC_API.G_MISS_NUM
11 ,contract_number OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12 ,contract_description OKL_RBK_SELECTED_CONTRACT_V.CONTRACT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13 ,kle_id NUMBER := OKC_API.G_MISS_NUM
14 ,transaction_id NUMBER := OKC_API.G_MISS_NUM
15 ,selected_flag OKL_RBK_SELECTED_CONTRACT_V.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
16 ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
17 ,attribute_category OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18 ,attribute1 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19 ,attribute2 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20 ,attribute3 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21 ,attribute4 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22 ,attribute5 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23 ,attribute6 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24 ,attribute7 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25 ,attribute8 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26 ,attribute9 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27 ,attribute10 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28 ,attribute11 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29 ,attribute12 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30 ,attribute13 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31 ,attribute14 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32 ,attribute15 OKL_RBK_SELECTED_CONTRACT_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33 ,created_by NUMBER := OKC_API.G_MISS_NUM
34 ,creation_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36 ,last_update_date OKL_RBK_SELECTED_CONTRACT_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
38 ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
39 G_MISS_mstv_rec mstv_rec_type;
40 TYPE mstv_tbl_type IS TABLE OF mstv_rec_type
41 INDEX BY BINARY_INTEGER;
42 -- OKL_RBK_SELECTED_CONTRACT Record Spec
43 TYPE mst_rec_type IS RECORD (
44 id NUMBER := OKC_API.G_MISS_NUM
45 ,request_name OKL_RBK_SELECTED_CONTRACT.REQUEST_NAME%TYPE := OKC_API.G_MISS_CHAR
46 ,khr_id NUMBER := OKC_API.G_MISS_NUM
47 ,contract_number OKL_RBK_SELECTED_CONTRACT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
48 ,contract_description OKL_RBK_SELECTED_CONTRACT.contract_description%TYPE := OKC_API.G_MISS_CHAR
49 ,kle_id NUMBER := OKC_API.G_MISS_NUM
50 ,transaction_id NUMBER := OKC_API.G_MISS_NUM
51 ,selected_flag OKL_RBK_SELECTED_CONTRACT.SELECTED_FLAG%TYPE := OKC_API.G_MISS_CHAR
52 ,status VARCHAR2(30) := OKC_API.G_MISS_CHAR
53 ,attribute_category OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
54 ,attribute1 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
55 ,attribute2 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
56 ,attribute3 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
57 ,attribute4 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
58 ,attribute5 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
59 ,attribute6 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
60 ,attribute7 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
61 ,attribute8 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
62 ,attribute9 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
63 ,attribute10 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
64 ,attribute11 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
65 ,attribute12 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
66 ,attribute13 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
67 ,attribute14 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
68 ,attribute15 OKL_RBK_SELECTED_CONTRACT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
69 ,created_by NUMBER := OKC_API.G_MISS_NUM
70 ,creation_date OKL_RBK_SELECTED_CONTRACT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
72 ,last_update_date OKL_RBK_SELECTED_CONTRACT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
74 ,transaction_date OKL_RBK_SELECTED_CONTRACT_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE);
75 G_MISS_mst_rec mst_rec_type;
76 TYPE mst_tbl_type IS TABLE OF mst_rec_type
77 INDEX BY BINARY_INTEGER;
78 ---------------------------------------------------------------------------
79 -- GLOBAL MESSAGE CONSTANTS
80 ---------------------------------------------------------------------------
81 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
94
95 -- The following variable is not in use
96 -- Fix for Bug# , dedey, 06/27/2002
97 G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
98
99
100 ---------------------------------------------------------------------------
101 -- GLOBAL EXCEPTIONS
102 ---------------------------------------------------------------------------
103 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
104
105 ---------------------------------------------------------------------------
106 -- GLOBAL VARIABLES
107 ---------------------------------------------------------------------------
108 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_MST_PVT';
109 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
110 ---------------------------------------------------------------------------
111 -- Procedures and Functions
112 ---------------------------------------------------------------------------
113
114 PROCEDURE qc;
115 PROCEDURE change_version;
116 PROCEDURE api_copy;
117 PROCEDURE insert_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_mstv_rec IN mstv_rec_type,
124 x_mstv_rec OUT NOCOPY mstv_rec_type);
125 PROCEDURE insert_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_mstv_tbl IN mstv_tbl_type,
132 x_mstv_tbl OUT NOCOPY mstv_tbl_type);
133 PROCEDURE lock_row(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_mstv_rec IN mstv_rec_type);
140 PROCEDURE lock_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_mstv_tbl IN mstv_tbl_type);
147 PROCEDURE update_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_mstv_rec IN mstv_rec_type,
154 x_mstv_rec OUT NOCOPY mstv_rec_type);
155 PROCEDURE update_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_mstv_tbl IN mstv_tbl_type,
162 x_mstv_tbl OUT NOCOPY mstv_tbl_type);
163 PROCEDURE delete_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_mstv_rec IN mstv_rec_type);
170 PROCEDURE delete_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_mstv_tbl IN mstv_tbl_type);
177 PROCEDURE validate_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_mstv_rec IN mstv_rec_type);
184 PROCEDURE validate_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_mstv_tbl IN mstv_tbl_type);
191 END OKL_MST_PVT;