eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKC_TERMS_COPY_PVT dependencies on OKC_K_ART_VARIABLES

Line 64: FROM okc_k_art_variables var

60: SELECT var.variable_value,
61: var.variable_value_id
62: , VAR.MR_VARIABLE_HTML
63: , VAR.MR_VARIABLE_XML
64: FROM okc_k_art_variables var
65: WHERE var.cat_id = p_cat_id
66: AND var.variable_code = p_variable_code;
67:
68: l_standard_flag VARCHAR2(1);

Line 70: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;

66: AND var.variable_code = p_variable_code;
67:
68: l_standard_flag VARCHAR2(1);
69: l_id1 VARCHAR2(2000);
70: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;
71: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;
72:
73: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);
74: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);

Line 71: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;

67:
68: l_standard_flag VARCHAR2(1);
69: l_id1 VARCHAR2(2000);
70: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;
71: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;
72:
73: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);
74: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);
75:

Line 73: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);

69: l_id1 VARCHAR2(2000);
70: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;
71: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;
72:
73: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);
74: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);
75:
76: BEGIN
77: OPEN csr_orig_target_dtls;

Line 74: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);

70: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;
71: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;
72:
73: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);
74: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);
75:
76: BEGIN
77: OPEN csr_orig_target_dtls;
78: FETCH csr_orig_target_dtls INTO l_id1;

Line 115: FROM OKC_K_ART_VARIABLES VAR

111: WHERE id = p_cat_id;
112:
113: CURSOR csr_source_value_id(p_cat_id IN NUMBER,p_variable_code IN VARCHAR2) IS
114: SELECT VAR.VARIABLE_VALUE_ID
115: FROM OKC_K_ART_VARIABLES VAR
116: WHERE VAR.CAT_ID = p_cat_id
117: AND VAR.VARIABLE_CODE = p_variable_code;
118:
119: l_standard_flag VARCHAR2(1);

Line 167: FROM okc_k_art_variables var

163: SELECT var.variable_value,
164: var.variable_value_id
165: -- , VAR.MR_VARIABLE_HTML
166: -- , VAR.MR_VARIABLE_XML
167: FROM okc_k_art_variables var
168: WHERE var.cat_id = p_cat_id
169: AND var.variable_code = p_variable_code;
170:
171: l_standard_flag VARCHAR2(1);

Line 173: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;

169: AND var.variable_code = p_variable_code;
170:
171: l_standard_flag VARCHAR2(1);
172: l_id1 VARCHAR2(2000);
173: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;
174: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;
175:
176: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);
177: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);

Line 174: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;

170:
171: l_standard_flag VARCHAR2(1);
172: l_id1 VARCHAR2(2000);
173: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;
174: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;
175:
176: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);
177: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);
178:

Line 176: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);

172: l_id1 VARCHAR2(2000);
173: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;
174: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;
175:
176: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);
177: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);
178:
179: BEGIN
180: OPEN csr_orig_target_dtls;

Line 177: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);

173: l_var_value_id okc_k_art_variables.variable_value_id%TYPE := NULL;
174: l_var_value okc_k_art_variables.variable_value%TYPE := NULL;
175:
176: l_MR_VARIABLE_HTML okc_k_art_variables.mr_variable_html%TYPE := to_clob(NULL);
177: l_MR_VARIABLE_XML okc_k_art_variables.mr_variable_xml%TYPE := to_clob(NULL);
178:
179: BEGIN
180: OPEN csr_orig_target_dtls;
181: FETCH csr_orig_target_dtls INTO l_id1;

Line 224: FROM OKC_K_ART_VARIABLES VAR

220: WHERE id = p_cat_id;
221:
222: CURSOR csr_source_value(p_cat_id IN NUMBER,p_variable_code IN VARCHAR2) IS
223: SELECT VAR.VARIABLE_VALUE
224: FROM OKC_K_ART_VARIABLES VAR
225: WHERE VAR.CAT_ID = p_cat_id
226: AND VAR.VARIABLE_CODE = p_variable_code;
227:
228: l_standard_flag VARCHAR2(1);

