[Home] [Help]
881: -- Do not support Simple API for variable deletion or update. This is the only
882: -- API from which this will be called.
883:
884:
885: DELETE FROM OKC_ARTICLE_VARIABLES
886: WHERE ARTICLE_VERSION_ID = p_article_version_id;
887:
888: -- If a local article version is deleted the attached global article version
889: -- becomes available in the adoption table with adoption type as "AVAILABLE".
2488:
2489: i := 0;
2490: IF (l_variable_code_tbl.COUNT > 0) THEN
2491: FORALL i IN l_variable_code_tbl.FIRST..l_variable_code_tbl.LAST
2492: INSERT INTO OKC_ARTICLE_VARIABLES
2493: (
2494: ARTICLE_VERSION_ID ,
2495: VARIABLE_CODE ,
2496: OBJECT_VERSION_NUMBER ,
2759: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2760: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2761:
2762: CURSOR existing_art_variable_csr (cp_article_version_id IN NUMBER) IS
2763: SELECT VARIABLE_CODE FROM OKC_ARTICLE_VARIABLES
2764: WHERE ARTICLE_VERSION_ID = cp_article_version_id;
2765: BEGIN
2766: IF (l_debug = 'Y') THEN
2767: okc_debug.log('1750: Entered update_article_variables', 2);
2803: END IF;
2804: IF p_do_dml = 'Y' THEN
2805: IF x_variables_to_insert_tbl.COUNT > 0 Then
2806: FORALL i in x_variables_to_insert_tbl.FIRST .. x_variables_to_insert_tbl.LAST
2807: INSERT INTO OKC_ARTICLE_VARIABLES
2808: (
2809: ARTICLE_VERSION_ID ,
2810: VARIABLE_CODE ,
2811: OBJECT_VERSION_NUMBER ,
2829: END IF;
2830:
2831: IF x_variables_to_delete_tbl.COUNT > 0 Then
2832: FORALL i in x_variables_to_delete_tbl.FIRST .. x_variables_to_delete_tbl.LAST
2833: DELETE FROM OKC_ARTICLE_VARIABLES
2834: WHERE VARIABLE_CODE = x_variables_to_delete_tbl(i)
2835: AND ARTICLE_VERSION_ID = p_article_version_id;
2836: END IF;
2837: END IF;
2935: l_clob CLOB;
2936: -- The following procedure is private to this API and will be used to update the variables for the articles
2937: -- It will perform the following:
2938: -- 1. Delete the existing variables no longer used
2939: -- 2. Create any new variables that do not exist in OKC_ARTICLE_VARIABLES
2940: -- BULK approach was considered for better performance with manipulation using PL/SQL arrays
2941: -- Other approach could be use of temp tables
2942: -- Easiest approach would have been is to bulk delete and bulk insert all article variables but maynot perform
2943: -- as efficiently
3628: --------------------------------------------
3629: -- Create Article Variables
3630: -- Insert at one shot .. This is much efficient than calling the create article version and parse out the variables
3631:
3632: INSERT INTO OKC_ARTICLE_VARIABLES
3633: (
3634: ARTICLE_VERSION_ID ,
3635: VARIABLE_CODE ,
3636: OBJECT_VERSION_NUMBER ,
3648: sysdate,
3649: sysdate,
3650: l_user_id,
3651: l_login_id
3652: FROM OKC_ARTICLE_VARIABLES
3653: WHERE ARTICLE_VERSION_ID = p_article_version_id;
3654: --------------------------------------------
3655: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;