DBA Data[Home] [Help]

APPS.OKC_ALLOWED_TMPL_USAGES_PVT dependencies on OKC_ALLOWED_TMPL_USAGES

Line 1: PACKAGE BODY OKC_ALLOWED_TMPL_USAGES_PVT AS

1: PACKAGE BODY OKC_ALLOWED_TMPL_USAGES_PVT AS
2: /* $Header: OKCVALDTMPLUSGB.pls 120.0 2005/05/25 18:48:22 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 63: SELECT OKC_ALLOWED_TMPL_USAGES_S.NEXTVAL FROM DUAL;

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

Line 105: -- FUNCTION get_rec for: OKC_ALLOWED_TMPL_USAGES

101:
102: END Get_Seq_Id;
103:
104: ---------------------------------------------------------------------------
105: -- FUNCTION get_rec for: OKC_ALLOWED_TMPL_USAGES
106: ---------------------------------------------------------------------------
107: FUNCTION Get_Rec (
108: p_allowed_tmpl_usages_id IN NUMBER,
109:

Line 137: CURSOR OKC_ALLOWED_TMPL_USAGES_pk_csr (cp_allowed_tmpl_usages_id IN NUMBER) IS

133: x_last_update_login OUT NOCOPY NUMBER,
134: x_last_update_date OUT NOCOPY DATE
135:
136: ) RETURN VARCHAR2 IS
137: CURSOR OKC_ALLOWED_TMPL_USAGES_pk_csr (cp_allowed_tmpl_usages_id IN NUMBER) IS
138: SELECT
139: TEMPLATE_ID,
140: DOCUMENT_TYPE,
141: DEFAULT_YN,

Line 164: FROM OKC_ALLOWED_TMPL_USAGES t

160: CREATION_DATE,
161: LAST_UPDATED_BY,
162: LAST_UPDATE_LOGIN,
163: LAST_UPDATE_DATE
164: FROM OKC_ALLOWED_TMPL_USAGES t
165: WHERE t.ALLOWED_TMPL_USAGES_ID = cp_allowed_tmpl_usages_id;
166: BEGIN
167:
168: IF (l_debug = 'Y') THEN

Line 173: OPEN OKC_ALLOWED_TMPL_USAGES_pk_csr (p_allowed_tmpl_usages_id);

169: Okc_Debug.Log('400: Entered get_rec', 2);
170: END IF;
171:
172: -- Get current database values
173: OPEN OKC_ALLOWED_TMPL_USAGES_pk_csr (p_allowed_tmpl_usages_id);
174: FETCH OKC_ALLOWED_TMPL_USAGES_pk_csr INTO
175: x_template_id,
176: x_document_type,
177: x_default_yn,

Line 174: FETCH OKC_ALLOWED_TMPL_USAGES_pk_csr INTO

170: END IF;
171:
172: -- Get current database values
173: OPEN OKC_ALLOWED_TMPL_USAGES_pk_csr (p_allowed_tmpl_usages_id);
174: FETCH OKC_ALLOWED_TMPL_USAGES_pk_csr INTO
175: x_template_id,
176: x_document_type,
177: x_default_yn,
178: x_attribute_category,

Line 200: IF OKC_ALLOWED_TMPL_USAGES_pk_csr%NOTFOUND THEN

196: x_creation_date,
197: x_last_updated_by,
198: x_last_update_login,
199: x_last_update_date;
200: IF OKC_ALLOWED_TMPL_USAGES_pk_csr%NOTFOUND THEN
201: RAISE NO_DATA_FOUND;
202: END IF;
203: CLOSE OKC_ALLOWED_TMPL_USAGES_pk_csr;
204:

Line 203: CLOSE OKC_ALLOWED_TMPL_USAGES_pk_csr;

199: x_last_update_date;
200: IF OKC_ALLOWED_TMPL_USAGES_pk_csr%NOTFOUND THEN
201: RAISE NO_DATA_FOUND;
202: END IF;
203: CLOSE OKC_ALLOWED_TMPL_USAGES_pk_csr;
204:
205: IF (l_debug = 'Y') THEN
206: Okc_Debug.Log('500: Leaving get_rec ', 2);
207: END IF;

Line 225: IF OKC_ALLOWED_TMPL_USAGES_pk_csr%ISOPEN THEN

221: p_token1_value => sqlcode,
222: p_token2 => G_SQLERRM_TOKEN,
223: p_token2_value => sqlerrm);
224:
225: IF OKC_ALLOWED_TMPL_USAGES_pk_csr%ISOPEN THEN
226: CLOSE OKC_ALLOWED_TMPL_USAGES_pk_csr;
227: END IF;
228:
229: RETURN G_RET_STS_UNEXP_ERROR ;

Line 226: CLOSE OKC_ALLOWED_TMPL_USAGES_pk_csr;

222: p_token2 => G_SQLERRM_TOKEN,
223: p_token2_value => sqlerrm);
224:
225: IF OKC_ALLOWED_TMPL_USAGES_pk_csr%ISOPEN THEN
226: CLOSE OKC_ALLOWED_TMPL_USAGES_pk_csr;
227: END IF;
228:
229: RETURN G_RET_STS_UNEXP_ERROR ;
230:

Line 234: -- Set_Attributes for:OKC_ALLOWED_TMPL_USAGES --

230:
231: END Get_Rec;
232:
233: -----------------------------------------
234: -- Set_Attributes for:OKC_ALLOWED_TMPL_USAGES --
235: -----------------------------------------
236: FUNCTION Set_Attributes(
237: p_template_id IN NUMBER,
238: p_document_type IN VARCHAR2,

Line 280: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;

276: x_attribute14 OUT NOCOPY VARCHAR2,
277: x_attribute15 OUT NOCOPY VARCHAR2
278: ) RETURN VARCHAR2 IS
279: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
280: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
281: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
282: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
283: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
284: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line 281: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;

277: x_attribute15 OUT NOCOPY VARCHAR2
278: ) RETURN VARCHAR2 IS
279: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
280: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
281: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
282: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
283: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
284: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
285: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line 282: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;

278: ) RETURN VARCHAR2 IS
279: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
280: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
281: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
282: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
283: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
284: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
285: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
286: BEGIN

Line 283: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

279: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
280: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
281: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
282: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
283: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
284: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
285: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
286: BEGIN
287: IF (l_debug = 'Y') THEN

Line 284: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

280: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
281: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
282: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
283: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
284: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
285: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
286: BEGIN
287: IF (l_debug = 'Y') THEN
288: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 285: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

281: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
282: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
283: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
284: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
285: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
286: BEGIN
287: IF (l_debug = 'Y') THEN
288: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
289: END IF;

Line 480: -- Validate_Attributes for: OKC_ALLOWED_TMPL_USAGES --

476:
477: END Set_Attributes ;
478:
479: ----------------------------------------------
480: -- Validate_Attributes for: OKC_ALLOWED_TMPL_USAGES --
481: ----------------------------------------------
482: FUNCTION Validate_Attributes (
483: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
484:

Line 685: -- Validate_Record for:OKC_ALLOWED_TMPL_USAGES --

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

Line 726: FROM okc_allowed_tmpl_usages usg,

722:
723: CURSOR l_default_doc_type_csr(pc_parent_tmpl_id NUMBER,
724: pc_org_id NUMBER) is
725: SELECT tmpl.template_name
726: FROM okc_allowed_tmpl_usages usg,
727: okc_terms_templates_all tmpl
728: WHERE document_type = p_document_type
729: AND allowed_tmpl_usages_id <> nvl(p_allowed_tmpl_usages_id, -9999)
730: AND nvl(usg.default_yn,'N') = 'Y'

Line 737: FROM okc_allowed_tmpl_usages

733: AND NVL(tmpl.org_id,-99) = NVL(pc_org_id,-99)
734: AND usg.template_id = tmpl.template_id;
735: CURSOR l_allowed_doc_exists_csr IS
736: SELECT '!'
737: FROM okc_allowed_tmpl_usages
738: WHERE template_id = p_template_id
739: AND document_type = p_document_type
740: AND allowed_tmpl_usages_id <> nvl(p_allowed_tmpl_usages_id, -9999);
741: CURSOR l_doc_name_csr IS

Line 866: -- validate_row for:OKC_ALLOWED_TMPL_USAGES --

862: ---------------------------------------------------------------------------
863: -- PROCEDURE validate_row
864: ---------------------------------------------------------------------------
865: ---------------------------------------
866: -- validate_row for:OKC_ALLOWED_TMPL_USAGES --
867: ---------------------------------------
868: PROCEDURE validate_row(
869: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
870:

Line 897: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;

893: p_attribute15 IN VARCHAR2 := NULL,
894:
895: p_object_version_number IN NUMBER
896: ) IS
897: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
898: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
899: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;

Line 898: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;

894:
895: p_object_version_number IN NUMBER
896: ) IS
897: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
898: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
899: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;

Line 899: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;

895: p_object_version_number IN NUMBER
896: ) IS
897: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
898: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
899: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;

Line 900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;

896: ) IS
897: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
898: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
899: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;

Line 901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;

897: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
898: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
899: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;

Line 902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;

898: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
899: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;

Line 903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;

899: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;

Line 904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;

900: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;

Line 905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;

901: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;

Line 906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;

902: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;

Line 907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;

903: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;

Line 908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;

904: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;

Line 909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;

905: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;

Line 910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;

906: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;

Line 911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;

907: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;

Line 912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;

908: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;

Line 913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;

909: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;

Line 914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;

910: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;

Line 915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;

911: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
919: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

Line 916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;

912: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
919: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
920: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line 917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;

913: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
919: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
920: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
921: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line 918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;

914: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
919: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
920: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
921: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
922: BEGIN

Line 919: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

915: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
919: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
920: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
921: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
922: BEGIN
923:

Line 920: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

916: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
919: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
920: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
921: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
922: BEGIN
923:
924: IF (l_debug = 'Y') THEN

Line 921: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

917: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
918: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
919: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
920: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
921: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
922: BEGIN
923:
924: IF (l_debug = 'Y') THEN
925: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 1037: -- Insert_Row for:OKC_ALLOWED_TMPL_USAGES --

1033: ---------------------------------------------------------------------------
1034: -- PROCEDURE Insert_Row
1035: ---------------------------------------------------------------------------
1036: -------------------------------------
1037: -- Insert_Row for:OKC_ALLOWED_TMPL_USAGES --
1038: -------------------------------------
1039: FUNCTION Insert_Row(
1040: p_template_id IN NUMBER,
1041: p_document_type IN VARCHAR2,

Line 1075: INSERT INTO OKC_ALLOWED_TMPL_USAGES(

1071: IF (l_debug = 'Y') THEN
1072: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
1073: END IF;
1074:
1075: INSERT INTO OKC_ALLOWED_TMPL_USAGES(
1076: TEMPLATE_ID,
1077: DOCUMENT_TYPE,
1078: DEFAULT_YN,
1079: ALLOWED_TMPL_USAGES_ID,

Line 1156: -- Insert_Row for:OKC_ALLOWED_TMPL_USAGES --

1152: END Insert_Row;
1153:
1154:
1155: -------------------------------------
1156: -- Insert_Row for:OKC_ALLOWED_TMPL_USAGES --
1157: -------------------------------------
1158: PROCEDURE Insert_Row(
1159: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1160: x_return_status OUT NOCOPY VARCHAR2,

Line 1188: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;

1184: x_allowed_tmpl_usages_id OUT NOCOPY NUMBER
1185:
1186: ) IS
1187:
1188: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1189: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
1190: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
1191: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1192: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line 1189: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;

1185:
1186: ) IS
1187:
1188: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1189: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
1190: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
1191: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1192: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1193: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line 1190: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;

1186: ) IS
1187:
1188: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1189: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
1190: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
1191: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1192: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1193: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
1194: BEGIN

Line 1191: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

1187:
1188: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1189: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
1190: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
1191: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1192: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1193: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
1194: BEGIN
1195:

Line 1192: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

1188: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1189: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
1190: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
1191: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1192: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1193: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
1194: BEGIN
1195:
1196: x_return_status := G_RET_STS_SUCCESS;

Line 1193: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

1189: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
1190: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
1191: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1192: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1193: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
1194: BEGIN
1195:
1196: x_return_status := G_RET_STS_SUCCESS;
1197:

Line 1335: -- Lock_Row for:OKC_ALLOWED_TMPL_USAGES --

1331: ---------------------------------------------------------------------------
1332: -- PROCEDURE Lock_Row
1333: ---------------------------------------------------------------------------
1334: -----------------------------------
1335: -- Lock_Row for:OKC_ALLOWED_TMPL_USAGES --
1336: -----------------------------------
1337: FUNCTION Lock_Row(
1338: p_allowed_tmpl_usages_id IN NUMBER,
1339: p_object_version_number IN NUMBER

Line 1343: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;

1339: p_object_version_number IN NUMBER
1340: ) RETURN VARCHAR2 IS
1341:
1342: l_return_status VARCHAR2(1);
1343: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1344: l_row_notfound BOOLEAN := FALSE;
1345:
1346: CURSOR lock_csr (cp_allowed_tmpl_usages_id NUMBER, cp_object_version_number NUMBER) IS
1347: SELECT object_version_number

Line 1348: FROM OKC_ALLOWED_TMPL_USAGES

1344: l_row_notfound BOOLEAN := FALSE;
1345:
1346: CURSOR lock_csr (cp_allowed_tmpl_usages_id NUMBER, cp_object_version_number NUMBER) IS
1347: SELECT object_version_number
1348: FROM OKC_ALLOWED_TMPL_USAGES
1349: WHERE ALLOWED_TMPL_USAGES_ID = cp_allowed_tmpl_usages_id
1350: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1351: FOR UPDATE OF object_version_number NOWAIT;
1352:

Line 1355: FROM OKC_ALLOWED_TMPL_USAGES

1351: FOR UPDATE OF object_version_number NOWAIT;
1352:
1353: CURSOR lchk_csr (cp_allowed_tmpl_usages_id NUMBER) IS
1354: SELECT object_version_number
1355: FROM OKC_ALLOWED_TMPL_USAGES
1356: WHERE ALLOWED_TMPL_USAGES_ID = cp_allowed_tmpl_usages_id;
1357: BEGIN
1358:
1359: IF (l_debug = 'Y') THEN

Line 1437: -- Lock_Row for:OKC_ALLOWED_TMPL_USAGES --

1433: RETURN( G_RET_STS_UNEXP_ERROR );
1434: END Lock_Row;
1435:
1436: -----------------------------------
1437: -- Lock_Row for:OKC_ALLOWED_TMPL_USAGES --
1438: -----------------------------------
1439: PROCEDURE Lock_Row(
1440: x_return_status OUT NOCOPY VARCHAR2,
1441:

Line 1501: -- Update_Row for:OKC_ALLOWED_TMPL_USAGES --

1497: ---------------------------------------------------------------------------
1498: -- PROCEDURE Update_Row
1499: ---------------------------------------------------------------------------
1500: -------------------------------------
1501: -- Update_Row for:OKC_ALLOWED_TMPL_USAGES --
1502: -------------------------------------
1503: FUNCTION Update_Row(
1504: p_allowed_tmpl_usages_id IN NUMBER,
1505: p_template_id IN NUMBER,

Line 1536: UPDATE OKC_ALLOWED_TMPL_USAGES

1532: IF (l_debug = 'Y') THEN
1533: Okc_Debug.Log('6400: Entered Update_Row', 2);
1534: END IF;
1535:
1536: UPDATE OKC_ALLOWED_TMPL_USAGES
1537: SET TEMPLATE_ID = p_template_id,
1538: DOCUMENT_TYPE = p_document_type,
1539: DEFAULT_YN = p_default_yn,
1540: ATTRIBUTE_CATEGORY = p_attribute_category,

Line 1587: -- Update_Row for:OKC_ALLOWED_TMPL_USAGES --

1583:
1584: END Update_Row;
1585:
1586: -------------------------------------
1587: -- Update_Row for:OKC_ALLOWED_TMPL_USAGES --
1588: -------------------------------------
1589: PROCEDURE Update_Row(
1590: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1591:

Line 1620: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;

1616: p_object_version_number IN NUMBER
1617:
1618: ) IS
1619:
1620: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
1621: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
1622: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;

Line 1621: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;

1617:
1618: ) IS
1619:
1620: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
1621: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
1622: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;

Line 1622: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;

1618: ) IS
1619:
1620: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
1621: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
1622: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;

Line 1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;

1619:
1620: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
1621: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
1622: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;

Line 1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;

1620: l_template_id OKC_ALLOWED_TMPL_USAGES.TEMPLATE_ID%TYPE;
1621: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
1622: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;

Line 1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;

1621: l_document_type OKC_ALLOWED_TMPL_USAGES.DOCUMENT_TYPE%TYPE;
1622: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;

Line 1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;

1622: l_default_yn OKC_ALLOWED_TMPL_USAGES.DEFAULT_YN%TYPE;
1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;

Line 1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;

1623: l_attribute_category OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE_CATEGORY%TYPE;
1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;

Line 1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;

1624: l_attribute1 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE1%TYPE;
1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;

Line 1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;

1625: l_attribute2 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE2%TYPE;
1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;

Line 1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;

1626: l_attribute3 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE3%TYPE;
1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;

Line 1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;

1627: l_attribute4 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE4%TYPE;
1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;

Line 1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;

1628: l_attribute5 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE5%TYPE;
1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;

Line 1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;

1629: l_attribute6 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE6%TYPE;
1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;

Line 1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;

1630: l_attribute7 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE7%TYPE;
1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;

Line 1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;

1631: l_attribute8 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE8%TYPE;
1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;

Line 1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;

1632: l_attribute9 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE9%TYPE;
1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1640: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

Line 1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;

1633: l_attribute10 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE10%TYPE;
1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1640: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1641: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line 1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;

1634: l_attribute11 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE11%TYPE;
1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1640: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1641: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1642: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line 1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;

1635: l_attribute12 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE12%TYPE;
1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1640: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1641: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1642: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
1643:

Line 1640: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

1636: l_attribute13 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE13%TYPE;
1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1640: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1641: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1642: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
1643:
1644: BEGIN

Line 1641: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

1637: l_attribute14 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE14%TYPE;
1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1640: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1641: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1642: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
1643:
1644: BEGIN
1645:

Line 1642: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

1638: l_attribute15 OKC_ALLOWED_TMPL_USAGES.ATTRIBUTE15%TYPE;
1639: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE;
1640: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
1641: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
1642: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
1643:
1644: BEGIN
1645:
1646: IF (l_debug = 'Y') THEN

Line 1838: -- Delete_Row for:OKC_ALLOWED_TMPL_USAGES --

1834: ---------------------------------------------------------------------------
1835: -- PROCEDURE Delete_Row
1836: ---------------------------------------------------------------------------
1837: -------------------------------------
1838: -- Delete_Row for:OKC_ALLOWED_TMPL_USAGES --
1839: -------------------------------------
1840: FUNCTION Delete_Row(
1841: p_allowed_tmpl_usages_id IN NUMBER
1842: ) RETURN VARCHAR2 IS

Line 1850: DELETE FROM OKC_ALLOWED_TMPL_USAGES

1846: IF (l_debug = 'Y') THEN
1847: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1848: END IF;
1849:
1850: DELETE FROM OKC_ALLOWED_TMPL_USAGES
1851: WHERE ALLOWED_TMPL_USAGES_ID = p_ALLOWED_TMPL_USAGES_ID;
1852:
1853: IF (l_debug = 'Y') THEN
1854: Okc_Debug.Log('8300: Leaving Delete_Row', 2);

Line 1878: -- Delete_Row for:OKC_ALLOWED_TMPL_USAGES --

1874:
1875: END Delete_Row;
1876:
1877: -------------------------------------
1878: -- Delete_Row for:OKC_ALLOWED_TMPL_USAGES --
1879: -------------------------------------
1880: PROCEDURE Delete_Row(
1881: x_return_status OUT NOCOPY VARCHAR2,
1882: p_allowed_tmpl_usages_id IN NUMBER,

Line 1946: END OKC_ALLOWED_TMPL_USAGES_PVT;

1942: x_return_status := G_RET_STS_UNEXP_ERROR;
1943:
1944: END Delete_Row;
1945:
1946: END OKC_ALLOWED_TMPL_USAGES_PVT;