APPS.WSH_ITM_QUERY_CUSTOM dependencies on DBMS_SQL

Line 356: DBMS_SQL.BIND_VARIABLE(p_CursorID,p_Table(i).g_Bind_Literal, p_Table(i).g_number_val);

352: IF l_debug_on THEN
353: WSH_DEBUG_SV.LOG (l_module_name, 'Binding literal ', p_Table(i).g_Bind_Literal, WSH_DEBUG_SV.C_STMT_LEVEL);
354: WSH_DEBUG_SV.LOG (l_module_name, 'Binding Value ', p_Table(i).g_number_val, WSH_DEBUG_SV.C_STMT_LEVEL);
355: END IF;
356: DBMS_SQL.BIND_VARIABLE(p_CursorID,p_Table(i).g_Bind_Literal, p_Table(i).g_number_val);
357: ELSIF p_Table(i).g_Value_Type = 'VARCHAR' THEN
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.LOG (l_module_name, 'Binding literal ', p_Table(i).g_Bind_Literal, WSH_DEBUG_SV.C_STMT_LEVEL);
360: WSH_DEBUG_SV.LOG (l_module_name, 'Binding Value ', p_Table(i).g_varchar_val, WSH_DEBUG_SV.C_STMT_LEVEL);

Line 362: DBMS_SQL.BIND_VARIABLE(p_CursorID,p_Table(i).g_Bind_Literal, p_Table(i).g_varchar_val);

358: IF l_debug_on THEN
359: WSH_DEBUG_SV.LOG (l_module_name, 'Binding literal ', p_Table(i).g_Bind_Literal, WSH_DEBUG_SV.C_STMT_LEVEL);
360: WSH_DEBUG_SV.LOG (l_module_name, 'Binding Value ', p_Table(i).g_varchar_val, WSH_DEBUG_SV.C_STMT_LEVEL);
361: END IF;
362: DBMS_SQL.BIND_VARIABLE(p_CursorID,p_Table(i).g_Bind_Literal, p_Table(i).g_varchar_val);
363: ELSIF p_Table(i).g_Value_Type = 'DATE' THEN
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.LOG (l_module_name, 'Binding literal ', p_Table(i).g_Bind_Literal, WSH_DEBUG_SV.C_STMT_LEVEL);
366: WSH_DEBUG_SV.LOG (l_module_name, 'Binding Value ', p_Table(i).g_date_val, WSH_DEBUG_SV.C_STMT_LEVEL);

Line 368: DBMS_SQL.BIND_VARIABLE(p_CursorID,p_Table(i).g_Bind_Literal, p_Table(i).g_date_val);

364: IF l_debug_on THEN
365: WSH_DEBUG_SV.LOG (l_module_name, 'Binding literal ', p_Table(i).g_Bind_Literal, WSH_DEBUG_SV.C_STMT_LEVEL);
366: WSH_DEBUG_SV.LOG (l_module_name, 'Binding Value ', p_Table(i).g_date_val, WSH_DEBUG_SV.C_STMT_LEVEL);
367: END IF;
368: DBMS_SQL.BIND_VARIABLE(p_CursorID,p_Table(i).g_Bind_Literal, p_Table(i).g_date_val);
369: END IF;
370: END LOOP;
371: END;
372: END;