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.1 2005/11/06 23:01:01 ndoddi noship $ */
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 58: -- FUNCTION get_rec for: OKC_K_ART_VARIABLES

54: E_Resource_Busy EXCEPTION;
55: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
56:
57: ---------------------------------------------------------------------------
58: -- FUNCTION get_rec for: OKC_K_ART_VARIABLES
59: ---------------------------------------------------------------------------
60: FUNCTION Get_Rec (
61: p_cat_id IN NUMBER,
62: p_variable_code IN VARCHAR2,

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

73: x_last_update_login OUT NOCOPY NUMBER,
74: x_last_update_date OUT NOCOPY DATE
75:
76: ) RETURN VARCHAR2 IS
77: CURSOR OKC_K_ART_VARIABLES_pk_csr (cp_cat_id IN NUMBER,cp_variable_code IN VARCHAR2) IS
78: SELECT
79: VARIABLE_TYPE,
80: EXTERNAL_YN,
81: VARIABLE_VALUE_ID,

Line 91: FROM OKC_K_ART_VARIABLES t

87: CREATION_DATE,
88: LAST_UPDATED_BY,
89: LAST_UPDATE_LOGIN,
90: LAST_UPDATE_DATE
91: FROM OKC_K_ART_VARIABLES t
92: WHERE t.CAT_ID = cp_cat_id and
93: t.VARIABLE_CODE = cp_variable_code;
94: BEGIN
95:

Line 106: OPEN OKC_K_ART_VARIABLES_pk_csr (p_cat_id, p_variable_code);

102: G_PKG_NAME, '400: Entered get_rec' );
103: END IF;
104:
105: -- Get current database values
106: OPEN OKC_K_ART_VARIABLES_pk_csr (p_cat_id, p_variable_code);
107: FETCH OKC_K_ART_VARIABLES_pk_csr INTO
108: x_variable_type,
109: x_external_yn,
110: x_variable_value_id,

Line 107: FETCH OKC_K_ART_VARIABLES_pk_csr INTO

103: END IF;
104:
105: -- Get current database values
106: OPEN OKC_K_ART_VARIABLES_pk_csr (p_cat_id, p_variable_code);
107: FETCH OKC_K_ART_VARIABLES_pk_csr INTO
108: x_variable_type,
109: x_external_yn,
110: x_variable_value_id,
111: x_variable_value,

Line 120: IF OKC_K_ART_VARIABLES_pk_csr%NOTFOUND THEN

116: x_creation_date,
117: x_last_updated_by,
118: x_last_update_login,
119: x_last_update_date;
120: IF OKC_K_ART_VARIABLES_pk_csr%NOTFOUND THEN
121: RAISE NO_DATA_FOUND;
122: END IF;
123: CLOSE OKC_K_ART_VARIABLES_pk_csr;
124:

Line 123: CLOSE OKC_K_ART_VARIABLES_pk_csr;

119: x_last_update_date;
120: IF OKC_K_ART_VARIABLES_pk_csr%NOTFOUND THEN
121: RAISE NO_DATA_FOUND;
122: END IF;
123: CLOSE OKC_K_ART_VARIABLES_pk_csr;
124:
125: /*IF (l_debug = 'Y') THEN
126: Okc_Debug.Log('500: Leaving get_rec ', 2);
127: END IF;*/

Line 155: IF OKC_K_ART_VARIABLES_pk_csr%ISOPEN THEN

151: p_token1_value => sqlcode,
152: p_token2 => G_SQLERRM_TOKEN,
153: p_token2_value => sqlerrm);
154:
155: IF OKC_K_ART_VARIABLES_pk_csr%ISOPEN THEN
156: CLOSE OKC_K_ART_VARIABLES_pk_csr;
157: END IF;
158:
159: RETURN G_RET_STS_UNEXP_ERROR ;

Line 156: CLOSE OKC_K_ART_VARIABLES_pk_csr;

152: p_token2 => G_SQLERRM_TOKEN,
153: p_token2_value => sqlerrm);
154:
155: IF OKC_K_ART_VARIABLES_pk_csr%ISOPEN THEN
156: CLOSE OKC_K_ART_VARIABLES_pk_csr;
157: END IF;
158:
159: RETURN G_RET_STS_UNEXP_ERROR ;
160:

Line 164: -- Set_Attributes for:OKC_K_ART_VARIABLES --

