[Home] [Help]
PACKAGE: APPS.OKC_CLS_PVT
Source
1 Package OKC_CLS_PVT AS
2 /* $Header: OKCSCLSS.pls 120.0 2005/05/25 22:30:19 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cls_rec_type IS RECORD (
7 code OKC_CLASSES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
8 fff_function_id NUMBER := OKC_API.G_MISS_NUM,
9 object_version_number NUMBER := OKC_API.G_MISS_NUM,
10 created_by NUMBER := OKC_API.G_MISS_NUM,
11 creation_date OKC_CLASSES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13 last_update_date OKC_CLASSES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14 last_update_login NUMBER := OKC_API.G_MISS_NUM,
15 application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
16 adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
17 g_miss_cls_rec cls_rec_type;
18 TYPE cls_tbl_type IS TABLE OF cls_rec_type
19 INDEX BY BINARY_INTEGER;
20 TYPE okc_classes_tl_rec_type IS RECORD (
21 code OKC_CLASSES_TL.CODE%TYPE := OKC_API.G_MISS_CHAR,
22 language OKC_CLASSES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
23 source_lang OKC_CLASSES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
24 sfwt_flag OKC_CLASSES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25 meaning OKC_CLASSES_TL.MEANING%TYPE := OKC_API.G_MISS_CHAR,
26 description OKC_CLASSES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27 created_by NUMBER := OKC_API.G_MISS_NUM,
28 creation_date OKC_CLASSES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
29 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
30 last_update_date OKC_CLASSES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31 last_update_login NUMBER := OKC_API.G_MISS_NUM);
32 g_miss_okc_classes_tl_rec okc_classes_tl_rec_type;
33 TYPE okc_classes_tl_tbl_type IS TABLE OF okc_classes_tl_rec_type
34 INDEX BY BINARY_INTEGER;
35 TYPE clsv_rec_type IS RECORD (
36 code OKC_CLASSES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
37 object_version_number NUMBER := OKC_API.G_MISS_NUM,
38 sfwt_flag OKC_CLASSES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39 fff_function_id NUMBER := OKC_API.G_MISS_NUM,
40 meaning OKC_CLASSES_V.MEANING%TYPE := OKC_API.G_MISS_CHAR,
41 description OKC_CLASSES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
42 created_by NUMBER := OKC_API.G_MISS_NUM,
43 creation_date OKC_CLASSES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45 last_update_date OKC_CLASSES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46 last_update_login NUMBER := OKC_API.G_MISS_NUM,
47 application_id OKC_CLASSES_V.APPLICATION_ID%TYPE :=OKC_API.G_MISS_NUM,
48 adv_search_form_function_id OKC_CLASSES_V.ADV_SEARCH_FORM_FUNCTION_ID%TYPE := OKC_API.G_MISS_NUM );
49 g_miss_clsv_rec clsv_rec_type;
50 TYPE clsv_tbl_type IS TABLE OF clsv_rec_type
51 INDEX BY BINARY_INTEGER;
52 ---------------------------------------------------------------------------
53 -- GLOBAL MESSAGE CONSTANTS
54 ---------------------------------------------------------------------------
55 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
56 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
57 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
58 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
59 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
60 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
61 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
62 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
63 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
64 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
65 ---------------------------------------------------------------------------
66 -- GLOBAL VARIABLES
67 ---------------------------------------------------------------------------
68 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CLS_PVT';
69 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
70 ---------------------------------------------------------------------------
71 -- Procedures and Functions
72 ---------------------------------------------------------------------------
73
74 PROCEDURE qc;
75 PROCEDURE change_version;
76 PROCEDURE api_copy;
77 PROCEDURE add_language;
78 PROCEDURE insert_row(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_clsv_rec IN clsv_rec_type,
85 x_clsv_rec OUT NOCOPY clsv_rec_type);
86
87 PROCEDURE insert_row(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_clsv_tbl IN clsv_tbl_type,
94 x_clsv_tbl OUT NOCOPY clsv_tbl_type);
95
96 PROCEDURE lock_row(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_clsv_rec IN clsv_rec_type);
103
104 PROCEDURE lock_row(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_clsv_tbl IN clsv_tbl_type);
111
112 PROCEDURE update_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_clsv_rec IN clsv_rec_type,
119 x_clsv_rec OUT NOCOPY clsv_rec_type);
120
121 PROCEDURE update_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_clsv_tbl IN clsv_tbl_type,
128 x_clsv_tbl OUT NOCOPY clsv_tbl_type);
129
130 PROCEDURE delete_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_clsv_rec IN clsv_rec_type);
137
138 PROCEDURE delete_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_clsv_tbl IN clsv_tbl_type);
145
146 PROCEDURE validate_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_clsv_rec IN clsv_rec_type);
153
154 PROCEDURE validate_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_clsv_tbl IN clsv_tbl_type);
161
162 END OKC_CLS_PVT;