eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_K_ART_VAR_EXT_BH

Line 2649: DELETE FROM OKC_K_ART_VAR_EXT_BH

2645: ELSE -- p_major_version IS NOT NULL THEN
2646: IF p_cat_id IS NOT NULL THEN
2647: IF p_variable_code IS NOT NULL
2648: THEN
2649: DELETE FROM OKC_K_ART_VAR_EXT_BH
2650: WHERE cat_id = p_cat_id
2651: AND variable_code = p_variable_code
2652: AND major_version =p_major_version;
2653:

Line 2659: DELETE FROM OKC_K_ART_VAR_EXT_BH

2655: WHERE cat_id = p_cat_id
2656: AND variable_code = p_variable_code
2657: AND major_version =p_major_version;
2658: ELSE
2659: DELETE FROM OKC_K_ART_VAR_EXT_BH
2660: WHERE cat_id = p_cat_id
2661: AND major_version =p_major_version;
2662:
2663: DELETE FROM OKC_K_ART_VAR_EXT_TLH

Line 2692: INSERT INTO okc_k_art_var_ext_bh

2688:
2689: PROCEDURE create_mrv_uda_data_version(p_cat_id IN NUMBER, p_major_version IN NUMBER)
2690: IS
2691: BEGIN
2692: INSERT INTO okc_k_art_var_ext_bh
2693: (
2694: EXTENSION_ID
2695: ,ATTR_GROUP_ID
2696: ,CAT_ID

Line 3241: FROM OKC_K_ART_VAR_EXT_BH

3237: , D_EXT_ATTR7
3238: , D_EXT_ATTR8
3239: , D_EXT_ATTR9
3240: , D_EXT_ATTR10
3241: FROM OKC_K_ART_VAR_EXT_BH
3242: WHERE cat_id=p_cat_id
3243: AND major_version =p_major_version;
3244:
3245: INSERT INTO OKC_K_ART_VAR_EXT_TL