[Home] [Help]
870: -- Do not support Simple API for variable deletion or update. This is the only
871: -- API from which this will be called.
872:
873:
874: DELETE FROM OKC_ARTICLE_VARIABLES
875: WHERE ARTICLE_VERSION_ID = p_article_version_id;
876:
877: -- If a local article version is deleted the attached global article version
878: -- becomes available in the adoption table with adoption type as "AVAILABLE".
2427:
2428: i := 0;
2429: IF (l_variable_code_tbl.COUNT > 0) THEN
2430: FORALL i IN l_variable_code_tbl.FIRST..l_variable_code_tbl.LAST
2431: INSERT INTO OKC_ARTICLE_VARIABLES
2432: (
2433: ARTICLE_VERSION_ID ,
2434: VARIABLE_CODE ,
2435: OBJECT_VERSION_NUMBER ,
2657: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2658: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2659:
2660: CURSOR existing_art_variable_csr (cp_article_version_id IN NUMBER) IS
2661: SELECT VARIABLE_CODE FROM OKC_ARTICLE_VARIABLES
2662: WHERE ARTICLE_VERSION_ID = cp_article_version_id;
2663: BEGIN
2664: IF (l_debug = 'Y') THEN
2665: okc_debug.log('1750: Entered update_article_variables', 2);
2701: END IF;
2702: IF p_do_dml = 'Y' THEN
2703: IF x_variables_to_insert_tbl.COUNT > 0 Then
2704: FORALL i in x_variables_to_insert_tbl.FIRST .. x_variables_to_insert_tbl.LAST
2705: INSERT INTO OKC_ARTICLE_VARIABLES
2706: (
2707: ARTICLE_VERSION_ID ,
2708: VARIABLE_CODE ,
2709: OBJECT_VERSION_NUMBER ,
2727: END IF;
2728:
2729: IF x_variables_to_delete_tbl.COUNT > 0 Then
2730: FORALL i in x_variables_to_delete_tbl.FIRST .. x_variables_to_delete_tbl.LAST
2731: DELETE FROM OKC_ARTICLE_VARIABLES
2732: WHERE VARIABLE_CODE = x_variables_to_delete_tbl(i)
2733: AND ARTICLE_VERSION_ID = p_article_version_id;
2734: END IF;
2735: END IF;
2828: l_clob CLOB;
2829: -- The following procedure is private to this API and will be used to update the variables for the articles
2830: -- It will perform the following:
2831: -- 1. Delete the existing variables no longer used
2832: -- 2. Create any new variables that do not exist in OKC_ARTICLE_VARIABLES
2833: -- BULK approach was considered for better performance with manipulation using PL/SQL arrays
2834: -- Other approach could be use of temp tables
2835: -- Easiest approach would have been is to bulk delete and bulk insert all article variables but maynot perform
2836: -- as efficiently
3502: --------------------------------------------
3503: -- Create Article Variables
3504: -- Insert at one shot .. This is much efficient than calling the create article version and parse out the variables
3505:
3506: INSERT INTO OKC_ARTICLE_VARIABLES
3507: (
3508: ARTICLE_VERSION_ID ,
3509: VARIABLE_CODE ,
3510: OBJECT_VERSION_NUMBER ,
3522: sysdate,
3523: sysdate,
3524: l_user_id,
3525: l_login_id
3526: FROM OKC_ARTICLE_VARIABLES
3527: WHERE ARTICLE_VERSION_ID = p_article_version_id;
3528: --------------------------------------------
3529: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;