APPS.OKC_TERMS_TEMPLATES_PVT dependencies on OKC_EXPRT_IMPORT_REFS

Line 2901: l_orig_sys_ref okc_exprt_import_refs.orig_sys_ref%TYPE;

2897: p_delete_parent_yn IN VARCHAR2 := 'N' --If set to 'Y', delete template without checking for translated templates.
2898: ) IS
2899: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
2900: l_template_model_id OKC_TERMS_TEMPLATES_ALL.template_model_id%TYPE;
2901: l_orig_sys_ref okc_exprt_import_refs.orig_sys_ref%TYPE;
2902: l_msg_count NUMBER;
2903: l_msg_data VARCHAR2(4000);
2904: l_status_code VARCHAR2(30);
2905: l_dummy_var VARCHAR2(1);

Line 3012: -- delete record from okc_exprt_import_refs

3008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3009: RAISE FND_API.G_EXC_ERROR;
3010: END IF; -- delete model successful
3011:
3012: -- delete record from okc_exprt_import_refs
3013: /* DELETE FROM okc_exprt_import_refs
3014: WHERE object_type_code = 'TEMPLATEMODEL'
3015: AND model_id = l_template_model_id ; */
3016:

Line 3013: /* DELETE FROM okc_exprt_import_refs

3009: RAISE FND_API.G_EXC_ERROR;
3010: END IF; -- delete model successful
3011:
3012: -- delete record from okc_exprt_import_refs
3013: /* DELETE FROM okc_exprt_import_refs
3014: WHERE object_type_code = 'TEMPLATEMODEL'
3015: AND model_id = l_template_model_id ; */
3016:
3017: END IF; -- template_model_id is NOT NULL