APPS.OKC_TERMS_TEMPLATES_PVT dependencies on OKC_EXPRT_IMPORT_REFS

Line 2924: l_orig_sys_ref okc_exprt_import_refs.orig_sys_ref%TYPE;

2920: p_delete_parent_yn IN VARCHAR2 := 'N' --If set to 'Y', delete template without checking for translated templates.
2921: ) IS
2922: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
2923: l_template_model_id OKC_TERMS_TEMPLATES_ALL.template_model_id%TYPE;
2924: l_orig_sys_ref okc_exprt_import_refs.orig_sys_ref%TYPE;
2925: l_msg_count NUMBER;
2926: l_msg_data VARCHAR2(4000);
2927: l_status_code VARCHAR2(30);
2928: l_dummy_var VARCHAR2(1);

Line 3035: -- delete record from okc_exprt_import_refs

3031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3032: RAISE FND_API.G_EXC_ERROR;
3033: END IF; -- delete model successful
3034:
3035: -- delete record from okc_exprt_import_refs
3036: /* DELETE FROM okc_exprt_import_refs
3037: WHERE object_type_code = 'TEMPLATEMODEL'
3038: AND model_id = l_template_model_id ; */
3039:

Line 3036: /* DELETE FROM okc_exprt_import_refs

3032: RAISE FND_API.G_EXC_ERROR;
3033: END IF; -- delete model successful
3034:
3035: -- delete record from okc_exprt_import_refs
3036: /* DELETE FROM okc_exprt_import_refs
3037: WHERE object_type_code = 'TEMPLATEMODEL'
3038: AND model_id = l_template_model_id ; */
3039:
3040: END IF; -- template_model_id is NOT NULL