APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_K_ART_VAR_EXT_TL

Line 2629: DELETE FROM OKC_K_ART_VAR_EXT_TL

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
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

Line 2636: DELETE FROM OKC_K_ART_VAR_EXT_TL

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;
2638:
2639: END IF;
2640: ELSE

Line 2654: DELETE FROM OKC_K_ART_VAR_EXT_TLH

2650: WHERE cat_id = p_cat_id
2651: AND variable_code = p_variable_code
2652: AND major_version =p_major_version;
2653:
2654: DELETE FROM OKC_K_ART_VAR_EXT_TLH
2655: WHERE cat_id = p_cat_id
2656: AND variable_code = p_variable_code
2657: AND major_version =p_major_version;
2658: ELSE

Line 2663: DELETE FROM OKC_K_ART_VAR_EXT_TLH

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
2664: WHERE cat_id = p_cat_id
2665: AND major_version =p_major_version;
2666:
2667: END IF;

Line 2911: INSERT INTO OKC_K_ART_VAR_EXT_TLH

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
2913: , ATTR_GROUP_ID
2914: , CAT_ID
2915: , VARIABLE_CODE

Line 3020: FROM OKC_K_ART_VAR_EXT_TL

3016: , TL_EXT_ATTR38
3017: , TL_EXT_ATTR39
3018: , TL_EXT_ATTR40
3019: , P_MAJOR_VERSION
3020: FROM OKC_K_ART_VAR_EXT_TL
3021: WHERE cat_id=p_cat_id;
3022: END create_mrv_uda_data_version;
3023:
3024: PROCEDURE restore_mrv_uda_data_version(p_cat_id IN NUMBER,p_major_version IN NUMBER)

Line 3245: INSERT INTO OKC_K_ART_VAR_EXT_TL

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
3246: (EXTENSION_ID
3247: , ATTR_GROUP_ID
3248: , CAT_ID
3249: , VARIABLE_CODE

Line 3352: FROM OKC_K_ART_VAR_EXT_TLH TLH

3348: , TLH.TL_EXT_ATTR37
3349: , TLH.TL_EXT_ATTR38
3350: , TLH.TL_EXT_ATTR39
3351: , TLH.TL_EXT_ATTR40
3352: FROM OKC_K_ART_VAR_EXT_TLH TLH
3353: WHERE 1=1
3354: AND TLH.cat_id=p_cat_id
3355: AND TLH.MAJOR_VERSION=p_major_version;
3356: END restore_mrv_uda_data_version;