160:
161: END Get_Rec;
162:
163: -----------------------------------------
164: -- Set_Attributes for:OKC_K_ART_VARIABLES --
165: -----------------------------------------
166: FUNCTION Set_Attributes(
167: p_cat_id IN NUMBER,
168: p_variable_code IN VARCHAR2,

Line 186: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

182: x_attribute_value_set_id OUT NOCOPY NUMBER,
183: x_override_global_yn OUT NOCOPY VARCHAR2
184: ) RETURN VARCHAR2 IS
185: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
186: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
187: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
188: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
189: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
190: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

Line 187: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

183: x_override_global_yn OUT NOCOPY VARCHAR2
184: ) RETURN VARCHAR2 IS
185: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
186: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
187: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
188: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
189: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
190: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
191: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

Line 188: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

184: ) RETURN VARCHAR2 IS
185: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
186: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
187: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
188: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
189: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
190: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
191: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
192: BEGIN

Line 189: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

185: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
186: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
187: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
188: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
189: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
190: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
191: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
192: BEGIN
193: /*IF (l_debug = 'Y') THEN

Line 190: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

186: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
187: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
188: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
189: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
190: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
191: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
192: BEGIN
193: /*IF (l_debug = 'Y') THEN
194: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 191: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

187: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
188: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
189: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
190: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
191: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
192: BEGIN
193: /*IF (l_debug = 'Y') THEN
194: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
195: END IF;*/

Line 322: -- Validate_Attributes for: OKC_K_ART_VARIABLES --

318:
319: END Set_Attributes ;
320:
321: ----------------------------------------------
322: -- Validate_Attributes for: OKC_K_ART_VARIABLES --
323: ----------------------------------------------
324: FUNCTION Validate_Attributes (
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
326:

Line 687: -- Validate_Record for:OKC_K_ART_VARIABLES --

683: -- PROCEDURE Validate_Record
684: -- It calls Item Level Validations and then makes Record Level Validations
685: ---------------------------------------------------------------------------
686: ------------------------------------------
687: -- Validate_Record for:OKC_K_ART_VARIABLES --
688: ------------------------------------------
689: FUNCTION Validate_Record (
690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691:

Line 793: -- validate_row for:OKC_K_ART_VARIABLES --

789: ---------------------------------------------------------------------------
790: -- PROCEDURE validate_row
791: ---------------------------------------------------------------------------
792: ---------------------------------------
793: -- validate_row for:OKC_K_ART_VARIABLES --
794: ---------------------------------------
795: PROCEDURE validate_row(
796: p_validation_level IN NUMBER,
797: x_return_status OUT NOCOPY VARCHAR2,

Line 809: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;

805: p_override_global_yn IN VARCHAR2,
806:
807: p_object_version_number IN NUMBER
808: ) IS
809: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
810: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
811: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;

Line 810: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;

806:
807: p_object_version_number IN NUMBER
808: ) IS
809: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
810: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
811: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;

Line 811: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;

807: p_object_version_number IN NUMBER
808: ) IS
809: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
810: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
811: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

Line 812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;

808: ) IS
809: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
810: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
811: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

Line 813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;

809: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
810: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
811: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

Line 814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;

810: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
811: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
818: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

Line 815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

811: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
818: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
819: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

Line 816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

812: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
818: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
819: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
820: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

Line 817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

813: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
818: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
819: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
820: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
821: BEGIN

Line 818: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

814: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
818: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
819: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
820: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
821: BEGIN
822:

Line 819: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

