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_REVIEW_VAR_VALUES_PVT dependencies on OKC_REVIEW_VAR_VALUES

Line 1: PACKAGE BODY OKC_REVIEW_VAR_VALUES_PVT AS

1: PACKAGE BODY OKC_REVIEW_VAR_VALUES_PVT AS
2: /* $Header: OKCVRUVB.pls 120.2 2005/09/13 22:38 vnanjang noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------

Line 29: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REVIEW_VAR_VALUES_PVT';

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

Line 62: SELECT OKC_REVIEW_VAR_VALUES_S1.NEXTVAL FROM DUAL;

58: p_REVIEW_UPLD_TERMS_id IN NUMBER,
59: x_REVIEW_UPLD_TERMS_id OUT NOCOPY NUMBER
60: ) RETURN VARCHAR2 IS
61: CURSOR l_seq_csr IS
62: SELECT OKC_REVIEW_VAR_VALUES_S1.NEXTVAL FROM DUAL;
63: BEGIN
64: IF (l_debug = 'Y') THEN
65: Okc_Debug.Log('100: Entered get_seq_id', 2);
66: END IF;

Line 104: -- FUNCTION get_rec for: OKC_REVIEW_VAR_VALUES

100:
101: END Get_Seq_Id;
102:
103: ---------------------------------------------------------------------------
104: -- FUNCTION get_rec for: OKC_REVIEW_VAR_VALUES
105: ---------------------------------------------------------------------------
106: FUNCTION Get_Rec (
107: p_REVIEW_UPLD_TERMS_id IN NUMBER,
108:

Line 125: CURSOR OKC_REVIEW_VAR_VALUES_pk_csr (cp_REVIEW_UPLD_TERMS_id IN NUMBER) IS

121: x_last_update_date OUT NOCOPY DATE,
122: x_language OUT NOCOPY VARCHAR2
123:
124: ) RETURN VARCHAR2 IS
125: CURSOR OKC_REVIEW_VAR_VALUES_pk_csr (cp_REVIEW_UPLD_TERMS_id IN NUMBER) IS
126: SELECT
127: REVIEW_VAR_VALUES_ID,
128: VARIABLE_NAME,
129: VARIABLE_CODE,

Line 141: FROM OKC_REVIEW_VAR_VALUES t

137: LAST_UPDATED_BY,
138: LAST_UPDATE_LOGIN,
139: LAST_UPDATE_DATE,
140: LANGUAGE
141: FROM OKC_REVIEW_VAR_VALUES t
142: WHERE t.REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;
143: BEGIN
144:
145: IF (l_debug = 'Y') THEN

Line 150: OPEN OKC_REVIEW_VAR_VALUES_pk_csr (p_REVIEW_UPLD_TERMS_id);

146: Okc_Debug.Log('400: Entered get_rec', 2);
147: END IF;
148:
149: -- Get current database values
150: OPEN OKC_REVIEW_VAR_VALUES_pk_csr (p_REVIEW_UPLD_TERMS_id);
151: FETCH OKC_REVIEW_VAR_VALUES_pk_csr INTO
152: x_REVIEW_VAR_VALUES_id,
153: x_variable_name,
154: x_variable_code,

Line 151: FETCH OKC_REVIEW_VAR_VALUES_pk_csr INTO

147: END IF;
148:
149: -- Get current database values
150: OPEN OKC_REVIEW_VAR_VALUES_pk_csr (p_REVIEW_UPLD_TERMS_id);
151: FETCH OKC_REVIEW_VAR_VALUES_pk_csr INTO
152: x_REVIEW_VAR_VALUES_id,
153: x_variable_name,
154: x_variable_code,
155: x_variable_type,

Line 166: IF OKC_REVIEW_VAR_VALUES_pk_csr%NOTFOUND THEN

162: x_last_updated_by,
163: x_last_update_login,
164: x_last_update_date,
165: x_language;
166: IF OKC_REVIEW_VAR_VALUES_pk_csr%NOTFOUND THEN
167: RAISE NO_DATA_FOUND;
168: END IF;
169: CLOSE OKC_REVIEW_VAR_VALUES_pk_csr;
170:

Line 169: CLOSE OKC_REVIEW_VAR_VALUES_pk_csr;

165: x_language;
166: IF OKC_REVIEW_VAR_VALUES_pk_csr%NOTFOUND THEN
167: RAISE NO_DATA_FOUND;
168: END IF;
169: CLOSE OKC_REVIEW_VAR_VALUES_pk_csr;
170:
171: IF (l_debug = 'Y') THEN
172: Okc_Debug.Log('500: Leaving get_rec ', 2);
173: END IF;

Line 191: IF OKC_REVIEW_VAR_VALUES_pk_csr%ISOPEN THEN

187: p_token1_value => sqlcode,
188: p_token2 => G_SQLERRM_TOKEN,
189: p_token2_value => sqlerrm);
190:
191: IF OKC_REVIEW_VAR_VALUES_pk_csr%ISOPEN THEN
192: CLOSE OKC_REVIEW_VAR_VALUES_pk_csr;
193: END IF;
194:
195: RETURN G_RET_STS_UNEXP_ERROR ;

Line 192: CLOSE OKC_REVIEW_VAR_VALUES_pk_csr;

188: p_token2 => G_SQLERRM_TOKEN,
189: p_token2_value => sqlerrm);
190:
191: IF OKC_REVIEW_VAR_VALUES_pk_csr%ISOPEN THEN
192: CLOSE OKC_REVIEW_VAR_VALUES_pk_csr;
193: END IF;
194:
195: RETURN G_RET_STS_UNEXP_ERROR ;
196:

Line 200: -- Set_Attributes for:OKC_REVIEW_VAR_VALUES --

196:
197: END Get_Rec;
198:
199: -----------------------------------------
200: -- Set_Attributes for:OKC_REVIEW_VAR_VALUES --
201: -----------------------------------------
202: FUNCTION Set_Attributes(
203: p_REVIEW_VAR_VALUES_id IN NUMBER,
204: p_REVIEW_UPLD_TERMS_id IN NUMBER,

Line 222: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;

218: x_variable_value OUT NOCOPY VARCHAR2,
219: x_attribute_value_set_id OUT NOCOPY NUMBER
220: ) RETURN VARCHAR2 IS
221: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
222: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
223: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
224: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
225: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
226: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

Line 223: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;

219: x_attribute_value_set_id OUT NOCOPY NUMBER
220: ) RETURN VARCHAR2 IS
221: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
222: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
223: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
224: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
225: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
226: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
227: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

Line 224: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;

220: ) RETURN VARCHAR2 IS
221: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
222: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
223: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
224: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
225: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
226: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
227: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
228: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;

Line 225: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

221: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
222: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
223: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
224: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
225: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
226: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
227: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
228: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
229: BEGIN

Line 226: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

222: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
223: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
224: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
225: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
226: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
227: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
228: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
229: BEGIN
230: IF (l_debug = 'Y') THEN

Line 227: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

223: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
224: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
225: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
226: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
227: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
228: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
229: BEGIN
230: IF (l_debug = 'Y') THEN
231: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 228: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;

224: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
225: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
226: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
227: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
228: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
229: BEGIN
230: IF (l_debug = 'Y') THEN
231: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
232: END IF;

Line 345: -- Validate_Attributes for: OKC_REVIEW_VAR_VALUES --

341:
342: END Set_Attributes ;
343:
344: ----------------------------------------------
345: -- Validate_Attributes for: OKC_REVIEW_VAR_VALUES --
346: ----------------------------------------------
347: FUNCTION Validate_Attributes (
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349:

Line 547: -- Validate_Record for:OKC_REVIEW_VAR_VALUES --

543: -- PROCEDURE Validate_Record
544: -- It calls Item Level Validations and then makes Record Level Validations
545: ---------------------------------------------------------------------------
546: ------------------------------------------
547: -- Validate_Record for:OKC_REVIEW_VAR_VALUES --
548: ------------------------------------------
549: FUNCTION Validate_Record (
550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
551:

Line 624: -- validate_row for:OKC_REVIEW_VAR_VALUES --

620: ---------------------------------------------------------------------------
621: -- PROCEDURE validate_row
622: ---------------------------------------------------------------------------
623: ---------------------------------------
624: -- validate_row for:OKC_REVIEW_VAR_VALUES --
625: ---------------------------------------
626: PROCEDURE validate_row(
627: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
628:

Line 643: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;

639: p_attribute_value_set_id IN NUMBER := NULL,
640:
641: p_object_version_number IN NUMBER
642: ) IS
643: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
644: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
645: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;

Line 644: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;

640:
641: p_object_version_number IN NUMBER
642: ) IS
643: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
644: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
645: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;

Line 645: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;

641: p_object_version_number IN NUMBER
642: ) IS
643: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
644: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
645: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;

Line 646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;

642: ) IS
643: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
644: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
645: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;

Line 647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;

643: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
644: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
645: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;

Line 648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;

644: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
645: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;

Line 649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;

645: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

Line 650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;

646: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
654: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

Line 651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;

647: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
654: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
655: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

Line 652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;

648: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
654: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
655: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
656: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;

Line 653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

649: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
654: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
655: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
656: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
657: BEGIN

Line 654: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

650: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
654: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
655: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
656: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
657: BEGIN
658:

Line 655: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

651: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
654: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
655: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
656: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
657: BEGIN
658:
659: IF (l_debug = 'Y') THEN

Line 656: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;

652: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
653: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
654: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
655: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
656: l_language OKC_REVIEW_VAR_VALUES.LANGUAGE%TYPE;
657: BEGIN
658:
659: IF (l_debug = 'Y') THEN
660: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 737: -- Insert_Row for:OKC_REVIEW_VAR_VALUES --

733: ---------------------------------------------------------------------------
734: -- PROCEDURE Insert_Row
735: ---------------------------------------------------------------------------
736: -------------------------------------
737: -- Insert_Row for:OKC_REVIEW_VAR_VALUES --
738: -------------------------------------
739: FUNCTION Insert_Row(
740: p_REVIEW_VAR_VALUES_id IN NUMBER,
741: p_REVIEW_UPLD_TERMS_id IN NUMBER,

Line 763: INSERT INTO OKC_REVIEW_VAR_VALUES(

759: IF (l_debug = 'Y') THEN
760: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
761: END IF;
762:
763: INSERT INTO OKC_REVIEW_VAR_VALUES(
764: REVIEW_VAR_VALUES_ID,
765: REVIEW_UPLD_TERMS_ID,
766: VARIABLE_NAME,
767: VARIABLE_CODE,

Line 821: -- Insert_Row for:OKC_REVIEW_VAR_VALUES --

817: END Insert_Row;
818:
819:
820: -------------------------------------
821: -- Insert_Row for:OKC_REVIEW_VAR_VALUES --
822: -------------------------------------
823: PROCEDURE Insert_Row(
824: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
825: x_return_status OUT NOCOPY VARCHAR2,

Line 841: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;

837: x_REVIEW_UPLD_TERMS_id OUT NOCOPY NUMBER
838:
839: ) IS
840:
841: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
842: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
843: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
844: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
845: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

Line 842: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;

838:
839: ) IS
840:
841: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
842: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
843: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
844: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
845: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
846: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

Line 843: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;

839: ) IS
840:
841: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
842: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
843: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
844: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
845: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
846: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
847: BEGIN

Line 844: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

840:
841: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
842: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
843: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
844: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
845: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
846: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
847: BEGIN
848:

Line 845: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

841: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
842: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
843: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
844: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
845: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
846: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
847: BEGIN
848:
849: x_return_status := G_RET_STS_SUCCESS;

Line 846: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

842: l_created_by OKC_REVIEW_VAR_VALUES.CREATED_BY%TYPE;
843: l_creation_date OKC_REVIEW_VAR_VALUES.CREATION_DATE%TYPE;
844: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
845: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
846: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
847: BEGIN
848:
849: x_return_status := G_RET_STS_SUCCESS;
850:

Line 967: -- Lock_Row for:OKC_REVIEW_VAR_VALUES --

963: ---------------------------------------------------------------------------
964: -- PROCEDURE Lock_Row
965: ---------------------------------------------------------------------------
966: -----------------------------------
967: -- Lock_Row for:OKC_REVIEW_VAR_VALUES --
968: -----------------------------------
969: FUNCTION Lock_Row(
970: p_REVIEW_UPLD_TERMS_id IN NUMBER,
971: p_object_version_number IN NUMBER

Line 975: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;

971: p_object_version_number IN NUMBER
972: ) RETURN VARCHAR2 IS
973:
974: l_return_status VARCHAR2(1);
975: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
976: l_row_notfound BOOLEAN := FALSE;
977:
978: CURSOR lock_csr (cp_REVIEW_UPLD_TERMS_id NUMBER, cp_object_version_number NUMBER) IS
979: SELECT object_version_number

Line 980: FROM OKC_REVIEW_VAR_VALUES

976: l_row_notfound BOOLEAN := FALSE;
977:
978: CURSOR lock_csr (cp_REVIEW_UPLD_TERMS_id NUMBER, cp_object_version_number NUMBER) IS
979: SELECT object_version_number
980: FROM OKC_REVIEW_VAR_VALUES
981: WHERE REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id
982: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
983: FOR UPDATE OF object_version_number NOWAIT;
984:

Line 987: FROM OKC_REVIEW_VAR_VALUES

983: FOR UPDATE OF object_version_number NOWAIT;
984:
985: CURSOR lchk_csr (cp_REVIEW_UPLD_TERMS_id NUMBER) IS
986: SELECT object_version_number
987: FROM OKC_REVIEW_VAR_VALUES
988: WHERE REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;
989: BEGIN
990:
991: IF (l_debug = 'Y') THEN

Line 1069: -- Lock_Row for:OKC_REVIEW_VAR_VALUES --

1065: RETURN( G_RET_STS_UNEXP_ERROR );
1066: END Lock_Row;
1067:
1068: -----------------------------------
1069: -- Lock_Row for:OKC_REVIEW_VAR_VALUES --
1070: -----------------------------------
1071: PROCEDURE Lock_Row(
1072: x_return_status OUT NOCOPY VARCHAR2,
1073:

Line 1133: -- Update_Row for:OKC_REVIEW_VAR_VALUES --

1129: ---------------------------------------------------------------------------
1130: -- PROCEDURE Update_Row
1131: ---------------------------------------------------------------------------
1132: -------------------------------------
1133: -- Update_Row for:OKC_REVIEW_VAR_VALUES --
1134: -------------------------------------
1135: FUNCTION Update_Row(
1136: p_REVIEW_UPLD_TERMS_id IN NUMBER,
1137: p_REVIEW_VAR_VALUES_id IN NUMBER,

Line 1156: UPDATE OKC_REVIEW_VAR_VALUES

1152: IF (l_debug = 'Y') THEN
1153: Okc_Debug.Log('6400: Entered Update_Row', 2);
1154: END IF;
1155:
1156: UPDATE OKC_REVIEW_VAR_VALUES
1157: SET REVIEW_VAR_VALUES_ID = p_REVIEW_VAR_VALUES_id,
1158: VARIABLE_NAME = p_variable_name,
1159: VARIABLE_CODE = p_variable_code,
1160: VARIABLE_TYPE = p_variable_type,

Line 1195: -- Update_Row for:OKC_REVIEW_VAR_VALUES --

1191:
1192: END Update_Row;
1193:
1194: -------------------------------------
1195: -- Update_Row for:OKC_REVIEW_VAR_VALUES --
1196: -------------------------------------
1197: PROCEDURE Update_Row(
1198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1199:

Line 1216: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;

1212: p_object_version_number IN NUMBER
1213:
1214: ) IS
1215:
1216: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
1217: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
1218: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;

Line 1217: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;

1213:
1214: ) IS
1215:
1216: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
1217: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
1218: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;

Line 1218: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;

1214: ) IS
1215:
1216: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
1217: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
1218: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;

Line 1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;

1215:
1216: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
1217: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
1218: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;

Line 1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;

1216: l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;
1217: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
1218: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1224: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

Line 1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;

1217: l_variable_name OKC_REVIEW_VAR_VALUES.VARIABLE_NAME%TYPE;
1218: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1224: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
1225: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

Line 1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;

1218: l_variable_code OKC_REVIEW_VAR_VALUES.VARIABLE_CODE%TYPE;
1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1224: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
1225: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
1226: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

Line 1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;

1219: l_variable_type OKC_REVIEW_VAR_VALUES.VARIABLE_TYPE%TYPE;
1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1224: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
1225: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
1226: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
1227:

Line 1224: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

1220: l_variable_value_id OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE_ID%TYPE;
1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1224: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
1225: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
1226: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
1227:
1228: BEGIN

Line 1225: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

1221: l_variable_value OKC_REVIEW_VAR_VALUES.VARIABLE_VALUE%TYPE;
1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1224: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
1225: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
1226: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
1227:
1228: BEGIN
1229:

Line 1226: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

1222: l_attribute_value_set_id OKC_REVIEW_VAR_VALUES.ATTRIBUTE_VALUE_SET_ID%TYPE;
1223: l_object_version_number OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1224: l_last_updated_by OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;
1225: l_last_update_login OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;
1226: l_last_update_date OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;
1227:
1228: BEGIN
1229:
1230: IF (l_debug = 'Y') THEN

Line 1376: -- Delete_Row for:OKC_REVIEW_VAR_VALUES --

1372: ---------------------------------------------------------------------------
1373: -- PROCEDURE Delete_Row
1374: ---------------------------------------------------------------------------
1375: -------------------------------------
1376: -- Delete_Row for:OKC_REVIEW_VAR_VALUES --
1377: -------------------------------------
1378: FUNCTION Delete_Row(
1379: p_REVIEW_UPLD_TERMS_id IN NUMBER
1380: ) RETURN VARCHAR2 IS

Line 1388: DELETE FROM OKC_REVIEW_VAR_VALUES

1384: IF (l_debug = 'Y') THEN
1385: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1386: END IF;
1387:
1388: DELETE FROM OKC_REVIEW_VAR_VALUES
1389: WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_ID;
1390: COMMIT;
1391:
1392: IF (l_debug = 'Y') THEN

Line 1417: -- Delete_Row for:OKC_REVIEW_VAR_VALUES --

1413:
1414: END Delete_Row;
1415:
1416: -------------------------------------
1417: -- Delete_Row for:OKC_REVIEW_VAR_VALUES --
1418: -------------------------------------
1419: PROCEDURE Delete_Row(
1420: x_return_status OUT NOCOPY VARCHAR2,
1421: p_REVIEW_UPLD_TERMS_id IN NUMBER,

Line 1489: END OKC_REVIEW_VAR_VALUES_PVT;

1485:
1486:
1487:
1488:
1489: END OKC_REVIEW_VAR_VALUES_PVT;
1490: