DBA Data[Home] [Help]

APPS.OKL_RULE_EXTRACT_PVT dependencies on OKC_UTIL

Line 112: l_jtf_query := OKC_UTIL.GET_SQL_FROM_JTFV(p_object_code => rule_source_rec.object_code);

108: l_query_string := ' SELECT '|| rule_source_rec.object_code||'.ID1, '||
109: rule_source_rec.object_code||'.ID2, '||
110: rule_source_rec.object_code||'.NAME, '||
111: rule_source_rec.object_code||'.DESCRIPTION';
112: l_jtf_query := OKC_UTIL.GET_SQL_FROM_JTFV(p_object_code => rule_source_rec.object_code);
113: If l_jtf_query is Null Then
114: --dbms_output.put_line('Get_Jtot_Query : falied in getting jtf query');
115: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
116: p_msg_name => G_ERROR,

Line 118: p_token1_value => 'FAILED IN GETTING JTF QUERY FROM OKC_UTIL'

114: --dbms_output.put_line('Get_Jtot_Query : falied in getting jtf query');
115: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
116: p_msg_name => G_ERROR,
117: p_token1 => p_rgd_code||':'||p_rgs_code||':'||p_buy_or_sell,
118: p_token1_value => 'FAILED IN GETTING JTF QUERY FROM OKC_UTIL'
119: );
120: RAISE OKL_API.G_EXCEPTION_ERROR;
121: Else
122: l_query_string := l_query_string || ' FROM ' ||l_jtf_query;