815: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
818: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
819: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
820: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
821: BEGIN
822:
823: /*IF (l_debug = 'Y') THEN

Line 820: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

816: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
817: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
818: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
819: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
820: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
821: BEGIN
822:
823: /*IF (l_debug = 'Y') THEN
824: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 925: -- Insert_Row for:OKC_K_ART_VARIABLES --

921: ---------------------------------------------------------------------------
922: -- PROCEDURE Insert_Row
923: ---------------------------------------------------------------------------
924: -------------------------------------
925: -- Insert_Row for:OKC_K_ART_VARIABLES --
926: -------------------------------------
927: FUNCTION Insert_Row(
928: p_cat_id IN NUMBER,
929: p_variable_code IN VARCHAR2,

Line 955: INSERT INTO OKC_K_ART_VARIABLES(

951: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
952: FND_LOG.STRING(G_PROC_LEVEL,
953: G_PKG_NAME, '3600: Entered Insert_Row function' );
954: END IF;
955: INSERT INTO OKC_K_ART_VARIABLES(
956: CAT_ID,
957: VARIABLE_CODE,
958: VARIABLE_TYPE,
959: EXTERNAL_YN,

Line 1022: -- Insert_Row for:OKC_K_ART_VARIABLES --

1018: END Insert_Row;
1019:
1020:
1021: -------------------------------------
1022: -- Insert_Row for:OKC_K_ART_VARIABLES --
1023: -------------------------------------
1024: PROCEDURE Insert_Row(
1025: p_validation_level IN NUMBER,
1026: x_return_status OUT NOCOPY VARCHAR2,

Line 1040: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

1036: x_variable_code OUT NOCOPY VARCHAR2
1037:
1038: ) IS
1039:
1040: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1041: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1042: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1043: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1044: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

Line 1041: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

1037:
1038: ) IS
1039:
1040: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1041: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1042: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1043: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1044: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1045: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

Line 1042: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

1038: ) IS
1039:
1040: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1041: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1042: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1043: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1044: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1045: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1046: BEGIN

Line 1043: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

1039:
1040: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1041: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1042: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1043: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1044: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1045: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1046: BEGIN
1047:

Line 1044: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

1040: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1041: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1042: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1043: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1044: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1045: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1046: BEGIN
1047:
1048: x_return_status := G_RET_STS_SUCCESS;

Line 1045: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

1041: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1042: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1043: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1044: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1045: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1046: BEGIN
1047:
1048: x_return_status := G_RET_STS_SUCCESS;
1049:

Line 1177: -- Lock_Row for:OKC_K_ART_VARIABLES --

1173: ---------------------------------------------------------------------------
1174: -- PROCEDURE Lock_Row
1175: ---------------------------------------------------------------------------
1176: -----------------------------------
1177: -- Lock_Row for:OKC_K_ART_VARIABLES --
1178: -----------------------------------
1179: FUNCTION Lock_Row(
1180: p_cat_id IN NUMBER,
1181: p_variable_code IN VARCHAR2,

Line 1188: FROM OKC_K_ART_VARIABLES

1184:
1185:
1186: CURSOR lock_csr (cp_cat_id NUMBER, cp_variable_code VARCHAR2, cp_object_version_number NUMBER) IS
1187: SELECT object_version_number
1188: FROM OKC_K_ART_VARIABLES
1189: WHERE CAT_ID = cp_cat_id AND VARIABLE_CODE = cp_variable_code
1190: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1191: FOR UPDATE OF object_version_number NOWAIT;
1192:

Line 1195: FROM OKC_K_ART_VARIABLES

1191: FOR UPDATE OF object_version_number NOWAIT;
1192:
1193: CURSOR lchk_csr (cp_cat_id NUMBER, cp_variable_code VARCHAR2) IS
1194: SELECT object_version_number
1195: FROM OKC_K_ART_VARIABLES
1196: WHERE CAT_ID = cp_cat_id AND VARIABLE_CODE = cp_variable_code;
1197:
1198: l_return_status VARCHAR2(1);
1199:

Line 1200: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

1196: WHERE CAT_ID = cp_cat_id AND VARIABLE_CODE = cp_variable_code;
1197:
1198: l_return_status VARCHAR2(1);
1199:
1200: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1201:
1202: l_row_notfound BOOLEAN := FALSE;
1203: BEGIN
1204:

Line 1302: -- Lock_Row for:OKC_K_ART_VARIABLES --

1298: RETURN( G_RET_STS_UNEXP_ERROR );
1299: END Lock_Row;
1300:
1301: -----------------------------------
1302: -- Lock_Row for:OKC_K_ART_VARIABLES --
1303: -----------------------------------
1304: PROCEDURE Lock_Row(
1305: x_return_status OUT NOCOPY VARCHAR2,
1306:

Line 1395: -- Update_Row for:OKC_K_ART_VARIABLES --

1391: ---------------------------------------------------------------------------
1392: -- PROCEDURE Update_Row
1393: ---------------------------------------------------------------------------
1394: -------------------------------------
1395: -- Update_Row for:OKC_K_ART_VARIABLES --
1396: -------------------------------------
1397: FUNCTION Update_Row(
1398: p_cat_id IN NUMBER,
1399: p_variable_code IN VARCHAR2,

Line 1425: UPDATE OKC_K_ART_VARIABLES

1421: FND_LOG.STRING(G_PROC_LEVEL,
1422: G_PKG_NAME, '6400: Entered Update_Row' );
1423: END IF;
1424:
1425: UPDATE OKC_K_ART_VARIABLES
1426: SET VARIABLE_TYPE = p_variable_type,
1427: EXTERNAL_YN = p_external_yn,
1428: VARIABLE_VALUE_ID = p_variable_value_id,
1429: VARIABLE_VALUE = p_variable_value,

Line 1474: -- Update_Row for:OKC_K_ART_VARIABLES --

1470:
1471: END Update_Row;
1472:
1473: -------------------------------------
1474: -- Update_Row for:OKC_K_ART_VARIABLES --
1475: -------------------------------------
1476: PROCEDURE Update_Row(
1477: p_validation_level IN NUMBER,
1478: x_return_status OUT NOCOPY VARCHAR2,

Line 1493: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;

1489: p_object_version_number IN NUMBER
1490:
1491: ) IS
1492:
1493: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1494: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1495: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;

Line 1494: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;

1490:
1491: ) IS
1492:
1493: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1494: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1495: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;

Line 1495: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;

1491: ) IS
1492:
1493: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1494: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1495: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

Line 1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;

1492:
1493: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1494: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1495: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

Line 1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;

1493: l_variable_type OKC_K_ART_VARIABLES.VARIABLE_TYPE%TYPE;
1494: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1495: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

Line 1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;

1494: l_external_yn OKC_K_ART_VARIABLES.EXTERNAL_YN%TYPE;
1495: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1502: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

Line 1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;

1495: l_variable_value_id OKC_K_ART_VARIABLES.VARIABLE_VALUE_ID%TYPE;
1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1502: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1503: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

Line 1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;

1496: l_variable_value OKC_K_ART_VARIABLES.VARIABLE_VALUE%TYPE;
1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1502: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1503: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1504: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

Line 1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;

1497: l_attribute_value_set_id OKC_K_ART_VARIABLES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1502: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1503: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1504: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1505:

Line 1502: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;

1498: l_override_global_yn OKC_K_ART_VARIABLES.OVERRIDE_GLOBAL_YN%TYPE;
1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1502: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1503: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1504: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1505:
1506: BEGIN

Line 1503: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;

1499: l_object_version_number OKC_K_ART_VARIABLES.OBJECT_VERSION_NUMBER%TYPE;
1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1502: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1503: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1504: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1505:
1506: BEGIN
1507:

Line 1504: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;

1500: l_created_by OKC_K_ART_VARIABLES.CREATED_BY%TYPE;
1501: l_creation_date OKC_K_ART_VARIABLES.CREATION_DATE%TYPE;
1502: l_last_updated_by OKC_K_ART_VARIABLES.LAST_UPDATED_BY%TYPE;
1503: l_last_update_login OKC_K_ART_VARIABLES.LAST_UPDATE_LOGIN%TYPE;
1504: l_last_update_date OKC_K_ART_VARIABLES.LAST_UPDATE_DATE%TYPE;
1505:
1506: BEGIN
1507:
1508: /*IF (l_debug = 'Y') THEN

Line 1704: -- Delete_Row for:OKC_K_ART_VARIABLES --

1700: ---------------------------------------------------------------------------
1701: -- PROCEDURE Delete_Row
1702: ---------------------------------------------------------------------------
1703: -------------------------------------
1704: -- Delete_Row for:OKC_K_ART_VARIABLES --
1705: -------------------------------------
1706: FUNCTION Delete_Row(
1707: p_cat_id IN NUMBER,
1708: p_variable_code IN VARCHAR2

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

1718: FND_LOG.STRING(G_PROC_LEVEL,
1719: G_PKG_NAME, '8200: Entered Delete_Row' );
1720: END IF;
1721:
1722: DELETE FROM OKC_K_ART_VARIABLES WHERE CAT_ID = p_CAT_ID AND VARIABLE_CODE = p_VARIABLE_CODE;
1723:
1724: /*IF (l_debug = 'Y') THEN
1725: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1726: END IF;*/

