APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_K_ART_VAR_EXT_B

Line 2625: DELETE FROM OKC_K_ART_VAR_EXT_B

2621: if p_major_version IS NULL THEN
2622: IF p_cat_id IS NOT NULL THEN
2623: IF p_variable_code IS NOT NULL
2624: THEN
2625: DELETE FROM OKC_K_ART_VAR_EXT_B
2626: WHERE cat_id = p_cat_id
2627: AND variable_code = p_variable_code;
2628:
2629: DELETE FROM OKC_K_ART_VAR_EXT_TL

Line 2633: DELETE FROM OKC_K_ART_VAR_EXT_B

2629: DELETE FROM OKC_K_ART_VAR_EXT_TL
2630: WHERE cat_id = p_cat_id
2631: AND variable_code = p_variable_code;
2632: ELSE
2633: DELETE FROM OKC_K_ART_VAR_EXT_B
2634: WHERE cat_id = p_cat_id;
2635:
2636: DELETE FROM OKC_K_ART_VAR_EXT_TL
2637: WHERE cat_id = p_cat_id;

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 2908: FROM OKC_K_ART_VAR_EXT_B

2904: , D_EXT_ATTR8
2905: , D_EXT_ATTR9
2906: , D_EXT_ATTR10
2907: ,p_major_version
2908: FROM OKC_K_ART_VAR_EXT_B
2909: WHERE cat_id=p_cat_id;
2910:
2911: INSERT INTO OKC_K_ART_VAR_EXT_TLH
2912: (EXTENSION_ID

Line 3027: INSERT INTO okc_k_art_var_ext_b

3023:
3024: PROCEDURE restore_mrv_uda_data_version(p_cat_id IN NUMBER,p_major_version IN NUMBER)
3025: IS
3026: BEGIN
3027: INSERT INTO okc_k_art_var_ext_b
3028: (
3029: EXTENSION_ID
3030: ,ATTR_GROUP_ID
3031: ,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