APPS.OKC_K_ART_VARIABLES_GRP dependencies on OKC_K_ART_VARIABLES

Line 1: PACKAGE BODY OKC_K_ART_VARIABLES_GRP AS

1: PACKAGE BODY OKC_K_ART_VARIABLES_GRP AS
2: /* $Header: OKCGVARB.pls 120.1 2011/12/09 13:42:39 serukull ship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: ---------------------------------------------------------------------------

Line 12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ART_VARIABLES__GRP';

8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: ---------------------------------------------------------------------------
10: -- GLOBAL VARIABLES
11: ---------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ART_VARIABLES__GRP';
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
14:
15: ------------------------------------------------------------------------------
16: -- GLOBAL CONSTANTS

Line 56: FROM OKC_K_ART_VARIABLES

52: l_ovn NUMBER;
53:
54: Cursor l_get_art_var_csr IS
55: SELECT object_version_number
56: FROM OKC_K_ART_VARIABLES
57: WHERE cat_id=p_cat_id
58: AND variable_code=p_variable_code;
59:
60: BEGIN

Line 141: OKC_K_ART_VARIABLES_PVT.update_row(

137: IF (l_debug = 'Y') THEN
138: okc_debug.log('700: updating article variable record ',2);
139: END IF;
140:
141: OKC_K_ART_VARIABLES_PVT.update_row(
142: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
143: x_return_status => x_return_status,
144: p_cat_id => p_cat_id,
145: p_variable_code => p_variable_code,

Line 247: FROM okc_k_art_variables v,

243: l_ovn NUMBER;
244:
245: Cursor l_get_cat_id_csr IS
246: SELECT DISTINCT k.id
247: FROM okc_k_art_variables v,
248: okc_k_articles_b k
249: WHERE k.id = v.cat_id
250: AND NVL(v.override_global_yn,'N') <> 'Y'
251: AND v.variable_code = p_variable_code

Line 297: UPDATE okc_k_art_variables

293: x_return_status := FND_API.G_RET_STS_SUCCESS;
294:
295: -- Updating variable values
296:
297: UPDATE okc_k_art_variables
298: SET variable_value = p_global_variable_value,
299: variable_value_id = p_global_variable_value_id,
300: global_variable_value = p_global_variable_value,
301: global_variable_value_id = p_global_variable_value_id,

Line 310: UPDATE okc_k_art_variables

306: (SELECT id FROM okc_k_articles_b WHERE document_type = p_doc_type AND document_id = p_doc_id);
307:
308: -- Update the global value for all records with override_global_yn = Y
309:
310: UPDATE okc_k_art_variables
311: SET global_variable_value = p_global_variable_value,
312: global_variable_value_id = p_global_variable_value_id,
313: object_version_number = object_version_number + 1
314: WHERE variable_code = p_variable_code

Line 525: UPDATE okc_k_art_variables

521: -- Updating variable values
522:
523: IF NVL(p_override_global_yn,'N') = 'N' THEN
524: -- override local with global values
525: UPDATE okc_k_art_variables
526: SET variable_value = NVL(global_variable_value,p_variable_value),
527: variable_value_id = NVL(global_variable_value_id,p_variable_value_id),
528: override_global_yn = 'N',
529: object_version_number = object_version_number + 1

Line 535: UPDATE okc_k_art_variables

531: AND cat_id = p_cat_id ;
532:
533: ELSE
534: -- override global with local values
535: UPDATE okc_k_art_variables
536: SET variable_value = p_variable_value,
537: variable_value_id = p_variable_value_id,
538: override_global_yn = 'Y',
539: object_version_number = object_version_number + 1

Line 682: END OKC_K_ART_VARIABLES_GRP;

678: END update_response_var_values;
679:
680:
681:
682: END OKC_K_ART_VARIABLES_GRP;