Line 357: ,(SELECT src.mr_variable_html FROM okc_k_art_variables src WHERE src.cat_id= KART.orig_system_reference_id1 AND src. variable_code = VAR.variable_code)

353: DECODE(p_keep_orig_ref,'Y',
354: get_orig_var_val_xml(
355: KART.ID,VAR.VARIABLE_CODE,
356: P_SOURCE_DOC_ID,P_SOURCE_DOC_TYPE,'HTML')
357: ,(SELECT src.mr_variable_html FROM okc_k_art_variables src WHERE src.cat_id= KART.orig_system_reference_id1 AND src. variable_code = VAR.variable_code)
358: )
359: ,to_clob(NULL)) mr_variable_html,
360: Decode(Nvl(BUSVAR.mrv_flag,'N'), 'Y', DECODE(p_keep_orig_ref,
361: 'Y',get_orig_var_val_xml(

Line 364: ,(SELECT src.mr_variable_xml FROM okc_k_art_variables src WHERE src.cat_id= KART.orig_system_reference_id1 AND src.variable_code = VAR.variable_code)

360: Decode(Nvl(BUSVAR.mrv_flag,'N'), 'Y', DECODE(p_keep_orig_ref,
361: 'Y',get_orig_var_val_xml(
362: KART.ID,VAR.VARIABLE_CODE,
363: P_SOURCE_DOC_ID,P_SOURCE_DOC_TYPE,'XML')
364: ,(SELECT src.mr_variable_xml FROM okc_k_art_variables src WHERE src.cat_id= KART.orig_system_reference_id1 AND src.variable_code = VAR.variable_code)
365: )
366: ,to_clob(NULL)) mr_variable_xml,
367:
368: Decode(Nvl(BUSVAR.mrv_flag,'N'), 'Y', DECODE(p_keep_orig_ref,

Line 382: AND not exists ( select 'x' from okc_k_art_variables where cat_id=kart.id);

378: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
379: AND KART.DOCUMENT_TYPE=p_target_doc_type
380: AND KART.DOCUMENT_ID=p_target_doc_id
381: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE
382: AND not exists ( select 'x' from okc_k_art_variables where cat_id=kart.id);
383:
384: -- This cursor will get variable code and values fromr okc_k_art_variables
385: CURSOR l_get_variables_csr IS
386: SELECT KART.ID CAT_ID,

Line 384: -- This cursor will get variable code and values fromr okc_k_art_variables

380: AND KART.DOCUMENT_ID=p_target_doc_id
381: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE
382: AND not exists ( select 'x' from okc_k_art_variables where cat_id=kart.id);
383:
384: -- This cursor will get variable code and values fromr okc_k_art_variables
385: CURSOR l_get_variables_csr IS
386: SELECT KART.ID CAT_ID,
387: VAR.VARIABLE_CODE,
388: BUSVAR.VARIABLE_TYPE,

Line 397: FROM OKC_K_ART_VARIABLES VAR,

393: VAR.OVERRIDE_GLOBAL_YN,
394: VAR.mr_variable_html,
395: VAR.mr_variable_xml,
396: KART1.cat_id SourceCatId
397: FROM OKC_K_ART_VARIABLES VAR,
398: OKC_K_ARTICLES_B KART,
399: OKC_K_ARTICLES_B KART1,
400: OKC_BUS_VARIABLES_B BUSVAR
401: WHERE KART.DOCUMENT_TYPE=p_target_doc_type

Line 423: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;

419: )
420: )
421: );
422:
423: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
424: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
425: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;

Line 424: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;

420: )
421: );
422:
423: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
424: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
425: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 425: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;

421: );
422:
423: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
424: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
425: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;

422:
423: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
424: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
425: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
430: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;

Line 427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;

423: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
424: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
425: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
430: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
431: TYPE mrvariablehtmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;

Line 428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;

424: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
425: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
430: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
431: TYPE mrvariablehtmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
432: TYPE mrvariablexmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;

