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.

APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_K_ART_VARIABLES

Line 1: PACKAGE BODY OKC_K_ART_VARIABLES_PVT AS

1: PACKAGE BODY OKC_K_ART_VARIABLES_PVT AS
2: /* $Header: OKCVVARB.pls 120.6 2011/12/09 13:54:06 serukull ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ART_VARIABLES_PVT';

26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ART_VARIABLES_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS

Line 64: -- FUNCTION get_rec for: OKC_K_ART_VARIABLES

60:
61: PROCEDURE create_mrv_uda_data_version(p_cat_id IN NUMBER, p_major_version IN NUMBER);
62:
63: ---------------------------------------------------------------------------
64: -- FUNCTION get_rec for: OKC_K_ART_VARIABLES
65: ---------------------------------------------------------------------------
66: FUNCTION Get_Rec (
67: p_cat_id IN NUMBER,
68: p_variable_code IN VARCHAR2,

Line 83: CURSOR OKC_K_ART_VARIABLES_pk_csr (cp_cat_id IN NUMBER,cp_variable_code IN VARCHAR2) IS

79: x_last_update_login OUT NOCOPY NUMBER,
80: x_last_update_date OUT NOCOPY DATE
81:
82: ) RETURN VARCHAR2 IS
83: CURSOR OKC_K_ART_VARIABLES_pk_csr (cp_cat_id IN NUMBER,cp_variable_code IN VARCHAR2) IS
84: SELECT
85: VARIABLE_TYPE,
86: EXTERNAL_YN,
87: VARIABLE_VALUE_ID,

Line 97: FROM OKC_K_ART_VARIABLES t

93: CREATION_DATE,
94: LAST_UPDATED_BY,
95: LAST_UPDATE_LOGIN,
96: LAST_UPDATE_DATE
97: FROM OKC_K_ART_VARIABLES t
98: WHERE t.CAT_ID = cp_cat_id and
99: t.VARIABLE_CODE = cp_variable_code;
100: BEGIN
101:

Line 112: OPEN OKC_K_ART_VARIABLES_pk_csr (p_cat_id, p_variable_code);

108: G_PKG_NAME, '400: Entered get_rec' );
109: END IF;
110:
111: -- Get current database values
112: OPEN OKC_K_ART_VARIABLES_pk_csr (p_cat_id, p_variable_code);
113: FETCH OKC_K_ART_VARIABLES_pk_csr INTO
114: x_variable_type,
115: x_external_yn,
116: x_variable_value_id,

Line 113: FETCH OKC_K_ART_VARIABLES_pk_csr INTO

109: END IF;
110:
111: -- Get current database values
112: OPEN OKC_K_ART_VARIABLES_pk_csr (p_cat_id, p_variable_code);
113: FETCH OKC_K_ART_VARIABLES_pk_csr INTO
114: x_variable_type,
115: x_external_yn,
116: x_variable_value_id,
117: x_variable_value,

Line 126: IF OKC_K_ART_VARIABLES_pk_csr%NOTFOUND THEN

122: x_creation_date,
123: x_last_updated_by,
124: x_last_update_login,
125: x_last_update_date;
126: IF OKC_K_ART_VARIABLES_pk_csr%NOTFOUND THEN
127: RAISE NO_DATA_FOUND;
128: END IF;
129: CLOSE OKC_K_ART_VARIABLES_pk_csr;
130:

Line 129: CLOSE OKC_K_ART_VARIABLES_pk_csr;

125: x_last_update_date;
126: IF OKC_K_ART_VARIABLES_pk_csr%NOTFOUND THEN
127: RAISE NO_DATA_FOUND;
128: END IF;
129: CLOSE OKC_K_ART_VARIABLES_pk_csr;
130:
131: /*IF (l_debug = 'Y') THEN
132: Okc_Debug.Log('500: Leaving get_rec ', 2);
133: END IF;*/

Line 161: IF OKC_K_ART_VARIABLES_pk_csr%ISOPEN THEN

157: p_token1_value => sqlcode,
158: p_token2 => G_SQLERRM_TOKEN,
159: p_token2_value => sqlerrm);
160:
161: IF OKC_K_ART_VARIABLES_pk_csr%ISOPEN THEN
162: CLOSE OKC_K_ART_VARIABLES_pk_csr;
163: END IF;
164:
165: RETURN G_RET_STS_UNEXP_ERROR ;

