[Home] [Help]
PACKAGE: APPS.OKL_OKC_MIGRATION_A_PVT
Source
1 Package OKL_OKC_MIGRATION_A_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLROMAS.pls 120.1 2005/08/03 19:22:58 manumanu noship $ */
3 G_API_TYPE VARCHAR2(10) := '_PVT';
4 --------------------------------------------------------------------------------------------
5 --ARTICLES
6 --------------------------------------------------------------------------------------------
7 TYPE catv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM,
9 chr_id NUMBER := OKC_API.G_MISS_NUM,
10 cle_id NUMBER := OKC_API.G_MISS_NUM,
11 cat_id NUMBER := OKC_API.G_MISS_NUM,
12 object_version_number NUMBER := OKC_API.G_MISS_NUM,
13 sfwt_flag OKC_K_ARTICLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
14 sav_sae_id NUMBER := OKC_API.G_MISS_NUM,
15 sav_sav_release OKC_K_ARTICLES_B.SAV_SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR,
16 sbt_code OKC_K_ARTICLES_B.SBT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18 comments OKC_K_ARTICLES_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
19 fulltext_yn OKC_K_ARTICLES_B.FULLTEXT_YN%TYPE := OKC_API.G_MISS_CHAR,
20 variation_description OKC_K_ARTICLES_TL.VARIATION_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
21 name OKC_K_ARTICLES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
22 -- text ... commented out to treat empty CLOB as an of empty content:
23 -- if need to nullify it then nullify contents, not the pointer
24 -- text OKC_K_ARTICLES_TL.TEXT%TYPE := OKC_API.G_MISS_CHAR,
25 attribute_category OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26 attribute1 OKC_K_ARTICLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27 attribute2 OKC_K_ARTICLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28 attribute3 OKC_K_ARTICLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29 attribute4 OKC_K_ARTICLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30 attribute5 OKC_K_ARTICLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31 attribute6 OKC_K_ARTICLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32 attribute7 OKC_K_ARTICLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33 attribute8 OKC_K_ARTICLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34 attribute9 OKC_K_ARTICLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35 attribute10 OKC_K_ARTICLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36 attribute11 OKC_K_ARTICLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37 attribute12 OKC_K_ARTICLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38 attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39 attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40 attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41 cat_type OKC_K_ARTICLES_B.CAT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
42 created_by NUMBER := OKC_API.G_MISS_NUM,
43 creation_date OKC_K_ARTICLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
44 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
45 last_update_date OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46 last_update_login NUMBER := OKC_API.G_MISS_NUM);
47 g_miss_catv_rec catv_rec_type;
48 TYPE catv_tbl_type IS TABLE OF catv_rec_type
49 INDEX BY BINARY_INTEGER;
50
51 --------------------------------------------------------------------------------------------
52 --RULE GROUPS
53 --------------------------------------------------------------------------------------------
54 TYPE rgpv_rec_type IS RECORD (
55 id NUMBER := OKC_API.G_MISS_NUM,
56 object_version_number NUMBER := OKC_API.G_MISS_NUM,
57 sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58 rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59 sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60 rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61 cle_id NUMBER := OKC_API.G_MISS_NUM,
62 chr_id NUMBER := OKC_API.G_MISS_NUM,
63 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64 parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65 comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66 attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67 attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68 attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69 attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70 attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71 attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72 attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73 attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74 attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75 attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76 attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77 attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78 attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79 attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80 attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81 attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82 created_by NUMBER := OKC_API.G_MISS_NUM,
83 creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85 last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86 last_update_login NUMBER := OKC_API.G_MISS_NUM);
87 TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
88 INDEX BY BINARY_INTEGER;
89
90 --------------------------------------------------------------------------------------------
91 --QA CHECK
92 --------------------------------------------------------------------------------------------
93 TYPE qa_msg_rec_type IS RECORD (
94 severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE,
95 name OKC_PROCESS_DEFS_V.NAME%TYPE,
96 description OKC_PROCESS_DEFS_V.DESCRIPTION%TYPE,
97 package_name OKC_PROCESS_DEFS_V.PACKAGE_NAME%TYPE,
98 procedure_name OKC_PROCESS_DEFS_V.PROCEDURE_NAME%TYPE,
99 error_status VARCHAR2(1),
100 data VARCHAR2(2000));
101
102 TYPE qa_msg_tbl_type IS TABLE OF qa_msg_rec_type
103 INDEX BY BINARY_INTEGER;
104
105
106 subtype msg_tbl_type is qa_msg_tbl_type;
107 --------------------------------------------------------------------------------------------
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_catv_rec IN catv_rec_type,
115 x_catv_rec OUT NOCOPY catv_rec_type);
116
117 PROCEDURE update_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_catv_rec IN catv_rec_type,
124 x_catv_rec OUT NOCOPY catv_rec_type);
125
126 PROCEDURE delete_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_catv_rec IN catv_rec_type);
133
134 ----------------------------------------------------------------------------------
135 -- INSERT for OKC_RGP_PVT
136 PROCEDURE insert_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_rgpv_rec IN rgpv_rec_type,
143 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
144 -- UPDATE for OKC_RGP_PVT
145 PROCEDURE update_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_rgpv_rec IN rgpv_rec_type,
152 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
153 -- DELETE for OKC_RGP_PVT
154 PROCEDURE delete_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_rgpv_rec IN rgpv_rec_type);
161 ----------------------------------------------------------------------------------
162 -- QA CHECK LIST
163 PROCEDURE execute_qa_check_list(
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_qcl_id IN NUMBER,
170 p_chr_id IN NUMBER,
171 x_msg_tbl OUT NOCOPY msg_tbl_type);
172
173 FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2;
174
175 END; -- Package Specification OKL_OKC_MIGRATION_A_PVT