Line 1759: -- Delete_Row for:OKC_K_ART_VARIABLES --

1755:
1756: END Delete_Row;
1757:
1758: -------------------------------------
1759: -- Delete_Row for:OKC_K_ART_VARIABLES --
1760: -------------------------------------
1761: PROCEDURE Delete_Row(
1762: x_return_status OUT NOCOPY VARCHAR2,
1763: p_cat_id IN NUMBER,

Line 1867: FROM OKC_K_ART_VARIABLES

1863: )
1864: IS
1865: CURSOR lock_csr IS
1866: SELECT rowid
1867: FROM OKC_K_ART_VARIABLES
1868: WHERE cat_id = p_cat_id
1869: FOR UPDATE NOWAIT;
1870:
1871: BEGIN

Line 1888: DELETE FROM OKC_K_ART_VARIABLES

1884: -- making OPEN/CLOSE cursor to lock records
1885: OPEN lock_csr;
1886: CLOSE lock_csr;
1887:
1888: DELETE FROM OKC_K_ART_VARIABLES
1889: WHERE cat_id = p_cat_id;
1890:
1891: /*IF (l_debug = 'Y') THEN
1892: Okc_Debug.Log('11000: Leaving Delete_set', 2);

Line 1978: FROM OKC_K_ART_VARIABLES

1974: )
1975: IS
1976: CURSOR lock_csr IS
1977: SELECT rowid
1978: FROM OKC_K_ART_VARIABLES
1979: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B
1980: WHERE SCN_ID=p_scn_id)
1981: FOR UPDATE NOWAIT;
1982:

Line 2000: DELETE FROM OKC_K_ART_VARIABLES

1996: -- making OPEN/CLOSE cursor to lock records
1997: OPEN lock_csr;
1998: CLOSE lock_csr;
1999:
2000: DELETE FROM OKC_K_ART_VARIABLES
2001: WHERE CAT_ID IN (SELECT ID FROM OKC_K_ARTICLES_B
2002: WHERE SCN_ID=p_scn_id);
2003:
2004: /*IF (l_debug = 'Y') THEN

Line 2093: FROM OKC_K_ART_VARIABLES

2089: IS
2090:
2091: CURSOR lock_csr IS
2092: SELECT rowid
2093: FROM OKC_K_ART_VARIABLES
2094: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE
2095: document_type=p_doc_type AND
2096: document_id = p_doc_id)
2097: FOR UPDATE NOWAIT;

Line 2116: DELETE FROM OKC_K_ART_VARIABLES

2112: -- making OPEN/CLOSE cursor to lock records
2113: OPEN lock_csr;
2114: CLOSE lock_csr;
2115:
2116: DELETE FROM OKC_K_ART_VARIABLES
2117: WHERE cat_id IN (SELECT id FROM OKC_K_ARTICLES_B WHERE
2118: document_type=p_doc_type AND
2119: document_id = p_doc_id);
2120:

Line 2227: INSERT INTO OKC_K_ART_VARIABLES_H (

2223:
2224: -----------------------------------------
2225: -- Saving Base Table
2226: -----------------------------------------
2227: INSERT INTO OKC_K_ART_VARIABLES_H (
2228: major_version,
2229: CAT_ID,
2230: VARIABLE_CODE,
2231: VARIABLE_TYPE,

Line 2259: FROM OKC_K_ART_VARIABLES

2255: CREATION_DATE,
2256: LAST_UPDATED_BY,
2257: LAST_UPDATE_LOGIN,
2258: LAST_UPDATE_DATE
2259: FROM OKC_K_ART_VARIABLES
2260: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_B
2261: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2262: AND DOCUMENT_ID = P_DOC_ID);
2263:

Line 2325: INSERT INTO OKC_K_ART_VARIABLES (

2321:
2322: -----------------------------------------
2323: -- Restoring Base Table
2324: -----------------------------------------
2325: INSERT INTO OKC_K_ART_VARIABLES (
2326: CAT_ID,
2327: VARIABLE_CODE,
2328: VARIABLE_TYPE,
2329: EXTERNAL_YN,

Line 2355: FROM OKC_K_ART_VARIABLES_H

2351: CREATION_DATE,
2352: LAST_UPDATED_BY,
2353: LAST_UPDATE_LOGIN,
2354: LAST_UPDATE_DATE
2355: FROM OKC_K_ART_VARIABLES_H
2356: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2357: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2358: AND DOCUMENT_ID = P_DOC_ID)
2359: AND major_version = p_major_version;

Line 2416: FROM OKC_K_ART_VARIABLES_H

2412: -----------------------------------------
2413: -- Restoring Base Table
2414: -----------------------------------------
2415: DELETE
2416: FROM OKC_K_ART_VARIABLES_H
2417: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2418: WHERE document_type = p_doc_type and document_id = p_doc_id)
2419: AND major_version = p_major_version;
2420:

Line 2455: END OKC_K_ART_VARIABLES_PVT;

2451: RETURN G_RET_STS_UNEXP_ERROR ;
2452:
2453: END Delete_Version;
2454:
2455: END OKC_K_ART_VARIABLES_PVT;