[Home] [Help]
PACKAGE: APPS.OKC_SPN_PVT
Source
1 Package OKC_SPN_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSSPNS.pls 120.0 2005/05/26 09:27:02 appldev noship $ */
6 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10 G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
11 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
12 TYPE spn_rec_type IS RECORD (
13 id NUMBER := OKC_API.G_MISS_NUM,
14 tve_id NUMBER := OKC_API.G_MISS_NUM,
15 uom_code OKC_SPAN.uom_code%TYPE := OKC_API.G_MISS_CHAR,
16 spn_id NUMBER := OKC_API.G_MISS_NUM,
17 duration NUMBER := OKC_API.G_MISS_NUM,
18 active_yn OKC_SPAN.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
19 name OKC_SPAN.NAME%TYPE := OKC_API.G_MISS_CHAR,
20 object_version_number NUMBER := OKC_API.G_MISS_NUM,
21 created_by NUMBER := OKC_API.G_MISS_NUM,
22 creation_date OKC_SPAN.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24 last_update_date OKC_SPAN.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25 last_update_login NUMBER := OKC_API.G_MISS_NUM,
26 attribute_category OKC_SPAN.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
27 attribute1 OKC_SPAN.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28 attribute2 OKC_SPAN.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
29 attribute3 OKC_SPAN.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
30 attribute4 OKC_SPAN.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
31 attribute5 OKC_SPAN.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
32 attribute6 OKC_SPAN.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
33 attribute7 OKC_SPAN.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
34 attribute8 OKC_SPAN.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
35 attribute9 OKC_SPAN.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
36 attribute10 OKC_SPAN.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
37 attribute11 OKC_SPAN.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
38 attribute12 OKC_SPAN.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
39 attribute13 OKC_SPAN.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
40 attribute14 OKC_SPAN.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
41 attribute15 OKC_SPAN.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
42 g_miss_spn_rec spn_rec_type;
43 TYPE spn_tbl_type IS TABLE OF spn_rec_type
44 INDEX BY BINARY_INTEGER;
45 TYPE spnv_rec_type IS RECORD (
46 id NUMBER := OKC_API.G_MISS_NUM,
47 object_version_number NUMBER := OKC_API.G_MISS_NUM,
48 tve_id NUMBER := OKC_API.G_MISS_NUM,
49 uom_code OKC_SPAN_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
50 spn_id NUMBER := OKC_API.G_MISS_NUM,
51 name OKC_SPAN_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
52 duration NUMBER := OKC_API.G_MISS_NUM,
53 active_yn OKC_SPAN_V.ACTIVE_YN%TYPE := OKC_API.G_MISS_CHAR,
54 attribute_category OKC_SPAN_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55 attribute1 OKC_SPAN_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56 attribute2 OKC_SPAN_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57 attribute3 OKC_SPAN_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58 attribute4 OKC_SPAN_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59 attribute5 OKC_SPAN_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60 attribute6 OKC_SPAN_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61 attribute7 OKC_SPAN_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62 attribute8 OKC_SPAN_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63 attribute9 OKC_SPAN_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64 attribute10 OKC_SPAN_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65 attribute11 OKC_SPAN_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66 attribute12 OKC_SPAN_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67 attribute13 OKC_SPAN_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68 attribute14 OKC_SPAN_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69 attribute15 OKC_SPAN_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70 created_by NUMBER := OKC_API.G_MISS_NUM,
71 creation_date OKC_SPAN_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73 last_update_date OKC_SPAN_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74 last_update_login NUMBER := OKC_API.G_MISS_NUM);
75 g_miss_spnv_rec spnv_rec_type;
76 TYPE spnv_tbl_type IS TABLE OF spnv_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 ---------------------------------------------------------------------------
92 -- GLOBAL VARIABLES
93 ---------------------------------------------------------------------------
94 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SPN_PVT';
95 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
96 ---------------------------------------------------------------------------
97 -- Procedures and Functions
98 ---------------------------------------------------------------------------
99
100 PROCEDURE qc;
101 PROCEDURE change_version;
102 PROCEDURE api_copy;
103 PROCEDURE insert_row(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_spnv_rec IN spnv_rec_type,
110 x_spnv_rec OUT NOCOPY spnv_rec_type);
111
112 PROCEDURE insert_row(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_spnv_tbl IN spnv_tbl_type,
119 x_spnv_tbl OUT NOCOPY spnv_tbl_type);
120
121 PROCEDURE lock_row(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_spnv_rec IN spnv_rec_type);
128
129 PROCEDURE lock_row(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_spnv_tbl IN spnv_tbl_type);
136
137 PROCEDURE update_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_spnv_rec IN spnv_rec_type,
144 x_spnv_rec OUT NOCOPY spnv_rec_type);
145
146 PROCEDURE update_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_spnv_tbl IN spnv_tbl_type,
153 x_spnv_tbl OUT NOCOPY spnv_tbl_type);
154
155 PROCEDURE delete_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_spnv_rec IN spnv_rec_type);
162
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_spnv_tbl IN spnv_tbl_type);
170
171 PROCEDURE validate_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_spnv_rec IN spnv_rec_type);
178
179 PROCEDURE validate_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_spnv_tbl IN spnv_tbl_type);
186
187 END OKC_SPN_PVT;