Line 162: CLOSE OKC_K_ART_VARIABLES_pk_csr;

158: p_token2 => G_SQLERRM_TOKEN,
159: p_token2_value => sqlerrm);
160:
161: IF OKC_K_ART_VARIABLES_pk_csr%ISOPEN THEN
162: CLOSE OKC_K_ART_VARIABLES_pk_csr;
163: END IF;
164:
165: RETURN G_RET_STS_UNEXP_ERROR ;
166:

Line 170: -- Set_Attributes for:OKC_K_ART_VARIABLES --

166:
167: END Get_Rec;
168:
169: -----------------------------------------
170: -- Set_Attributes for:OKC_K_ART_VARIABLES --
171: -----------------------------------------
172: FUNCTION Set_Attributes(
173: p_cat_id IN NUMBER,
174: p_variable_code IN VARCHAR2,

Line 192: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

188: x_attribute_value_set_id OUT NOCOPY NUMBER,
189: x_override_global_yn OUT NOCOPY VARCHAR2
190: ) RETURN VARCHAR2 IS
191: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
192: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
193: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
194: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
195: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
196: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

Line 193: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

189: x_override_global_yn OUT NOCOPY VARCHAR2
190: ) RETURN VARCHAR2 IS
191: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
192: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
193: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
194: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
195: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
196: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
197: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

Line 194: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

190: ) RETURN VARCHAR2 IS
191: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
192: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
193: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
194: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
195: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
196: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
197: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
198: BEGIN

Line 195: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

191: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
192: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
193: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
194: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
195: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
196: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
197: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
198: BEGIN
199: /*IF (l_debug = 'Y') THEN

Line 196: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

192: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
193: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
194: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
195: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
196: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
197: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
198: BEGIN
199: /*IF (l_debug = 'Y') THEN
200: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 197: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

193: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
194: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
195: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
196: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
197: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
198: BEGIN
199: /*IF (l_debug = 'Y') THEN
200: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
201: END IF;*/

Line 328: -- Validate_Attributes for: OKC_K_ART_VARIABLES --

324:
325: END Set_Attributes ;
326:
327: ----------------------------------------------
328: -- Validate_Attributes for: OKC_K_ART_VARIABLES --
329: ----------------------------------------------
330: FUNCTION Validate_Attributes (
331: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332:

Line 693: -- Validate_Record for:OKC_K_ART_VARIABLES --

689: -- PROCEDURE Validate_Record
690: -- It calls Item Level Validations and then makes Record Level Validations
691: ---------------------------------------------------------------------------
692: ------------------------------------------
693: -- Validate_Record for:OKC_K_ART_VARIABLES --
694: ------------------------------------------
695: FUNCTION Validate_Record (
696: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
697:

Line 799: -- validate_row for:OKC_K_ART_VARIABLES --

795: ---------------------------------------------------------------------------
796: -- PROCEDURE validate_row
797: ---------------------------------------------------------------------------
798: ---------------------------------------
799: -- validate_row for:OKC_K_ART_VARIABLES --
800: ---------------------------------------
801: PROCEDURE validate_row(
802: p_validation_level IN NUMBER,
803: x_return_status OUT NOCOPY VARCHAR2,

Line 815: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;

811: p_override_global_yn IN VARCHAR2,
812:
813: p_object_version_number IN NUMBER
814: ) IS
815: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
816: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
817: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;

Line 816: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;

812:
813: p_object_version_number IN NUMBER
814: ) IS
815: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
816: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
817: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;

Line 817: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;

813: p_object_version_number IN NUMBER
814: ) IS
815: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
816: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
817: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

Line 818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;

814: ) IS
815: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
816: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
817: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

Line 819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;

815: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
816: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
817: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

Line 820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;

816: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
817: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
824: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

Line 821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

817: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
824: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
825: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

Line 822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

818: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
824: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
825: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
826: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

Line 823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

819: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
824: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
825: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
826: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
827: BEGIN

Line 824: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

820: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
824: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
825: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
826: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
827: BEGIN
828:

Line 825: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

