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:
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;
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:
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,
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
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,
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,
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:
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;
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 ;
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:
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,
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;
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;
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
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
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);
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;
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:
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:
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'
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
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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:
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
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);
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,
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,
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,
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;
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;
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
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:
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;
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:
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
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
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:
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
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:
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,
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,
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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
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:
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
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
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);
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,
1942: x_return_status := G_RET_STS_UNEXP_ERROR;
1943:
1944: END Delete_Row;
1945:
1946: END OKC_ALLOWED_TMPL_USAGES_PVT;