[Home] [Help]
PACKAGE: APPS.OKL_SLX_PVT
Source
1 Package Okl_Slx_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSSLXS.pls 115.1 2002/02/06 20:35:37 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE slxv_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM
8 ,lpo_id NUMBER := Okc_Api.G_MISS_NUM
9 ,sty_id NUMBER := Okc_Api.G_MISS_NUM
10 ,object_version_number NUMBER := Okc_Api.G_MISS_NUM
11 ,late_policy_exempt_yn OKL_STRM_TYPE_EXEMPT_V.LATE_POLICY_EXEMPT_YN%TYPE := Okc_Api.G_MISS_CHAR
12 ,attribute_category OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR
13 ,attribute1 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR
14 ,attribute2 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR
15 ,attribute3 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR
16 ,attribute4 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR
17 ,attribute5 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR
18 ,attribute6 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR
19 ,attribute7 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR
20 ,attribute8 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR
21 ,attribute9 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR
22 ,attribute10 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR
23 ,attribute11 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR
24 ,attribute12 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR
25 ,attribute13 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR
26 ,attribute14 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR
27 ,attribute15 OKL_STRM_TYPE_EXEMPT_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR
28 ,created_by NUMBER := Okc_Api.G_MISS_NUM
29 ,creation_date OKL_STRM_TYPE_EXEMPT_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
30 ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
31 ,last_update_date OKL_STRM_TYPE_EXEMPT_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
32 ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
33 G_MISS_slxv_rec slxv_rec_type;
34 TYPE slxv_tbl_type IS TABLE OF slxv_rec_type
35 INDEX BY BINARY_INTEGER;
36 TYPE slx_rec_type IS RECORD (
37 id NUMBER := Okc_Api.G_MISS_NUM
38 ,lpo_id NUMBER := Okc_Api.G_MISS_NUM
39 ,sty_id NUMBER := Okc_Api.G_MISS_NUM
40 ,object_version_number NUMBER := Okc_Api.G_MISS_NUM
41 ,late_policy_exempt_yn OKL_STRM_TYPE_EXEMPT.LATE_POLICY_EXEMPT_YN%TYPE := Okc_Api.G_MISS_CHAR
42 ,attribute_category OKL_STRM_TYPE_EXEMPT.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR
43 ,attribute1 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR
44 ,attribute2 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR
45 ,attribute3 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR
46 ,attribute4 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR
47 ,attribute5 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR
48 ,attribute6 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR
49 ,attribute7 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR
50 ,attribute8 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR
51 ,attribute9 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR
52 ,attribute10 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR
53 ,attribute11 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR
54 ,attribute12 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR
55 ,attribute13 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR
56 ,attribute14 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR
57 ,attribute15 OKL_STRM_TYPE_EXEMPT.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR
58 ,created_by NUMBER := Okc_Api.G_MISS_NUM
59 ,creation_date OKL_STRM_TYPE_EXEMPT.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
60 ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
61 ,last_update_date OKL_STRM_TYPE_EXEMPT.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
62 ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
63 G_MISS_slx_rec slx_rec_type;
64 TYPE slx_tbl_type IS TABLE OF slx_rec_type
65 INDEX BY BINARY_INTEGER;
66 ---------------------------------------------------------------------------
67 -- GLOBAL MESSAGE CONSTANTS
68 ---------------------------------------------------------------------------
69 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
70 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
71 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
72 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
73 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
74 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
76 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
77 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
78 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
79 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
80 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
81 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
82
83 ---------------------------------------------------------------------------
84 -- GLOBAL EXCEPTIONS
85 ---------------------------------------------------------------------------
86 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
87
88 ---------------------------------------------------------------------------
89 -- GLOBAL VARIABLES
90 ---------------------------------------------------------------------------
91 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SLX_PVT';
92 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
93 ---------------------------------------------------------------------------
94 -- Procedures and Functions
95 ---------------------------------------------------------------------------
96
97 PROCEDURE qc;
98 PROCEDURE change_version;
99 PROCEDURE api_copy;
100 PROCEDURE insert_row(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_slxv_rec IN slxv_rec_type,
107 x_slxv_rec OUT NOCOPY slxv_rec_type);
108 PROCEDURE insert_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_slxv_tbl IN slxv_tbl_type,
115 x_slxv_tbl OUT NOCOPY slxv_tbl_type);
116 PROCEDURE lock_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_slxv_rec IN slxv_rec_type);
123 PROCEDURE lock_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_slxv_tbl IN slxv_tbl_type);
130 PROCEDURE update_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_slxv_rec IN slxv_rec_type,
137 x_slxv_rec OUT NOCOPY slxv_rec_type);
138 PROCEDURE update_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_slxv_tbl IN slxv_tbl_type,
145 x_slxv_tbl OUT NOCOPY slxv_tbl_type);
146 PROCEDURE delete_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_slxv_rec IN slxv_rec_type);
153 PROCEDURE delete_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_slxv_tbl IN slxv_tbl_type);
160 PROCEDURE validate_row(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_slxv_rec IN slxv_rec_type);
167 PROCEDURE validate_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_slxv_tbl IN slxv_tbl_type);
174 END Okl_Slx_Pvt;