821: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
824: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
825: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
826: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
827: BEGIN
828:
829: /*IF (l_debug = 'Y') THEN

Line 826: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

822: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
823: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
824: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
825: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
826: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
827: BEGIN
828:
829: /*IF (l_debug = 'Y') THEN
830: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 931: -- Insert_Row for:OKC_K_ART_VARIABLES --

927: ---------------------------------------------------------------------------
928: -- PROCEDURE Insert_Row
929: ---------------------------------------------------------------------------
930: -------------------------------------
931: -- Insert_Row for:OKC_K_ART_VARIABLES --
932: -------------------------------------
933: FUNCTION Insert_Row(
934: p_cat_id IN NUMBER,
935: p_variable_code IN VARCHAR2,

Line 963: INSERT INTO OKC_K_ART_VARIABLES(

959: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
960: FND_LOG.STRING(G_PROC_LEVEL,
961: G_PKG_NAME, '3600: Entered Insert_Row function' );
962: END IF;
963: INSERT INTO OKC_K_ART_VARIABLES(
964: CAT_ID,
965: VARIABLE_CODE,
966: VARIABLE_TYPE,
967: EXTERNAL_YN,

Line 1034: -- Insert_Row for:OKC_K_ART_VARIABLES --

1030: END Insert_Row;
1031:
1032:
1033: -------------------------------------
1034: -- Insert_Row for:OKC_K_ART_VARIABLES --
1035: -------------------------------------
1036: PROCEDURE Insert_Row(
1037: p_validation_level IN NUMBER,
1038: x_return_status OUT NOCOPY VARCHAR2,

Line 1054: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

1050: x_variable_code OUT NOCOPY VARCHAR2
1051:
1052: ) IS
1053:
1054: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1055: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1056: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1057: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1058: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

Line 1055: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

1051:
1052: ) IS
1053:
1054: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1055: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1056: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1057: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1058: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1059: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

Line 1056: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

1052: ) IS
1053:
1054: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1055: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1056: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1057: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1058: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1059: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1060: BEGIN

Line 1057: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

1053:
1054: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1055: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1056: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1057: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1058: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1059: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1060: BEGIN
1061:

Line 1058: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

1054: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1055: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1056: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1057: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1058: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1059: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1060: BEGIN
1061:
1062: x_return_status := G_RET_STS_SUCCESS;

Line 1059: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

1055: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1056: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1057: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1058: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1059: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1060: BEGIN
1061:
1062: x_return_status := G_RET_STS_SUCCESS;
1063:

Line 1193: -- Lock_Row for:OKC_K_ART_VARIABLES --

1189: ---------------------------------------------------------------------------
1190: -- PROCEDURE Lock_Row
1191: ---------------------------------------------------------------------------
1192: -----------------------------------
1193: -- Lock_Row for:OKC_K_ART_VARIABLES --
1194: -----------------------------------
1195: FUNCTION Lock_Row(
1196: p_cat_id IN NUMBER,
1197: p_variable_code IN VARCHAR2,

Line 1204: FROM OKC_K_ART_VARIABLES

1200:
1201:
1202: CURSOR lock_csr (cp_cat_id NUMBER, cp_variable_code VARCHAR2, cp_object_version_number NUMBER) IS
1203: SELECT object_version_number
1204: FROM OKC_K_ART_VARIABLES
1205: WHERE CAT_ID = cp_cat_id AND VARIABLE_CODE = cp_variable_code
1206: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1207: FOR UPDATE OF object_version_number NOWAIT;
1208:

Line 1211: FROM OKC_K_ART_VARIABLES

1207: FOR UPDATE OF object_version_number NOWAIT;
1208:
1209: CURSOR lchk_csr (cp_cat_id NUMBER, cp_variable_code VARCHAR2) IS
1210: SELECT object_version_number
1211: FROM OKC_K_ART_VARIABLES
1212: WHERE CAT_ID = cp_cat_id AND VARIABLE_CODE = cp_variable_code;
1213:
1214: l_return_status VARCHAR2(1);
1215:

Line 1216: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

1212: WHERE CAT_ID = cp_cat_id AND VARIABLE_CODE = cp_variable_code;
1213:
1214: l_return_status VARCHAR2(1);
1215:
1216: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1217:
1218: l_row_notfound BOOLEAN := FALSE;
1219: BEGIN
1220:

Line 1318: -- Lock_Row for:OKC_K_ART_VARIABLES --

1314: RETURN( G_RET_STS_UNEXP_ERROR );
1315: END Lock_Row;
1316:
1317: -----------------------------------
1318: -- Lock_Row for:OKC_K_ART_VARIABLES --
1319: -----------------------------------
1320: PROCEDURE Lock_Row(
1321: x_return_status OUT NOCOPY VARCHAR2,
1322:

Line 1411: -- Update_Row for:OKC_K_ART_VARIABLES --

1407: ---------------------------------------------------------------------------
1408: -- PROCEDURE Update_Row
1409: ---------------------------------------------------------------------------
1410: -------------------------------------
1411: -- Update_Row for:OKC_K_ART_VARIABLES --
1412: -------------------------------------
1413: FUNCTION Update_Row(
1414: p_cat_id IN NUMBER,
1415: p_variable_code IN VARCHAR2,

Line 1441: UPDATE OKC_K_ART_VARIABLES

1437: FND_LOG.STRING(G_PROC_LEVEL,
1438: G_PKG_NAME, '6400: Entered Update_Row' );
1439: END IF;
1440:
1441: UPDATE OKC_K_ART_VARIABLES
1442: SET VARIABLE_TYPE = p_variable_type,
1443: EXTERNAL_YN = p_external_yn,
1444: VARIABLE_VALUE_ID = p_variable_value_id,
1445: VARIABLE_VALUE = p_variable_value,

Line 1490: -- Update_Row for:OKC_K_ART_VARIABLES --

1486:
1487: END Update_Row;
1488:
1489: -------------------------------------
1490: -- Update_Row for:OKC_K_ART_VARIABLES --
1491: -------------------------------------
1492: PROCEDURE Update_Row(
1493: p_validation_level IN NUMBER,
1494: x_return_status OUT NOCOPY VARCHAR2,

Line 1509: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;

1505: p_object_version_number IN NUMBER
1506:
1507: ) IS
1508:
1509: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1510: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1511: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;

Line 1510: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;

1506:
1507: ) IS
1508:
1509: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1510: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1511: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;

Line 1511: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;

1507: ) IS
1508:
1509: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1510: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1511: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

Line 1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;

1508:
1509: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1510: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1511: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

Line 1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;

1509: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1510: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1511: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

Line 1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;

1510: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1511: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1518: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

Line 1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

1511: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1518: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1519: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

Line 1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

1512: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1518: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1519: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1520: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

Line 1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

1513: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1518: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1519: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1520: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1521:

Line 1518: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

1514: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1518: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1519: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1520: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1521:
1522: BEGIN

Line 1519: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

1515: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1518: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1519: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1520: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1521:
1522: BEGIN
1523:

Line 1520: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

1516: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1517: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1518: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1519: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1520: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1521:
1522: BEGIN
1523:
1524: /*IF (l_debug = 'Y') THEN

Line 1720: -- Delete_Row for:OKC_K_ART_VARIABLES --

1716: ---------------------------------------------------------------------------
1717: -- PROCEDURE Delete_Row
1718: ---------------------------------------------------------------------------
1719: -------------------------------------
1720: -- Delete_Row for:OKC_K_ART_VARIABLES --
1721: -------------------------------------
1722: FUNCTION Delete_Row(
1723: p_cat_id IN NUMBER,
1724: p_variable_code IN VARCHAR2

Line 1742: DELETE FROM OKC_K_ART_VARIABLES WHERE CAT_ID = p_CAT_ID AND VARIABLE_CODE = p_VARIABLE_CODE;

1738: IF isArtVariableMRV(p_cat_id =>p_CAT_ID, p_VARIABLE_CODE => p_VARIABLE_CODE) = 'Y' THEN
1739: delete_mrv_uda_data(p_cat_id =>p_CAT_ID, p_VARIABLE_CODE => p_VARIABLE_CODE, p_major_version => NULL);
1740: END IF;
1741:
1742: DELETE FROM OKC_K_ART_VARIABLES WHERE CAT_ID = p_CAT_ID AND VARIABLE_CODE = p_VARIABLE_CODE;
1743:
1744: /*IF (l_debug = 'Y') THEN
1745: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1746: END IF;*/

