459: ) RETURN VARCHAR2 IS
460: item_not_found_error EXCEPTION;
461: CURSOR okc_aaev_pk_csr (p_id IN NUMBER) IS
462: SELECT '1'
463: FROM Okc_Action_Attributes_V
464: WHERE okc_action_attributes_v.id = p_id;
465:
466: l_dummy_var VARCHAR2(1);
467:
460: item_not_found_error EXCEPTION;
461: CURSOR okc_aaev_pk_csr (p_id IN NUMBER) IS
462: SELECT '1'
463: FROM Okc_Action_Attributes_V
464: WHERE okc_action_attributes_v.id = p_id;
465:
466: l_dummy_var VARCHAR2(1);
467:
468: CURSOR okc_coev_pk_csr (p_id IN NUMBER) IS
655: CREATION_DATE,
656: LAST_UPDATED_BY,
657: LAST_UPDATE_DATE,
658: LAST_UPDATE_LOGIN
659: FROM Okc_Action_Attributes_V
660: WHERE okc_action_attributes_v.id = p_id;
661: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
662: CURSOR okc_coev_pk_csr (p_id IN NUMBER) IS
663: SELECT
656: LAST_UPDATED_BY,
657: LAST_UPDATE_DATE,
658: LAST_UPDATE_LOGIN
659: FROM Okc_Action_Attributes_V
660: WHERE okc_action_attributes_v.id = p_id;
661: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
662: CURSOR okc_coev_pk_csr (p_id IN NUMBER) IS
663: SELECT
664: ID,
2140: '_PVT'
2141: );
2142: END delete_row;
2143: ---------------------------------------------------------------
2144: -- Procedure for mass insert in OKC_ACTION_ATTRIBUTES_VALS _B and TL tables
2145: ---------------------------------------------------------------
2146: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_aavv_tbl aavv_tbl_type) IS
2147: l_tabsize NUMBER := p_aavv_tbl.COUNT;
2148: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;