Line 429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;

425: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
430: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
431: TYPE mrvariablehtmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
432: TYPE mrvariablexmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;
433:

Line 430: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;

426: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
430: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
431: TYPE mrvariablehtmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
432: TYPE mrvariablexmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;
433:
434: cat_tbl CatList;

Line 431: TYPE mrvariablehtmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;

427: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
430: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
431: TYPE mrvariablehtmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
432: TYPE mrvariablexmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;
433:
434: cat_tbl CatList;
435: var_tbl VarList;

Line 432: TYPE mrvariablexmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;

428: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
429: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
430: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
431: TYPE mrvariablehtmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
432: TYPE mrvariablexmlList IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;
433:
434: cat_tbl CatList;
435: var_tbl VarList;
436: var_type_tbl VarTypeList;

Line 497: INSERT INTO OKC_K_ART_VARIABLES(cat_id,

493:
494: -- Bulk inserting
495: IF cat_tbl.COUNT>0 THEN
496: FORALL i IN cat_tbl.FIRST..cat_tbl.LAST
497: INSERT INTO OKC_K_ART_VARIABLES(cat_id,
498: variable_code,
499: variable_type,
500: external_yn,
501: attribute_value_set_id,

Line 2252: SELECT ROWID FROM OKC_K_ART_VARIABLES

2248: AND DOCUMENT_ID = p_doc_id
2249: AND SOURCE_FLAG IS NULL FOR UPDATE NOWAIT;
2250:
2251: CURSOR lock_var_for_del_csr IS
2252: SELECT ROWID FROM OKC_K_ART_VARIABLES
2253: WHERE CAT_ID IN
2254: (SELECT ID FROM OKC_K_ARTICLES_B
2255: WHERE DOCUMENT_TYPE=p_doc_type
2256: AND DOCUMENT_ID=p_doc_id

Line 2365: , OKC_K_ART_VARIABLES KVAR

2361:
2362: DELETE FROM OKC_K_ART_VAR_EXT_B WHERE cat_id IN ( SELECT kart.ID
2363: FROM OKC_K_ARTICLES_B KART
2364: , OKC_BUS_VARIABLES_B BUS_VAR
2365: , OKC_K_ART_VARIABLES KVAR
2366: WHERE kart.document_type=p_doc_type
2367: AND kart.document_id = p_doc_id
2368: AND kart.SOURCE_FLAG IS NOT NULL
2369: AND KVAR.cat_id=kart.id

Line 2373: DELETE FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN

2369: AND KVAR.cat_id=kart.id
2370: AND KVAR.variable_code=BUS_VAR.variable_code
2371: AND BUS_VAR.MRV_FLAG='Y');
2372:
2373: DELETE FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN
2374: (SELECT ID FROM OKC_K_ARTICLES_B WHERE DOCUMENT_TYPE=p_doc_type
2375: AND DOCUMENT_ID=p_doc_id
2376: AND SOURCE_FLAG IS NOT NULL);
2377: OPEN lock_kart_for_del_csr;

Line 3832: FROM OKC_K_ART_VARIABLES_H VAR,

3828: VAR.OVERRIDE_GLOBAL_YN,
3829: VAR.MR_VARIABLE_HTML,
3830: VAR.MR_VARIABLE_XML,
3831: BUS_VAR.MRV_FLAG
3832: FROM OKC_K_ART_VARIABLES_H VAR,
3833: OKC_K_ARTICLES_B KART,
3834: OKC_K_ARTICLES_BH KART1,
3835: OKC_BUS_VARIABLES_B BUS_VAR
3836: WHERE KART.ORIG_SYSTEM_REFERENCE_ID1=KART1.ID

Line 3846: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;

3842: AND KART1.MAJOR_VERSION = p_source_version_number
3843: AND KART.ORIG_SYSTEM_REFERENCE_CODE=G_COPY
3844: AND VAR.MAJOR_VERSION = p_source_version_number;
3845:
3846: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
3847: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
3848: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;

Line 3847: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;

3843: AND KART.ORIG_SYSTEM_REFERENCE_CODE=G_COPY
3844: AND VAR.MAJOR_VERSION = p_source_version_number;
3845:
3846: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
3847: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
3848: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 3848: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;

3844: AND VAR.MAJOR_VERSION = p_source_version_number;
3845:
3846: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
3847: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
3848: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;

3845:
3846: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
3847: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
3848: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
3853: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;

Line 3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;

3846: TYPE CatList IS TABLE OF OKC_K_ART_VARIABLES.CAT_ID%TYPE INDEX BY BINARY_INTEGER;
3847: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
3848: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
3853: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
3854: TYPE mrvariablehtml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;

Line 3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;

3847: TYPE VarList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE INDEX BY BINARY_INTEGER;
3848: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
3853: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
3854: TYPE mrvariablehtml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
3855: TYPE mrvariablexml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;

Line 3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;

3848: TYPE VarTypeList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE INDEX BY BINARY_INTEGER;
3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
3853: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
3854: TYPE mrvariablehtml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
3855: TYPE mrvariablexml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;
3856: TYPE MRVFLAG IS TABLE OF OKC_BUS_VARIABLES_B.MRV_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 3853: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;

3849: TYPE ExternalList IS TABLE OF OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE INDEX BY BINARY_INTEGER;
3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
3853: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
3854: TYPE mrvariablehtml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
3855: TYPE mrvariablexml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;
3856: TYPE MRVFLAG IS TABLE OF OKC_BUS_VARIABLES_B.MRV_FLAG%TYPE INDEX BY BINARY_INTEGER;
3857:

Line 3854: TYPE mrvariablehtml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;

3850: TYPE ValSetList IS TABLE OF OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE INDEX BY BINARY_INTEGER;
3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
3853: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
3854: TYPE mrvariablehtml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
3855: TYPE mrvariablexml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;
3856: TYPE MRVFLAG IS TABLE OF OKC_BUS_VARIABLES_B.MRV_FLAG%TYPE INDEX BY BINARY_INTEGER;
3857:
3858: cat_tbl CatList;

Line 3855: TYPE mrvariablexml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;

3851: TYPE VarValList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
3852: TYPE VarIdList IS TABLE OF OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE INDEX BY BINARY_INTEGER;
3853: TYPE OverrideGlobalYnList IS TABLE OF OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE INDEX BY BINARY_INTEGER;
3854: TYPE mrvariablehtml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_html%TYPE INDEX BY BINARY_INTEGER;
3855: TYPE mrvariablexml IS TABLE OF OKC_K_ART_VARIABLES.mr_variable_xml%TYPE INDEX BY BINARY_INTEGER;
3856: TYPE MRVFLAG IS TABLE OF OKC_BUS_VARIABLES_B.MRV_FLAG%TYPE INDEX BY BINARY_INTEGER;
3857:
3858: cat_tbl CatList;
3859: var_tbl VarList;

Line 4036: INSERT INTO OKC_K_ART_VARIABLES(cat_id,

4032:
4033: -- Bulk inserting
4034: IF cat_tbl.COUNT > 0 THEN
4035: FORALL i IN cat_tbl.FIRST..cat_tbl.LAST
4036: INSERT INTO OKC_K_ART_VARIABLES(cat_id,
4037: variable_code,
4038: variable_type,
4039: external_yn,
4040: attribute_value_set_id,

Line 4073: OKC_K_ART_VARIABLES_PVT.restore_mrv_uda_data_version(cat_tbl(i),p_source_version_number);

4069:
4070: FOR i IN cat_tbl.FIRST..cat_tbl.LAST
4071: LOOP
4072: IF MRV_flag_tbl(i) = 'Y' THEN
4073: OKC_K_ART_VARIABLES_PVT.restore_mrv_uda_data_version(cat_tbl(i),p_source_version_number);
4074: END IF;
4075: END LOOP;
4076: END IF;
4077: