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.0 2005/05/25 18:15:47 appldev noship $ */
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 140: OKC_K_ART_VARIABLES_PVT.update_row(

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

Line 245: FROM okc_k_art_variables v,

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

Line 295: UPDATE okc_k_art_variables

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

Line 308: UPDATE okc_k_art_variables

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

Line 518: UPDATE okc_k_art_variables

514: -- Updating variable values
515:
516: IF NVL(p_override_global_yn,'N') = 'N' THEN
517: -- override local with global values
518: UPDATE okc_k_art_variables
519: SET variable_value = NVL(global_variable_value,p_variable_value),
520: variable_value_id = NVL(global_variable_value_id,p_variable_value_id),
521: override_global_yn = 'N',
522: object_version_number = object_version_number + 1

Line 528: UPDATE okc_k_art_variables

524: AND cat_id = p_cat_id ;
525:
526: ELSE
527: -- override global with local values
528: UPDATE okc_k_art_variables
529: SET variable_value = p_variable_value,
530: variable_value_id = p_variable_value_id,
531: override_global_yn = 'Y',
532: object_version_number = object_version_number + 1

Line 675: END OKC_K_ART_VARIABLES_GRP;

671: END update_response_var_values;
672:
673:
674:
675: END OKC_K_ART_VARIABLES_GRP;