Line 1779: -- Delete_Row for:OKC_K_ART_VARIABLES --

1775:
1776: END Delete_Row;
1777:
1778: -------------------------------------
1779: -- Delete_Row for:OKC_K_ART_VARIABLES --
1780: -------------------------------------
1781: PROCEDURE Delete_Row(
1782: x_return_status OUT NOCOPY VARCHAR2,
1783: p_cat_id IN NUMBER,

Line 1887: FROM OKC_K_ART_VARIABLES

1883: )
1884: IS
1885: CURSOR lock_csr IS
1886: SELECT rowid
1887: FROM OKC_K_ART_VARIABLES
1888: WHERE cat_id = p_cat_id
1889: FOR UPDATE NOWAIT;
1890:
1891: BEGIN

Line 1912: DELETE FROM OKC_K_ART_VARIABLES

1908: IF isArtVariableMRV(p_cat_id =>p_CAT_ID, p_VARIABLE_CODE => null) = 'Y' THEN
1909: delete_mrv_uda_data(p_cat_id =>p_CAT_ID, p_VARIABLE_CODE => null, p_major_version => NULL);
1910: END IF;
1911:
1912: DELETE FROM OKC_K_ART_VARIABLES
1913: WHERE cat_id = p_cat_id;
1914:
1915:
1916: /*IF (l_debug = 'Y') THEN

Line 2003: FROM OKC_K_ART_VARIABLES

1999: )
2000: IS
2001: CURSOR lock_csr IS
2002: SELECT rowid
2003: FROM OKC_K_ART_VARIABLES
2004: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B
2005: WHERE SCN_ID=p_scn_id)
2006: FOR UPDATE NOWAIT;
2007:

Line 2013: , OKC_K_ART_VARIABLES KVAR

2009: IS
2010: SELECT kart.ID
2011: FROM OKC_K_ARTICLES_B KART
2012: , OKC_BUS_VARIABLES_B BUS_VAR
2013: , OKC_K_ART_VARIABLES KVAR
2014: WHERE kart.SCN_ID=p_scn_id
2015: AND KVAR.cat_id=kart.id
2016: AND KVAR.variable_code=BUS_VAR.variable_code
2017: AND BUS_VAR.MRV_FLAG='Y';

Line 2042: DELETE FROM OKC_K_ART_VARIABLES

2038: delete_mrv_uda_data(p_cat_id => cat_rec.ID, p_VARIABLE_CODE => null, p_major_version => NULL);
2039: END LOOP;
2040:
2041:
2042: DELETE FROM OKC_K_ART_VARIABLES
2043: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B
2044: WHERE SCN_ID=p_scn_id);
2045:
2046: /*IF (l_debug = 'Y') THEN

Line 2136: FROM OKC_K_ART_VARIABLES

2132: IS
2133:
2134: CURSOR lock_csr IS
2135: SELECT rowid
2136: FROM OKC_K_ART_VARIABLES
2137: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE
2138: document_type= p_doc_type AND
2139: document_id = p_doc_id
2140: AND

Line 2153: , OKC_K_ART_VARIABLES KVAR

2149: IS
2150: SELECT kart.ID
2151: FROM OKC_K_ARTICLES_B KART
2152: , OKC_BUS_VARIABLES_B BUS_VAR
2153: , OKC_K_ART_VARIABLES KVAR
2154: WHERE kart.document_type=p_doc_type
2155: AND kart.document_id = p_doc_id
2156: AND KVAR.cat_id=kart.id
2157: AND KVAR.variable_code=BUS_VAR.variable_code

Line 2189: DELETE FROM OKC_K_ART_VARIABLES

2185: delete_mrv_uda_data(p_cat_id => cat_rec.ID, p_VARIABLE_CODE => null, p_major_version => NULL);
2186: END LOOP;
2187:
2188:
2189: DELETE FROM OKC_K_ART_VARIABLES
2190: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE
2191: document_type=p_doc_type AND
2192: document_id = p_doc_id);
2193:

Line 2292: , OKC_K_ART_VARIABLES KVAR

2288: IS
2289: SELECT kart.ID
2290: FROM OKC_K_ARTICLES_B KART
2291: , OKC_BUS_VARIABLES_B BUS_VAR
2292: , OKC_K_ART_VARIABLES KVAR
2293: WHERE kart.document_type=p_doc_type
2294: AND kart.document_id = p_doc_id
2295: AND KVAR.cat_id=kart.id
2296: AND KVAR.variable_code=BUS_VAR.variable_code

Line 2316: INSERT INTO OKC_K_ART_VARIABLES_H (

2312:
2313: -----------------------------------------
2314: -- Saving Base Table
2315: -----------------------------------------
2316: INSERT INTO OKC_K_ART_VARIABLES_H (
2317: major_version,
2318: CAT_ID,
2319: VARIABLE_CODE,
2320: VARIABLE_TYPE,

Line 2352: FROM OKC_K_ART_VARIABLES

2348: LAST_UPDATE_LOGIN,
2349: LAST_UPDATE_DATE,
2350: mr_variable_html,
2351: mr_variable_xml
2352: FROM OKC_K_ART_VARIABLES
2353: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_B
2354: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2355: AND DOCUMENT_ID = P_DOC_ID);
2356: /*IF (l_debug = 'Y') THEN

Line 2411: , OKC_K_ART_VARIABLES_H KVAR

2407: IS
2408: SELECT kart.ID
2409: FROM OKC_K_ARTICLES_BH KART
2410: , OKC_BUS_VARIABLES_B BUS_VAR
2411: , OKC_K_ART_VARIABLES_H KVAR
2412: WHERE kart.document_type=p_doc_type
2413: AND kart.document_id = p_doc_id
2414: AND KVAR.cat_id=kart.id
2415: AND KVAR.variable_code=BUS_VAR.variable_code

Line 2437: INSERT INTO OKC_K_ART_VARIABLES (

2433:
2434: -----------------------------------------
2435: -- Restoring Base Table
2436: -----------------------------------------
2437: INSERT INTO OKC_K_ART_VARIABLES (
2438: CAT_ID,
2439: VARIABLE_CODE,
2440: VARIABLE_TYPE,
2441: EXTERNAL_YN,

Line 2471: FROM OKC_K_ART_VARIABLES_H

2467: LAST_UPDATE_LOGIN,
2468: LAST_UPDATE_DATE,
2469: mr_variable_html,
2470: mr_variable_xml
2471: FROM OKC_K_ART_VARIABLES_H
2472: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2473: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2474: AND DOCUMENT_ID = P_DOC_ID)
2475: AND major_version = p_major_version;

Line 2525: , OKC_K_ART_VARIABLES_H KVAR

2521: IS
2522: SELECT kart.ID
2523: FROM OKC_K_ARTICLES_BH KART
2524: , OKC_BUS_VARIABLES_B BUS_VAR
2525: , OKC_K_ART_VARIABLES_H KVAR
2526: WHERE kart.document_type=p_doc_type
2527: AND kart.document_id = p_doc_id
2528: AND KVAR.cat_id=kart.id
2529: AND KVAR.variable_code=BUS_VAR.variable_code

Line 2552: FROM OKC_K_ART_VARIABLES_H

2548: delete_mrv_uda_data(p_cat_id => cat_rec.id,p_variable_code => NULL, p_major_version =>p_major_version);
2549: END LOOP;
2550:
2551: DELETE
2552: FROM OKC_K_ART_VARIABLES_H
2553: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2554: WHERE document_type = p_doc_type and document_id = p_doc_id)
2555: AND major_version = p_major_version;
2556:

Line 2600: FROM okc_k_art_variables kav

2596:
2597: IF p_cat_id IS NOT NULL THEN
2598: SELECT 'Y'
2599: INTO l_mrv_flag
2600: FROM okc_k_art_variables kav
2601: WHERE cat_id = p_cat_id
2602: AND EXISTS (SELECT 1
2603: FROM okc_bus_variables_b var
2604: WHERE kav.variable_code=var.variable_code

Line 3358: END OKC_K_ART_VARIABLES_PVT;

3354: AND TLH.cat_id=p_cat_id
3355: AND TLH.MAJOR_VERSION=p_major_version;
3356: END restore_mrv_uda_data_version;
3357:
3358: END OKC_K_ART_VARIABLES_PVT;