1: PACKAGE BODY okc_review_upld_terms_pvt AS
2: /* $Header: OKCVRUTB.pls 120.62.12020000.4 2012/11/20 10:54:08 skavutha ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
26: G_RECORD_VALID_LEVEL CONSTANT NUMBER := OKC_API.G_RECORD_VALID_LEVEL;
27: ---------------------------------------------------------------------------
28: -- GLOBAL VARIABLES
29: ---------------------------------------------------------------------------
30: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REVIEW_UPLD_TERMS_PVT';
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
32: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
33:
34: ------------------------------------------------------------------------------
60: p_REVIEW_UPLD_TERMS_id IN NUMBER,
61: x_REVIEW_UPLD_TERMS_id OUT NOCOPY NUMBER
62: ) RETURN VARCHAR2 IS
63: CURSOR l_seq_csr IS
64: SELECT OKC_REVIEW_UPLD_TERMS_S1.NEXTVAL FROM DUAL;
65: BEGIN
66: IF (l_debug = 'Y') THEN
67: Okc_Debug.Log('100: Entered get_seq_id', 2);
68: END IF;
102:
103: END Get_Seq_Id;
104:
105: ---------------------------------------------------------------------------
106: -- FUNCTION get_rec for: OKC_REVIEW_UPLD_TERMS
107: ---------------------------------------------------------------------------
108: FUNCTION Get_Rec (
109: p_REVIEW_UPLD_TERMS_id IN NUMBER,
110:
157: CREATION_DATE,
158: LAST_UPDATED_BY,
159: LAST_UPDATE_LOGIN,
160: LAST_UPDATE_DATE
161: FROM OKC_REVIEW_UPLD_TERMS t
162: WHERE t.REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;
163: BEGIN
164:
165: IF (l_debug = 'Y') THEN
225:
226: END Get_Rec;
227:
228: -----------------------------------------
229: -- Set_Attributes for:OKC_REVIEW_UPLD_TERMS --
230: -----------------------------------------
231: FUNCTION Set_Attributes(
232: p_REVIEW_UPLD_TERMS_id IN NUMBER,
233: p_document_id IN NUMBER,
267: x_new_parent_id OUT NOCOPY NUMBER,
268: x_upload_level OUT NOCOPY NUMBER
269: ) RETURN VARCHAR2 IS
270: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
271: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
272: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
273: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
268: x_upload_level OUT NOCOPY NUMBER
269: ) RETURN VARCHAR2 IS
270: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
271: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
272: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
273: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
269: ) RETURN VARCHAR2 IS
270: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
271: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
272: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
273: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
277: BEGIN
270: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
271: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
272: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
273: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
277: BEGIN
278: IF (l_debug = 'Y') THEN
271: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
272: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
273: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
277: BEGIN
278: IF (l_debug = 'Y') THEN
279: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
272: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
273: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
274: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
275: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
276: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
277: BEGIN
278: IF (l_debug = 'Y') THEN
279: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
280: END IF;
454:
455: END Set_Attributes ;
456:
457: ----------------------------------------------
458: -- Validate_Attributes for: OKC_REVIEW_UPLD_TERMS --
459: ----------------------------------------------
460: FUNCTION Validate_Attributes (
461: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
462:
708: -- PROCEDURE Validate_Record
709: -- It calls Item Level Validations and then makes Record Level Validations
710: ---------------------------------------------------------------------------
711: ------------------------------------------
712: -- Validate_Record for:OKC_REVIEW_UPLD_TERMS --
713: ------------------------------------------
714: FUNCTION Validate_Record (
715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
716:
806: ---------------------------------------------------------------------------
807: -- PROCEDURE validate_row
808: ---------------------------------------------------------------------------
809: ---------------------------------------
810: -- validate_row for:OKC_REVIEW_UPLD_TERMS --
811: ---------------------------------------
812: PROCEDURE validate_row(
813: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
814:
835:
836:
837: p_object_version_number IN NUMBER
838: ) IS
839: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
840: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
841: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
842: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
836:
837: p_object_version_number IN NUMBER
838: ) IS
839: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
840: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
841: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
842: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
837: p_object_version_number IN NUMBER
838: ) IS
839: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
840: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
841: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
842: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
838: ) IS
839: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
840: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
841: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
842: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
839: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
840: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
841: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
842: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
840: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
841: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
842: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
841: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
842: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
842: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
843: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
844: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
845: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
846: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
847: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
848: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
849: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
850: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
858: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
851: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
858: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
859: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
852: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
858: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
859: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
860: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
853: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
858: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
859: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
860: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
861: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
854: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
858: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
859: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
860: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
861: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
862: BEGIN
855: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
858: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
859: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
860: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
861: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
862: BEGIN
863:
856: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
858: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
859: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
860: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
861: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
862: BEGIN
863:
864: IF (l_debug = 'Y') THEN
857: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
858: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
859: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
860: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
861: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
862: BEGIN
863:
864: IF (l_debug = 'Y') THEN
865: Okc_Debug.Log('3100: Entered validate_row', 2);
968: ---------------------------------------------------------------------------
969: -- PROCEDURE Insert_Row
970: ---------------------------------------------------------------------------
971: -------------------------------------
972: -- Insert_Row for:OKC_REVIEW_UPLD_TERMS --
973: -------------------------------------
974: FUNCTION Insert_Row(
975: p_REVIEW_UPLD_TERMS_id IN NUMBER,
976: p_document_id IN NUMBER,
1004: IF (l_debug = 'Y') THEN
1005: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
1006: END IF;
1007:
1008: INSERT INTO OKC_REVIEW_UPLD_TERMS(
1009: REVIEW_UPLD_TERMS_ID,
1010: DOCUMENT_ID,
1011: DOCUMENT_TYPE,
1012: OBJECT_ID,
1081: END Insert_Row;
1082:
1083:
1084: -------------------------------------
1085: -- Insert_Row for:OKC_REVIEW_UPLD_TERMS --
1086: -------------------------------------
1087: PROCEDURE Insert_Row(
1088: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1089: x_return_status OUT NOCOPY VARCHAR2,
1110: x_REVIEW_UPLD_TERMS_id OUT NOCOPY NUMBER
1111:
1112: ) IS
1113:
1114: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1115: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
1116: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
1117: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1118: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1111:
1112: ) IS
1113:
1114: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1115: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
1116: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
1117: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1118: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1119: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1112: ) IS
1113:
1114: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1115: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
1116: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
1117: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1118: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1119: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1120: BEGIN
1113:
1114: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1115: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
1116: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
1117: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1118: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1119: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1120: BEGIN
1121:
1114: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1115: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
1116: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
1117: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1118: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1119: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1120: BEGIN
1121:
1122: x_return_status := G_RET_STS_SUCCESS;
1115: l_created_by OKC_REVIEW_UPLD_TERMS.CREATED_BY%TYPE;
1116: l_creation_date OKC_REVIEW_UPLD_TERMS.CREATION_DATE%TYPE;
1117: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1118: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1119: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1120: BEGIN
1121:
1122: x_return_status := G_RET_STS_SUCCESS;
1123:
1253: ---------------------------------------------------------------------------
1254: -- PROCEDURE Lock_Row
1255: ---------------------------------------------------------------------------
1256: -----------------------------------
1257: -- Lock_Row for:OKC_REVIEW_UPLD_TERMS --
1258: -----------------------------------
1259: FUNCTION Lock_Row(
1260: p_REVIEW_UPLD_TERMS_id IN NUMBER,
1261: p_object_version_number IN NUMBER
1261: p_object_version_number IN NUMBER
1262: ) RETURN VARCHAR2 IS
1263:
1264: l_return_status VARCHAR2(1);
1265: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1266: l_row_notfound BOOLEAN := FALSE;
1267:
1268: CURSOR lock_csr (cp_REVIEW_UPLD_TERMS_id NUMBER, cp_object_version_number NUMBER) IS
1269: SELECT object_version_number
1266: l_row_notfound BOOLEAN := FALSE;
1267:
1268: CURSOR lock_csr (cp_REVIEW_UPLD_TERMS_id NUMBER, cp_object_version_number NUMBER) IS
1269: SELECT object_version_number
1270: FROM OKC_REVIEW_UPLD_TERMS
1271: WHERE REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id
1272: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1273: FOR UPDATE OF object_version_number NOWAIT;
1274:
1273: FOR UPDATE OF object_version_number NOWAIT;
1274:
1275: CURSOR lchk_csr (cp_REVIEW_UPLD_TERMS_id NUMBER) IS
1276: SELECT object_version_number
1277: FROM OKC_REVIEW_UPLD_TERMS
1278: WHERE REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;
1279: BEGIN
1280:
1281: IF (l_debug = 'Y') THEN
1355: RETURN( G_RET_STS_UNEXP_ERROR );
1356: END Lock_Row;
1357:
1358: -----------------------------------
1359: -- Lock_Row for:OKC_REVIEW_UPLD_TERMS --
1360: -----------------------------------
1361: PROCEDURE Lock_Row(
1362: x_return_status OUT NOCOPY VARCHAR2,
1363:
1419: ---------------------------------------------------------------------------
1420: -- PROCEDURE Update_Row
1421: ---------------------------------------------------------------------------
1422: -------------------------------------
1423: -- Update_Row for:OKC_REVIEW_UPLD_TERMS --
1424: -------------------------------------
1425: FUNCTION Update_Row(
1426: p_REVIEW_UPLD_TERMS_id IN NUMBER,
1427: p_document_id IN NUMBER,
1452: IF (l_debug = 'Y') THEN
1453: Okc_Debug.Log('6400: Entered Update_Row', 2);
1454: END IF;
1455:
1456: UPDATE OKC_REVIEW_UPLD_TERMS
1457: SET DOCUMENT_ID = p_document_id,
1458: DOCUMENT_TYPE = p_document_type,
1459: OBJECT_ID = p_object_id,
1460: OBJECT_TYPE = p_object_type,
1501:
1502: END Update_Row;
1503:
1504: -------------------------------------
1505: -- Update_Row for:OKC_REVIEW_UPLD_TERMS --
1506: -------------------------------------
1507: PROCEDURE Update_Row(
1508: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1509:
1531: p_object_version_number IN NUMBER
1532:
1533: ) IS
1534:
1535: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
1536: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
1537: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1538: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1532:
1533: ) IS
1534:
1535: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
1536: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
1537: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1538: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1533: ) IS
1534:
1535: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
1536: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
1537: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1538: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1534:
1535: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
1536: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
1537: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1538: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1535: l_document_id OKC_REVIEW_UPLD_TERMS.DOCUMENT_ID%TYPE;
1536: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
1537: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1538: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1536: l_document_type OKC_REVIEW_UPLD_TERMS.DOCUMENT_TYPE%TYPE;
1537: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1538: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1537: l_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
1538: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1538: l_object_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1539: l_object_title OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1540: l_object_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1541: l_parent_object_type OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1542: l_parent_id OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1543: l_article_id OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1544: l_article_version_id OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1552: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
1545: l_label OKC_REVIEW_UPLD_TERMS.LABEL%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1552: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
1553: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1546: l_display_seq OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1552: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
1553: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1554: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1547: l_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1552: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
1553: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1554: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1555: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1548: l_error_message_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE;
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1552: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
1553: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1554: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1555: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1556:
1549: l_warning_message_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE;
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1552: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
1553: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1554: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1555: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1556:
1557: BEGIN
1550: l_object_version_number OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE;
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1552: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
1553: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1554: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1555: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1556:
1557: BEGIN
1558:
1551: l_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
1552: l_upload_level OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE;
1553: l_last_updated_by OKC_REVIEW_UPLD_TERMS.LAST_UPDATED_BY%TYPE;
1554: l_last_update_login OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_LOGIN%TYPE;
1555: l_last_update_date OKC_REVIEW_UPLD_TERMS.LAST_UPDATE_DATE%TYPE;
1556:
1557: BEGIN
1558:
1559: IF (l_debug = 'Y') THEN
1741: ---------------------------------------------------------------------------
1742: -- PROCEDURE Delete_Row
1743: ---------------------------------------------------------------------------
1744: -------------------------------------
1745: -- Delete_Row for:OKC_REVIEW_UPLD_TERMS --
1746: -------------------------------------
1747: FUNCTION Delete_Row(
1748: p_REVIEW_UPLD_TERMS_id IN NUMBER
1749: ) RETURN VARCHAR2 IS
1753: IF (l_debug = 'Y') THEN
1754: Okc_Debug.Log('8200: Entered Delete_Row', 2);
1755: END IF;
1756:
1757: DELETE FROM OKC_REVIEW_UPLD_TERMS
1758: WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_ID;
1759:
1760: IF (l_debug = 'Y') THEN
1761: Okc_Debug.Log('8300: Leaving Delete_Row', 2);
1781:
1782: END Delete_Row;
1783:
1784: -------------------------------------
1785: -- Delete_Row for:OKC_REVIEW_UPLD_TERMS --
1786: -------------------------------------
1787: PROCEDURE Delete_Row(
1788: x_return_status OUT NOCOPY VARCHAR2,
1789: p_REVIEW_UPLD_TERMS_id IN NUMBER,
1868: x_msg_count OUT NOCOPY NUMBER
1869: ) IS
1870:
1871:
1872: TYPE rut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE upld_level_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE obj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE obj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1869: ) IS
1870:
1871:
1872: TYPE rut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE upld_level_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE obj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE obj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1870:
1871:
1872: TYPE rut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE upld_level_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE obj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE obj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1871:
1872: TYPE rut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE upld_level_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE obj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE obj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1872: TYPE rut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE upld_level_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE obj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE obj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1873: TYPE upld_level_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.UPLOAD_LEVEL%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE obj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE obj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1874: TYPE obj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE obj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE obj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE obj_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1877: TYPE pobj_type_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_OBJECT_TYPE%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1878: TYPE pobj_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE art_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE art_ver_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1888: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1888: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1889: TYPE obj_title_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1888: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1889: TYPE obj_title_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE INDEX BY BINARY_INTEGER;
1890: TYPE orut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OLD_REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1888: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1889: TYPE obj_title_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE INDEX BY BINARY_INTEGER;
1890: TYPE orut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OLD_REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1891: TYPE curr_obj_id_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1888: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1889: TYPE obj_title_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE INDEX BY BINARY_INTEGER;
1890: TYPE orut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OLD_REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1891: TYPE curr_obj_id_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1892: TYPE curr_disp_seq_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1888: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1889: TYPE obj_title_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE INDEX BY BINARY_INTEGER;
1890: TYPE orut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OLD_REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1891: TYPE curr_obj_id_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1892: TYPE curr_disp_seq_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1893: --2 way word sync with clause edit
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1888: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1889: TYPE obj_title_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE INDEX BY BINARY_INTEGER;
1890: TYPE orut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OLD_REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1891: TYPE curr_obj_id_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1892: TYPE curr_disp_seq_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1893: --2 way word sync with clause edit
1894: TYPE obj_text_wml_tab IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER;
1936: lock_text,
1937: new_parent_id,
1938: object_title,
1939: old_review_upld_terms_id
1940: FROM okc_review_upld_terms
1941: WHERE document_id = p_document_id
1942: AND document_type = p_document_type
1943: CONNECT BY PRIOR review_upld_terms_id = new_parent_id
1944: START WITH new_parent_id is null
1967: object_title,
1968: old_review_upld_terms_id --,
1969: --OKC_WORD_DOWNLOAD_UPLOAD.UPLOAD_POST_PROCESSOR(p_document_id,p_document_type,object_id)
1970: --OKC_WORD_DOWNLOAD_UPLOAD.GET_LATEST_WMLBLOB(p_document_id,p_document_type, object_id)
1971: FROM okc_review_upld_terms
1972: WHERE document_id = p_document_id
1973: AND document_type = p_document_type
1974: CONNECT BY PRIOR review_upld_terms_id = new_parent_id
1975: START WITH new_parent_id is null
1982: document_id = p_document_id;
1983:
1984: CURSOR is_article_ibr (p_review_upld_terms_id NUMBER) is
1985: SELECT 'Y'
1986: from okc_article_versions av, okc_review_upld_terms ar
1987: where av.article_version_id = ar.article_version_id
1988: and av.insert_by_reference = 'Y'
1989: and ar.review_upld_terms_id= p_review_upld_terms_id;
1990:
1989: and ar.review_upld_terms_id= p_review_upld_terms_id;
1990:
1991: CURSOR is_article_mandatory (p_review_upld_terms_id NUMBER) is
1992: SELECT 'Y'
1993: from okc_k_articles_b akb, okc_review_upld_terms ar
1994: where akb.id = ar.object_id
1995: and akb.mandatory_yn = 'Y'
1996: and ar.review_upld_terms_id= p_review_upld_terms_id;
1997:
1996: and ar.review_upld_terms_id= p_review_upld_terms_id;
1997:
1998: CURSOR is_article_text_locked (p_review_upld_terms_id NUMBER) is
1999: SELECT 'Y'
2000: from okc_article_versions av, okc_review_upld_terms ar
2001: where av.article_version_id = ar.article_version_id
2002: and av.lock_text = 'Y'
2003: and ar.review_upld_terms_id= p_review_upld_terms_id;
2004:
2004:
2005: cursor get_clause_type_csr(p_review_upld_terms_id NUMBER) is
2006: SELECT
2007: aa.article_type
2008: from okc_articles_all aa, okc_review_upld_terms rev
2009: where
2010: rev.article_id = aa.article_id
2011: and rev.review_upld_terms_id = p_review_upld_terms_id;
2012:
2025: l_user_access VARCHAR2(30);
2026: l_parent_id NUMBER;
2027: l_doc_num_scheme NUMBER;
2028: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;
2029: l_parent_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
2030: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2031: l_root_obj_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
2032: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
2033: -- 2 way word sync with clause edit
2027: l_doc_num_scheme NUMBER;
2028: l_parent_object_title OKC_SECTIONS_B.HEADING%TYPE;
2029: l_parent_object_id OKC_REVIEW_UPLD_TERMS.OBJECT_ID%TYPE;
2030: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
2031: l_root_obj_type OKC_REVIEW_UPLD_TERMS.OBJECT_TYPE%TYPE;
2032: l_scn_code OKC_SECTIONS_B.SCN_CODE%TYPE;
2033: -- 2 way word sync with clause edit
2034: l_prof_value VARCHAR2(1);
2035: l_wml_i NUMBER;
2631: p_document_type => p_document_type,
2632: p_document_id => p_document_id,
2633: p_lock_terms_flag => 'N');
2634:
2635: delete from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2636: document_id = p_document_id;
2637:
2638: delete from okc_review_upld_header where document_type = p_document_type and
2639: document_id = p_document_id;
2638: delete from okc_review_upld_header where document_type = p_document_type and
2639: document_id = p_document_id;
2640:
2641: delete from okc_review_messages where REVIEW_UPLD_TERMS_ID
2642: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2643: document_id = p_document_id);
2644:
2645: delete from OKC_REVIEW_VAR_VALUES where REVIEW_UPLD_TERMS_ID
2646: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2642: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2643: document_id = p_document_id);
2644:
2645: delete from OKC_REVIEW_VAR_VALUES where REVIEW_UPLD_TERMS_ID
2646: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2647: document_id = p_document_id);
2648:
2649: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: After delete on Review Tables');
2755: END IF;
2756: -- Initialize API return status to success
2757: x_return_status := FND_API.G_RET_STS_SUCCESS;
2758:
2759: OKC_REVIEW_UPLD_TERMS_PVT.delete_uploaded_terms(
2760: p_api_version => l_api_version,
2761: p_init_msg_list => p_init_msg_list ,
2762: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2763: p_commit => FND_API.G_FALSE,
2849: DELETE
2850: FROM OKC_REVIEW_MESSAGES m
2851: WHERE m.REVIEW_UPLD_TERMS_id IN
2852: (SELECT REVIEW_UPLD_TERMS_id
2853: FROM okc_REVIEW_UPLD_TERMS
2854: WHERE document_id = p_document_id
2855: AND document_type = p_document_type);
2856:
2857: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2861: DELETE
2862: FROM OKC_REVIEW_VAR_VALUES v
2863: WHERE v.REVIEW_UPLD_TERMS_id IN
2864: (SELECT REVIEW_UPLD_TERMS_id
2865: FROM okc_REVIEW_UPLD_TERMS
2866: WHERE document_id = p_document_id
2867: AND document_type = p_document_type);
2868:
2869: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2870: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: After delete review variables');
2871: END IF;
2872:
2873: DELETE
2874: FROM OKC_REVIEW_UPLD_TERMS
2875: WHERE document_id = p_document_id
2876: AND document_type = p_document_type;
2877:
2878: DELETE
2936: ) IS
2937: l_api_name CONSTANT VARCHAR2(30) := 'Sync_Review_Tables';
2938: l_api_version CONSTANT NUMBER := 1;
2939: l_doc_exists VARCHAR2(1);
2940: l_rev_id_for_doc OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2941: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE;
2942: l_clauses_no_parent_exist VARCHAR2(1);
2943: l_clause_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2944: l_section_title FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2948: l_user_access VARCHAR2(30);
2949: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2950: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2951: l_count NUMBER;
2952: l_prev_rev_id OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2953: l_prev_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
2954: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;
2955:
2956: cursor check_document_row_exists IS
2949: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2950: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2951: l_count NUMBER;
2952: l_prev_rev_id OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2953: l_prev_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
2954: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;
2955:
2956: cursor check_document_row_exists IS
2957: select REVIEW_UPLD_TERMS_id from okc_REVIEW_UPLD_TERMS
2953: l_prev_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
2954: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;
2955:
2956: cursor check_document_row_exists IS
2957: select REVIEW_UPLD_TERMS_id from okc_REVIEW_UPLD_TERMS
2958: where document_type = p_document_type and document_id = p_document_id
2959: and object_id = p_document_id and object_type = p_document_type;
2960:
2961: cursor unresolved_del_rec is
2959: and object_id = p_document_id and object_type = p_document_type;
2960:
2961: cursor unresolved_del_rec is
2962: select REVIEW_UPLD_TERMS_id, object_id, object_type, parent_id, parent_object_type,
2963: new_parent_id from okc_REVIEW_UPLD_TERMS
2964: where document_type = p_document_type
2965: and document_id = p_document_id
2966: and action = 'DELETED'
2967: and new_parent_id is null
2968: order by object_type ;
2969:
2970: cursor clauses_without_parent_exist is
2971: select 'Y'
2972: from OKC_REVIEW_UPLD_TERMS
2973: where document_type = p_document_type
2974: and document_id = p_document_id
2975: and ( (object_type = 'ARTICLE'
2976: and new_parent_id IS NULL)
2975: and ( (object_type = 'ARTICLE'
2976: and new_parent_id IS NULL)
2977: OR (object_type = 'ARTICLE'
2978: and new_parent_id = (select review_upld_terms_id
2979: from okc_review_upld_terms
2980: where document_type = p_document_type
2981: and document_id = p_document_id
2982: and object_id = p_document_id
2983: and object_type = p_document_type))
2986:
2987:
2988: cursor clauses_without_parent_id is
2989: select REVIEW_UPLD_TERMS_id, object_id, object_type, parent_id, parent_object_type,
2990: new_parent_id from okc_REVIEW_UPLD_TERMS
2991: where document_type = p_document_type and document_id = p_document_id
2992: and object_type = 'ARTICLE' and new_parent_id IS NULL and article_id is null and article_version_id is null;
2993:
2994: cursor clauses_no_parent_id_and_moved is
2993:
2994: cursor clauses_no_parent_id_and_moved is
2995: select REVIEW_UPLD_TERMS_id, object_id, object_type, parent_id, parent_object_type,
2996: new_parent_id
2997: from okc_REVIEW_UPLD_TERMS
2998: where document_type = p_document_type
2999: and document_id = p_document_id
3000: and ((object_type = 'ARTICLE'
3001: and new_parent_id IS NULL
3003: and article_version_id is not null)
3004: OR (object_type = 'SECTION' and new_parent_id IS NULL));
3005:
3006: cursor unassigned_section_exists is
3007: select REVIEW_UPLD_TERMS_id from okc_REVIEW_UPLD_TERMS
3008: where document_type = p_document_type and document_id = p_document_id
3009: and object_type = 'SECTION' and to_char(object_title) = Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE);
3010:
3011: cursor review_variable_values is
3011: cursor review_variable_values is
3012: select rev_var.variable_value_id, rev_var.REVIEW_UPLD_TERMS_id, rev_var.variable_name,
3013: rev_var.language, rev_var.variable_code, rev_var.variable_type, rev_var.attribute_value_set_id,
3014: rev_var.variable_value_id
3015: from OKC_REVIEW_VAR_VALUES rev_var, okc_REVIEW_UPLD_TERMS rev
3016: where rev_var.REVIEW_UPLD_TERMS_id = rev.REVIEW_UPLD_TERMS_id
3017: and rev.document_type = p_document_type and rev.document_id = p_document_id;
3018:
3019:
3030: kart_var.variable_value kart_variable_value, rev_var.variable_value rev_variable_value,
3031: kart_var.variable_type, rev_var.variable_value_id
3032:
3033: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,
3034: OKC_REVIEW_UPLD_TERMS rev, okc_article_versions av
3035: WHERE rev.object_id = kart_var.cat_id
3036: AND rev.REVIEW_UPLD_TERMS_id = rev_var.REVIEW_UPLD_TERMS_id
3037: AND kart_var.variable_code = rev_var.variable_code
3038: AND av.article_version_id = rev.article_version_id
3050: and nvl(av.insert_by_reference,'N') <> 'Y';
3051:
3052: cursor variables_removed is
3053: select rev.review_upld_terms_id, kart_var.variable_code, variable_name, language, description
3054: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av
3055: where rev.object_id = kart_var.cat_id
3056: and rev.document_type = p_document_type and rev.document_id = p_document_id
3057: and rev.article_version_id = av.article_version_id
3058: and kart_var.variable_code not in (select variable_code from okc_review_Var_values rev_var
3066: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
3067: decode(rev_var.variable_value,
3068: NULL, 'N',
3069: 'Y') modified
3070: from okc_review_upld_Terms rev, okc_review_var_values rev_var, okc_article_versions av
3071: where rev.document_type = p_document_type and rev.document_id = p_document_id
3072: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3073: and av.article_version_id = rev.article_version_id
3074: and not exists(
3071: where rev.document_type = p_document_type and rev.document_id = p_document_id
3072: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3073: and av.article_version_id = rev.article_version_id
3074: and not exists(
3075: select 'x' from okc_k_art_variables kart_var, okc_review_upld_Terms rev_upld where
3076: rev_upld.review_upld_Terms_id = rev_var.review_upld_terms_id
3077: and rev_upld.object_id = kart_var.cat_id
3078: and rev_var.variable_code = kart_var.variable_code
3079: and (
3093: and nvl(av.insert_by_reference,'N') <> 'Y';
3094:
3095: cursor invalid_variable_added(p_intent VARCHAR2) is
3096: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type
3097: from okc_review_upld_terms rev, okc_review_var_values rev_var
3098: where document_type = p_document_type and rev.document_id = p_document_id
3099: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3100: and ((rev_var.variable_type in ('S','D') and not exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
3101: and var_doc.doc_type = p_document_type))
3107: cursor valid_var_new_clause(p_intent VARCHAR2) is
3108: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
3109: decode(rev_var.variable_value,
3110: NULL, 'N', 'Y') modified
3111: from okc_review_upld_Terms rev, okc_review_var_values rev_var
3112: where rev.document_type = p_document_type and rev.document_id = p_document_id
3113: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3114: and (
3115: (rev_var.variable_type = 'U'
3128: cursor valid_new_var_ibr(p_intent VARCHAR2) is
3129: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
3130: decode(rev_var.variable_value,
3131: NULL, 'N', 'Y') modified
3132: from okc_review_upld_terms rev, okc_review_var_values rev_var, okc_article_versions av
3133: where rev.document_type = p_document_type and rev.document_id = p_document_id
3134: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3135: and av.article_version_id = rev.article_version_id
3136: and (
3148: and nvl(av.insert_by_reference,'N') = 'Y';
3149:
3150: cursor empty_title_csr is
3151: SELECT rev.object_title, rev.REVIEW_UPLD_TERMS_id, rev.object_type
3152: from okc_REVIEW_UPLD_TERMS rev
3153: where document_type = p_document_type and
3154: document_id = p_document_id and
3155: object_title is null
3156: and object_type IN ('ARTICLE', 'SECTION');
3161:
3162:
3163: CURSOR is_article_ibr(p_user_access VARCHAR2) is
3164: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3165: from okc_article_versions av, okc_review_upld_terms ar
3166: where av.article_version_id = ar.article_version_id
3167: and av.insert_by_reference = 'Y'
3168: and ar.document_type = p_document_type
3169: and ar.document_id = p_document_id
3172: and p_user_access <> 'SUPER_USER';
3173:
3174: CURSOR is_article_mandatory(p_user_access VARCHAR2) is
3175: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3176: from okc_k_articles_b akb, okc_review_upld_terms ar
3177: where akb.id = ar.object_id
3178: and akb.mandatory_yn = 'Y'
3179: and ar.document_type = p_document_type
3180: and ar.document_id = p_document_id
3183: and p_user_access <> 'SUPER_USER';
3184:
3185: CURSOR is_article_text_locked(p_user_access VARCHAR2) is
3186: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3187: from okc_article_versions av, okc_review_upld_terms ar
3188: where av.article_version_id = ar.article_version_id
3189: and av.lock_text = 'Y'
3190: and ar.document_type = p_document_type
3191: and ar.document_id = p_document_id
3199: rev_msg.review_upld_terms_id,
3200: rev_msg.error_severity
3201: from
3202: okc_review_messages rev_msg ,
3203: okc_review_upld_terms rev_trm
3204: where
3205: rev_msg.review_upld_terms_id = rev_trm.review_upld_terms_id
3206: and rev_trm.document_type = p_document_type
3207: and rev_trm.document_id = p_document_id
||
||
3245:
3246: cursor check_sec_clause_title is
3247: select review_upld_terms_id,
3248: object_title, object_type
3249: from okc_review_upld_terms rev
3250: where rev.document_type = p_document_type
3251: and rev.document_id = p_document_id
3252: and rev.object_type in ('SECTION','ARTICLE')
3253: and rev.action in ('ADDED','UPDATED')
3254: and ((object_type = 'SECTION' and length(to_char(object_title)) > 80) OR (object_type = 'ARTICLE' and length(to_char(object_title)) > 450)) ;
3255:
3256: cursor terms_disp_csr is
3257: select review_upld_terms_id, object_type, object_id, object_title, action, display_seq, new_parent_id
3258: from okc_review_upld_Terms
3259: where document_type = p_document_type
3260: and document_id = p_document_id
3261: and nvl(action,'XXX') <> 'DELETED'
3262: start with new_parent_id is null
3264: order siblings by review_upld_terms_id;
3265:
3266: cursor parent_ids_csr is
3267: select review_upld_terms_id
3268: from okc_review_upld_Terms
3269: where document_type = p_document_type
3270: and document_id = p_document_id ;
3271:
3272: cursor deleted_terms_csr is
3271:
3272: cursor deleted_terms_csr is
3273: select new_parent_id,
3274: display_seq
3275: from okc_review_upld_Terms
3276: where document_type = p_document_type
3277: and document_id = p_document_id
3278: and action = 'DELETED';
3279:
3277: and document_id = p_document_id
3278: and action = 'DELETED';
3279:
3280: --TYPE disp_seq_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3281: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
3283:
3284: curr_disp_seqs disp_seq_tab;
3285: del_disp_seqs disp_seq_tab;
3278: and action = 'DELETED';
3279:
3280: --TYPE disp_seq_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3281: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
3282: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
3283:
3284: curr_disp_seqs disp_seq_tab;
3285: del_disp_seqs disp_seq_tab;
3286: del_new_parents new_parent_tab;
3323:
3324: open check_document_row_exists;
3325: fetch check_document_row_exists into l_doc_exists;
3326: if (check_document_row_exists%NOTFOUND) THEN
3327: INSERT into okc_REVIEW_UPLD_TERMS(
3328: REVIEW_UPLD_TERMS_ID,
3329: DOCUMENT_ID,
3330: DOCUMENT_TYPE,
3331: OBJECT_ID,
3348: CREATION_DATE,
3349: LAST_UPDATED_BY,
3350: LAST_UPDATE_DATE)
3351: (
3352: SELECT OKC_REVIEW_UPLD_TERMS_S1.NEXTVAL,
3353: P_DOCUMENT_ID,
3354: P_DOCUMENT_TYPE,
3355: p_document_id,
3356: P_DOCUMENT_TYPE,
3380: fetch check_document_row_exists into l_rev_id_for_doc;
3381: close check_document_row_exists;
3382:
3383:
3384: update okc_REVIEW_UPLD_TERMS
3385: set new_parent_id = (select REVIEW_UPLD_TERMS_id from okc_REVIEW_UPLD_TERMS where
3386: document_type = p_document_type and document_id = p_document_id
3387: and object_type = p_document_type and object_id = p_document_id)
3388: where document_type = p_document_type and document_id = p_document_id
3381: close check_document_row_exists;
3382:
3383:
3384: update okc_REVIEW_UPLD_TERMS
3385: set new_parent_id = (select REVIEW_UPLD_TERMS_id from okc_REVIEW_UPLD_TERMS where
3386: document_type = p_document_type and document_id = p_document_id
3387: and object_type = p_document_type and object_id = p_document_id)
3388: where document_type = p_document_type and document_id = p_document_id
3389: and object_type = 'SECTION' and new_parent_id = p_document_id;
3388: where document_type = p_document_type and document_id = p_document_id
3389: and object_type = 'SECTION' and new_parent_id = p_document_id;
3390:
3391:
3392: update okc_REVIEW_UPLD_TERMS rev
3393: set rev.article_id = (select sav_sae_id from okc_k_articles_b
3394: where document_type = p_document_type
3395: and document_id = p_document_id
3396: and id = rev.object_id)
3410: and document_id = p_document_id
3411: and id = rev.object_id);
3412:
3413:
3414: update okc_Review_upld_terms rev_terms
3415: set action = 'ADDED',
3416: article_id = null,
3417: article_version_id = null,
3418: object_id = null
3415: set action = 'ADDED',
3416: article_id = null,
3417: article_version_id = null,
3418: object_id = null
3419: where rev_terms.review_upld_terms_id > (select min(review_upld_terms_id) from okc_Review_upld_terms
3420: where object_id = rev_terms.object_id
3421: and object_type = 'ARTICLE'
3422: and document_Type = p_document_type and document_id = p_document_id
3423: )
3424: and document_Type = p_document_type and document_id = p_document_id
3425: and object_type = 'ARTICLE' ;
3426:
3427:
3428: update okc_Review_upld_terms rev_terms
3429: set action = 'ADDED',
3430: article_id = null,
3431: article_version_id = null,
3432: object_id = null
3429: set action = 'ADDED',
3430: article_id = null,
3431: article_version_id = null,
3432: object_id = null
3433: where rev_terms.review_upld_terms_id > (select min(review_upld_terms_id) from okc_Review_upld_terms
3434: where object_id = rev_terms.object_id
3435: and object_type = 'SECTION'
3436: and document_Type = p_document_type and document_id = p_document_id)
3437: and document_Type = p_document_type and document_id = p_document_id
3438: and object_type = 'SECTION';
3439:
3440:
3441:
3442: UPDATE OKC_REVIEW_UPLD_TERMS
3443: SET ACTION='ADDED'
3444: WHERE OBJECT_ID IS NULL
3445: AND DOCUMENT_ID = P_DOCUMENT_ID
3446: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3447: AND ACTION IS NULL
3448: AND object_type IN ('ARTICLE','SECTION');
3449: --AND NEW_PARENT_ID IS NOT NULL;
3450:
3451: UPDATE OKC_REVIEW_UPLD_TERMS UT
3452: SET ACTION='ADDED'
3453: WHERE ACTION IS NULL
3454: AND DOCUMENT_ID = P_DOCUMENT_ID
3455: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3481: AND S1.DOCUMENT_ID = UT.DOCUMENT_ID
3482: AND NVL(S1.AMENDMENT_OPERATION_CODE,'ZZZ') = 'DELETED' ))
3483: ));
3484:
3485: INSERT INTO OKC_REVIEW_UPLD_TERMS(
3486: REVIEW_UPLD_TERMS_ID,
3487: DOCUMENT_ID,
3488: DOCUMENT_TYPE,
3489: OBJECT_ID,
3505: CREATED_BY,
3506: CREATION_DATE,
3507: LAST_UPDATED_BY,
3508: LAST_UPDATE_DATE)
3509: (SELECT OKC_REVIEW_UPLD_TERMS_S1.NEXTVAL,
3510: KART.DOCUMENT_ID,
3511: KART.DOCUMENT_TYPE,
3512: KART.ID,
3513: 'ARTICLE',
3527: 'DELETED',
3528: NULL,
3529: NULL,
3530: (SELECT REVIEW_UPLD_TERMS_ID
3531: FROM OKC_REVIEW_UPLD_TERMS PARENT
3532: WHERE PARENT.OBJECT_ID = KART.SCN_ID
3533: AND PARENT.DOCUMENT_TYPE = p_document_type
3534: AND PARENT.DOCUMENT_ID = p_document_id),
3535: -- KART.SCN_ID,
3546: AND KART.ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID
3547: AND KART.DOCUMENT_ID = P_DOCUMENT_ID
3548: AND KART.DOCUMENT_TYPE = P_DOCUMENT_TYPE
3549: AND NOT EXISTS (SELECT 1
3550: FROM OKC_REVIEW_UPLD_TERMS UT
3551: WHERE UT.OBJECT_ID = KART.ID
3552: AND UT.OBJECT_TYPE = 'ARTICLE'
3553: AND UT.DOCUMENT_ID = P_DOCUMENT_ID
3554: AND UT.DOCUMENT_TYPE = P_DOCUMENT_TYPE));
3553: AND UT.DOCUMENT_ID = P_DOCUMENT_ID
3554: AND UT.DOCUMENT_TYPE = P_DOCUMENT_TYPE));
3555:
3556:
3557: INSERT INTO OKC_REVIEW_UPLD_TERMS(
3558: REVIEW_UPLD_TERMS_ID,
3559: DOCUMENT_ID,
3560: DOCUMENT_TYPE,
3561: OBJECT_ID,
3577: CREATED_BY,
3578: CREATION_DATE,
3579: LAST_UPDATED_BY,
3580: LAST_UPDATE_DATE)
3581: (SELECT OKC_REVIEW_UPLD_TERMS_S1.NEXTVAL,
3582: SCN.DOCUMENT_ID,
3583: SCN.DOCUMENT_TYPE,
3584: SCN.ID,
3585: 'SECTION',
3598: -- SCN.SCN_ID,
3599: DECODE(SCN.SCN_ID, NULL,l_rev_id_for_doc,
3600: p_document_id, l_rev_id_for_doc,
3601: (SELECT REVIEW_UPLD_TERMS_ID
3602: FROM OKC_REVIEW_UPLD_TERMS PARENT
3603: WHERE PARENT.OBJECT_ID = SCN.SCN_ID
3604: AND PARENT.DOCUMENT_TYPE = p_document_type
3605: AND PARENT.DOCUMENT_ID = p_document_id)
3606: ),
3612: FROM OKC_SECTIONS_B SCN
3613: WHERE SCN.DOCUMENT_ID = P_DOCUMENT_ID
3614: AND SCN.DOCUMENT_TYPE = P_DOCUMENT_TYPE
3615: AND NOT EXISTS (SELECT 1
3616: FROM OKC_REVIEW_UPLD_TERMS UT
3617: WHERE UT.OBJECT_ID = SCN.ID
3618: AND UT.DOCUMENT_TYPE = p_document_type
3619: AND UT.DOCUMENT_ID = p_document_id
3620: AND UT.OBJECT_TYPE = 'SECTION'));
3620: AND UT.OBJECT_TYPE = 'SECTION'));
3621:
3622:
3623: for del_csr in unresolved_del_rec loop
3624: UPDATE OKC_REVIEW_UPLD_TERMS REV
3625: SET NEW_PARENT_ID = (SELECT REVIEW_UPLD_TERMS_ID
3626: FROM OKC_REVIEW_UPLD_TERMS PARENT
3627: WHERE PARENT.OBJECT_ID = REV.PARENT_ID
3628: AND REV.REVIEW_UPLD_TERMS_id = del_csr.REVIEW_UPLD_TERMS_id
3622:
3623: for del_csr in unresolved_del_rec loop
3624: UPDATE OKC_REVIEW_UPLD_TERMS REV
3625: SET NEW_PARENT_ID = (SELECT REVIEW_UPLD_TERMS_ID
3626: FROM OKC_REVIEW_UPLD_TERMS PARENT
3627: WHERE PARENT.OBJECT_ID = REV.PARENT_ID
3628: AND REV.REVIEW_UPLD_TERMS_id = del_csr.REVIEW_UPLD_TERMS_id
3629: AND PARENT.DOCUMENT_TYPE = p_document_type
3630: AND PARENT.document_id = p_document_id
3637: -- 2 way word sync with clause edit begins
3638: l_prof_value := OKC_WORD_DOWNLOAD_UPLOAD.GET_WORD_SYNC_PROFILE;
3639: IF l_prof_value = 'Y' THEN
3640:
3641: UPDATE OKC_REVIEW_UPLD_TERMS UT
3642: SET ACTION='UPDATED',
3643: DISPLAY_SEQ = (select KART.display_sequence
3644: FROM OKC_K_ARTICLES_B KART
3645: WHERE KART.ID = UT.OBJECT_ID)
3667:
3668:
3669: ELSE
3670:
3671: UPDATE OKC_REVIEW_UPLD_TERMS UT
3672: SET ACTION='UPDATED',
3673: DISPLAY_SEQ = (select KART.display_sequence
3674: FROM OKC_K_ARTICLES_B KART
3675: WHERE KART.ID = UT.OBJECT_ID)
3725:
3726: END IF;
3727: -- 2 way word sync with clause edit ends
3728:
3729: UPDATE OKC_REVIEW_UPLD_TERMS UT
3730: SET ACTION='UPDATED',
3731: DISPLAY_SEQ = (SELECT SECTION_SEQUENCE FROM OKC_SECTIONS_B SCN
3732: WHERE SCN.ID = UT.OBJECT_ID
3733: AND to_char(UT.OBJECT_TITLE) <> SCN.HEADING)
3742: AND SCN.DOCUMENT_ID = UT.DOCUMENT_ID
3743:
3744: AND to_char(UT.OBJECT_TITLE) <> SCN.HEADING);
3745:
3746: UPDATE OKC_REVIEW_UPLD_TERMS UT
3747: SET NON_STANDARD_FLAG = 'Y'
3748: WHERE DOCUMENT_ID = P_DOCUMENT_ID
3749: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3750: AND OBJECT_TYPE = 'ARTICLE'
3791: close unassigned_section_exists;
3792: end if;
3793: close clauses_without_parent_exist;
3794: for clause_no_parent_csr in clauses_without_parent_id loop
3795: update okc_REVIEW_UPLD_TERMS
3796: set new_parent_id = l_unassigned_scn_id, action = 'ADDED'
3797: where REVIEW_UPLD_TERMS_id = clause_no_parent_csr.REVIEW_UPLD_TERMS_id;
3798: end loop;
3799:
3797: where REVIEW_UPLD_TERMS_id = clause_no_parent_csr.REVIEW_UPLD_TERMS_id;
3798: end loop;
3799:
3800: for clauses_moved_no_section_csr in clauses_no_parent_id_and_moved loop
3801: update OKC_REVIEW_UPLD_TERMS
3802: set new_parent_id = l_unassigned_scn_id
3803: where REVIEW_UPLD_TERMS_id =clauses_moved_no_section_csr.REVIEW_UPLD_TERMS_id;
3804: end loop;
3805:
3840:
3841: l_message_name := 'OKC_REVIEW_VAR_VAL_CHG';
3842: for valid_var_added_csr in valid_variable_added(l_intent) loop
3843: -- Fix for bug# 5229387. Clauses should be marked as 'UPDATED' only if action is null
3844: update okc_review_upld_terms
3845: set action='UPDATED'
3846: where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id and action is null;
3847:
3848: update OKC_REVIEW_VAR_VALUES
3931: end loop;
3932:
3933: for removed_var_csr in variables_removed loop
3934: -- Fix for bug# 5229387. Clauses should be marked as 'UPDATED' only if action is null
3935: update okc_review_upld_terms
3936: set action='UPDATED'
3937: where review_upld_terms_id = removed_var_csr.review_upld_terms_id and action is null;
3938:
3939: insert into okc_review_var_values(
3971:
3972: l_message_name := 'OKC_REVIEW_INVALID_VARIABLE';
3973: for invalid_var_added_csr in invalid_variable_added(l_intent) loop
3974: -- Fix for bug# 5229387. Clauses should be marked as 'UPDATED' only if action is null
3975: update okc_review_upld_terms
3976: set action='UPDATED'
3977: where review_upld_terms_id = invalid_var_added_csr.review_upld_terms_id and action is null;
3978:
3979: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3997: delete from okc_review_var_values revvar
3998: where revvar.rowid > (select min(rowid) from okc_review_var_values
3999: where review_upld_terms_id = revvar.review_upld_terms_id
4000: and revvar.variable_code = variable_code)
4001: and exists(select 1 from okc_Review_upld_terms rev
4002: where revvar.review_upld_terms_id = rev.review_upld_terms_id
4003: and rev.document_type = p_document_type
4004: and rev.document_id = p_document_id);
4005:
4029: l_clause_counter:= 1;
4030: l_section_counter := 1;
4031: for emp_csr in empty_title_csr loop
4032: if(emp_csr.object_type = 'ARTICLE') then
4033: update okc_REVIEW_UPLD_TERMS
4034: set object_title = l_clause_title || l_clause_counter
4035: where REVIEW_UPLD_TERMS_id = emp_csr.REVIEW_UPLD_TERMS_id;
4036: l_clause_counter := l_clause_counter + 1;
4037: end if;
4035: where REVIEW_UPLD_TERMS_id = emp_csr.REVIEW_UPLD_TERMS_id;
4036: l_clause_counter := l_clause_counter + 1;
4037: end if;
4038: if(emp_csr.object_type = 'SECTION') then
4039: update okc_REVIEW_UPLD_TERMS
4040: set object_title = l_section_title || l_section_counter
4041: where REVIEW_UPLD_TERMS_id = emp_csr.REVIEW_UPLD_TERMS_id;
4042: l_section_counter := l_section_counter + 1;
4043: end if;
4043: end if;
4044: end loop;
4045:
4046:
4047: update okc_review_upld_terms rev
4048: set action = 'DELETED',
4049: object_title = (select nvl(ver.display_name,art. article_title)
4050: from OKC_K_ARTICLES_B kart, OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4051: where kart.id = rev.object_id
4126:
4127: end loop;
4128: for upd_csr in update_err_warn_csr loop
4129: if (upd_csr.error_severity = 'E') then
4130: update okc_review_upld_terms
4131: set error_message_count = upd_csr.err_warn_count
4132: where review_upld_terms_id = upd_csr.review_upld_terms_id;
4133: end if;
4134: if (upd_csr.error_severity = 'W') then
4131: set error_message_count = upd_csr.err_warn_count
4132: where review_upld_terms_id = upd_csr.review_upld_terms_id;
4133: end if;
4134: if (upd_csr.error_severity = 'W') then
4135: update okc_review_upld_terms
4136: set warning_message_count = upd_csr.err_warn_count
4137: where review_upld_terms_id = upd_csr.review_upld_terms_id;
4138: end if;
4139: end loop;
4184: END IF;
4185: END LOOP;
4186: END IF;
4187:
4188: UPDATE okc_review_upld_terms
4189: SET display_seq = l_sequence
4190: WHERE review_upld_terms_id = disp_rec.review_upld_terms_id;
4191:
4192: curr_disp_seqs(NVL(disp_rec.new_parent_id,-999)) := l_sequence;
4196:
4197:
4198: for upd_csr in update_err_warn_csr loop
4199: if (upd_csr.error_severity = 'E') then
4200: update okc_review_upld_terms
4201: set error_message_count = upd_csr.err_warn_count
4202: where review_upld_terms_id = upd_csr.review_upld_terms_id;
4203: end if;
4204: if (upd_csr.error_severity = 'W') then
4201: set error_message_count = upd_csr.err_warn_count
4202: where review_upld_terms_id = upd_csr.review_upld_terms_id;
4203: end if;
4204: if (upd_csr.error_severity = 'W') then
4205: update okc_review_upld_terms
4206: set warning_message_count = upd_csr.err_warn_count
4207: where review_upld_terms_id = upd_csr.review_upld_terms_id;
4208: end if;
4209: end loop;
4256: END Sync_Review_Tables;
4257:
4258: /*
4259: -- PROCEDURE Create_Unassigned_Section
4260: -- creating un-assigned sections in a document in okc_REVIEW_UPLD_TERMS table
4261: */
4262: PROCEDURE Create_Unassigned_Section (
4263: p_api_version IN NUMBER,
4264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4281: l_scn_id NUMBER;
4282: l_temp_id NUMBER;
4283: Cursor l_get_max_seq_csr IS
4284: SELECT nvl(max(display_seq),0)+10
4285: FROM OKC_REVIEW_UPLD_TERMS
4286: WHERE DOCUMENT_TYPE= p_document_type
4287: AND DOCUMENT_ID = p_document_id
4288: AND PARENT_ID IS NULL or new_parent_id = p_document_id;
4289:
4333: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4334: RAISE FND_API.G_EXC_ERROR;
4335: END IF;
4336: x_scn_id := l_scn_id;
4337: INSERT INTO OKC_REVIEW_UPLD_TERMS(
4338: REVIEW_UPLD_TERMS_ID,
4339: DOCUMENT_ID,
4340: DOCUMENT_TYPE,
4341: OBJECT_ID,
4443: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4444: END Create_Unassigned_Section ;
4445:
4446:
4447: END OKC_REVIEW_UPLD_TERMS_PVT;