APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_K_ART_VARIABLES_H

Line 2316: INSERT INTO OKC_K_ART_VARIABLES_H (

2312:
2313: -----------------------------------------
2314: -- Saving Base Table
2315: -----------------------------------------
2316: INSERT INTO OKC_K_ART_VARIABLES_H (
2317: major_version,
2318: CAT_ID,
2319: VARIABLE_CODE,
2320: VARIABLE_TYPE,

Line 2411: , OKC_K_ART_VARIABLES_H KVAR

2407: IS
2408: SELECT kart.ID
2409: FROM OKC_K_ARTICLES_BH KART
2410: , OKC_BUS_VARIABLES_B BUS_VAR
2411: , OKC_K_ART_VARIABLES_H KVAR
2412: WHERE kart.document_type=p_doc_type
2413: AND kart.document_id = p_doc_id
2414: AND KVAR.cat_id=kart.id
2415: AND KVAR.variable_code=BUS_VAR.variable_code

Line 2471: FROM OKC_K_ART_VARIABLES_H

2467: LAST_UPDATE_LOGIN,
2468: LAST_UPDATE_DATE,
2469: mr_variable_html,
2470: mr_variable_xml
2471: FROM OKC_K_ART_VARIABLES_H
2472: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2473: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2474: AND DOCUMENT_ID = P_DOC_ID)
2475: AND major_version = p_major_version;

Line 2525: , OKC_K_ART_VARIABLES_H KVAR

2521: IS
2522: SELECT kart.ID
2523: FROM OKC_K_ARTICLES_BH KART
2524: , OKC_BUS_VARIABLES_B BUS_VAR
2525: , OKC_K_ART_VARIABLES_H KVAR
2526: WHERE kart.document_type=p_doc_type
2527: AND kart.document_id = p_doc_id
2528: AND KVAR.cat_id=kart.id
2529: AND KVAR.variable_code=BUS_VAR.variable_code

Line 2552: FROM OKC_K_ART_VARIABLES_H

2548: delete_mrv_uda_data(p_cat_id => cat_rec.id,p_variable_code => NULL, p_major_version =>p_major_version);
2549: END LOOP;
2550:
2551: DELETE
2552: FROM OKC_K_ART_VARIABLES_H
2553: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2554: WHERE document_type = p_doc_type and document_id = p_doc_id)
2555: AND major_version = p_major_version;
2556: